AnsweredAssumed Answered

Import from CSV file incomplete but no errors reported

Question asked by JimBoutilier on Mar 11, 2013
Latest reply on Mar 11, 2013 by philmodjunk

Summary

Import from CSV file incomplete but no errors reported

Product

FileMaker Pro

Version

12.0v3 (10-09-2012)

Operating system version

OS X 10.8.2 Build 12C60

Description of the issue

Do a File|Import on a CSV file (38GB, 97 columns, 41M rows) and import appears to take place with no errors reported but only 3.8M records imported.

Steps to reproduce the problem

Do a File|Import on a CSV file (38GB, 97 columns, 41M rows) and import appears to take place with no errors reported but only 3.8M records imported.

Expected result

Either all 41M records should be imported or some sort of error should be generated explaining why they were not.

Actual result

Import appears to complete normally without any error

Exact text of any error message(s) that appear

No error displayed but log reads


==================================================================
2013-03-10 19:19:42.844 -0600     TWC Extracts.fmp12     0     Import operations started
2013-03-10 19:19:42.864 -0600     TWC Extracts.fmp12     0     Import of tables from file “tve_cust_acct_xtr_new.csv” started
2013-03-10 19:19:42.933 -0600     tve_cust_acct_xtr_new     0     fields imported : 97
2013-03-10 19:19:42.935 -0600     TWC Extracts.fmp12     0     tables imported : 1
2013-03-10 19:19:42.936 -0600     TWC Extracts.fmp12     0     Import completed
2013-03-10 19:19:42.938 -0600     TWC Extracts.fmp12     0     Import operations committed
2013-03-10 19:19:42.939 -0600     TWC Extracts.fmp12     0     ==================================================================

Workaround

None

Outcomes