In Sales > Orders when I export csv and open it in excel some characters are not encoded properly. e.g: ü is exported as: ü etc.
Do suggest some solution to this problem. Thanks
-
Preferred This Link It May Help You!!! magento.stackexchange.com/questions/42929/…– Rushikesh SolankiJan 9, 2017 at 11:33
-
@RushikeshSolanki I have tried it , but problem still persists, recommend some other solution please.– Irfan GhaffarJan 9, 2017 at 12:23
Add a comment
|
1 Answer
I'd like to extend from this and share my experience.
I use https://www.magentocommerce.com/magento-connect/enhanced-admin-grids-editor.html for grid customization and it also has a cool export feature built in.
As well as that I also use an extension called https://www.magentocommerce.com/magento-connect/blue-jalappeno-order-export.html which is HIGHLY customizable in the extensions model - if you'd like to give a little bit more information on what you want the export to look like I can point you in the right direction.
answered Jan 9, 2017 at 12:08
-
Actually, when exported csv file is opened in other editors i.e other than Ms excel, there is no encoding problem but when I open it in MS excel, many characters have encoding problem. Jan 9, 2017 at 12:15
-
-
-
stackoverflow.com/questions/20215700/…, I have used this one but it do not works. Jan 9, 2017 at 12:20
-