@chungchan123456,
I have just included a path to fix UTF-8 exports.
Could you update and check again?
@carazo
Thanks for the quick turn around!
The export works for Asian characters now. However, seems the import doesn’t work yet. I tried to export the users, remove one of them in system and then import the same user. However, that user can’t be imported. The plugin just shows a blank line with header only after import.
@chungchan123456,
Sorry but your problem now is importing or exporting?
Export works?
@carazo
The original issue was export. Export works fine now after your UTF-8 fix.
Then I try to import now and seem can’t import. After I import, The plugin just shows a blank line with header only after import.
Thanks.
@carazo
I did some more testing. Looks like its a data issue.
Any idea how to count the number of characters in a string with Asian characters?
e.g. “活石教育中心 LIVINGSTONE ACADEMY EDUCATION CENTRE2″ is counted as 56 characters in the metadata. Tried to use LEN() or LENB() in excel, but still can’t get 56.
s:10:”store_name”;s:56:”活石教育中心 LIVINGSTONE ACADEMY EDUCATION CENTRE2″;s:6:”social”
Thanks.
Could you try to explain better the error you get?
@carazo
e.g. the following is one of the column from the export file.
s:10:”store_name”;s:56:”活石教育中心 LIVINGSTONE ACADEMY EDUCATION CENTRE2″;s:6:”social”
I need to amend some data before I import. e.g. I amend the store name from “活石教育中心 LIVINGSTONE ACADEMY EDUCATION CENTRE” to “活石教育中心 LIVINGSTONE ACADEMY EDUCATION CENTRE22”. The import doesn’t work. Then, I found that I need to change “s:56” to “s:57”. So that means s:<number of byte of the string> is the format to use. Looks like each of this Asian character takes 3 byte.
So the question is how to get number of byte of the string automatically. e.g. How you can get this value in the plugin? Ideally, I can do the same in excel automatically so that I can modify all the users in one go and then import.
Hope it clarifies.
Thanks.
@chungchan123456,
Sorry but I cannot understand it yet.
