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 <[email protected]> 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 <[email protected]> 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 >
