Blog

Software tips, techniques, and news.

Redesigned FileMaker Import Dialog

As of FileMaker 18, the Import Dialog has been redesigned to be more user-friendly, flexible and fast. Some of the new features include the ability to select the target fields in a list that can be filtered and the ability to perform auto-enter options individually for each field.

youtube-preview

What Is New?

  • User-friendly interface

  • Ability to select the target field from a list that can be filtered

  • A custom row can be used as the "Field Names" row in the source file for certain data types

  • Auto-enter options are independent for each field

  • Ability to import data from files using a custom character to separate values

User Friendly Interface

The way information is presented makes it easier for the users to understand how the import process works. For example the use of colors to define if the field will be imported or not, or if it will be used to find a match conveys what is going to be done in a very efficient and natural way.

Redesigned FileMaker Import Dialog User Interface
In addition FileMaker provides diagrams in a pop-up window of the different operations that could be performed when importing.

FileMaker Import Dialog Import Methods

Search Target Field

FileMaker now allows us to choose the target fields from a list that can be filtered, decreasing the time needed to map fields, especially when including a considerable amount of fields.

FileMaker Import Dialog Filter Fields

Use Custom Record As Field Names

You can now select any row in the import file as the header row (the row containing the field names). All rows in the file before the header row will be omitted.

Custom Row Header of Source FileExcluded Row When Using Custom Header

Independent Auto-Enters

You can choose which auto-enters to fire when importing by clicking on the red gear button located on the right side of each field with auto-enter options.

FileMaker Import Dialog Choose Which Fields to Fire Auto-Enters

Custom Character Separators

You have now the ability to import files that have separators other than commas and tabs, getting rid of the need to preprocess the file before importing.

FileMaker Import Dialog Custom Delimiter

Conclusion

FileMaker greatly improved importing with a more intuitive interface, a more efficient methodology, and more flexible functionality. Contact us if you would like help importing data into your FileMaker application.

Did you know we are an authorized reseller for Claris FileMaker Licensing?
Contact us to discuss upgrading your Claris FileMaker software.

Download the Redesigned FileMaker Import Dialog File

Please complete the form below to download your FREE FileMaker file.

FileMaker Experience *
Terms of Use *
OPT-IN: I agree that I am downloading a completely free FileMaker application file with no strings attached. This file is unlocked, and I may use it for my business or organization as I see fit. Because I am downloading a free file, I agree that I should receive occasional marketing. I understand that I can OPT-OUT of these emails at anytime.
carlos machado headshot.
Carlos Machado

Carlos is an experienced application developer who is outgoing and energetic, enthusiastically embracing new challenges whenever they appear. Having been introduced to FileMaker at the age of ten, Carlos’s passion for its power has intensified over the years. Originally from Cuba, Carlos relocated from California to be part of the talented DB Services team.