Hello!
I've been trying to do a simple ETL import from a csv file to a brand new
graph database using Orientdb 2.0-M3 without any luck.
The problem is that when i'm running the oetl.bat (which I downloaded
from https://github.com/orientechnologies/orientdb-etl/tree/2.0-M3/script),
OrientDB invariably interprets strings starting with digitsas numbers and
outputs a java.lang.NumberFormatException. Or at least this is what I
deducted since for some entries in the csv (those with fields not starting
with digits) it does not output errors.
Here is the simple ETL file:
{
"source": { "file": { "path": "test.csv" } },
"extractor": { "row": {} },
"transformers": [
{ "csv": {} },
{ "vertex": { "class": "Organization" } }
],
"loader": {
"orientdb": {
"dbURL":
"plocal:c:\\programming\\orientdb-community-2.0-M3\\bin\\testdb",
"dbType": "graph",
"dbUser": "root",
"dbPassword": "root",
"classes": [
{"name": "Organization", "extends": "V"},
{"name": "User", "extends": "V"},
{"name": "SUB_CHILD", "extends": "E"},
{"name": "BELONGS_TO", "extends": "E"}
], "indexes": [
{"class":"Organization", "fields":["Tpid:string"], "type":"UNIQUE"
}
]
}
}
}
And here is the test.csv file:
Name,ShortName,Tpid
Name1,SUE_SSFG,FD71D202-7942-1000-878F-C0A8B4340001
Name2,SUE_SSFG2,7D71D202-7942-1000-878F-C0A8B4340001
The output is the following:
OrientDB etl v.2.0-M3 (build @BUILD@) www.orientechnologies.com
BEGIN ETL PROCESSOR
[2:csv] ERROR Error on setting document field Tpid=null
(cause=java.lang.Number
ormatException: For input string: "7D71D202-7942-1000-878F-C0A8B4340001")
END ETL PROCESSOR
+ extracted 3 rows (0 rows/sec) - 3 rows -> loaded 2 vertices (0
vertices/sec)
otal time: 180ms [0 warnings, 1 errors]
It only output an error for the property starting with a digit...
I've tried both with the orientdb-etl-2.0-M3 that came with the M3 archive
downloaded from the site and with the self-compiled version from github
(wierdly, these 2 differ in content).
Any clues?
--
---
You received this message because you are subscribed to the Google Groups
"OrientDB" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
