ok, I don't know what happened before, my file looked screwy so I re-exported my file and re-imported it, and this time it worked, no errors.
Now I just need to figure out how to get the relationships… In the meantime, I'll write down what I did before I forget… many thanks for your help! :) sam On Monday, April 14, 2014 8:40:34 AM UTC-7, Michael Hunger wrote: > > What do your files look like? > > Michael > > Am 14.04.2014 um 17:28 schrieb Samantha Zeitlin > <[email protected]<javascript:> > >: > > 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] <javascript:>. > 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.
