
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 ], ],