Sunday, 15 May 2011

csv - SyntaxException with Neo4j LOAD command -



csv - SyntaxException with Neo4j LOAD command -

i'm using neo4j 2.1.2 windows attempting utilize neo4j's load csv command next error...

neo4j-sh (?)$ load csv headers "file:../test/unclaimed.csv" csvline merge (o:original_transaction_number { value: csvline.otn }) merge (i:institution {name: csvline.institution }) merge (i)<-[:transaction_of]-(o) ; syntaxexception: invalid input 'l': expected <init> (line 1, column 1) "load csv headers "file:../test/unclaimed.csv" csvline" ^

infact same error entering load

neo4j-sh (?)$ load ; ==> syntaxexception: invalid input 'l': expected <init> (line 1, column 1) ==> "load " ==> ^

could explain what's happening?

(edit:)->(fixed)->(the problem)

combination of issues here.

i had before tried upgrading 2.1.2 extracting files 2.0.3 folder - fixed - @stefan

fixing 1. , prefixing "cypher 2.1" (thanks @michael) gave more informative error "syntaxexception: invalid input '"': expected whitespace, comment or (line 1, column 23) - i missing keyword

after getting many "loadexternalresourceexception: couldn't load external resource at: file:../test/unclaimed.csv" , many variants of "file://c:/nosql/test/" etc i finally figured syntax accessing local file on windows "file:c:/nosql/test/unclaimed.csv" , not file:// might inferred examples on http://neo4j.com/docs/2.1.2/cypherdoc-importing-csv-files-with-cypher/ or familiar uri schema

thanks folks

csv neo4j load uri filenames

No comments:

Post a Comment