Re: Export to Excel (CSV) Does not support Internationalization
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 ( 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 found a way to solve this problem by to opening the csv file using a text editor, then change encoding into UTF-8. If i try to open the file again in excel, everything looks great!. Can anybody help me fix the exported csv file encoding automatically? Thanks in advance
Re: Export to Excel (CSV) Does not support Internationalization
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 file encoding. Applying the solution you mentioned won't fix the problem then. Excel is able to open an html file with correct encoding info in the header and a simple plain html table. building on this, i implemented a a workaround solution to my problem (Open in excel), where i added a new map-view type screenxls that would render the form as a simple html page with plain table. On Tue, Sep 6, 2011 at 6:16 PM, BJ Freeman bjf...@free-man.net wrote: 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 ( 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 found a way to solve this problem by to opening the csv file using a text editor, then change encoding into UTF-8. If i try to open the file again in excel, everything looks great!. Can anybody help me fix the exported csv file encoding automatically? Thanks in advance -- Thanks IyadK
Re: Export to Excel (CSV) Does not support Internationalization
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 outputs. The way all the necessary support for output is done by the handlers(rendering engine) This to me is the correct way to handle UI. Iyad Khaddam sent the following on 9/6/2011 12:06 PM: 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 file encoding. Applying the solution you mentioned won't fix the problem then. Excel is able to open an html file with correct encoding info in the header and a simple plain html table. building on this, i implemented a a workaround solution to my problem (Open in excel), where i added a new map-view type screenxls that would render the form as a simple html page with plain table. On Tue, Sep 6, 2011 at 6:16 PM, BJ Freeman bjf...@free-man.net wrote: 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 ( 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 found a way to solve this problem by to opening the csv file using a text editor, then change encoding into UTF-8. If i try to open the file again in excel, everything looks great!. Can anybody help me fix the exported csv file encoding automatically? Thanks in advance
Re: Export to Excel (CSV) Does not support Internationalization
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 supported everywhere, including the database, terminal, editors, import/output. On Tue, Sep 6, 2011 at 12:06 PM, Iyad Khaddam iya...@gmail.com wrote: 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 file encoding. Applying the solution you mentioned won't fix the problem then. Excel is able to open an html file with correct encoding info in the header and a simple plain html table. building on this, i implemented a a workaround solution to my problem (Open in excel), where i added a new map-view type screenxls that would render the form as a simple html page with plain table. On Tue, Sep 6, 2011 at 6:16 PM, BJ Freeman bjf...@free-man.net wrote: 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 ( 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 found a way to solve this problem by to opening the csv file using a text editor, then change encoding into UTF-8. If i try to open the file again in excel, everything looks great!. Can anybody help me fix the exported csv file encoding automatically? Thanks in advance -- Thanks IyadK
