Only imports 1 row from csv
neo4j@basaltaura.nl
Hi at Neo4j, I set up a Neo4j free AuraDB cloud account and use https://data-importer.neo4j.io/ to import from a csv file (sample Dutch BAG address data downloaded from https://geocatalogus.nl/dataset/bag-cbs-adressen-basis/resource/ecbe6732-5a6b-4858-84db-b03c410ff7aa). However, import only gives me the first record. Is this working as expected or should I adjust something to import complete file (178 records).
Gregory King
Hi, can you share more details of your model such as the node you were creating and what ID it used that resulted in only 1 row being loaded? Thanks!
neo4j@basaltaura.nl
Gregory King: Hi Gregory, here is the header and first two records:
_id,openbareruimte,huisnummer,huisletter,huisnummertoevoeging,postcode,woonplaats,gemeente,provincie,object_id,object_type,nevenadres,x,y,lon,lat
1,Revaleiland,446,"","",1014ZG,Amsterdam,Amsterdam,Noord-Holland,363010012127937,VBO,f,120595.409,489706.904,4.88175301801513,52.3941286651264
2,Nieuwe Looiersstraat,71,A,"",1017VB,Amsterdam,Amsterdam,Noord-Holland,363010001165473,VBO,f,121516,485954,4.89565126411048,52.3604571877261
I'm using _id as ID. I attached a screenshot of the model, let me know if there is a better way to share this info.
Gregory King
neo4j@basaltaura.nl: Hey, thanks for sharing more info. This looks like the problem is related to character encoding. The file as downloaded from the site you linked to has the file in the encoding
us-ascii
. I'm not yet completely clear why Data Importer is failing, but we know it is generally much more reliable to have files in the more widely used utf-8
encoding. I tried with a utf-8
encoded version of the file and it seems to work fine.In the meantime while we're looking into it, please use something like to following *nix command to convert your file character encoding to
utf-8
:iconv -f MACROMAN -t UTF-8 input.csv output-utf8.csv