The Chinese issue is because of a space in it, which is invalid to Orient. It seems that the reason is my database direction asks for root.
在 2015年3月28日星期六 UTC+8下午12:22:32，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 > <http://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 > <http://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? > -- --- 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.
