Importing data from FileMaker

Support
1

Hi,

I’m getting this error when trying to import data in a table from CSV file (UTF-8) of FMP.
Included the CSV first line.

"24","M.","Denis","April","Denis April","Denis April","April Denis","Denis April","A","Photo","Entreprise Levisiennes","","","","ent.levisiennes@videotron.ca","","","Décédé le 26 octobre 2014","(418) 831-4111","(418) 254-5808","Aucun","Aucun","215, rue Principale","","Saint-Étienne","Québec","G6J 1E8","Canada","Saint-Étienne, G6J 1E8","","","","Québec","","","http://www.fr.canada411.ca/search/?stype=re&pac=418&pex=833&pnum=2181&x=-635&y=-371","1980-01-01","Non membre","2014-09-28","","","",""

Something to do with empty field (“”)?

Thank you.

Import
Import1652×322 38.5 KB

2

Hi f.i.SCIENCES,

Am I able to get your table definition so we can test it here and ensure everything is going into the right fields, as I have already ensured it is a valid CSV.

Thanks, this would be helpful.

1 Like
3

Hi f.i.SCIENCES,

We have done a few tests here and we believe you have 43 fields based on the data provided. Can you please ensure the following:

  1. When you import your csv file ensure you have the column names included prior to the data. Example:
    Field 1, Field 2, Field 3
    data1, data2, data3

  2. Make sure a comma prior to your data which comes after the primary key because on our investigation the primary key is not exported from FileMaker. We will generate your primary key on import. Please have a look at the following link to know how to generate the primary key field.

Import and Export CSV Files | Five | Low-Code For Real Developers

Your csv file should be similar to this:
PrimaryKey, Field 1, Field 2, Field 3
,data1, data2, data3

We used your data that you provided and imported into a ‘test’ table and we got it working. We used the following, however, you would need to change the column headers to your names.

The Bold is the column headers and then the data that you provided us with the extra comma.

TableTestKey,Field1,Field2,Field3,Field4,Field5,Field6,Field7,Field8,Field9,Field10,Field11,Field12,Field13,Field14,Field15,Field16,Field17,Field18,Field19,Field20,Field21,Field22,Field23,Field24,Field25,Field26,Field27,Field28,Field29,Field30,Field31,Field32,Field33,Field34,Field35,Field36,Field37,Field38,Field39,Field40,Field41,Field42,Field43
,“24”,“M.”,“Denis”,“April”,“Denis April”,“Denis April”,“April Denis”,“Denis April”,“A”,“Photo”,“Entreprise Levisiennes”,“”,“”,“”,“ent.levisiennes@videotron.ca”,“”,“”,“Décédé le 26 octobre 2014”,“(418) 831-4111”,“(418) 254-5808”,“Aucun”,“Aucun”,“215, rue Principale”,“”,“Saint-Étienne”,“Québec”,“G6J 1E8”,“Canada”,“Saint-Étienne, G6J 1E8”,“”,“”,“”,“Québec”,“”,“”,“http://www.fr.canada411.ca/search/?stype=re&pac=418&pex=833&pnum=2181&x=-635&y=-371",“1980-01-01”,"Non membre”,“2014-09-28”,“”,“”,“”,“”

Let me know if this works for you.