Probably something about the escaping. The other issue you got were missing or wrong username/password.
On Mon, Sep 26, 2016 at 1:17 PM, Marwa Elabri <[email protected]> wrote: > Sorry when I made this > I tried this one > LOAD CSV WITH HEADERS FROM "file:///C:/Program > Files/PostgreSQL/9.2/data/course.csv" AS row > CREATE (:Course {name: "Course" + row.id, difficulty: row.difficulty}); > > But Igot the this error > Caused by: org.neo4j.cypher.internal.frontend.v3_0.SyntaxException: > Invalid input 'c': expected '\', ''', '"', 'b', 'f', 'n', 'r', 't', '_', > '%', UTF16 or UTF32 (line 1, column 82 (offset: 81)) > > > > > > Le lundi 26 septembre 2016 12:10:04 UTC+1, Marwa Elabri a écrit : >> >> This what I have in neo4j.conf >> >> # This setting constrains all `LOAD CSV` import files to be under the >> `import` directory. Remove or uncomment it to >> # allow files to be loaded from anywhere in filesystem; this introduces >> possible security problems. See the `LOAD CSV` >> # section of the manual for details. >> #dbms.directories.import=import >> >> >> And this is the error in the database logs >> >> 03:48.655+0000 ERROR [o.n.b.v.r.i.ErrorReporter] >> org.neo4j.bolt.security.auth.AuthenticationException: Authentication >> token must contain: 'scheme : basic' (ID:28EC794B7F093B1D0FBD23024C >> AB4B2228146F579ACA218C903B24AEF2B137C9) >> at org.neo4j.bolt.security.auth.BasicAuthentication.authenticat >> e(BasicAuthentication.java:58) >> at org.neo4j.bolt.v1.runtime.internal.StandardStateMachineSPI.a >> uthenticate(StandardStateMachineSPI.java:116) >> at org.neo4j.bolt.v1.runtime.internal.SessionStateMachine$State >> $1.init(SessionStateMachine.java:77) >> at org.neo4j.bolt.v1.runtime.internal.SessionStateMachine.init( >> SessionStateMachine.java:641) >> at org.neo4j.bolt.v1.runtime.internal.concurrent.SessionWorkerF >> acade.lambda$init$2(SessionWorkerFacade.java:61) >> at org.neo4j.bolt.v1.runtime.internal.concurrent.SessionWorkerF >> acade$$Lambda$177/1559497201.accept(Unknown Source) >> at org.neo4j.bolt.v1.runtime.internal.concurrent.SessionWorker. >> execute(SessionWorker.java:116) >> at org.neo4j.bolt.v1.runtime.internal.concurrent.SessionWorker. >> run(SessionWorker.java:77) >> at java.lang.Thread.run(Unknown Source) >> >> >> I tried this one >> LOAD CSV WITH HEADERS FROM "file:///C:/Program >> Files/PostgreSQL/9.2/data/course.csv" AS row >> CREATE (:Course {name: "Course" + row.id, difficulty: row.difficulty}); >> >> But Igot the same error >> >> >> >> >> >> Le lundi 26 septembre 2016 11:35:07 UTC+1, Michael Hunger a écrit : >>> >>> Check the database logs and share the error? >>> >>> I presume you mean the Neo4j driver? >>> >>> Make sure you provide the csv data in the configured (in neo4j.conf) >>> import directory. >>> >>> You might also have one slash too much. >>> >>> If you put your data into the import directory a file:///course.csv" >>> should be good enough >>> >>> >>> >>> On Mon, Sep 26, 2016 at 12:19 PM, Marwa Elabri <[email protected]> >>> wrote: >>> >>>> I execute this statement on neo4j version 1.1 RC-2 >>>> USING PERIODIC COMMIT LOAD >>>> CSV WITH HEADERS FROM 'file:\\C:\\Program >>>> Files\\PostgreSQL\\9.2\\data\\course.csv' >>>> AS row >>>> CREATE (:Course {name: "Course" + row.id, difficulty: >>>> row.difficulty}); >>>> >>>> but I get this error : >>>> >>>> An unexpected failure occurred, see details in the database logs, >>>> reference number 2c7fc132-9b14-421c-b5af-1412938013bf. >>>> >>>> However, I used it before and It runs >>>> >>>> please any help >>>> >>>> -- >>>> You received this message because you are subscribed to the Google >>>> Groups "Neo4j" group. >>>> To unsubscribe from this group and stop receiving emails from it, send >>>> an email to [email protected]. >>>> For more options, visit https://groups.google.com/d/optout. >>>> >>> >>> -- > You received this message because you are subscribed to the Google Groups > "Neo4j" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > For more options, visit https://groups.google.com/d/optout. > -- You received this message because you are subscribed to the Google Groups "Neo4j" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
