cancel
Showing results for 
Search instead for 
Did you mean: 

Head's Up! These forums are read-only. All users and content have migrated. Please join us at community.neo4j.com.

Using ID spaces with apoc.import.csv throws error

neo4j version: 3.4.9, apoc-3.4.0.6-all.jar
Using ID spaces with apoc.import.csv throws the following error and fails.

Neo.ClientError.Procedure.ProcedureCallFailed: Failed to invoke procedure `apoc.import.csv`: Caused by: java.lang.IllegalStateException: No match found

My test file is:
orgid:ID(Org-ID),permid:INT,name:STRING
1,10,Google
2,20,Apple
3,30,Boeing
And I am calling like this:

CALL apoc.import.csv([{fileName: 'file:/tmp/org.csv', labels: ['Organization']}], [], {})

Without the ID spaces it works. Manual says it should work with ID spaces. What is that I am missing here.

Pranab

1 REPLY 1

Hi Pranab,

a bit belatedly but here's why it failed: the id spaces are parsed using regular expressions and Org-ID does not match \w+. Use OrgId or something similar instead.

Gabor