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,

Vanessa

 

 

Outcomes