Export to Excel (CSV) Does not support Internationalization

2011-09-06 Thread Iyad Khaddam
Hi, There are many places where we can export screens to CSV, like the one in Accounting ( https://localhost:8443/accounting/control/AcctgTransEntriesSearchResultsCsv.csv ) I'm using Arabic. When exporting to CSV, the file opens in excel correctly, but all arabic words are encoded incorrectly. I

Re: Export to Excel (CSV) Does not support Internationalization

2011-09-06 Thread BJ Freeman
The view-map, the type=“screencsv” to invoke the “csv screen renderer” also set the content-type=“text/csv” and encoding=UTF-8 Iyad Khaddam sent the following on 9/6/2011 7:12 AM: Hi, There are many places where we can export screens to CSV, like the one in Accounting (

Re: Export to Excel (CSV) Does not support Internationalization

2011-09-06 Thread Iyad Khaddam
Hi BJ Freeman, Thanks for your reply. Actually, the problem is not related to OFBIZ, it is a problem in Excel. Excel would use ASCII to import CSV files. If you have a CSV file with a different encoding than ASCII, then you have to use the import tool in excel that will allow you to specify the

Re: Export to Excel (CSV) Does not support Internationalization

2011-09-06 Thread BJ Freeman
Ok what I was trying to communicate was two things. 1) the use of screencvs 2) adding the encoding tag in the view-map. I am working on being able to have the same view-map name but with different Types, content-type, and encoding. The way the same widgets can be used but produce different

Re: Export to Excel (CSV) Does not support Internationalization

2011-09-06 Thread Mike
I use Excel 2007, and there are many character import options available for csv: Excel - Data - From Text - CHOOSE FILE - select delimited - File Origin (Dropdown Menu): 55 Entries, including UTF-8 This is stock Excel, as far as I can tell. If you are going to use UTF-8, it needs to be