Get Customer Name to Appear in Stat Report

Moderator: crythias

Post Reply
jason123
Znuny newbie
Posts: 33
Joined: 25 Apr 2016, 15:27
Znuny Version: OTRS 5

Get Customer Name to Appear in Stat Report

Post by jason123 »

Does anyone know if there is a way to get the Customer Name in the Stat reports?

I can get the Customer ID and Customer User but that is it.

Thanks,
Jason
Eggllo
Znuny newbie
Posts: 79
Joined: 09 Jun 2016, 14:27
Znuny Version: 5.0.10

Re: Get Customer Name to Appear in Stat Report

Post by Eggllo »

Hey,

Check out Core::Ticket in sysconfig. The setting DynamicFieldFromCustomerUser::Mapping should let you map customer attributes to dynamic fields. Just make a dynamic field for the customer name, and then use that setting to map it. You should be able to show the resulting dynamic field in your stat reports.
OTRS v5.0.10 with ITSM extension.
MySQL database
Ubuntu 16.04 LTS
jason123
Znuny newbie
Posts: 33
Joined: 25 Apr 2016, 15:27
Znuny Version: OTRS 5

Re: Get Customer Name to Appear in Stat Report

Post by jason123 »

Thank you, this is definitely the way I need to do it.

I checked out the documentation regarding this (did not notice it before) at http://otrs.github.io/doc/manual/admin/ ... stomeruser. However, I cannot seem to connect the dots on how to get it to work. Some questions are as follows:
  • I enabled both DynamicFieldFromCustomerUser::Mapping and Ticket::EventModulePost###930-DynamicFieldFromCustomerUser,but how do I set the latter to show customer names for existing customers rather than when the ticket is updated or when the ticket is created?
    • I have configured Ticket::Frontend::AgentTicketFreeText###DynamicField as follows, is it correct?
      • Key=CustomerFirstname; Content=1
    • When creating the dynamic field, how do I specify its Name, Label, Default Value, etc. to get the customer names to appear in this field?
    Thank you for your help,
    Jason
    nice2cu
    Znuny newbie
    Posts: 21
    Joined: 22 Nov 2010, 18:44
    Znuny Version: 5.0.20
    Real Name: Robert Langhammer
    Company: emaxit

    Re: Get Customer Name to Appear in Stat Report

    Post by nice2cu »

    Is there now a solutioGreetings, Robert
    jason123
    Znuny newbie
    Posts: 33
    Joined: 25 Apr 2016, 15:27
    Znuny Version: OTRS 5

    Re: Get Customer Name to Appear in Stat Report

    Post by jason123 »

    Hello nice2cu,

    I have moved onto other things, this has been moved lower on my priority list. However, my conclusion, when I find time to work on it again, is to hook the module or template and make the modification in Perl. I have been doing this more and more using the otrs/Custom/ dir.

    Thanks,
    j
    Snowmanko
    Znuny newbie
    Posts: 59
    Joined: 06 Mar 2015, 17:45
    Znuny Version: 6.0.5-1

    Re: Get Customer Name to Appear in Stat Report

    Post by Snowmanko »

    Anyone know how to map this?
    OTRS 6.0.3-1, MySQL
    Post Reply