Now I remove
#dbms.directories.import=import from neo4j.conf
to allow file to be loaded from anywhere and I execute these statements
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});
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});
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 always it says that the I have illegal caracters in the path
please help
Le lundi 26 septembre 2016 12:17:33 UTC+1, Marwa Elabri a écrit :
>
> 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:28EC794B7F093B1D0FBD23024CAB4B2228146F579ACA218C903B24AEF2B137C9)
>> at
>> org.neo4j.bolt.security.auth.BasicAuthentication.authenticate(BasicAuthentication.java:58)
>> at
>> org.neo4j.bolt.v1.runtime.internal.StandardStateMachineSPI.authenticate(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.SessionWorkerFacade.lambda$init$2(SessionWorkerFacade.java:61)
>> at
>> org.neo4j.bolt.v1.runtime.internal.concurrent.SessionWorkerFacade$$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.
