.com Solutions has experience with FileMaker versions 1 - 20 since 1986. Projects can include new development projects, data recovery, database migrations, addition of functionality to existing databases, ODBC data transfer, synchronizing data between databases, and creating charts from FileMaker or other databases. Whenever possible, each project is developed for full compatibility with both macOS and Windows platforms.
Even without completely redesigning existing database solutions, many types of improvements can be completed economically. Sometimes these projects involve using FileMaker Scripts to copy records from older non-relational database structures to relational tables. Existing layouts can be updated with new functionality. Data recovery can also be attempted on older unsupported files which cant be recovered with the Recover feature.
Creating Charts From FileMaker Data - Using the highly acclaimed xmCHART
FileMaker plug-in, FileMaker solutions can be developed to create
charts and reports. FileMaker scripts are used to update FileMaker
database records from an external database to create charts and reports
at the press of a button.
ODBC Data Transfer - .com Solutions has extensive experience with ODBC connectivity for 9 different database servers on multiple platforms. Data may be imported into FileMaker or retrieved from FileMaker via ODBC on MacOS X or Windows. Experience with a wide range of databases has been invaluable for development projects involving ODBC connectivity. Each database has its own unique techniques which need to be used to insure a successful implementation.
Dynamic SetField() Technique - FileMaker 8.5 introduces new functionality which allows layout objects to be referenced by name. Database fields can now be filled with data by referencing a layout field by its object name prior to using an empty SetField() script step statement. Since a field doesnt have to be directly referenced in the FileMaker Script, this technique enables fields to be specified in a dynamic manner.
Electronic Document Filing - The popular Troi File plug-in (www.troi.com) has been utilized to implement electronic document filing within a FileMaker CRM solution. A wide variety of documents including Statements, Invoices and user-generated documents are automatically filed, listed, opened or saved electronically across the network to a documents server. Documents are automatically filed according to client file and subcategory onto the documents server from both MacOSX and Windows computers.
Temp Table Usage - Sometimes, you only need to store information for a short period of time. This technique can be used to reformat information suitable for reporting. Once the report has been generated, the contents of the temp table can automatically be removed, in preparation for the next reporting cycle.
External Development Environments - External development environments include Perl, AppleScript and the Revolution graphical development environment. LiveCode is used for the development of all products.
Project Documentation - Substantial development projects are generally
quoted to include printed and electronic versions of a user/developer
manual. A typical manual includes configuration, theory of operation
diagrams, user oriented instructions, troubleshooting and reference
information. The reference section includes relationship graphs, and
detailed table, layout and scripting info.