etl----csv with Chinese characters
Peng Lin
Hi All,
i am Chinese, and i have a lot of data stored in xlsx and with Chinese characters in it.
i saved it as cvs, and try to import it into OrientDB when i met the error:
OrientDB etl v.2.0.4 (build @BUILD@) www.orientechnologies.com
BEGIN ETL PROCESSOR
[1:csv] ERROR Error on setting document field =29556 (cause=java.lang.IllegalArgumentException: Invalid field name ' '. Character ' ' is invalid)
[2:csv] ERROR Error on setting document field =333343 (cause=java.lang.IllegalArgumentException: Invalid field name ' '. Character ' ' is invalid)
[3:csv] ERROR Error on setting document field =11212 (cause=java.lang.IllegalArgumentException: Invalid field name ' '. Character ' ' is invalid)
[4:csv] ERROR Error on setting document field =333 (cause=java.lang.IllegalArgumentException: Invalid field name ' '. Character ' ' is invalid)
[5:csv] ERROR Error on setting document field =11111 (cause=java.lang.IllegalArgumentException: Invalid field name ' '. Character ' ' is invalid)
END ETL PROCESSOR
+ extracted 6 rows (0 rows/sec) - 6 rows -> loaded 5 documents (0 documents/sec) Total time: 23ms [0 warnings, 5 errors]
When i changed the Chinese to English, it finished, but i can’t login with admin admin...
OrientDB etl v.2.0.4 (build @BUILD@) www.orientechnologies.com
BEGIN ETL PROCESSOR
END ETL PROCESSOR
+ extracted 6 rows (0 rows/sec) - 6 rows -> loaded 5 documents (0 documents/sec) Total time: 22ms [0 warnings, 0 errors]
my csv:
ID;make;model;ÖÐ ÎÄ
1;honda;civic;29556
2;toyota;corolla;333343
3;jeep;compass;11212
4;honda;pilot;333
5;subaru;outback;11111
my config:
{
"source": { "file": { "path": "/Users/apple/code/python/testXlrc/test_my.csv" } },
"extractor": { "row": {} },
"transformers": [
{ "csv": {"separator": ";", "nullValue": "NULL"} }
],
"loader": {
"orientdb": {
"dbURL": "plocal:/databases/xhg",
"dbUser":"admin",
"dbPassword":"admin",
"dbAutoCreate": true,
"dbType":"document"
}
}
}
Can anybody help me?
Peng Lin
在 2015年3月28日星期六 UTC+8下午12:22:32，Peng Lin写道：