Importing CSV doesn't work properly

[mehdi_ajroud]

Hey everyone ,

I am using this query to import my CSV file :

LOAD CSV WITH HEADERS FROM 'file:///Contrats2018.csv' AS Contracts FIELDTERMINATOR ';'
CREATE (c:Contrat18 { id:Contracts.contract_id , cpv:Contracts.contract_CPV_3_digits})

And after executing , I find the same number of nodes that I have in my file but for IDs they re just generated by neo4j for my nodes , and it doesn't import my properties .
Help please !!

[Benoit]

Can you give the result of this query : MATCH (c:Contrat18) RETURN c LIMIT 5 ?

Can you also share the header of your csv ?

[mehdi_ajroud]

Hey Benoit ,

Here is the file csv that I am using

and here is the result after importing in neo4j :

Knowing that I imported other nodes and I have all properties .

[12kunal34]

Hi mehdi ,

could you please open your file in notepad and share it.
i doubt that it is not ' ; ' separated

[mehdi_ajroud · Accepted solution]

exactly ! that's why I added FIELDTERMINATOR ';'