KonaKart Community Forum

Installation / Configuration => Programming of KonaKart => Topic started by: Sony George on April 21, 2010, 01:06:03 pm

Title: Export file is written in ASCII so unicode product descriptions are lost
Post by: Sony George on April 21, 2010, 01:06:03 pm
Dear Konakart,

When we export the data using ExportFromKKUsingEng.bat a new file is created named exportedDataEng.txt
the problem is that the export/import utility is writing this file in ASCII format,
so if there is UNICODE data like product description is lost and turned to ? ? ? ? ?
because of this , the exported file cannot be imported to database..

is there any way to write the file as unicode ??
the following is the mysql url i use
torque.dsfactory.store1.connection.url      = jdbc:mysql://localhost:3306/konakartdb?zeroDateTimeBehavior=convertToNull&useUnicode=true&characterEncoding=UTF-8&characterSetResults=UTF-8

i tried the following options,
first i created a file named exportedDataEng.txt  and made it UTF-8 encoding file, then tried the export, still the data was in ASCII,
i think the file i created in UTF-8 encoding was first deleted by kkimporter/exported and created a new ASCII file....


Please Advice

Regards
Title: Re: Export file is written in ASCII so unicode product descriptions are lost
Post by: greg on April 29, 2010, 05:35:42 pm
This will be fixed in the next version of KonaKart (probably to be called v5.0.n.n and due out sometime in June)

For now your best bet is to write a simple import/export routine that uses the KonaKart APIs.


If required urgently, supported customers should get in touch through the normal channels.
Title: Re: Export file is written in ASCII so unicode product descriptions are lost
Post by: Sony George on May 07, 2010, 09:49:04 pm
Dear Greg,

Please note that Import is also having the same problem, ie: if we try to import a Unicode data then, Unicode char are lost and illegal char are saved as product details

regards

Sony George
Title: Re: Export file is written in ASCII so unicode product descriptions are lost
Post by: greg on May 08, 2010, 05:38:49 am
Yes, thanks, it's the same problem.. again fixed in the next release (v5 release)