New Millennium | Experts in FileMaker Accounting Solutions for Your Business

Developer Software

FMrobot
Now available for both Windows and Macintosh

Overview | Purchase | Download | FAQs | Support | Revision History | View Cart
 

Move Fields, Custom Functions, Value Lists, and Privilege Sets
FMrobot 2 also Transfers Relationships!

FMrobot 2.2 for Windows is available for FileMaker 10 Advanced (as well as FileMaker 7 Developer or 8/8.5/9 Advanced).
A Mac version of FMrobot that is compatible with FileMaker 10 will be available soon. Please check back.

Screenshot:
     FMrobot screenshot

View video demos:
      Relationships Preview
      FMrobot Introduction



FMrobot automates the creation of tables and fields in a FileMaker Pro file. This includes bringing over fields with their field types and their field definitions (calculations, auto-enter values, validations, etc.). FMrobot can also move Custom Functions, Value Lists, and Privilege Sets from one file to another. FMrobot 2 for Windows now transfers Relationships and Table Occurrences!

FileMaker Pro 8 - 10 gives you the ability to transfer fields and tables, but you need FMrobot to transfer Custom Functions, Value Lists, Privilege Sets, Relationships and Table Occurrences between files.

FMrobot gives you the power to:

  • Move Relationships and TO’s! (available in FMrobot 2 for Win only)
  • Move Custom Functions from one file to another
  • Move Value Lists from one file to another (custom VL's only)
  • Move Privilege Sets from one file to another
  • Move tables from one file to another
  • Create a standard library of fields to put into any table
  • Create a library of "template tables"
  • Duplicate a table
  • Consolidate many tables into a single file
  • Add fields to an existing table
  • Fully compatible with FileMaker Pro 7 - 10 on Windows (The Mac version will soon be compatible with FM 10, as well.)

The data source for the definitions of the fields, value lists, and privilege sets is the Database Design Report produced by FileMaker Pro 8/8.5/9/10 Advanced or FileMaker Developer 6 or 7.

New tables can be created using all of the fields from another table or only selected fields, and fields may be added to existing tables. Field names and field types will always be created correctly, as will any aspects of the field definitions (calculations, auto-enter values, validations, etc.) which do not have other dependencies. For calculations, if the necessary dependencies (other fields, etc.) are not all in place, the calculation will be "commented out". If any error of this sort occurs, a comment is placed in the field comment field. Later, when the dependencies have been added, you can simply uncomment the calculation.


Rapid development is now a reality!


How does FMrobot compare with FileMaker's ability to transfer tables and fields?

We've had several questions asking why you might want to use FMrobot since FileMaker can transfer tables and fields between files.

FMrobot 2

FMP 8-10 Table and Field Transfer

What you can transfer

In addition to transferring fields and tables, FMrobot 2 allows you to transfer:

  • Relationships and TOs!
  • Custom Functions
  • Value Lists
  • Privilege Sets
Only allows you to transfer fields and tables
Unresolved Calculations

When field calculations don't resolve, FMrobot neatly comments out the calculation while keeping the calculation intact -- and also places a note in the field's general comment area.

Once the necessary elements are in place, it is extremely quick and easy to sort fields by general comments, and then remove the comment bracketing within the calculation to activate it.

Also comments out unresolved calculations, but does not make a note in the general field comment area.

The only way to locate commented out calculations is to check through an external log file or to go through each calculation field manually

FileMaker Compatibility

FMrobot can transfer elements
- from any .fp5 or .fp7 file
- to target files in FileMaker 7, 8, 9, or 10.

Only works with FileMaker 8 - 10 files.