[otrs] Edit PDF stats

[Soporte Informatica PGJE]

Hi everybody,

I have OTRS 3.1.2

I wanna show only names from agent and customers without ID in my PDF stat.
I thing that with a view  en my database in a relationship between ticket,
customers and agents tables, but i didnt know the way.

How i can do only show “Names” winthout IDS from Customers and Agent/Owner
in TicketList and TicketAcomulation Stats?
Wich the correct and easy way?

My stats today:
https://dl.dropbox.com/u/6443236/otrs/Ticket%20List.pdf
https://dl.dropbox.com/u/6443236/otrs/Tickets%20Acomulations.pdf


Regards from Mexico :)

--
Martin Edmundo

---------------------------------------------------------------------
OTRS mailing list: otrs - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/otrs
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs

[Carlos Rodríguez]

Hi Martin,

I don't think there is an easy way to do that, e.g. in TicketAccumulation this values are fetch from the DB in this lines

sub GetObjectAttributes {

    my ( $Self, %Param ) = @_;

    # get user list

    my %UserList = $Self->{UserObject}->UserList(

        Type  => 'Long',

        Valid => 0,

    );

While it could sound like good idea to try using Type => 'Short', that will not help, because you will only get the UserLogin that THATS what you want to avoid, so I see 2 options, there are maybe more.

1 Loop trough %UserList and remove the login part form the value, I mean is always in format "LastName, FirstName (UserLogin)" (without the quotes), so a Regex can do the magic.... but be careful with names like "De la Torre Heranandez, María Concepción Socorro (2) (Maria2)" where (2) is part of the name as a differentiator..... (you know, it could happen) and (Maria) is the UserLogin

2 Loop trough %UserList and get the UserData by UserGet() on each key, and assemble a temp UserList, when is done, copy the temp UserList to the Original. This is obviously slower than 1. 

Both are dirty solutions  and will need some development skills, as well as modifications to OTRS files, if you wish to to that I will recommend you to  read the Development Manual  and create a package so you don't modify an OTRS file directly, and if you uninstall the package you modified file is removed and replaced with the original. so is safer and portable.

((enjoy))

Carlos Rodríguez

[Soporte Informatica PGJE]

Hi Carlos Rodriguez,

So far are giving me information to keep working, I'll check. Thank you very
much.

========
De: otrs-b...@otrs.org [mailto:otrs-b...@otrs.org] En nombre de Carlos
Rodríguez
Enviado el: martes, 19 de junio de 2012 09:15 p.m.
Para: User questions and discussions about OTRS.
Asunto: Re: [otrs] Edit PDF stats