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.

Reply via email to