Relationships not created in MYSQL

[davidmeza1]

I am importing a MySQL DB. When mapping, I get the nodes, however none of the relationships are created between the nodes. The relationships (foreign keys) are set up in the MySQL db. Also, if I go ahead a try to load the nodes using Batch import, I get the following error:

Creating Neo4j store from CSV...

• Direct driver instance 1406014249 created for server address localhost:7687
• Start Importing CSV nodes...
• Creating constraints on nodes...
• Created constraints
• Creating nodes...
• Creating node with label WorkValue
• Creating node with label ToolUse
• Closing driver instance 1406014249
• Closing connection pool towards localhost:7687
• Command failed due to error (IndexOutOfBoundsException: Index: 5, Size: 5). Rerun with --debug flag for detailed diagnostic information.

I get this error when tring Load CSV through tool:

Export time: 9.374 (s)

• Creating Neo4j store from CSV...
• Direct driver instance 70323523 created for server address localhost:7687
• Command failed due to error (ClientException: Couldn't load the external resource at: file:/Users/dmeza/Library/Application%20Support/Neo4j%20Desktop/Application/neo4jDatabases/database-c3be440d-2fee-4fbe-92eb-d040282abb9e/installation-3.5.12/import/var/folders/_8/xsw3zqm14hl_5wv8q9kkzj0c0000gp/T/csv-003/ONET/NODE_ONET.workvalues_d8302af1-e774-4b3f-b364-f55896b4967b.csv). Rerun with --debug flag for detailed diagnostic information.

I am running Neo4j Desktop on a MAC Mojave OS, Neo4j Ent 3.5.12 and ETL Tool 1.4.2.

[conker84]

Hi @davidmeza1 thanks a lot for reaching us, can you try with the following jar? neo4j-etl-ui-1.4.2-release.tar.gz In order to install it provide the path where you downloaded with the file:// prefix

Btw, is it possible to share your dataset? You can sand it to andrea.santurbano[at]larus-ba.it

Looking forward to your feedback

[davidmeza1]

Sorry, Still not working. Hers is the data source I am using, https://www.onetcenter.org/database.html#all-files. I downloaded the MySQL All Files.

[conker84]

Let me try, I'll be back asap

[conker84]

neo4j-etl-ui-1.4.2-release.tar.gz

Hi @davidmeza1 can you try with this jar? Thanks a lot!

[conker84]

@davidmeza1 ping

[conker84]

@davidmeza1 ping :)

[davidmeza1]

Sorry, I have been on leave. I will look at it this week.

[conker84]

Cool thanks!