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?

Vincent Miano
Apr 19 · 4 min read
Here is a simple “company” record, linked to a contact in a portal
Relationship between companies and contacts in the FileMaker graph
1 column with data from the company, the 2 following ones with data from the contact
Normal import process
left : The new “import” point of view | right : “Allow creation of records in this table via this relationship”
Script used to distribute data from the “flat file” import table into the tables used in the database

Lesterius

We are creative business consultants who co-create FileMaker Platform based solutions with our customers.

Vincent Miano

Written by

FileMaker consultant, since 2016

Lesterius

Lesterius

We are creative business consultants who co-create FileMaker Platform based solutions with our customers.