What do your files look like? Michael
Am 14.04.2014 um 17:28 schrieb Samantha Zeitlin <[email protected]>: > ok I had missed the instruction to copy the db into graph.db and run neo4j > from inside the bin folder... pretty confusing when there are so many things > with the same names. > > I was able to get it to work with a file that had commas in it (I used the > wrong csv file by accident). Still can't figure out how to add relationships > if I don't know what they are already? > > And when I try to go back and run the import script again with a > tab-delimited "csv" file, I get a java error again? > > ~/Desktop/neo4j-community-2.0.1/batch_importer_20$ ./import.sh test.db > spaced_joined.csv > Usage: Importer data/dir nodes.csv relationships.csv [node_index > node-index-name fulltext|exact nodes_index.csv rel_index rel-index-name > fulltext|exact rels_index.csv ....] > Using: Importer batch.properties test.db spaced_joined.csv rels.csv > > Writing Configuration File to batch.properties > > Total import time: 1 seconds > Exception in thread "main" java.lang.IllegalArgumentException: Unknown Type 0 > at org.neo4j.batchimport.importer.Type.fromString(Type.java:172) > at > org.neo4j.batchimport.importer.AbstractLineData.createHeaders(AbstractLineData.java:46) > at > org.neo4j.batchimport.importer.CsvLineData.<init>(CsvLineData.java:16) > at org.neo4j.batchimport.Importer.createLineData(Importer.java:173) > at org.neo4j.batchimport.Importer.importNodes(Importer.java:93) > at org.neo4j.batchimport.Importer.doImport(Importer.java:228) > at org.neo4j.batchimport.Importer.main(Importer.java:83) > > In spite of this error and no message about nodes imported, I get a folder > full of files. But when I look at it, there's no data. > > > > > On Friday, April 11, 2014 4:07:03 PM UTC-7, Michael Hunger wrote: > Hi Samantha, > > glad that you made it so far. > > You imported the data into the "target/db" directory. Please note that this > directory as it resides in "target" might be deleted if you run "mvn clean" > which cleans out the whole "target" directory. > So better specify a different directory to import into like "graph.db" > (without the target/ ) > > To use it with the server you have to copy the _contents_ of that directory, > into /path/to/neo4j-server/data/graph.db > eg. > > cp -r target/db/* /path/to/neo4j-server/data/graph.db > > And only after that start the server > > If you use neo4j-shell without a server you also have to provide the path > > neo4j-shell -path target/db > > Please try, that and it would be awesome if you would write it up in a blog > post. > > P.S. Did you see the "binary download" instructions? Should be much easier: > > https://github.com/jexp/batch-import/tree/20#binary-download > > Cheers, > > Michael > > Am 11.04.2014 um 20:09 schrieb Samantha Zeitlin <[email protected]>: > >> >> I'm trying to use the batch-importer for a single, csv file (2086 rows) on >> Mac. I'm new to neo4j. Sat in on an "intro" session at Hackbright not too >> long ago, went through some of the tutorials, and actually interacting with >> the database looks pretty straightforward once it has been built. >> >> But I'm stuck on the very first step: trying to build one and look at it. >> >> I'm just blindly following instructions, I don't really know what I'm doing >> here. Here follows a list of what I did: >> >> At first, the old version of batch-importer seemed (?) to work. I followed >> the instructions on Max Demarzi's blog post, i.e. >> http://maxdemarzi.com/2012/02/28/batch-importer-part-1/ >> >> my csv file looks something like this : >> >> Unnamed: 0 people users refs >> 0 0c8e29fd23c6 a974d06d9187 >> 1 0c8e29fd23c6 c798a44cc829 0012d39f387d >> 2 0c8e29fd23c6 7d54ec992072 0134e76e7738 >> 3 0c8e29fd23c6 52380be9221f 0153923edd56 >> ... >> >> >> (these would all be nodes, I want to add the relationships after import >> using something like this: >> http://stackoverflow.com/questions/13823988/batch-insertion-with-neo4j) >> >> >> So first I ran this command: java -server -Xmx4G -jar >> target/batch-import-jar-with-dependencies.jar target/db myfile.csv >> >> and it looked like it ran correctly, because I got things that look like >> this: >> >> Importing 34400 Nodes took 0 seconds >> >> Total import time: 2 seconds >> >> and a target folder full of files: >> >> bash-3.2$ ls >> active_tx_log >> neostore.propertystore.db.index.keys >> index >> neostore.propertystore.db.index.keys.id >> messages.log >> neostore.propertystore.db.strings >> neostore >> neostore.propertystore.db.strings.id >> neostore.id neostore.relationshipstore.db >> neostore.nodestore.db >> neostore.relationshipstore.db.id >> neostore.nodestore.db.id >> neostore.relationshiptypestore.db >> neostore.propertystore.db >> neostore.relationshiptypestore.db.id >> neostore.propertystore.db.arrays >> neostore.relationshiptypestore.db.names >> neostore.propertystore.db.arrays.id >> neostore.relationshiptypestore.db.names.id >> neostore.propertystore.db.id nioneo_logical.log.active >> neostore.propertystore.db.index tm_tx_log.1 >> neostore.propertystore.db.index.id >> >> So I thought that looked ok. Then, to start the server, I typed: >> >> neo4j start >> >> and in the browser I went to http://localhost:7474 >> >> And I can see the Neo4j dashboard, etc. but I didn't see anything under the >> data tab. >> >> ??? >> >> So although there seem to be .db files, there is no graph.db file, and I'm >> not sure how to do anything if I can't actually view my data after it has >> been imported? I tried viewing the .db files themselves, and they're not >> human-readable (binary hashes?), so I don't know if that step actually >> worked correctly? >> >> >> So I googled around some more and thought maybe the problem is that my >> database isn't connected to the server. So next I tried: >> >> neo4j-shell >> >> and it said: >> >> NOTE: Remote Neo4j graph database service 'shell' at port 1337 >> >> and if I go to http://localhost:1337, the page is blank, which makes sense. >> >> So then I tried: >> >> neo4j-shell -path db >> >> but it said: >> >> ERROR: java.io.FileNotFoundException: /db/messages.log (No such file or >> directory) >> >> Which is clearly confusing me, since if you look above, there is indeed a >> messages.log file in the /db folder. And when I view it, there is a lot of >> stuff in there, and no big warning or error labels that I can see (?). >> >> But then I realized I'm using the new (2.0.1) community version of neo4j, >> and wondered if that might be part of the problem? So, I tried following the >> directions to use the batch-importer-20 version, but it's giving me >> different java errors. Someone else on the google group seemed to have a >> similar problem: >> >> Exception in thread "main" java.lang.NoClassDefFoundError >> >> and it looked like you advised them to use import-mvn.sh instead of >> import.sh, so I tried that, but maven is saying there are no projects to >> compile. Which makes sense, I think, I just don't know what to do about it? >> >> So... >> >> I really just need step-by-step instructions, and I can't find them >> anywhere. Or at least, the ones I found that looked simple, are either out >> of date (like @maxdemarzi's site) and/or didn't work for me, maybe because >> I'm missing some (probably really simple) steps/details in how to execute >> them? >> >> I'm thinking if I can get this to work, I might write it up in a blog post, >> since I don't think I'm the only one who wants to use neo4j this way (?). >> >> Thanks for any help you have time to provide. >> >> Sam >> >> >> -- >> 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.
