Example Of A Basic FileMaker Import Operation

From Dwayne Wright PMP - Certified FileMaker Developer
WEB: www.dwaynewright.com
EMAIL: info@dwaynewright.com
TWITTER: dwaynewright
YOUTUBE: FileMakerThoughts

This example shows off the most basic import. We have 2 source files and one destination file. I included two source files to show off the difference when importing from a text file or importing from another FileMaker file. When you click the Import Text File button, you can see the data you are importing but not the field labels. Two of the data fields look like they have very similar data. If you run across a situation like this when you do your imports, make sure you are familiar with the data you are importing.

When you import from a FileMaker file, you see the field labels and then can see the data in the source file by clicking one of the scan data buttons.

In either import, you can see that the destination file grows in the overall number of records. This is because we set the import up for add new records as the import action. You can experiment with the other import action options of Replace Data In Found Set or Update Matching Records In Current Found Set options.

An example file can be downloaded by clicking (here)

© 2010 - Dwayne Wright - dwaynewright.com

The material on this document is offered AS IS. There is NO REPRESENTATION OR WARRANTY, expressed or implied, nor does any other contributor to this document. WARRANTIES OF MERCHANT ABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE EXPRESSLY DISCLAIMED. Consequential and incidental damages are expressly excluded. FileMaker Pro is the registered trademark of FileMaker Inc.