AnsweredAssumed Answered

Import Scripts

Question asked by andrewtraub on Oct 24, 2012
Latest reply on Oct 24, 2012 by nickchapin

Does anyone know how to import a csv file into multiple tables in Filemaker?


The import tool seems to want to create a new table or import into one table, but I want to split the data into multiple tables.


So, for example, each row in the csv file contains a name, address, home address, phone, fax, cell phone, etc


In the database, I have a table for name, one-to-many table for addresses, one-to-many table for phones, etc.


So I would want to pull in a row, split the name and identifying information into one table, the address(es) into a related table, and the phone numbers into a related table.


If it can't be done from the csv, then surely I can let filemaker create a new table and then run a script to split the data from that table.