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.

 

Thanks,

 

Andrew

Outcomes