Customer Information Center - adding customer mobile number

[Atavius]

Hi,
in the past I edited few times our Customer Information Center so I am familiar with basics on how to edit it. Right now I need to create new column in the table that should display mobile phone number of the customers, but I am unable to figure out how to query this data from SQL. I tried queering $QData{"mobile"}, but this shows only empty field. Any idea what I am doing wrong?

Thanks in advance

[crythias]

Add the column in the table. Call it something like my_mobile so it doesn't get clobbered by updates. Update the Map in SysConfig.

[Atavius]

Hi crythias,
where in SysConfig can I find the map?

[crythias]

You will want to copy the relevant section from Defaults.pm to Config.pm. Read my Need help? Link and search this forum.

[Atavius]

I already copied CustomerUser part of code to config.pm. But when I add

Code: Select all

my_mobile => [ 'mobile'],

and then add

Code: Select all

   <td>
                $QData{"my_mobile"}
            </td>

to AgentDashboardCustormerUserList I end up with empty cell. Any idea what I am doing wrong?

[crythias]

You didn't update the CustomerUser Map. I didn't indicate anything about changing templates.

[Atavius]

I am not sure if we understand each other. I already have mobile number stored on customers in field UserMobile/Mobile. All I need to do is to add new column to table in Customer Information Center that will display data from this column. So I am not sure why I need to map new field, because field and data are already in database. All I need to query them somehow... If you could explain what needs to be done I would appreciate it.

[crythias]

viewtopic.php?t=17640
http://otrs.github.io/doc/manual/admin/ ... kends.html
http://otrs.github.io/doc/manual/admin/ ... on-mapping

[Atavius]

I saw those links before, but I still dont understand how they relate to my case.

Here is my map from config.pm:

Code: Select all

  Map => [

            # note: Login, Email and CustomerID needed!
            # var, frontend, storage, shown (1=always,2=lite), required, storage-type, http-link, readonly, http-link-target, link class(es)
            [ 'UserTitle',      'Title',      'title',      1, 0, 'var', '', 0 ],
            [ 'UserFirstname',  'Firstname',  'first_name', 1, 1, 'var', '', 0 ],
            [ 'UserLastname',   'Lastname',   'last_name',  1, 1, 'var', '', 0 ],
            [ 'UserLogin',      'Username',   'login',      1, 1, 'var', '', 0 ],
            [ 'UserPassword',   'Password',   'pw',         0, 0, 'var', '', 0 ],
            [ 'UserEmail',      'Email',      'email',      1, 1, 'var', '', 0 ],
#            [ 'UserEmail',      'Email', 'email',           1, 1, 'var', '$Env{"CGIHandle"}?Action=AgentTicketCompose;ResponseID=1;TicketID=$Data{"TicketID"};ArticleID=$Data{"ArticleID"}', 0, '', 'AsPopup OTRSPopup_TicketAction' ],
            [ 'UserCustomerID', 'CustomerID', 'customer_id', 0, 1, 'var', '', 0 ],
#            [ 'UserCustomerIDs', 'CustomerIDs', 'customer_ids', 1, 0, 'var', '', 0 ],
            [ 'UserPhone',        'Phone',       'phone',        1, 0, 'var', '', 0 ],
            [ 'UserFax',          'Fax',         'fax',          1, 0, 'var', '', 0 ],
            [ 'UserMobile',       'Mobile',      'mobile',       1, 0, 'var', '', 0 ],
            [ 'UserStreet',       'Street',      'street',       1, 0, 'var', '', 0 ],
            [ 'UserZip',          'Zip',         'zip',          1, 0, 'var', '', 0 ],
            [ 'UserCity',         'City',        'city',         1, 0, 'var', '', 0 ],
            [ 'UserCountry',      'Country',     'country',      1, 0, 'var', '', 0 ],
            [ 'UserComment',      'Comment',     'comments',     1, 0, 'var', '', 0 ],
            [ 'ValidID',          'Valid',       'valid_id',     0, 1, 'int', '', 0 ],
        ],

As you can see I have field UserMobile already mapped (I think it is done out of box). When I look into customer I see field Mobile and data in it:


Now what I am trying is to display this data here in collumn Mobil:


So if field is already once mapped why I need to map it again?? I just need to display it.

[crythias]

I apologize. I didn't have a visual idea of what you were trying to accomplish and also didn't exactly know what version of OTRS you're using.

Note that any option that might possibly work for 3.3 will need to be adjusted for 4.x.

Basically, though, what's the point? If you're trying to use it as a phone directory, it's not what it's for. Chances are, you probably want to talk about a ticket in which case the data exists and getting to a ticket or creating a ticket will provide everything you want. Unless you need a phone list and then you can query that.

[Atavius]

Well, reason why I need to show mobile number directly in customer info center, is fact that we are sending SMS to our customers with ticket number as their reference. Problem is that our contact records often contain multiple customers with several e-mail aliases, but not all of the contains mobile number, which our agents find out only after clicking on new ticket. Idea here is to display mobile number directly besides customer so that agents will be to create ticket for the right alias that also have mobile number.

So is there a way to query data from customer to show mobile number? Only way that I found so far is by adding mobile to CustomerUserListFields, which works, but result as far for desirable since its not looking nice.