Hi, I am trying to put a POC OTRS system together here, and most things are going well. It is installed on the Windows platform. The following are working fine :- LDAP/Active Directory Agent Integration LDAP/Active Directory Customer Integration We have a separate 'external' customers database running on MSSQL via ODBC and have got a partially working backend configuration (below). Performing a customer search works partially. I can perform a search and get a list of customer details shown down the left hand side of the window. However, when I click on a customer, I am expecting the detail fields on the right hand side to be populated. This is not happening. Also, customer details are not shown on the ticket view. I have done a trace on the DBD calls, and can show that it is retrieving the expected values from the database. I have scoured google and trawled through the mailing lists, but cannot spot anything useful. Can anyone point me in the right direction please? TIA, Dave --------- $Self->{CustomerUser} = { Name => 'OSCAR Database', Module => 'Kernel::System::CustomerUser::DB', Params => { # if you want to use an external database, add the # required settings DSN => 'DBI:ODBC:OTRS', User => 'otrsuser', Password => 'xxxxxxxxxxxx', Table => 'otrs_customers', Type => 'mssql', }, # customer uniq id CustomerKey => 'uid', # customer # CustomerID => 'email', CustomerUserListFields => ['company_name', 'first_name', 'last_name', 'email'], CustomerUserSearchFields => ['first_name', 'last_name', 'email', 'company_name'], CustomerUserSearchPrefix => '', CustomerUserSearchSuffix => '*', CustomerUserSearchListLimit => 250, CustomerUserPostMasterSearchFields => ['email'], CustomerUserNameFields => ['first_name','last_name'], AdminSetPreferences => 0, # just a read only source ReadOnly => 1, Map => [ # note: Login, Email and CustomerID needed! # var, frontend, storage, shown (1=always,2=lite), required, storage-type, http-link, readonly # [ 'UserSalutation', 'Salutation', 'salutation', 1, 0, 'var', '', 0 ], [ 'UserFirstname', 'Firstname', 'first_name', 1, 0, 'var', '', 0 ], [ 'UserLastname', 'Lastname', 'last_name', 1, 0, 'var', '', 0 ], [ 'UserEmail', 'Email', 'email', 1, 0, 'var', '', 0 ], # [ 'UserCustomerID', 'CustomerID', 'email', 0, 0, 'var', '', 0 ], [ 'UserPhone', 'Phone', 'phone', 1, 0, 'var', '', 0 ], [ 'UserComment', 'Company', 'company_name', 1, 0, 'var', '', 0 ], ], # default selections Selections => { UserSalutation => { 'Mr.' => 'Mr.', 'Mrs.' => 'Mrs.', }, }, }; ----------------------------------------------- Visit us at NISC 8 : 16th to 18th May 2007 : www.nisc.org.uk Any opinions expressed in this message are those of the individual and not necessarily the company. This message and any files transmitted with it are confidential and solely for the use of the intended recipient. If you are not the intended recipient or the person responsible for delivering to the intended recipient, be advised that you have received this message in error and that any use is strictly prohibited. Sapphire Technologies Ltd Registered office is Globe House, Station Street, Stockton-on-Tees, Cleveland TS20 2AB Registered in England No. 3183935. VAT Reg. No. 664 8748 81 http://www.sapphire.net