2 Replies Latest reply on Jun 11, 2016 11:05 AM by kurt.bleicken

    .csv import question ...

    kurt.bleicken

      When importing a .csv file do the fields after the first row need to be surrounded by quotation marks?

       

      I thought that if they were not surrounded by "   "  then

       

      c/o Smith, Night, Day & Morning       would foul up the import order. i.e. FM would wee the commas and think it meant that 'Night' was the next field content. However, that doesn't seem to be happening the whole c/o Smith, Night, Day & Morning is importing correctly.

        • 1. Re: .csv import question ...
          beverly

          what do your dialogs look like when importing the .csv?

          There is a choice of making the first row the field/column names. Those are not quoted.

          But, yes! for the following rows, the content (except numbers) needs to be quoted in each column.

           

          Importing by Tab-delimited does not have quoted columns (or comma-separated).

           

          A way to 'test' is to stop at the column/field matching and "scroll" through the records that might be imported (the triangle-arrows). If you see there is a problem, don't complete the import.

           

           

          beverly

          • 2. Re: .csv import question ...
            kurt.bleicken

            Thanks Beverly.