Learning Claris FileMaker

How can I import and export data in FileMaker?

• Import of individual files
• Import of entire folders with files
• Export of container fields
• Export of a text field as a file
• Generate file paths
• Extract filenames from container fields
• Calculate file names for export.

Here at the Beezwax, we have been performing research on FileMaker 18 import changes, specifically new support for ESV: Emoji Separated Values.

Now there is no excuse for NOT running imports on #FileMaker 18 server - stop by and check out this post... and "you may ask yourself..." how could I NOT have this in every solution.

Make things super speedy for your users by importing asynchronously!

Learn how to use the import function instead of a loop script to create multiple new records in FileMaker quickly.

There are always new transitions to our lives where we move on to something better.

Some transitions are small and others that are larger most likely require careful planning in order to progress.

Then with the plan in place, it lessens the likelihood of problems and may create a better foundation.

Read more on the blog

FileMaker's import process has not changed in a long time and so it's ripe for an update. FileMaker, Inc. has shown it a lot of love in FileMaker 18!

FileMaker’s importing capabilities are pretty extensive but they're not always intuitive.

The new import dialog interface features a mix of graphics and text so it should be very easy for both new and seasoned developers to choose the most appropriate actions.

Let's explore the new import features and functions.

Importing data in a FileMaker database from a “flat file”

Importing data can be easy when doing it table after table, with well structured data; but what about importing a “flat file”, where data destined to be put in different tables are mixed?

A few years ago, I worked on a FileMaker project where the client told us that every week they need to import about 7,000 rows of data that represent some information that this company uses. And every week there might be some modified records, some records that don’t show up any longer, and some new records that hadn’t already existed. For this example, let’s just call it this data “Products”.

Over the years that weekly information grew to about 12,000 records per week. This PRODUCT table itself had 35 fields of data. So, without a way to manage the duplicates, every week lots of redundant data would need to be imported.


To give you an idea of how much data this solution grew to …

Read more on the blog ...

Watch this video and learn how to import data into FileMaker Pro... and learn the little tricks to keep you out of trouble!