Downloaded the "latest" apoc jar file. 275 procedures but no export.csv.* ... here is the e to g range of procedure names...only cypher and graphml ...
apoc.es.stats, apoc.example.movies, apoc.export.cypher.all, apoc.export.cypher.data, apoc.export.cypher.graph, apoc.export.cypher.query, apoc.export.cypherAll, apoc.export.cypherData, apoc.export.cypherGraph, apoc.export.cypherQuery, apoc.export.graphml.all, apoc.export.graphml.data, apoc.export.graphml.graph, apoc.export.graphml.query, apoc.generate.ba, On Tuesday, November 22, 2016 at 2:51:40 AM UTC-8, Michael Hunger wrote: > > I added CSV export to apoc via apoc.export.csv.query(query, file, config). > > Please have a look at let me know if it makes sense. > > see: https://neo4j-contrib.github.io/neo4j-apoc-procedures/#_export_import > you'll have to set `apoc.export.file.enabled=true` in your neo4j.conf see > https://neo4j-contrib.github.io/neo4j-apoc-procedures/#_configuration_options > > Michael > > On Tue, Nov 22, 2016 at 7:19 AM, Michael Hunger < > michael...@neotechnology.com <javascript:>> wrote: > >> Your use-case is interesting, grab me on neo4j.com/slack and we can chat >> about the procedure. >> >> Should be easy to add. >> >> Michael >> >> On Tue, Nov 22, 2016 at 7:13 AM, Glenn Hoetker <ghoe...@gmail.com >> <javascript:>> wrote: >> >>> Dear Michael, >>> >>> Thank you very much for the quick and helpful answer. Much appreciated. >>> >>> Glenn >>> >>> On Monday, November 21, 2016 at 11:09:37 PM UTC-7, Michael Hunger wrote: >>>> >>>> There is currently no "simple" export command, but I want to add one to >>>> the apoc procedure library, just haven't gotten around to do it. >>>> >>>> https://github.com/neo4j-contrib/neo4j-apoc-procedures/issues/117 >>>> >>>> Meanwhile if you can run neo4j-shell you could use: >>>> https://github.com/jexp/neo4j-shell-tools#export >>>> >>>> On Tue, Nov 22, 2016 at 12:07 AM, Glenn Hoetker <ghoe...@gmail.com> >>>> wrote: >>>> >>>>> Hi all. >>>>> >>>>> I'm struggling with something that seems like it should be so simple >>>>> that I'm convinced I'm just missing something. I wish to use Neo4j as >>>>> part >>>>> of analyzing a large database of patents. The FINAL step will be to use >>>>> data derived via Neo4j to do statistical analysis. The easiest way to >>>>> get >>>>> the derived data into my statistical software would be as a CSV. >>>>> Consider >>>>> a super simple example, calculating how many patents each inventor >>>>> (identified by "hanId") has invented. >>>>> >>>>> In the browser, I can run the command >>>>> >>>>> match (i:Inventor)-[:Invented]->(p:Patent) return i.hanId as Inventor, >>>>> count(p) as Patents limit 100 >>>>> >>>>> To get the results of that query to a csv file, I >>>>> >>>>> a) press the export file button in the results pane >>>>> b) choose CSV >>>>> c) go to the new tab >>>>> d) save it, including selecting a directory and filename using the >>>>> file dialog. >>>>> >>>>> It gives me just what I want >>>>> >>>>> Inventor,Patents >>>>> 3342952,1 >>>>> 1484384,1 >>>>> 3554015,1 >>>>> 9816,11 >>>>> >>>>> but with many more steps than seems like should be required. In my ideal >>>>> world, there would be an "Export" command, allowing me to do something >>>>> like this to replace steps (a) through (d) >>>>> >>>>> >>>>> match (i:Inventor)-[:Invented]->(p:Patent) return i.hanId as Inventor, >>>>> count(p) as Patents limit 100 export "/Users/Me/patentCount.csv" replace >>>>> >>>>> That doesn't exist (yet??!! Maybe?? Please??). But, I have to think there >>>>> is some way to do this programmatically that I just haven't found. The >>>>> "manual" approach isn't really viable given the number of derived >>>>> statistics required, how long some of the queries will take, and the need >>>>> for reproducability (step (d) in particular is not cool for reproducible >>>>> science). >>>>> >>>>> >>>>> Like I said, I feel like I'm just overlooking something simple here. Can >>>>> anyone point me in the right direction? >>>>> >>>>> >>>>> Thank you. >>>>> >>>>> >>>>> Glenn >>>>> >>>>> -- >>>>> 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 neo4j+un...@googlegroups.com. >>>>> 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 neo4j+un...@googlegroups.com <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 neo4j+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
