1 Reply Latest reply on Mar 11, 2013 3:39 PM by philmodjunk

    Import from CSV file incomplete but no errors reported

    JimBoutilier

      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