See: https://twitter.com/neo4j/status/448767039516454912
LOAD CSV FROM
"file:/jenkins/workspace/neo4j-2.1-release-candidate/target/community/cypher/cypher-docs/target/docs/dev/ql/import/csv-files/roles.csv"
AS csvLine
MERGE (p:Person { name: csvLine[0]})
MERGE (m:Movie { title: csvLine[1]})
CREATE (p)-[:PLAYED { role: csvLine[2]}]->(m)
On Wed, Mar 26, 2014 at 11:17 AM, <[email protected]> wrote:
> Thanks a lot Micheal. It worked with 2.1.0.
>
> Now, can you please explain how to import from csv without headers. An
> example with a command would be very much helpful.
>
>
> On Wednesday, March 26, 2014 12:30:36 PM UTC+5:30, Michael Hunger wrote:
>
>> Load csv is only available in 2.1 milestone 1
>>
>> Sent from mobile device
>>
>> Am 26.03.2014 um 06:29 schrieb [email protected]:
>>
>> Hi Micheal,
>>
>> Thanks for your reply.
>>
>> I am using Neo4J 2.0.1 and I had placed opencsv-2.3.jar into lib folder (
>> also system/lib does not contain opencsv.jar).
>>
>> But the error I encounter is as follows:
>> ____________________________________________________________
>> ________________________________________________________________________
>> neo4j-sh (?)$ CYPHER 2.1.
>>
>>
>> > load csv with headers from
>> > "file:/home/hduser/Desktop/blogcountrydiet/NODES.csv"
>> as csvimport create (node {name: csvimport.Name, type: csvimport.Type})
>> > ;
>> SyntaxException: Supported versions are: 1.9, 2.0
>> ____________________________________________________________
>> ________________________________________________________________________
>>
>> Please Help!
>>
>> On Tuesday, March 25, 2014 9:01:22 PM UTC+5:30, Michael Hunger wrote:
>>>
>>> Which Neo4j version are you using?
>>>
>>> If you use it from the shell there is still one bug in the Milestone.
>>>
>>> You have to copy opencsv.jar from system/lib to lib/
>>>
>>> And probably use cypher 2.1 as prefix for your LOAD CSV command.
>>>
>>> CYPHER 2.1. LOAD CSV ...
>>>
>>> Please try that.
>>>
>>>
>>> On Tue, Mar 25, 2014 at 4:07 PM, <[email protected]> wrote:
>>>
>>>> Im trying to load a csv file into neo4j using neo4j shell.
>>>>
>>>> load csv with headers from
>>>> "file:/home/hduser/Desktop/blogcountrydiet/NODES.csv"
>>>> as csvimport create (node {name: csvimport.Name, type: csvimport.Type})
>>>>
>>>> But it is throwing error:
>>>>
>>>> ==> Unknown command 'load'
>>>>
>>>> Could not able to import anything into neo4j database.
>>>>
>>>> Can you please tell me the reason or pre-requisites or explain how to
>>>> import csv files??
>>>>
>>>> Thanks in advance.
>>>>
>>>> --
>>>> 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.
>
--
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.
