neo4j etl导入数据json错误,没明白是咋回事儿
发布于 5 年前 作者 penggd 1693 次浏览 来自 问答

COMMAND: java -cp “D:\neo4j desktop\graphApps_global\neo4j-etl-ui/dist/neo4j-etl.jar” org.neo4j.etl.NeoIntegrationCli export --mapping-file “C:\Users\ASUS\AppData\Local\Temp/mysql_iagt_iagt_mapping.json” --destination “D:\neo4j desktop\neo4jDatabases\database-5d0b3dc5-6024-4534-8cc3-74dd51eed58d\installation-3.5.14/data/databases/graph.db/” --import-tool “D:\neo4j desktop\neo4jDatabases\database-5d0b3dc5-6024-4534-8cc3-74dd51eed58d\installation-3.5.14/bin” --rdbms:password “iagt” --rdbms:user “iagt” --rdbms:url “jdbc:mysql://172.18.231.40:8066/iagt?autoReconnect=true&useSSL=false&useCursorFetch=true&allowPublicKeyRetrieval=true” --csv-directory “C:\Users\ASUS\AppData\Local\Temp” --options-file “C:\Users\ASUS\AppData\Local\Temp/import-tool-options.json” --using “bulk:neo4j-import” --neo4j:url “bolt://localhost:7687” --neo4j:user “neo4j” --neo4j:password “neo4jpgd” --force

  • Reading options from file C:\Users\ASUS\AppData\Local\Temp\import-tool-options.json.
  • Reading metadata mapping from file: C:\Users\ASUS\AppData\Local\Temp/mysql_iagt_iagt_mapping.json
  • Command failed due to error (JsonParseException: Unexpected character (’,’ (code 44)): was expecting a colon to separate field name and value at [Source: C:\Users\ASUS\AppData\Local\Temp\mysql_iagt_iagt_mapping.json; line: 1, column: 10502]). Rerun with --debug flag for detailed diagnostic information. ![RJW{N6B{D8B[IQ71LUIRA5.png
2 回复

option.json 什么内容? 我的内容如下: {“multiline-fields”:“true”}

我用windows下运行 命令成功导入,你借鉴下 java -cp “D:\software\neo4j-etl-cli-1.3.1\lib\neo4j-etl.jar” org.neo4j.etl.NeoIntegrationCli export --rdbms:password “sa123” --rdbms:user sa --rdbms:schema userrole.dbo --rdbms:url “jdbc:sqlserver://localhost:1433;databaseName=userrole” --import-tool C:\Users\PGM-PC.Neo4jDesktop\neo4jDatabases\database-3c4ee7da-eb1e-4509-94a3-12c1a7d6f3ee\installation-3.5.14\bin --options-file E:\import-tool-options.json --csv-directory E:\ --destination E:\graph.db\ --driver E:\sqljdbc42.jar

导入提示 image.png

回到顶部