CSV Import Errors

I scripted a recurring csv text file import that has worked fine for a few years. The data elements are wrapped in quotes. Yesterday, I discovered one of the imports failed to import all the data lines. This was because one of the data elements included an extra pair of quotes. When I looked at the import script step, I discovered the delimiter was sent to “tab” instead of “comma”. I’m surprised the import worked at all, since the csv delimiter was not a tab.

Your script step is likely still okay. Print the script and look at the import script step again. I found that FileMaker switches the import file type now and again when you inspect the script step and the file is not available or no longer as programmed.