LOADING CSV

Neo4j Graph Platform
1

Hello

please some help I used the below code to load my CSV file on Neo4j

LOAD CSV WITH HEADERS FROM "file:///C:/modules.CSV" AS Modules create(:Modules{mod_code:Modules .mod_code,old_code:Modules.old_code,title:Modules.title,credits:toInteger(Modules.credits),level:toInteger(Modules.level),semester:Modules.semester,pre_requisite:Modules.pre_requisite,Module_leader:Modules.module_leader})

the property key for the semester was not created and was not uploaded all other property key was created except from the semester

someone, please help

below is the property I intend to create and load on my database

semester

S1

S2

S2

S1

S1

S2

S2

S1

S2

unknown

S1

S1 and S2

S1 and S2

S2

S2

S1

S1

S1

S2

S1

S2

S1

S1

S1

S2

S2

S1

S1

S2

S2

S1

unknown

unknown

unknown

S1

S2

S1

S1

unknown

S2

S1

S2

S2

S1

S1

S2

S2

unknown

unknown

unknown

S1 and S2

2

Could the be a space following 'semester' in your spreadsheet? Can you provide the first few lines of your csv file?

3

sorry how do you mean the first few lines?

because what I provided is the part of the CSV that didn't upload

4

@glilienfield it works fine now you were right there was space on the csv file thank you

5

It may help if I can see the data. Also, did you check to verify there are no spaces after the word 'semester' in the header line of your csv file.