7 Replies Latest reply on Dec 6, 2016 10:33 AM by andries_heylen

    CSV files fails to import of you have a multi line column that you don't map

    andries_heylen

      Hi

       

      Issue

      When you have a CSV file that has a column with a multiline value (eg it contains carriage returns), FileMaker fails to import the file correctly if that column is not mapped in the import script step.

       

      Steps to reproduce

      1. Create CSV file with following data:

       

      ID, FirstName, LastName, Comment

      1000,Andries,Heylen,

      1001,Mark,Peeters,"This is a nice place,

      I would love to stay more"

      1002,Bart,Candle,"Hello everybody"

      1003,Maria,Geeraarts,

      1004,Gunther,Student,

       

       

       

       

      2. Import this csv file into FileMaker without mapping the "Comment" column

       

      Expected result

      5 records would have been imported

       

      Result

      only the first 2 records are correctly imported, then the 4th is messed up, and maybe other records are correctly imported afterwards.