So I've got the backend customer database thing working in OTRS, nice.
Unfortunately, in the http-link in the Mapping I don't know what other
$Data{'variables'} are available other than CustomerID.
I also don't know how to set the customerID as the email address from the
DB, which is my unique ID as well as login. Can I set CustomerID to the email
address, or can I access the email address from the ticket or the Customer
within OTRS so I can pass the email address back to OTRS to get the customer
history in a single click?
My current config:
$Self->{CustomerUser} = {
Name => 'Company',
Module => 'Kernel::System::CustomerUser::DB',
Params => {
DSN => 'DBI:mysql:database=mydb;host=myhost',
User => 'otrs',
Password => 'xxx',
Table => 'users',
},
# customer uniq id
CustomerKey => 'email',
# customer #
CustomerID => 'email',
CustomerUserListFields => ['email','fn', 'ln', 'id'],
CustomerUserSearchFields => ['email', 'ln', 'id', 'fn'],
CustomerUserSearchPrefix => '',
CustomerUserSearchSuffix => '*',
CustomerUserSearchListLimit => 250,
CustomerUserPostMasterSearchFields => ['email'],
CustomerUserNameFields => ['fn','ln'],
CustomerUserEmailUniqCheck => 1,
# 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
[ 'UserFirstname', 'Name', 'concat(fn," ",ln)', 1,
1, 'var', '', 0 ],
[ 'UserEmail', 'Search Tickets', 'email', 1, 1,
'var',
'$Env{"CGIHandle"}?Action=AgentTicketSearch&Subaction=Search&From=$Data{"CustomerID"}',
0 ],
[ 'UserCustomerID', 'Admin ID', 'id', 1, 1, 'var',
'http://myadminsite/?query=$Data{"CustomerID"}', 0 ],
[ 'UserLogin', 'Search Tickets', 'email', 0, 1,
'var',
'$Env{"CGIHandle"}?Action=AgentTicketSearch&Subaction=Search&From=$Data{"CustomerID"}',
0 ],
],
};
---------------------------------------------------------------------------
Peter Beckman Internet Guy
[EMAIL PROTECTED] http://www.angryox.com/
---------------------------------------------------------------------------
** PLEASE NOTE PurpleCow.com IS NOW AngryOx.com DO NOT USE PurpleCow.com **
** PurpleCow.com is now owned by City Auto Credit LLC as of May 23, 2007 **
---------------------------------------------------------------------------
_______________________________________________
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 or consulting for your OTRS system?
=> http://www.otrs.com/
