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
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 (
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
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
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