[otrs] External Customer DB & Customer info Zoom

[Brannon Kirsch]

Hello,
   I am just testing out OTRS and have successfully connected it to our
existing MS SQL customer database. The only problem I am running into is
that the "Customer Info:" area of Tickets (Zoom, New Email, New Phone)
is blank.
The customer ID is populated correctly and I can search for customers to
get their info, send them email, ect.

Also, possibly related, after a search for customers; I click on a
customer and access the "Customer User Management" screen. All of the
fields are blank.
I have set the MS SQL table as read only, set the always show in the
table mapping, and display info on the ticket front end selection.

Any ideas?

Thank you for your help!


-Brannon


Used field in my Config.pm

#   Ticket::Frontend::CustomerInfo*
    # (show customer user info on Compose (Phone and Email), Zoom and
    # Queue view)
    $Self->{'Ticket::Frontend::CustomerInfoCompose'} = 1;
    $Self->{'Ticket::Frontend::CustomerInfoZoom'} = 1;
    $Self->{'Ticket::Frontend::CustomerInfoQueue'} = 1;

#----
        ReadOnly => 1,
        Map => [
            # note: Login, Email and CustomerID needed!
            # var, frontend, storage, shown (1=always,2=lite), required,
storage-type, http-link,$
#           [ 'UserSalutation', 'null', 'salutation', 1, 0, 'var', 0,
1],
            [ 'UserFirstname', 'myfirstname', ' myfirstname ', 1, 1,
'var', 0, 1],
            [ 'UserLastname', 'mylastname', ' mylastname ', 1, 1, 'var',
0, 1],
            [ 'UserLogin', 'Username', 'Username', 1, 1, 'var', 0, 1],
            [ 'UserPassword', 'Password', 'Password', 1, 1, 'var', 0,
1],
            [ 'UserEmail', 'Email', 'Email', 1, 1, 'var', 0, 1],
#           [ 'UserPhone', 'Phone', 'Phone', 1, 0, 'var', 0, 1],
#           [ 'UserEmail',      'Email', 'email',           0, 1,
#
'var','$Env{"CGIHandle"}?Action=AgentTicketCompose&ResponseID=1&TicketID
=$Data{"Ticke$
            [ 'UserCustomerID', 'mycustomerid', ' mycustomerid ', 1, 1,
'var', 0, 1],
#           [ 'UserCustomerIDs', 'CustomerIDs', 'customer_ids', 1, 0,
'var', '', 0 ],
            [ 'UserComment', 'Notes', 'Notes', 1, 0, 'var', 0, 1],
#            [ 'ValidID',         'null',     'valid_id',    0, 1,
'int', '', 0 ],
        ],