How to set apoc.export.file.enabled=true in Neo4j

Question

I am using the APOC library of Neo4j to export the results of a Cypher query to a CSV file. However, I get the following error message:

Failed to invoke procedure `apoc.export.csv.query`: Caused by: java.lang.RuntimeException: Export to files not enabled, please set apoc.export.file.enabled=true in your apoc.conf.

Otherwise, if you are running in a cloud environment without filesystem access, use the `{stream:true}` config and null as a 'file' parameter to stream the export back to your client.

There is no apoc.conf file, so I added "apoc.export.file.enabled=true" to neo4j.conf file, but Neo4j failed to restart after adding "apoc.export.file.enabled=true". How can I fix this error?

Answer 1

You need to create an "apoc.conf" file in the same folder as your "neo4j.conf" file. The "neo4j.conf" file should be present in the "conf" folder of the graph you are running. 

To locate the "conf" folder, 

• click on "..." near the start/stop button of your graph on Neo4j Desktop.
• on the pop-up menu, click on "Terminal" to open the terminal.
• on the terminal, run "ls -l" and it will show you the "conf" folder.
• run "cd conf" to go to the "conf" folder.

Once inside the "conf" folder, create a new file "apoc.conf" and add line "apoc.export.file.enabled=true".

Now restart Neo4j, and you should not get the error.