Load .cypher file in Terminal from Desktop

Neo4j Graph Platform Desktop
,
1

I am using Desktop 1.6.0 on Linux Arch and the project is using 5.26.4.

I have created a model of my graph in Neo4j Data Importer and generated the Cypher script to the file to load the data from my files. Two node files and three relationship files.

The cypher code looks straight forward and no problems. The generated script creates a param for file_path_root & file_(file name).

:param {
// Define the file path root and the individual file names required for loading.
// Default file locations - Operations Manual
file_path_root: "/home/dean/.config/Neo4j Desktop/Application/projects/project-0969176e-a5c9-4018-94d5-4884f84ae28f/", // Change this to the folder your script can access the files at.
file_0: 'aaaaaa.csv',
file_1: 'bbbbb.csv',
file_2: 'ccccccc.csv',
file_3: 'dddddd.csv',
file_4: 'eeeeeee.csv'
};

After opening terminal and connecting to the project (bin/cypher-shell -a bolt://localhost:7687 -u neo4j -p ***). With the ***.cypher file in the project folder, using the call i terminal:

:source /dean/.config/Neo4j Desktop/Application/projects/project****/***.cypher

returns:
Incorrect numbers of arguments.

Which seems to mean it doesn't like the space in the file's path. OK, I can run the .cypher file from a folder that doesn't have a space in the path. This then returns:
Invalid URL and points to an illegal character in the position of the space in the path.

This is the install path of Neo4j, I can't seem to change that. I've searched came across a solution of replacing the space in the call with %20.

returns:
Invalid URL and no protocol.

How am I supposed to call out these files. From Neo4j Browser you call out file:///aaaaaa.csv. In terminal this gives: Cannot find file.

2

Hi Dean, sorry for the inconvenience. I created an internal ticket to fix this. In the mean time a workaround might be to use something like cypher-shell -u neo4j -p password -f 'my/path has spaces/hello.cypher'.

3

You can enclose the path in double quotes when you have spaces in the path.

4

This may work for calling out the .cypher file, but I've been able to call the .cypher file from another location without the space. Then the space in the csv file path stops the script in the .cypher file.

5

I've tried double quotes in every possible combination I can think of. At best I get an illegal character in path error. Where in my code I posted would you recommend putting the double quotes?

6

OK, so I have other issues. I need to go back to the basics of loading from csv.

Loading from csv in browser gives me:

Neo.ClientError.Statement.ExternalResourceFailed

Cannot load from URL 'file:///.csv': Couldn't load the external resource at: file:///.csv

7

I have found several issues trying to do this myself to test for you. I thought the above errors could be fixed by setting the config key equal to true in the neo4j.conf file, but that did not get rid of that error:

dbms.security.allow_csv_import_from_file_urls=true