neo4j-devtools / neo4j-desktop

The Neo4j Graph Platform, on your desktop OS.
19 stars 1 forks source link

Cannot find import folder on Win11 after upgrade to 4.4.5 and desktop 1.4.15 #122

Closed ForFriars closed 1 year ago

ForFriars commented 1 year ago

Upgraded to 4.4.5 Saturday, 23 Sept, on Windows 11 and Desktop version 1.4.15 and neo4j-browser/v4.4.7

Now 8 saved "favorite" scripts cannot find the corresponding files. Load CSV with Headers from 'file:///FraternitiesGuardiansLoadClean.csv'as row Returns error message: Couldn't load the external resource at: file:/FraternitiesGuardiansLoadClean.csv

Graph database opened fine and queries running ok. Database schema looks ok.

Found an import folder and confirmed the .csv files are in the folder. C:\Users\drade.Neo4jDesktop\relate-data\dbmss\dbms-a7895407-9f08-4263-bfe2-36f81c425627\import>dir Volume in drive C is Local Disk Volume Serial Number is 3083-64C1

Directory of C:\Users\drade.Neo4jDesktop\relate-data\dbmss\dbms-a7895407-9f08-4263-bfe2-36f81c425627\import

09/24/2022 08:07 AM

. 08/20/2022 06:49 AM .. 08/21/2022 02:45 PM 16,987 FraternitiesGuardiansLoad.csv 09/24/2022 07:06 AM 43,869 FraternitiesGuardiansLoadClean.csv 08/21/2022 07:46 AM 44,441 FriarBirthday.csv 08/21/2022 06:56 AM 38,071 FriarEmail.csv 08/21/2022 07:52 AM 25,559 FriarFeast.csv 08/20/2022 07:52 AM 78,213 FriarLoadFile.csv 08/21/2022 06:57 AM 44,438 FriarMobile.csv 08/21/2022 07:29 AM 47,869 FriarNameLoad.csv 08/21/2022 02:30 PM 91,854 FriarResidence.csv 08/20/2022 06:54 AM 262,569 Friars.csv 08/20/2022 03:50 PM 59,114 LocationLoad.csv 11 File(s) 752,984 bytes 2 Dir(s) 416,540,151,808 bytes free

Clue: URI is not hierarchical, reference 1f086ced-78f7-4221-a1aa-87f8aab874a6. org.neo4j.fabric.executor.FabricException: URI is not hierarchical

Desktop 4.4.5 ... Open folder ... menu works as expected for each item EXCEPT import

I tried editing the config file ... default was no # before the dbms.directories.import So, I added # (comment out), Noticed that the other dbms.directories have # , so tried removing the # from all including import

Current config file content

The name of the default database.

dbms.default_database=neo4j

Paths of directories in the installation.

dbms.directories.data=data

dbms.directories.plugins=plugins

dbms.directories.logs=logs

dbms.directories.lib=lib

dbms.directories.run=run

dbms.directories.licenses=licenses

dbms.directories.metrics=metrics

dbms.directories.transaction.logs.root=data/transactions

dbms.directories.dumps.root=data/dumps

This setting constrains all LOAD CSV import files to be under the import directory. Remove or comment it out to

allow files to be loaded from anywhere in the filesystem; this introduces possible security problems. See the

LOAD CSV section of the manual for details.

dbms.directories.import=import

tried replacing import with

C:\Users\drade.Neo4jDesktop\relate-data\dbmss\dbms-a7895407-9f08-4263-bfe2-36f81c425627\import

Got "trying to open undefined directory"

Replaced the back slash with forward slash .... same error message.

Day five of trying to find someone on discord or in the neo4j community ... @Håkan Löfqvist has been most helpful. Made the recommendation for the complete path but not clear on slash type so I tried and failed with both. Still stuck.

Dave

ForFriars commented 1 year ago

https://discord.com/channels/787399249741479977/818578585194594334/1023254988950077571

https://discord.com/channels/787399249741479977/816627121732059146/1024104764650295416

ForFriars commented 1 year ago

Solution: Move the import folder to the C: drive root ... "c:\" Edit the neo4j config file (NOT the CONF-DEFAULT file) with dbms.directories.import=c:/import Save neo4j ... (my version has only three lines) Start neo4j Desktop

More on Discord: https://discord.com/channels/787399249741479977/816627121732059146/1025052439772147763