How do you specify the “—output-mapping-file” path

neo4j-contrib / neo4j-etl

Data import from relational databases to Neo4j.

https://neo4j.com/developer/neo4j-etl/

Other

214 stars 46 forks source link

How do you specify the “—output-mapping-file” path #28

Open spocyber opened 5 years ago

spocyber commented 5 years ago

COMMAND: java -cp "C:\Users\FAS01.Neo4jDesktop\graphApps\neo4j-etl-ui/dist/neo4j-etl.jar" org.neo4j.etl.NeoIntegrationCli generate-metadata-mapping --rdbms:url "jdbc:mysql://192.168.249.241:3306/btc?autoReconnect=true&useSSL=false&useCursorFetch=true" --rdbms:password "neo4j" --rdbms:user "root" --schema "btc" --output-mapping-file "undefined/import/mysql_btc_btc_mapping.json"

Skipping reading import options from file because file [] doesn't exist.
Command failed due to error (FileNotFoundException: undefined\import\mysql_btc_btc_mapping.json (�� θ� ã�� ϴ�)). Rerun with --debug flag for detailed diagnostic information.

The above error occurs when the “Start Mapping” button is pressed. How do you specify the “—output-mapping-file” path? Client OS : Windows 7 Neo4j Server OS : Ubuntu 14.04 mysql Server OS : Ubuntu 14.04

oneplanetliving commented 5 years ago

Hi edward3132, I got exaclty the same issue, did you find a solution ? Thanks

vadimio commented 5 years ago

I am on Ubuntu 16.04, postgres/cocroachDB and have the same issue

jexp commented 5 years ago

@albertodelazzari could you have a look?

vadimio commented 5 years ago

I am on Ubuntu 16.04, postgres/cocroachDB and have the same issue

Just to be more precise if someone is going to debug it: os: Ubuntu 16.04, 64 bit. Linux ucd 4.4.0-142-generic #168-Ubuntu neo4j: running in docker with locally mapped folders, version 3.5.3, community edition neo4j-desktop: 1.1.15

Log (replaced user name and password with "xxxxx" for security reasons) COMMAND: java -cp "/home/xxxx/.config/Neo4j Desktop/Application/graphApps/neo4j-etl-ui/dist/neo4j-etl.jar" org.neo4j.etl.NeoIntegrationCli generate-metadata-mapping --rdbms:url "jdbc:postgresql://localhost:26257/everysheep?ssl=false" --rdbms:password "xxxxxxx" --rdbms:user "root" --output-mapping-file "undefined/import/postgresql_everysheep_mapping.json"

Skipping reading import options from file because file [] doesn't exist.
Command failed due to error (FileNotFoundException: undefined/import/postgresql_everysheep_mapping.json (No such file or directory)). Rerun with --debug flag for detailed diagnostic information.

jexp commented 5 years ago

Are you using a local or remote Neo4j database?

vadimio commented 5 years ago

I am running docker image of latest neo4j in a VirtualBox. So, it would be behaving as a remote neo4j

On Mon, Feb 25, 2019 at 5:08 PM Michael Hunger notifications@github.com wrote:

Are you using a local or remote Neo4j database?

— You are receiving this because you commented. Reply to this email directly, view it on GitHub https://github.com/neo4j-contrib/neo4j-etl/issues/28#issuecomment-467250389, or mute the thread https://github.com/notifications/unsubscribe-auth/AM3I40vjlBb5ei32Jza1weM7BjxBV6cWks5vRIkjgaJpZM4W9t4Q .

jexp commented 5 years ago

Sorry the ETL tool currently only works with "local" desktop databases, as desktop doesn't provide a local directory for remote db's. We will address that in one of the next releases.