andries_heylen

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

Discussion created by andries_heylen on Nov 3, 2016
Latest reply on Dec 6, 2016 by 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.

Outcomes