Spreeadsheet, utf-8 and ms excel

RT Users
1

When export a search result as tsv spreedsheet ms excel doesn’t properly
display non ASCII characters:

for example ￜ is displayed as ò

and so on,

the exported file is utf-8 encoded but I think this info isn’t passed to ms excel.

any hint?

regards
Nicola

2

When export a search result as tsv spreedsheet ms excel doesn’t
properly
display non ASCII characters:

for example ò is displayed as ò

and so on,

Nicola, What RT are you testing with?

PGP.sig (186 Bytes)

3

When export a search result as tsv spreedsheet ms excel doesn’t
properly
display non ASCII characters:

for example ￜ is displayed as ò

and so on,

Nicola, What RT are you testing with?

Thanks for your quick answer,

I’m using rt 3.6.5 on centos 5.1,

I quickly looked at 3.6.6 code and doesn’t seem there are changes
related to spreeadsheet generation

If I open the tsv file with notepad and save it as unicode and then I
open the file with ms excel all is fine,

If I open with openoffice calc and import as utf-8 all is fine,

even if I change content_type from application/vnd.ms-excel to text/csv
in Results.csv source file and then I import the generated tsv in ms
excel and specify utf-8 encoding all is fine

maybe some header in missing in tsv generation

4

When export a search result as tsv spreedsheet ms excel doesn’t
properly
display non ASCII characters:

for example ò is displayed as ò

and so on,

Nicola, What RT are you testing with?

Thanks for your quick answer,

I’m using rt 3.6.5 on centos 5.1,

I quickly looked at 3.6.6 code and doesn’t seem there are changes
related to spreeadsheet generation

If I open the tsv file with notepad and save it as unicode and then I
open the file with ms excel all is fine,

If I open with openoffice calc and import as utf-8 all is fine,

even if I change content_type from application/vnd.ms-excel to text/
csv
in Results.csv source file and then I import the generated tsv in ms
excel and specify utf-8 encoding all is fine

maybe some header in missing in tsv generation

Can you find out whether MS accepts a way to specify this from MIME
types (possbily application/vnd.ms-excel; charset=utf8) ? If there’s a
change we can make, I’d be happy to make it

PGP.sig (186 Bytes)

5

When export a search result as tsv
spreedsheet ms excel doesn’t
properly
display non ASCII characters:

for example � is displayed as ò

and so on,

Nicola, What RT are
you testing with?

Thanks for your quick
answer,

I’m using rt 3.6.5 on centos 5.1,

I quickly looked at 3.6.6 code and doesn’t seem
there are changes
related to spreeadsheet generation

If I open the tsv file with notepad and save it
as unicode and then I
open the file with ms excel all is
fine,

If I open with openoffice calc and
import as utf-8 all is fine,

even if I change
content_type from application/vnd.ms-excel to text/
csv
in Results.csv source file and then I import the generated tsv
in ms
excel and specify utf-8 encoding all is fine

maybe some header in missing in tsv generation

Can you find out whether MS accepts a way to
specify this from MIME
types (possbily application/vnd.ms-excel;
charset=utf8) ? If there’s a
change we can make, I’d be happy to
make it

It doesn’t work …

Can I export the
spreadsheets with iso-8859-15 encoding ?

thanks
Nicola

6

Nicola,

When you save your spreadsheet, what do you have in the "save as type"

dropdown? Make sure it is NOT “,txt” or anything other than “.xls”.

Kenn
LBNLOn 5/1/2008 8:50 AM, Mailing List SVR wrote:

Il giorno gio, 01/05/2008 alle 09.55 -0400, Jesse Vincent ha scritto:

On May 1, 2008, at 8:21 AM, Mailing List SVR wrote:

When export a search result as tsv spreedsheet ms excel doesn’t
properly
display non ASCII characters:

for example ￜ is displayed as ò

and so on,

Nicola, What RT are you testing with?

Thanks for your quick answer,

I’m using rt 3.6.5 on centos 5.1,

I quickly looked at 3.6.6 code and doesn’t seem there are changes
related to spreeadsheet generation

If I open the tsv file with notepad and save it as unicode and then I
open the file with ms excel all is fine,

If I open with openoffice calc and import as utf-8 all is fine,

even if I change content_type from application/vnd.ms-excel to text/csv
in Results.csv source file and then I import the generated tsv in ms
excel and specify utf-8 encoding all is fine

maybe some header in missing in tsv generation

the exported file is utf-8 encoded but I think this info isn’t
passed to ms excel.

any hint?

regards
Nicola

The rt-users Archives

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

The rt-users Archives

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

7

Nicola,

When you save your
spreadsheet, what do you have in the “save as type”

dropdown? Make sure it is NOT “,txt” or anything other than
“.xls”.

Kenn
LBNL

Kenn,

thanks for your answer, the type is xls.

I did a test also changing charset as suggested here (UTF-16LE)

http://www.weberdev.com/get_example-3701.html

but still
doesn’t work

When export a search
result as tsv spreedsheet ms excel doesn’t

properly

display non ASCII characters:

for example � is displayed
as ò

and so
on,

Nicola, What RT are you
testing with?

Thanks for your quick answer,

I’m using rt 3.6.5 on centos 5.1,

I quickly looked at 3.6.6 code and doesn’t seem
there are changes
related to spreeadsheet generation

If I open the tsv file with notepad and save it
as unicode and then I
open the file with ms excel all is
fine,

If I open with openoffice calc and
import as utf-8 all is fine,

even if I change
content_type from application/vnd.ms-excel to text/csv
in
Results.csv source file and then I import the generated tsv in ms
excel and specify utf-8 encoding all is fine

maybe some header in missing in tsv generation

the exported file is utf-8 encoded but I think this
info isn’t
passed to ms excel.

any hint?

regards

Nicola

http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help:
http://wiki.bestpractical.com
Commercial support:
sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from
O’Reilly Media.
Buy a copy at
http://rtbook.bestpractical.com

http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials
from O’Reilly Media.
Buy a copy at
http://rtbook.bestpractical.com

8

Il giorno gio, 01/05/2008 alle
09.55 -0400, Jesse Vincent ha
scritto:

When export a search result as tsv

spreedsheet ms excel doesn’t

properly
display non ASCII characters:

for example � is
displayed as ò

and so on,

Nicola, What RT are
you
testing with?

Thanks for your quick
answer,

I’m using rt 3.6.5 on
centos 5.1,

I quickly looked at 3.6.6
code and doesn’t seem
there are changes

related to spreeadsheet generation

If
I open the tsv file with notepad and save it
as unicode and then
I
open the file with ms excel all is
fine,

If I open with openoffice calc and
import as utf-8 all is fine,

even if I change

content_type from application/vnd.ms-excel to
text/

csv
in Results.csv source file
and then I import the generated tsv
in ms

excel and specify utf-8 encoding all is fine

maybe some header in missing in tsv generation

Can you find out whether MS accepts
a way to
specify this from MIME
types (possbily
application/vnd.ms-excel;
charset=utf8) ? If there’s a
change we can make, I’d be happy to
make it

It doesn’t work …

Can I export the
spreadsheets with iso-8859-15 encoding ?

thanks

Nicola

It seems that Excel doesn’t
use the charset header, it always import the file as Windows-1252 (on
Windows). The only solution I found is to export as html entity.

I tested the solution proposed here (export as html entity) and it
works:

http://www.listsearch.com/Lasso/Thread/index.lasso?16733

I
would like some help to do this inside request tracker,

thanks
Nicola

http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com

Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly
Media.

9

It seems that Excel doesn’t
use the charset header, it always import the file as Windows-1252 (on
Windows). The only solution I found is to export as html entity.

I tested the solution proposed here (export as html entity) and it
works:

http://www.listsearch.com/Lasso/Thread/index.lasso?16733

I
would like some help to do this inside request tracker,

I also wrote this as a workaround:

http://search.cpan.org/dist/RT-Extension-SearchResults-XLS/

10

It seems that Excel doesn’t
use the charset header, it always import the file as Windows-1252 (on
Windows). The only solution I found is to export as html entity.

I tested the solution proposed here (export as html entity) and it
works:

http://www.listsearch.com/Lasso/Thread/index.lasso?16733

I
would like some help to do this inside request tracker,

I also wrote this as a workaround:

http://search.cpan.org/dist/RT-Extension-SearchResults-XLS/

Thanks Emmanuel,

when I do perl Makefile.pl i get the following error:

include /usr/local/src/RT-Extension-SearchResults-XLS/inc/Module/Install.pm
Cannot autoload main - main::AUTOLOAD at inc/Module/Install.pm line 88.

what prerequisite modules I have to install?

11

http://search.cpan.org/dist/RT-Extension-SearchResults-XLS/

Thanks Emmanuel,

when I do perl Makefile.pl i get the following error:

include /usr/local/src/RT-Extension-SearchResults-XLS/inc/Module/Install.pm
Cannot autoload main - main::AUTOLOAD at inc/Module/Install.pm line 88.

Can you try this new release:

ftp://pause.perl.org/incoming/RT-Extension-SearchResults-XLS-0.02.tar.gz

I’ve upgraded the old version of Module::Install I used which should fix
this problem (mismatch between Module::Install versions).

Thanks!!

It works just fine,

I need to install spreedsheet-excel perl module too, and then change
the spreedsheet link to Results.xls,

regards
Nicola

12

Thanks!!

You’re welcome.

It works just fine,

I need to install spreedsheet-excel perl module too, and then change

Of course, CPAN should telled you this dependency.

the spreedsheet link to Results.xls,

Yes, this is an “extension” so it doesn’t replace the tsv export, but as
you did, you can easily replace it.

13

RT-Extension-SearchResults-XLS-0.09 - Add Excel format export to RT search results - metacpan.org

Thanks Emmanuel,

when I do perl Makefile.pl i get the following error:

include /usr/local/src/RT-Extension-SearchResults-XLS/inc/Module/Install.pm
Cannot autoload main - main::AUTOLOAD at inc/Module/Install.pm line 88.

Can you try this new release:

ftp://pause.perl.org/incoming/RT-Extension-SearchResults-XLS-0.02.tar.gz

I’ve upgraded the old version of Module::Install I used which should fix
this problem (mismatch between Module::Install versions).

Thanks!!

It works just fine,

I need to install spreedsheet-excel perl module too, and then change
the spreedsheet link to Results.xls,

Hi Emmanuel,

do you have some hints for this extension and RT 3.8.1?

thanks
Nicola

14

Hi Emmanuel,

do you have some hints for this extension and RT 3.8.1?

Well I didn’t tried it on 3.8, so you’re talking to me that I need ot
have a look and update it :wink:

Well, I will try to find time for this as soon as possible :slight_smile:

15

Hi Emmanuel,

do you have some hints for this extension and RT 3.8.1?

Well I didn’t tried it on 3.8, so you’re talking to me that I need ot
have a look and update it :wink:

Well, I will try to find time for this as soon as possible :slight_smile:

I just uploaded a new version (0.03) to CPAN with updated
Module::Install and updated Results.xls with new features of 3.8
Results.tsv.
Should be available soon on mirrors.

Thought, in 3.8, the XLS link appears with action buttons at the bottom
of the page, not easy to find for users, but it’s there.
I’m waiting for a new callback in RT source code to be able to add the
link along other export links (iCal, RSS, …) on the top.

16

I just uploaded a new version (0.03) to CPAN with updated
Module::Install and updated Results.xls with new features of 3.8
Results.tsv.
Should be available soon on mirrors.

Thought, in 3.8, the XLS link appears with action buttons at the bottom
of the page, not easy to find for users, but it’s there.
I’m waiting for a new callback in RT source code to be able to add the
link along other export links (iCal, RSS, …) on the top.

The new callback is now in svn, so I just uploaded a new release 0.04
which uses this callback.