AnsweredAssumed Answered

Importing (via FM scripting) Issues

Question asked by vanessa.vinson on Jul 11, 2016
Latest reply on Jul 13, 2016 by wimdecorte

I am new to FileMaker, and I am needing help writing an import for a file.


I have been successful in reading in the file; however, it is picking up the headers.  I am unable to check the header box as it is grayed out. 

How do I get to ignore headers in the script?


I am also wanting that when it updates or adds a new record to only show that found set that was modified or added.

How do I get the found set to display after the import is complete (with only the modified/added records).


After the import completes I get a pop-up message that says:

"There are less records in the data source than in the target table. Not all records were updated. "

Is this bad? If so how do I fix it?


In my code I say (can't share real layout/table names):

Go to Layout ["ABC" (the Table)]

Import Records ["$path"; Update existing; Mac Roman]


Any help on these 3 subjects is greatly appreciated.


Thank you,