Wrong encoding in graphs and csv

Moderator: crythias

Post Reply
majo053
OTRS expert
Posts: 52
Joined: 08 Nov 2011, 17:28
OTRS Version?: 4.0.5

Wrong encoding in graphs and csv

Post by majo053 » 28 Dec 2011, 13:31

Hi all! I have wrong encoding in graphs and CSV. I use UTF-8 encoding in Config.pm. PDF output is OK. Can you please advise the problem? Thanks.

mysql> status;
--------------
Server characterset: utf8
Db characterset: utf8
Client characterset: utf8
Conn. characterset: utf8

mysql> SHOW VARIABLES LIKE "character_set_%";
+--------------------------+----------------------------+
| Variable_name | Value |
+--------------------------+----------------------------+
| character_set_client | utf8 |
| character_set_connection | utf8 |
| character_set_database | utf8 |
| character_set_filesystem | binary |
| character_set_results | utf8 |
| character_set_server | utf8 |
| character_set_system | utf8 |

Apache> AddDefaultCharset UTF-8

OTRS 3.0.11
Last edited by majo053 on 28 Dec 2011, 19:57, edited 1 time in total.
OTRS and ITSM 4.0.6 (production), MariaDB Ver 15.1 Distrib 5.5.40-MariaDB, CentOS 7.0.1406 (Core)

mshi
OTRS expert
Posts: 66
Joined: 08 Mar 2011, 11:10
OTRS Version?: 3.0

Re: Wrong encoding in graphs and csv

Post by mshi » 28 Dec 2011, 16:30

Pls check if you have installed needed charactor fonts on you "Operating System".

Mshi
OTRS: 3.0.7
ITSM: 3.0.2
Running on: Ubuntu 10.04 LTS with MySQL, integrated with MS 2003 Active Directory Server

majo053
OTRS expert
Posts: 52
Joined: 08 Nov 2011, 17:28
OTRS Version?: 4.0.5

Re: Wrong encoding in graphs and csv

Post by majo053 » 28 Dec 2011, 19:29

Do you mean this?

[root@otrs otrs]# find . -iname "*.ttf"
./var/fonts/DejaVuSans.ttf
./var/fonts/DejaVuSansMono-Oblique.ttf
./var/fonts/DejaVuSans-Bold.ttf
./var/fonts/DejaVuSans-BoldOblique.ttf
./var/fonts/DejaVuSans-Oblique.ttf
./var/fonts/DejaVuSansMono-BoldOblique.ttf
./var/fonts/DejaVuSansMono.ttf
./var/fonts/DejaVuSansMono-Bold.ttf

PS: I have OS Centos 6.1.
OTRS and ITSM 4.0.6 (production), MariaDB Ver 15.1 Distrib 5.5.40-MariaDB, CentOS 7.0.1406 (Core)

majo053
OTRS expert
Posts: 52
Joined: 08 Nov 2011, 17:28
OTRS Version?: 4.0.5

Re: Wrong encoding in graphs and csv

Post by majo053 » 04 Jan 2012, 18:10

Can you please someone help me?
OTRS and ITSM 4.0.6 (production), MariaDB Ver 15.1 Distrib 5.5.40-MariaDB, CentOS 7.0.1406 (Core)

micshi
OTRS wizard
Posts: 191
Joined: 05 Jul 2011, 16:10
OTRS Version?: 3.2.2
Real Name: Micshi
Location: Beijing
Contact:

Re: Wrong encoding in graphs and csv

Post by micshi » 09 Feb 2012, 04:25

Hi,

open microsoft excel first, then import your csv file into excel, when importing csv file you should select utf8 encode.

micshi
OTRS 3.2.2, ITSM 3.2.2, SystemMonitor
Ubuntu, Apache2, MySQL 5
My OTRS Blog
OTRS Basic Concept Training
OTRS Demo Instance

majo053
OTRS expert
Posts: 52
Joined: 08 Nov 2011, 17:28
OTRS Version?: 4.0.5

Re: Wrong encoding in graphs and csv

Post by majo053 » 09 Feb 2012, 09:08

Yes I know this. My problem is GD graphs. Where is problem?
OTRS and ITSM 4.0.6 (production), MariaDB Ver 15.1 Distrib 5.5.40-MariaDB, CentOS 7.0.1406 (Core)

micshi
OTRS wizard
Posts: 191
Joined: 05 Jul 2011, 16:10
OTRS Version?: 3.2.2
Real Name: Micshi
Location: Beijing
Contact:

Re: Wrong encoding in graphs and csv

Post by micshi » 09 Feb 2012, 11:17

Could you post a screen shot for your graph?

Micshi
OTRS 3.2.2, ITSM 3.2.2, SystemMonitor
Ubuntu, Apache2, MySQL 5
My OTRS Blog
OTRS Basic Concept Training
OTRS Demo Instance

majo053
OTRS expert
Posts: 52
Joined: 08 Nov 2011, 17:28
OTRS Version?: 4.0.5

Re: Wrong encoding in graphs and csv

Post by majo053 » 09 Feb 2012, 18:30

Of course!

From left: incident, neurčený, žiadosť o službu, žiadosť o zmenu
You do not have the required permissions to view the files attached to this post.
OTRS and ITSM 4.0.6 (production), MariaDB Ver 15.1 Distrib 5.5.40-MariaDB, CentOS 7.0.1406 (Core)

micshi
OTRS wizard
Posts: 191
Joined: 05 Jul 2011, 16:10
OTRS Version?: 3.2.2
Real Name: Micshi
Location: Beijing
Contact:

Re: Wrong encoding in graphs and csv

Post by micshi » 10 Feb 2012, 06:20

Thanks for your screen shot.

I am sure it's a bug since I can reproduce this issue.

Thanks,

micshi
OTRS 3.2.2, ITSM 3.2.2, SystemMonitor
Ubuntu, Apache2, MySQL 5
My OTRS Blog
OTRS Basic Concept Training
OTRS Demo Instance

majo053
OTRS expert
Posts: 52
Joined: 08 Nov 2011, 17:28
OTRS Version?: 4.0.5

Re: Wrong encoding in graphs and csv

Post by majo053 » 10 Feb 2012, 09:26

Thanks micshi. Please where i find this bug report?
OTRS and ITSM 4.0.6 (production), MariaDB Ver 15.1 Distrib 5.5.40-MariaDB, CentOS 7.0.1406 (Core)

micshi
OTRS wizard
Posts: 191
Joined: 05 Jul 2011, 16:10
OTRS Version?: 3.2.2
Real Name: Micshi
Location: Beijing
Contact:

Re: Wrong encoding in graphs and csv

Post by micshi » 10 Feb 2012, 10:13

you can submit the bug to http://bugs.otrs.org

thanks,

micshi
OTRS 3.2.2, ITSM 3.2.2, SystemMonitor
Ubuntu, Apache2, MySQL 5
My OTRS Blog
OTRS Basic Concept Training
OTRS Demo Instance

majo053
OTRS expert
Posts: 52
Joined: 08 Nov 2011, 17:28
OTRS Version?: 4.0.5

Re: Wrong encoding in graphs and csv

Post by majo053 » 10 Feb 2012, 11:31

OTRS and ITSM 4.0.6 (production), MariaDB Ver 15.1 Distrib 5.5.40-MariaDB, CentOS 7.0.1406 (Core)

Mike_B
Moderator
Posts: 266
Joined: 12 Jan 2010, 18:16
OTRS Version?: CVS HEAD

Re: Wrong encoding in graphs and csv

Post by Mike_B » 10 Feb 2012, 18:13

Hi,

This is actually already fixed in OTRS 3.1.x and upcoming 3.0.12.
You could address this issue on your system by replacing the file
/opt/otrs/Kernel/System/Stats.pm with the one from CVS:

http://source.otrs.org/viewvc.cgi/otrs/ ... ev=rel-3_0

Previously, GD used a built-in font that did not have glyphs for non-western
characters. Now we use a font that does. Also, the fonts look much better now.

Please try the fix and let me know if it works for you!

--
Mike

*** This bug has been marked as a duplicate of bug 3804 ***
huntingbears.nl - @michielbeijen on Twitter

Post Reply