Customer info in other language

I need to store some information such as customer name another
language. However, saving fails.

Also, e-mail sending and even receiving doesn’t support other
characters.

Thoughts?


You received this message because you are subscribed to the Google Groups “Web Notes Framework Forum” group.
To post to this group, send email to wn...@googlegroups.com.
To unsubscribe from this group, send email to wnframework+un...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/wnframework?hl=en.

Hi Ali,

Seems like a unicode issues... we believe we had fix this in most places.... surprised that it is still there

did you setup mysql (my.cnf) to utf-8 encoding... (i think default mysql 5 is still ansi)

- Rushabh



On Sep 22, 2011, at 5:08 PM, Ali wrote:

I need to store some information such as customer name another
language. However, saving fails.

Also, e-mail sending and even receiving doesn't support other
characters.

Thoughts?

-- 
You received this message because you are subscribed to the Google Groups "Web Notes Framework Forum" group.
To post to this group, send email to wn...@googlegroups.com.
To unsubscribe from this group, send email to wnframework+un...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/wnframework?hl=en.


---------------------------------------------------------------------------------
ERPNext - World's most affordable ERP - (Rs 299 / $7 per user per month)

Twitter: @rushabh_mehta






You received this message because you are subscribed to the Google Groups “Web Notes Framework Forum” group.

To post to this group, send email to wn...@googlegroups.com.

To unsubscribe from this group, send email to wnframework+un...@googlegroups.com.

For more options, visit this group at http://groups.google.com/group/wnframework?hl=en.

Thanks for the tip Rushabh. It’s storing properly now.

The only issue remaining is when an erpnext reads emails from the
server, the subject isn’t rendered properly. It looks something like
this:

=?windows-1256?B?ytPKIMjH4drRyO0=?=

On Sep 23, 9:18 am, Rushabh Mehta rm...@gmail.com wrote:

Hi Ali,

Seems like a unicode issues… we believe we had fix this in most
places… surprised that it is still there

did you setup mysql (my.cnf) to utf-8 encoding… (i think default
mysql 5 is still ansi)

  • Rushabh

On Sep 22, 2011, at 5:08 PM, Ali wrote:

I need to store some information such as customer name another
language. However, saving fails.

Also, e-mail sending and even receiving doesn’t support other
characters.

Thoughts?


You received this message because you are subscribed to the Google
Groups “Web Notes Framework Forum” group.
To post to this group, send email to wn...@googlegroups.com.
To unsubscribe from this group, send email to wnframework
+un...@googlegroups.com.
For more options, visit this group athttp://groups.google.com/
group/wnframework?hl=en.



ERPNext - World’s most affordable ERP - (Rs 299 / $7 per user per month)

Website:https://www.erpnext.com
Twitter: @rushabh_mehta


You received this message because you are subscribed to the Google Groups “Web Notes Framework Forum” group.
To post to this group, send email to wn...@googlegroups.com.
To unsubscribe from this group, send email to wnframework+un...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/wnframework?hl=en.

Ali,

On Sep 24, 2011, at 9:23 PM, Ali wrote:

Thanks for the tip Rushabh. It's storing properly now.

Great!

The only issue remaining is when an erpnext reads emails from the
server, the subject isn't rendered properly. It looks something like
this:

=?windows-1256?B?ytPKIMjH4drRyO0=?=


Thats the first time I am seeing this.... the parsing is delegated to the python email lib. I assume that should work..... Any clues?




On Sep 23, 9:18 am, Rushabh Mehta <rm...@gmail.com> wrote:
Hi Ali,

Seems like a unicode issues... we believe we had fix this in most  
places.... surprised that it is still there

did you setup mysql (my.cnf) to utf-8 encoding... (i think default  
mysql 5 is still ansi)

- Rushabh

On Sep 22, 2011, at 5:08 PM, Ali wrote:



I need to store some information such as customer name another
language. However, saving fails.

Also, e-mail sending and even receiving doesn't support other
characters.

Thoughts?

--
You received this message because you are subscribed to the Google  
Groups "Web Notes Framework Forum" group.
To post to this group, send email to wn...@googlegroups.com.
To unsubscribe from this group, send email to wnframework
For more options, visit this group athttp://groups.google.com/
group/wnframework?hl=en.

------------------------------------------------------------------------
---------
ERPNext - World's most affordable ERP - (Rs 299 / $7 per user per month)

Twitter: @rushabh_mehta

-- 
You received this message because you are subscribed to the Google Groups "Web Notes Framework Forum" group.
To post to this group, send email to wn...@googlegroups.com.
To unsubscribe from this group, send email to wnframework+un...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/wnframework?hl=en.


---------------------------------------------------------------------------------
ERPNext - World's most affordable ERP - (Rs 299 / $7 per user per month)

Twitter: @rushabh_mehta






You received this message because you are subscribed to the Google Groups “Web Notes Framework Forum” group.

To post to this group, send email to wn...@googlegroups.com.

To unsubscribe from this group, send email to wnframework+un...@googlegroups.com.

For more options, visit this group at http://groups.google.com/group/wnframework?hl=en.

Hi,

I’ve installed the first version of installer (which has an old version of framework I guess) and all tables in database has “latin1” charset. So system does not allow to work with unicode symbols. After entering and saving of document they transforming to “???..”. How to fix it? Do I need to alter all tables manually for this? Will this be fixed in next install friendly releases?



You received this message because you are subscribed to the Google Groups “ERPNext Technical Forum” group.

To view this discussion on the web visit https://groups.google.com/d/msg/wnframework/-/dbEVv13nAJcJ.

To post to this group, send email to wn...@googlegroups.com.

To unsubscribe from this group, send email to wnframework+un...@googlegroups.com.

For more options, visit this group at http://groups.google.com/group/wnframework?hl=en.

Hi Anton,

Its best if you install the latest update - all tables are ut8 in there - also the code is much more utf8 friendly. (see install instructions on this list a few days ago)

You can also run the patch vim erpnext/patches/jan_mar_2012/convert_tables_to_utf8.py

also make sure your settings in my.cnf default to utf8

best,
Rushabh

-----------------------------------------------------
ERPNext - Business Operating System

W: https://erpnext.com
T: @rushabh_mehta

On 15-Mar-2012, at 6:44 PM, AntonK wrote:

Hi,

I've installed the first version of installer (which has an old version of framework I guess) and all tables in database has "latin1" charset. So system does not allow to work with unicode symbols. After entering and saving of document they transforming to "???????...". How to fix it? Do I need to alter all tables manually for this? Will this be fixed in next install friendly releases?




You received this message because you are subscribed to the Google Groups “ERPNext Technical Forum” group.

To view this discussion on the web visit https://groups.google.com/d/msg/wnframework/-/dbEVv13nAJcJ.

To post to this group, send email to wn…@googlegroups.com.

To unsubscribe from this group, send email to wnframework+un…@googlegroups.com.

For more options, visit this group at http://groups.google.com/group/wnframework?hl=en.




You received this message because you are subscribed to the Google Groups “ERPNext Technical Forum” group.

To post to this group, send email to wn...@googlegroups.com.

To unsubscribe from this group, send email to wnframework+un...@googlegroups.com.

For more options, visit this group at http://groups.google.com/group/wnframework?hl=en.

Rushabh,

I’ve checked latest version but there is also “DEFAULT CHARSET=latin1”
in “CREATE TABLE” statement for all tables in master.sql. Is this
normal? Or somewhere must be setting with higher priority? Also I’ve
checked my.cnf - there is no settings about charset currently.

Its best if you install the latest update - all tables are ut8 in there - also the code is much more utf8 friendly. (see install instructions on this list a few days ago)


You received this message because you are subscribed to the Google Groups “ERPNext Technical Forum” group.
To post to this group, send email to wn...@googlegroups.com.
To unsubscribe from this group, send email to wnframework+un...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/wnframework?hl=en.

Are you sure you are looking at the latest master from GitHub? Let me check this tomorrow.

As a quick fix you can just do a mass search and replace in the SQL file and it should work.

Sent from mobile

On 15-Mar-2012, at 10:58 PM, AntonK an...@gmail.com wrote:

Rushabh,

I’ve checked latest version but there is also “DEFAULT CHARSET=latin1”
in “CREATE TABLE” statement for all tables in master.sql. Is this
normal? Or somewhere must be setting with higher priority? Also I’ve
checked my.cnf - there is no settings about charset currently.

Its best if you install the latest update - all tables are ut8 in there - also the code is much more utf8 friendly. (see install instructions on this list a few days ago)


You received this message because you are subscribed to the Google Groups “ERPNext Technical Forum” group.
To post to this group, send email to wn...@googlegroups.com.
To unsubscribe from this group, send email to wnframework+un...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/wnframework?hl=en.


You received this message because you are subscribed to the Google Groups “ERPNext Technical Forum” group.
To post to this group, send email to wn...@googlegroups.com.
To unsubscribe from this group, send email to wnframework+un...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/wnframework?hl=en.

Hi,

I have another issue with language - I have items in stock with non ascii symbols (cyrillic) in Item Code, when I use Stock Reconciliation I get an error: “UnicodeDecodeError: ‘ascii’ codec can’t decode byte 0xd0 in position 0: ordinal not in range(128)” which is rased by stock_reconciliation.py in row 63 (self.data.append([d.encode(“ascii”) for d in s])). I’ve tried to omit this decoding but got another error:
File “erpnext/stock/doctype/warehouse/warehouse.py”, line 42, in get_bin
bin = sql(“select name from tabBin where item_code = ‘%s’ and warehouse = ‘%s’” % (item_code, self.doc.name))
UnicodeDecodeError: ‘ascii’ codec can’t decode byte 0xd0 in position 43: ordinal not in range(128)
”.
Is it possible to use your system with non ascii characters?


On Thursday, March 15, 2012 9:49:34 PM UTC+4, rushabh wrote:

Are you sure you are looking at the latest master from GitHub? Let me check this tomorrow.

As a quick fix you can just do a mass search and replace in the SQL file and it should work.

Sent from mobile




You received this message because you are subscribed to the Google Groups “ERPNext Technical Forum” group.

To view this discussion on the web visit https://groups.google.com/d/msg/wnframework/-/dBJPFfoSdGsJ.

To post to this group, send email to wn...@googlegroups.com.

To unsubscribe from this group, send email to wnframework+un...@googlegroups.com.

For more options, visit this group at http://groups.google.com/group/wnframework?hl=en.

Hi Anton, it works for the most part. There may be some places that might be using some old encoding code. Will have to look at it next week as I am travelling.

Make sure the file you are uploading is encoded as utt8. If you are on windows you might have to do it via notepad. And remove all the encoding code.

Sent from mobile

On 24-Mar-2012, at 1:33 AM, AntonK <an...@gmail.com> wrote:

Hi,

I have another issue with language - I have items in stock with non ascii symbols (cyrillic) in Item Code, when I use Stock Reconciliation I get an error: "UnicodeDecodeError: 'ascii' codec can't decode byte 0xd0 in position 0: ordinal not in range(128)" which is rased by stock_reconciliation.py in row 63 (self.data.append([d.encode("ascii") for d in s])). I've tried to omit this decoding but got another error:
"File "erpnext/stock/doctype/warehouse/warehouse.py", line 42, in get_bin bin = sql("select name from tabBin where item_code = '%s' and warehouse = '%s'" % (item_code, self.doc.name)) UnicodeDecodeError: 'ascii' codec can't decode byte 0xd0 in position 43: ordinal not in range(128)".
Is it possible to use your system with non ascii characters?


On Thursday, March 15, 2012 9:49:34 PM UTC+4, rushabh wrote:
Are you sure you are looking at the latest master from GitHub? Let me check this tomorrow.

As a quick fix you can just do a mass search and replace in the SQL file and it should work.

Sent from mobile




You received this message because you are subscribed to the Google Groups “ERPNext Technical Forum” group.

To view this discussion on the web visit https://groups.google.com/d/msg/wnframework/-/dBJPFfoSdGsJ.

To post to this group, send email to wn…@googlegroups.com.

To unsubscribe from this group, send email to wnframework+un…@googlegroups.com.

For more options, visit this group at http://groups.google.com/group/wnframework?hl=en.



You received this message because you are subscribed to the Google Groups “ERPNext Technical Forum” group.

To post to this group, send email to wn...@googlegroups.com.

To unsubscribe from this group, send email to wnframework+un...@googlegroups.com.

For more options, visit this group at http://groups.google.com/group/wnframework?hl=en.

Rushabh,
I’ve checked - csv file is in utf8. I also tried to change encode(‘ascii’) to encode(‘cp1251’) but no luck - it somehow uses ascii all the same according to error message:
" File “/usr/lib/python2.7/encodings/cp1251.py”, line 12, in encode
    return codecs.charmap_encode(input,errors,encoding_table)
UnicodeDecodeError: ‘ascii’ codec can’t decode byte 0xd0 in position 0: ordinal not in range(128)
"


On Saturday, March 24, 2012 11:33:34 AM UTC+4, rushabh wrote:

Hi Anton, it works for the most part. There may be some places that might be using some old encoding code. Will have to look at it next week as I am travelling.

Make sure the file you are uploading is encoded as utt8. If you are on windows you might have to do it via notepad. And remove all the encoding code.

Sent from mobile




You received this message because you are subscribed to the Google Groups “ERPNext Technical Forum” group.

To view this discussion on the web visit https://groups.google.com/d/msg/wnframework/-/dgBVmsC2mX8J.

To post to this group, send email to wn...@googlegroups.com.

To unsubscribe from this group, send email to wnframework+un...@googlegroups.com.

For more options, visit this group at http://groups.google.com/group/wnframework?hl=en.

Rushabh,
I’ve checked - csv file is in utf8. But there is no BOM, should it be there?. I also tried to change
encode(‘ascii’) to encode(‘utf-8’) but no luck - it somehow uses ascii
all the same according to error message:
" File “erpnext/stock/doctype/stock_reconciliation/stock_reconciliation.py”, line 63, in convert_into_list
self.data.append([d.encode(“utf-8”) for d in s])
UnicodeDecodeError: ‘ascii’ codec can’t decode byte 0xd0 in position 0: ordinal not in range(128)

"

On Saturday, March 24, 2012 11:33:34 AM UTC+4, rushabh wrote:

Hi Anton, it works for the most part. There may be some places that might be using some old encoding code. Will have to look at it next week as I am travelling.

Make sure the file you are uploading is encoded as utt8. If you are on windows you might have to do it via notepad. And remove all the encoding code.

Sent from mobile



You received this message because you are subscribed to the Google Groups “ERPNext Technical Forum” group.

To view this discussion on the web visit https://groups.google.com/d/msg/wnframework/-/T3gVc5L0luUJ.

To post to this group, send email to wn...@googlegroups.com.

To unsubscribe from this group, send email to wnframework+un...@googlegroups.com.

For more options, visit this group at http://groups.google.com/group/wnframework?hl=en.

Hi Anton,

The encode function converts a Unicode string to an ASCII byte string by encoding special characters based on a character set, which is utf8 in this case.

Recently we faced an issue in import because there was a hyphen like character which was not getting encoded properly while saving the csv file as utf8. We were using OpenOffice. You will need to find which particular cell data is causing the decoding issue. There might be a character which might be causing the issue.

I would suggest you to try importing only one record and see if you are getting the same error.

Thanks
Anand

Sent from my Sony Ericsson Xperia mini pro

AntonK an...@gmail.com wrote:

Rushabh,
I’ve checked - csv file is in utf8. But there is no BOM, should it be
there?. I also tried to change encode(‘ascii’) to encode(‘utf-8’) but no
luck - it somehow uses ascii all the same according to error message:
" File
“erpnext/stock/doctype/stock_reconciliation/stock_reconciliation.py”, line
63, in convert_into_list self.data.append([d.encode(“utf-8”) for d in s])
UnicodeDecodeError: ‘ascii’ codec can’t decode byte 0xd0 in position 0:
ordinal not in range(128)
"

On Saturday, March 24, 2012 11:33:34 AM UTC+4, rushabh wrote:

Hi Anton, it works for the most part. There may be some places that might
be using some old encoding code. Will have to look at it next week as I am
travelling.

Make sure the file you are uploading is encoded as utt8. If you are on
windows you might have to do it via notepad. And remove all the encoding
code.

Sent from mobile


You received this message because you are subscribed to the Google Groups “ERPNext Technical Forum” group.
To view this discussion on the web visit https://groups.google.com/d/msg/wnframework/-/T3gVc5L0luUJ.
To post to this group, send email to wn...@googlegroups.com.
To unsubscribe from this group, send email to wnframework+un...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/wnframework?hl=en.


You received this message because you are subscribed to the Google Groups “ERPNext Technical Forum” group.
To post to this group, send email to wn...@googlegroups.com.
To unsubscribe from this group, send email to wnframework+un...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/wnframework?hl=en.

Hi Anton it's difficult to say unless I have a look at the code. If every string is encoded UTF8 then there should be no issues and all forced .encode() methods must be removed.

Sent from mobile

On 24-Mar-2012, at 7:26 PM, AntonK <an...@gmail.com> wrote:

Rushabh,
I've checked - csv file is in utf8. But there is no BOM, should it be there?. I also tried to change encode('ascii') to encode('utf-8') but no luck - it somehow uses ascii all the same according to error message:
" File "erpnext/stock/doctype/stock_reconciliation/stock_reconciliation.py", line 63, in convert_into_list self.data.append([d.encode("utf-8") for d in s]) UnicodeDecodeError: 'ascii' codec can't decode byte 0xd0 in position 0: ordinal not in range(128)
"

On Saturday, March 24, 2012 11:33:34 AM UTC+4, rushabh wrote:
Hi Anton, it works for the most part. There may be some places that might be using some old encoding code. Will have to look at it next week as I am travelling.

Make sure the file you are uploading is encoded as utt8. If you are on windows you might have to do it via notepad. And remove all the encoding code.

Sent from mobile



You received this message because you are subscribed to the Google Groups “ERPNext Technical Forum” group.

To view this discussion on the web visit https://groups.google.com/d/msg/wnframework/-/T3gVc5L0luUJ.

To post to this group, send email to wn…@googlegroups.com.

To unsubscribe from this group, send email to wnframework+un…@googlegroups.com.

For more options, visit this group at http://groups.google.com/group/wnframework?hl=en.



You received this message because you are subscribed to the Google Groups “ERPNext Technical Forum” group.

To post to this group, send email to wn...@googlegroups.com.

To unsubscribe from this group, send email to wnframework+un...@googlegroups.com.

For more options, visit this group at http://groups.google.com/group/wnframework?hl=en.

Anand,
It is russian letter causing error. Cell data is “П001”. That is the correct Item Code stored in erpnext database. CSV file have only one test string, please find it attached.

On Saturday, March 24, 2012 7:00:45 PM UTC+4, Anand Doshi wrote:

Hi Anton,

The encode function converts a Unicode string to an ASCII byte string by encoding special characters based on a character set, which is utf8 in this case.

Recently we faced an issue in import because there was a hyphen like character which was not getting encoded properly while saving the csv file as utf8. We were using OpenOffice. You will need to find which particular cell data is causing the decoding issue. There might be a character which might be causing the issue.

I would suggest you to try importing only one record and see if you are getting the same error.

Thanks
Anand




You received this message because you are subscribed to the Google Groups “ERPNext Technical Forum” group.

To view this discussion on the web visit https://groups.google.com/d/msg/wnframework/-/UmYahdq_lP0J.

To post to this group, send email to wn...@googlegroups.com.

To unsubscribe from this group, send email to wnframework+un...@googlegroups.com.

For more options, visit this group at http://groups.google.com/group/wnframework?hl=en.

Hi Anton,

A quick question. Have you run the convert to utf8 patch?

-Anand

Sent from my Sony Ericsson Xperia mini pro

AntonK an...@gmail.com wrote:

Anand,
It is russian letter causing error. Cell data is “П001”. That is the
correct Item Code stored in erpnext database. CSV file have only one test
string, please find it attached.

On Saturday, March 24, 2012 7:00:45 PM UTC+4, Anand Doshi wrote:

Hi Anton,

The encode function converts a Unicode string to an ASCII byte string by
encoding special characters based on a character set, which is utf8 in this
case.

Recently we faced an issue in import because there was a hyphen like
character which was not getting encoded properly while saving the csv file
as utf8. We were using OpenOffice. You will need to find which particular
cell data is causing the decoding issue. There might be a character which
might be causing the issue.

I would suggest you to try importing only one record and see if you are
getting the same error.

Thanks
Anand


You received this message because you are subscribed to the Google Groups “ERPNext Technical Forum” group.
To view this discussion on the web visit https://groups.google.com/d/msg/wnframework/-/UmYahdq_lP0J.
To post to this group, send email to wn...@googlegroups.com.
To unsubscribe from this group, send email to wnframework+un...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/wnframework?hl=en.


You received this message because you are subscribed to the Google Groups “ERPNext Technical Forum” group.
To post to this group, send email to wn...@googlegroups.com.
To unsubscribe from this group, send email to wnframework+un...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/wnframework?hl=en.

No, should I? I’ve installed the latest version of erpnext recently.

On Saturday, March 24, 2012 7:41:24 PM UTC+4, Anand Doshi wrote:

Hi Anton,

A quick question. Have you run the convert to utf8 patch?

-Anand

Sent from my Sony Ericsson Xperia mini pro

AntonK <an…@gmail.com> wrote:

>Anand,
>It is russian letter causing error. Cell data is “П001”. That is the
>correct Item Code stored in erpnext database. CSV file have only one test
>string, please find it attached.
>
>On Saturday, March 24, 2012 7:00:45 PM UTC+4, Anand Doshi wrote:
>>
>> Hi Anton,
>>
>> The encode function converts a Unicode string to an ASCII byte string by
>> encoding special characters based on a character set, which is utf8 in this
>> case.
>>
>> Recently we faced an issue in import because there was a hyphen like
>> character which was not getting encoded properly while saving the csv file
>> as utf8. We were using OpenOffice. You will need to find which particular
>> cell data is causing the decoding issue. There might be a character which
>> might be causing the issue.
>>
>> I would suggest you to try importing only one record and see if you are
>> getting the same error.
>>
>> Thanks
>> Anand
>>
>>
>
>–
>You received this message because you are subscribed to the Google Groups “ERPNext Technical Forum” group.
>To view this discussion on the web visit https://groups.google.com/d/ msg/wnframework/-/UmYahdq_lP0J .
>To post to this group, send email to wn…@googlegroups.com.
>To unsubscribe from this group, send email to wnframework+unsubscribe@ googlegroups.com.
>For more options, visit this group at http://groups.google.com/ group/wnframework?hl=en.
>



You received this message because you are subscribed to the Google Groups “ERPNext Technical Forum” group.

To view this discussion on the web visit https://groups.google.com/d/msg/wnframework/-/GHe6-bXKy5IJ.

To post to this group, send email to wn...@googlegroups.com.

To unsubscribe from this group, send email to wnframework+un...@googlegroups.com.

For more options, visit this group at http://groups.google.com/group/wnframework?hl=en.

No, should I? I’ve installed the latest version of erpnext recently.

On Saturday, March 24, 2012 7:41:24 PM UTC+4, Anand Doshi wrote:

Hi Anton,

A quick question. Have you run the convert to utf8 patch?

-Anand




You received this message because you are subscribed to the Google Groups “ERPNext Technical Forum” group.

To view this discussion on the web visit https://groups.google.com/d/msg/wnframework/-/w4jjEjUeRFsJ.

To post to this group, send email to wn...@googlegroups.com.

To unsubscribe from this group, send email to wnframework+un...@googlegroups.com.

For more options, visit this group at http://groups.google.com/group/wnframework?hl=en.

Hi Anton,

I think you should.
Use python wnf.py -d yourdbname -p patches.jan_mar_2012.convert_to_utf8

*pls confirm the patch name… In erpnext/patches/Jan_mar_2012 folder

I think thats the patch.

It converts your database tables to support utf8

Thanks,
Anand.

Sent from my Sony Ericsson Xperia mini pro

AntonK an...@gmail.com wrote:

No, should I? I’ve installed the latest version of erpnext recently.

On Saturday, March 24, 2012 7:41:24 PM UTC+4, Anand Doshi wrote:

Hi Anton,

A quick question. Have you run the convert to utf8 patch?

-Anand


You received this message because you are subscribed to the Google Groups “ERPNext Technical Forum” group.
To view this discussion on the web visit https://groups.google.com/d/msg/wnframework/-/w4jjEjUeRFsJ.
To post to this group, send email to wn...@googlegroups.com.
To unsubscribe from this group, send email to wnframework+un...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/wnframework?hl=en.


You received this message because you are subscribed to the Google Groups “ERPNext Technical Forum” group.
To post to this group, send email to wn...@googlegroups.com.
To unsubscribe from this group, send email to wnframework+un...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/wnframework?hl=en.

Anand,
all tables in my database already have CHARSET=utf8 (I’ve run the patch though - all the same). I think issue is somewhere in csv file reading part. Maybe charset must be explicitly specified in file_manager.py?

On Saturday, March 24, 2012 11:31:51 PM UTC+4, Anand Doshi wrote:

Hi Anton,

I think you should.
Use python wnf.py -d yourdbname -p patches.jan_mar_2012.convert_ to_utf8

*pls confirm the patch name… In erpnext/patches/Jan_mar_2012 folder

I think thats the patch.

It converts your database tables to support utf8

Thanks,
Anand.



You received this message because you are subscribed to the Google Groups “ERPNext Technical Forum” group.

To view this discussion on the web visit https://groups.google.com/d/msg/wnframework/-/cm0TDSTuvbwJ.

To post to this group, send email to wn...@googlegroups.com.

To unsubscribe from this group, send email to wnframework+un...@googlegroups.com.

For more options, visit this group at http://groups.google.com/group/wnframework?hl=en.