AnsweredAssumed Answered

FileMaker doesn't import first real record when importing a text file with blank first record

Question asked by JohnDCCIU on Sep 26, 2013
Latest reply on Sep 27, 2013 by philmodjunk

Summary

FileMaker doesn't import first real record when importing a text file with blank first record

Product

FileMaker Pro

Version

FileMaker 12.0v4 Advanced

Operating system version

OS X 10.8.5

Description of the issue

Using File/Import or the Import Record script step, if you import a text file that has a blank first record, the import skips the blank record but also skips the first real record.

As a side note, when this kind of file is chosen, the "Don't Import First Record (contains field names)" checkbox is checkmarked in the import dialog, but it's grayed out and you can't uncheck it.

Steps to reproduce the problem

Create a text file with a blank first record, and 5 records with some data in them.

Expected result

The blank first record should be skipped, but the remaining 5 records should be imported:

Record 1:  One
Record 2:  Two
Record 3:  Three
Record 4:  Four
Record 5:  Five

Actual result

The blank first record is skipped but so also is the first real record.  The resulting table contains only 4 records.

Record 1:  Two
Record 2:  Three
Record 3:  Four
Record 4:  Five

Exact text of any error message(s) that appear

None

Configuration information

None

Workaround

None in FileMaker.  You can manually delete that first blank record in the import file to get around the problem that way

Screen_Shot_2013-09-26_at_4.13.19_PM.jpg

Outcomes