[otrs] Customer Database Connection: Email?

17 Aug 2007

      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
beckman@angryox.com                                 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 **
---------------------------------------------------------------------------