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
_______________________________________________
OTRS mailing list: otrs - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/otrs
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs
Support orr consulting for your OTRS system?
=> http://www.otrs.com/
