In Import Script, default to Show: Tab-Separated Text
Many of my scripts import fixed length text files (reports from a mainframe). I import each line of the text file into separate record in one field. If Show: All Available is selected, FileMaker assumes a CSV file, which messed up the import if there is a comma anywhere in the record.
I do not know the file name ahead of time so the import script brings up an Open File dialog where I select the file to be imported. If Open File has Show: All Available and I forget to change it to Show: Tab Separated Text, the import is messed up.
How do I set the import script to always default to Show: Tab-Separated Text. I know it can be done since some of my script work that way. But, I can't figure out how to get the other script to default to Show: Tab-Separated Text.
The best way to default to Tab Separated Text is to give the file extension .tab. Delete the "Import Records" script step and create another. This will ensure everything is imported correctly.