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 |
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 > > |
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 <[hidden email]> 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 |
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 <[hidden email]> 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 >>> >>> >> > > > |
In reply to this post by Iyad Khaddam
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 <[hidden email]> 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 <[hidden email]> 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 > |
Free forum by Nabble | Edit this page |