CSV import error - Unquoted fields do not allow \r or \n in line 2

Hello, I am trying to use a CSV file to import some observations. I am receiving this error:

Unquoted fields do not allow \r or \n in line 2.

  • Row(s): 2

Could someone help me to explain what I need to change? :) Thank you.

Sounds as though the converter is hitting a line break in your CSV file and thinks, perhaps correctly, that it’s not done parsing the line yet. If the line break occurs in some free text, that text needs to be wrapped in quotes in the CSV file. Don’t know how you generated it, but check the parameters or options on whatever is making the CSV file and it may let you correct that.

just a guess, but maybe in your csv you have a header row (row 1), a blank row (row 2), and additional rows that contain the data. if that’s the case, then maybe delete the blank second row and reload. it would be helpful to be able to see what the contents of your csv look like to do better troubleshooting.

Moved this to “Bug Reports”.

1 Like

I want to import an Observations.org file with additional fields like NUMBER and het OBSERVATION FIELD Osbservado.url. As an example i wanted to use https://www.inaturalist.org/projects/leaf-and-plant-galls/contributors/ahospers because in there leaf-and-plant-galls.csv there are additional fields like ,Tags,Geoprivacy,Host,Reference URL,Gall Location
How did they manage to get those Host,Reference URL,Gall Location fields in their import ?

I started with a dummy project https://www.inaturalist.org/projects/observado-org-observation-org-waarnemingen-be but how to add fields like Number, Host,Reference URL, Observado. URL

Blockquotespecies guess,Date,Description,Location,Latitude / y coord / northing,Longitude / x coord / easting,Tags,Geoprivacy,Host,Reference URL,Gall Location

A hash mark at the start of a row will mean the entire row is ignored

#Lorem,2013-01-01,Description of observation,Wellington City,-41,174,“Comma,Separated”,[Leave blank for ‘open’],taxon,text,“One of Leaf, Stem, Flower, Root”
Ipsum,2013-01-01 09:10:11,“List,Of,Tags”,Private,
Dolor,2013-01-01T14:40:33,Obscured,

https://www.inaturalist.org/observations/import#csv_import

I thought the file beneath worked, but i did not see TAGS

Blockquote Taxon naam , Datum waarneming , Beschrijving , Plaatsnaam , Latitude / y coord / northing , Longitude / x coord / easting , Labels , Geoprivacy
Adoxa moschatellina,1994-05-15 2:54pm,“19940515 Germany - Eifel https://observation.org/waarneming/view/46691641","Germany - Eifel”,50.52865175 , 6.402132511 ,“NJN, zoka”
Ajuga reptans,1994-05-15 2:54pm,"19940515 Germany - Eifel https://observation.org/waarneming/view/46691644 ",“Germany - Eifel”,50.52865175 , 6.402132511 ,“NJN, zoka”

But i do not see TAGS
Adoxa https://www.inaturalist.org/observations/31248048
https://www.inaturalist.org/observations/31246916

Ajuga https://www.inaturalist.org/observations/31248049
https://www.inaturalist.org/observations/31246919

Na example Observation Field Host Plant
image