5 Replies Latest reply on Sep 13, 2012 10:24 AM by consulting17

    Importing .csv files

    consulting17

      Can anyone help me??? I'm trying to import a .csv file into Filemaker Pro11 Advanced and keep getting error msg that all records skipped do to error.

        • 1. Re: Importing .csv files
          beverly

          what format is the .csv? If it's NOT exactly as it should be:

                

          • double-quoted text

                

          • no quotes on numbers is ok

                

          • comma (",") between all values/cells/fields

                

          • return-delimited between rows/records

                

          • exact number of columns in each row

           

          ... then you will have failure. Are you specifying ".csv" as import type? are you trying to import into existing table? if so, how do you match names?

           

          not enough info to answer fully,

          Beverly

          • 2. Re: Importing .csv files
            consulting17

            thank you for your help Beverly, I'm trying to import into an existing table. The fields appear to be identical

            • 3. Re: Importing .csv files
              beverly

              "fields appear to be identical". Do you have a .csv with the first row as field names?

               

              if you see the names, have you selected "matching names" or are you relying on custom order?

              Are you posting a graphic of your import dialog to this forum? I'm on email and haven't checked. If not, please do!

               

              Beverly

              • 4. Re: Importing .csv files
                ch0c0halic

                Do you have any field validations?

                If you have a field that requires a value yet are importing nothing into it.

                If there is an Auto-Enter field but you didn't check "Allow auto-enter options while importing…" during the import.

                • 5. Re: Importing .csv files
                  consulting17

                  thank you very much, the problem was in the validations for two of my fields. This is my first time on this site and am greatful for everyones help.