[SOLVED] No values in Ticket queue overview on dashboard

Moderator: crythias

Locked
aph
Znuny superhero
Posts: 646
Joined: 20 Jun 2014, 12:11
Znuny Version: 3.3.9, 4.x, 5.x

[SOLVED] No values in Ticket queue overview on dashboard

Post by aph »

In the Ticket queue overview widget, I have added two new states (in DashboardBackend###0270-TicketQueueOverview under Ticket -> Frontend::Agent::Dashboard). These states contain the German charachter ü. As a result, no values are shown in the respective columns.
When I removed and readded the state names, the widget displayed the values correctly. Today I noticed once again that the values were missing.

What could be the reason behind it? How can I avoid having to remove and readd the state names at regular intervals?

P.s:: I have double checked that the state IDs are correct.
Last edited by aph on 12 May 2015, 14:36, edited 2 times in total.
OTRS 3.3.x (private/testing) on Windows Server 2008 with MSSQL database.
OTRS 3.3.x (private/testing) on CentOS with MySQL database and apache
aph
Znuny superhero
Posts: 646
Joined: 20 Jun 2014, 12:11
Znuny Version: 3.3.9, 4.x, 5.x

Re: No values in Ticket queue overview on dashboard

Post by aph »

Any ideas on this one? Could it have something to do with encoding?
OTRS 3.3.x (private/testing) on Windows Server 2008 with MSSQL database.
OTRS 3.3.x (private/testing) on CentOS with MySQL database and apache
aph
Znuny superhero
Posts: 646
Joined: 20 Jun 2014, 12:11
Znuny Version: 3.3.9, 4.x, 5.x

Re: No values in Ticket queue overview on dashboard

Post by aph »

Any ideas on this one? Is it a bug?
OTRS 3.3.x (private/testing) on Windows Server 2008 with MSSQL database.
OTRS 3.3.x (private/testing) on CentOS with MySQL database and apache
schulmann
Znuny wizard
Posts: 477
Joined: 20 Nov 2011, 16:08
Znuny Version: 6.5.11
Real Name: Schulmann

Re: No values in Ticket queue overview on dashboard

Post by schulmann »

aph wrote:In the Ticket queue overview widget, I have added two new states (in DashboardBackend###0270-TicketQueueOverview under Ticket -> Frontend::Agent::Dashboard). These states contain the German charachter ü.
My experience says: It's best practice to use english names for ticket states and define appropriate translations in a custom translate file if needed.
Znuny6/Debian/ESXi
aph
Znuny superhero
Posts: 646
Joined: 20 Jun 2014, 12:11
Znuny Version: 3.3.9, 4.x, 5.x

Re: No values in Ticket queue overview on dashboard

Post by aph »

schulmann wrote: My experience says: It's best practice to use english names for ticket states and define appropriate translations in a custom translate file if needed.
Thanks. I renamed the state and used an English name. I have a custom translation file de_Custom.pm. If I add the translation "English name" => "German name" to the custom file, the changes are not visible in the system. I have applied the setPermissions, cleared cache, rebuilt config and restarted apache. The other translations from the custom file are loaded (some of which contain the character ü).

My language file is as follows

Code: Select all

package Kernel::Language::de_Custom;

use strict;
use warnings;

use vars qw(@ISA $VERSION);

sub Data {
    my $Self = shift;

    # $$START$$
# possible charsets
    $Self->{Charset} = ['utf-8', ];
    # own translations
    $Self->{Translation}->{'New phone ticket'} = 'lülülülü';
 $Self->{Translation}->('State1') = 'übersetzung';
    # $$STOP$$
    return 1;
}

1;
So the translation for 'New phone ticket' is displayed correctly, but the translation for 'State1' is not displayed at all.

Any pointers?
OTRS 3.3.x (private/testing) on Windows Server 2008 with MSSQL database.
OTRS 3.3.x (private/testing) on CentOS with MySQL database and apache
reneeb
Znuny guru
Posts: 5018
Joined: 13 Mar 2011, 09:54
Znuny Version: 6.0.x
Real Name: Renée Bäcker
Company: Perl-Services.de
Contact:

Re: No values in Ticket queue overview on dashboard

Post by reneeb »

use

Code: Select all

use utf8;
in the code and you have to use curly braces, not parenthesis...
Perl / Znuny development: http://perl-services.de
Free Znuny add ons from the community: http://opar.perl-services.de
Commercial add ons: http://feature-addons.de
aph
Znuny superhero
Posts: 646
Joined: 20 Jun 2014, 12:11
Znuny Version: 3.3.9, 4.x, 5.x

Re: [SOLVED]No values in Ticket queue overview on dashboard

Post by aph »

Thanks! I had over looked it in putty :D (need to increase the font size or get my eyes checked) :lol:
OTRS 3.3.x (private/testing) on Windows Server 2008 with MSSQL database.
OTRS 3.3.x (private/testing) on CentOS with MySQL database and apache
Locked