Handling neo4j error

[bsieva]

WHILE IMPORTING sss.csv file in NEO4J, this error appear.

Neo.ClientError.Statement.SyntaxError
Neo.ClientError.Statement.SyntaxError: Invalid input 's': expected four hexadecimal digits specifying a unicode character (line 2, column 39 (offset: 60))
"LOAD CSV WITH HEADERS FROM 'file:C:\Users\SIEVA-2019.Neo4jDesktop\neo4jDatabases/sss.csv' AS line"

PLEASE, HELP ME HANDLE THIS.

[bsieva]

WHILE IMPORTING sss.csv file in NEO4J, this error appear.

*Neo.ClientError.Statement.SyntaxError*
Neo.ClientError.Statement.SyntaxError: Invalid input 's': expected four hexadecimal digits specifying a unicode character (line 2, column 39 (offset: 60))
"LOAD CSV WITH HEADERS FROM 'file:C:\Users\SIEVA-2019.Neo4jDesktop\neo4jDatabases/sss.csv' AS line"

PLEASE, HELP ME HANDLE THIS.

COMMAND USED:

USING PERIODIC COMMIT
LOAD CSV WITH HEADERS FROM 'file:C:\Users\SIEVA-2019.Neo4jDesktop\neo4jDatabases/sss.csv' AS line
CREATE (:Track { TrackId: line.Id, Name: line.Track, Length: line.Length})

[mark_andrews]

bsieva:

USING PERIODIC COMMIT

It also looks like you are missing the number of records to periodically commit.
"USING PERIODIC COMMIT 500"
I've never tried it without a number so I don't know how it would react.

[david_allen]

Agree with Mark. The file URL for loading paths, even on windows, should look more like this:

file:///C/path/to/file.csv

Note the use of slashes NOT backslashes, and note the specific use of TRIPLE slash after file: that is not a typo.

More information here:

IEBlog

File URIs in Windows

Invalid file URIs are among the most common illegal URIs that we were forced to accommodate in IE7. As I mentioned in a previous blog post there is much confusion over how to handle file URIs. The standard for the file scheme doesn’t give specific...

[mark_andrews]

bsieva:

expected four hexadecimal digits specifying a unicode character

I think the problem is with the \ in the path. If you change that to match the other /, it should work.
"LOAD CSV WITH HEADERS FROM 'file:///C:/Users/SIEVA-2019.Neo4jDesktop/neo4jDatabases/sss.csv'"