Sorry wrong clipboard content :) http://docs.neo4j.org/chunked/milestone/import-importing-data-from-a-single-csv-file.html
On Wed, Mar 26, 2014 at 11:32 AM, Michael Hunger < [email protected]> wrote: > 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.
