importing database records does not parse UTF-8

Sat, 02/07/2009 - 04:22 — JesseDavis

I have a CSV file of records with Japanese names. I export the csv in unicode UTF-8, and can view the characters correctly in other programs, but the japanese text is garbled when imported through the 'import' button in the Database Tool.

you can log into my workspace to see the result, but it is just that the database imports the records properly, but garbles the japanese text.

Bug Reports

Sat, 02/07/2009 - 05:01 — akkinenirajesh

UTF8 support for Database

UTF8 support for Database Import & Export records has been added. New update will be released with in next 2 days.

Thu, 02/12/2009 - 07:08 — JesseDavis

Almost! It now works to

Almost! It now works to import japanese text, however now any cells that were blank on the original spreadsheet are ignored, and the data from the next column is moved over!

The records I am importing have several fields blank per record, so this is not good. A blank cell on the spreadsheet that was exported (or a ,, on the csv file) should be a blank cell on the DB table.

Good luck.
J

Thu, 02/12/2009 - 11:00 — akkinenirajesh

I thought about it when I saw

I thought about it when I saw your CSV file. We will fix it.

Rajesh

Fri, 02/13/2009 - 01:19 — akkinenirajesh

This issue has been fixed and

This issue has been fixed and update is also released (v1.1.27.3b)

Thank you

Fri, 02/13/2009 - 17:07 — JesseDavis

hmm, it works, but a little

hmm, it works, but a little strangely.

Now, all blank fields are filled with commas, but they usually import correctly in terms of the right data in the right field.

also, I have had slightly inconsistent results when importing. I will keep looking and report when I figure it out. For now it works good enough though, thankyou.

Mon, 02/16/2009 - 05:30 — akkinenirajesh