AnsweredAssumed Answered

Import data from csv or text file with a twist...

Question asked by kalfred on Nov 17, 2016
Latest reply on Nov 18, 2016 by ja.marting

I'd like to know if I can create a script that will import a text or csv file into a table and then assign a specific foreign key to each of the newly imported records. Basically the Filemaker Table will have the following fields:


  1. RecordID (Automatically Generated)
  2. ForeignKeyID
  3. Data001
  4. Data002
  5. Data003

The file to import will contain these fields:


  1. Data001
  2. Data002
  3. Data003


The imported data will be appended to a table with existing data and then the ForeingKeyID will be added for each of the newly imported records.


Thanks for any help.