Export to Excel (CSV) Does not support "Internationalization"

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

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

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

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

[Mike Z]

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
>