3 Replies Latest reply on May 8, 2012 8:12 PM by jimlongo

    Strange csv import problem

    jimlongo

      Title

      Strange csv import problem

      Post

      Hi, I have an import that I do from a csv file that I download from a database on the web.

      There are 3 csv files.

      I import them one at a time into FM11.  I have been doing this on 2 computers (a MacPro and an iMac) for a couple of years without any problem.

      I just installed FileMaker on a MacBook.  The first 2 csv files import just as usual, but the 3rd one which is the simplest always fails with the Import Records Summary dialog indicating 

       

      Total records added / updated: n    (where "n" is the number of records in the file)
      Total records skipped due to errors: n
      Total fields skipped due to errors: n
      Table created: <none>
       

      It's odd because the same file will import just fine into the same database (using Dropbox to share the files) on the other 2 computers.

      Anyone come across something like that before?

       

      Thanks,

      jim

        • 1. Re: Strange csv import problem
          davidanders

          Import the problem CSV file into one of the two working databases.

          Immediately export the imported records from FMP to a file.

          Try to import the export into the problem database.

          If it works, the problem could be an anomalous character, or an OSX version quirk.

          • 2. Re: Strange csv import problem
            jimlongo

            Thanks david,

            There is only 1 database file.  It's being shared through Dropbox.

            I just open it on whichever computer i'm on, download the 3 csv files via web browser and import.

            It's the same OS on all 3 computers, same version of FM.

            I even transferred the problem csv file via Dropbox so that i could eliminate any download differences.

            I guess it's some hardware thing except for the fact that the first 2 csv files import without problem, it's only the 3rd one that errors.  I'm scratching my head trying to figure out what's different about the third file import.

             

            • 3. Re: Strange csv import problem
              jimlongo

              hmmm . . . what's different?

              System Preferences -> Language & Text -> Formats 

              There is one import field that is a timestamp.

              Just ensured the prefs match and it works now.