Data Control Specialists - FileMaker Pro Database Design, Train and Support

collect your data the way you want to...
not the way some software expects you to!


database

design and development

professionals

The Services

The Data Control Specialists benefits:

Whatever your business requirement, we can assist you. Perhaps you are a small business considering a new custom database tool for the first time or you have an existing system that you would like to upgrade to meet the new objectives of your business or your organization. Because Data Control Specialists regularly perform these kinds of operations - you'd be surprised how easy it can be.

FileMaker 7 Conversion Services and considerations

  • You have:
    • a Microsoft Access database that you want to convert to FileMaker
    • a FileMaker database that you want to change to SQL or another platform conversion.
    • a flat file database that needs to be made relational
    • information contained in a spreadsheet that you would like converted into a database on a particular platform.
  • Wouldn't it be great if you could just drop your existing pre-7 solutions onto a magic converter and have them instantly converted to FileMaker 7 tables within a master database file? Sure, we wish it were so too,  but it’s so we offer conversion services.
  • We can help convert your FileMaker Pro 4/5/6 solutions up to the new and improved FileMaker Pro 7.
    • We will clean up your current files and
    • remove obsolete information and structures such as scripts and layouts that are no longer used.
    • design and implement new database security in FileMaker Pro 7
    • convert your files then verify the conversion changes.
  • Some databases need manual modification after conversion, but in any event we will test thoroughly to make sure every aspect has been converted successfully. We will make sure that field data is correct, calculations and validations are working properly as well as scripts and security access to touch on a few.
    • We then
    • populate the converted database with current data
    • delete the test data and import data from converted copies of your current database, and last but not least,
    • deploy the converted database when we have completed the post-conversion tasks, tested the converted database, and are confident that it is ready for use.
  • Develop anew
    • Because there are extensive changes and improved features in FileMaker Pro 7, it might make sense to re-create your database in FileMaker Pro 7 rather than converting it in its current design and structure. For example, when converting a multi-file database, the files are not combined into a single file with multiple, related tables. The preferred route is to create a new FileMaker Pro 7 system, with as few files as necessary, taking advantage of the new data model with all of the tables and relationships that you want, and then import data from your original files. By designing your database in FileMaker Pro 7, we can remove obsolete functionality and code, and get the full benefit of the improvements made to FileMaker Pro.
    • Maybe there is a bug in your current system, a layout that needs to be amended or its just plain slow. Data Control Specialists just love to clean up. A few key changes in the right places can significantly improve the performance of your system.
  • Access your applications with a browser
    • FileMaker applications look and feel the same when accessed from a browser either in your office or from anywhere in the world. Now you can easily share all or part of your organization’s data with your staff, your customers and your suppliers from anywhere on the internet.
    • FileMaker Pro 7 is ideal for giving your organization a professional e-commerce presence without the typical high cost of web-based application development.
  • Take your work with you on your hand-held device.
    • FileMaker 7 Mobile
    • Standalone application, runtime support
    • Sync multiple devices
    • Script execution before & after sync

 

The Family

The Benefits

The FileMaker Pro version 7 benefits:

  • FileMaker 7 file structure is very different from that of earlier versions, especially since databases can now be made up of multiple tables. This eliminates the need to have several databases open at once and makes for a much cleaner interface, translating to a better user experience and ultimately, less programming.
  • All changes can be done on live served file
  • Can use separate accounts to test behaviors across different accounts
  • Can look at records that someone else is using - just can't edit (record locking)
  • Account management can be set in server box (running FM7 Server) so that Operating System-level account names can be used as FM7 logins
  • Many "gatekeeper points":
    • Custom layout privileges - report writers can't screw up data, but can be set to create new layouts
    • Custom script privileges
    • Accounts & privileges themselves can be created and customized
    • Type in path to picture, picture appears in container field
    • Data entered in one field can affect the results in another on the fly
    • Calculations can now control font formats (font, size, color, etc.)
    • Indexable calculations can now be used for key fields.
    • Near instant finds, even in databases with millions of records
    • Offline tables can be swapped in as they are updated

FileMaker 7 Server

  • Supports any number of network interfaces
  • Multithreaded
  • Serves 125 files of unlimited tables each- that’s 125 hosted databases
  • Number of users supported:
    • Server
      • 250 Pro clients
    • Server Advanced (uses Apache IIS)
      • 250 simultaneous FMP clients
      • 100 Web sessions
      • 50 ODBC (count against Pro users)
  • Improved performance with increased server-side processing
  • Encrypted data transfer
  • Control database visibility (solution partitioning)
  • Cross-platform remote administration
  • Leverage existing user accounts with external authentication
  • Performance good enough to compete with  Citrix-style solutions
  • Software benefits:
    • Cross-platform remote administration using Server Admin (RSA)
    • Administrators do not need to be familiar with FMP
    • Remote administration auditing
    • New event log listing identities of RSA & other activities
    • "Live" backups
    • Files are copied while in use, paused, cache flushed, files synchronized (mostly dispenses with "coffee cup" cursors)
    • Performs most calculations, queries, finds & sorts.
    • Efficient network performance (fewer, larger packets)
    • Live schema & security modification
    • FileMaker Server 7 will take advantage of server-class machines better than ever
    • Full advantage of multiple processors (though not yet G5 optimized)
    • 70% of system RAM can be used for cache
    • All of user interface is cached, greatly adding to speed
    • Customized security calculations performed on the server (Define Fields in live hosted database)
    • Alternate database & default backup folders - does not have to be in particular folder

FileMaker 7 Server Advanced

  • Instant Web Publishing - 100 simultaneous sessions
  • Custom web publishing with XML & XSLT
  • SSL support
  • XSLT site assistant
  • CDML conversion tools
  • Data Source (ODBC/JDBC/XML)
  • Support for popular web development tools

 FileMaker 7 Mobile

  • FM7 compatibility
  • Standalone application, runtime support
  • Sync multiple devices
  • Script execution before & after synchronization

Copyright Data Control Specialists 2005-