es wäre super wenn sich jemand melden könnte. Leider gab es schon einige Antworten im Forum, aber keine passte bei mir. Ich würde gerne mit folgendem Eintrag in der Config.pm meine VTiger-Kundentabelle in OTRS einbinden:
Code: Select all
# CustomerUser
# (customer user database backend and settings)
$Self->{CustomerUser} = {
Name => 'VTigerCRM',
Module => 'Kernel::System::CustomerUser::DB',
Params => {
# if you want to use an external database, add the
# required settings
# DSN => 'DBI:odbc:yourdsn',
DSN => 'DBI:mysql:database=vtigercrm510;host=localhost',
User => 'vtigerUser',
Password => 'MyPassword',
Table => 'vtiger_contactdetails',
},
# customer uniq id
CustomerKey => 'contactid',
# customer #
CustomerID => 'contact_no',
# CustomerValid => 'valid_id',
CustomerUserListFields => ['firstname', 'lastname', 'email'],
# CustomerUserListFields => ['login', 'first_name', 'last_name', 'customer_id', 'email'],
CustomerUserSearchFields => ['email', 'firstname', 'lastname'],
CustomerUserSearchPrefix => '',
CustomerUserSearchSuffix => '*',
CustomerUserSearchListLimit => 250,
CustomerUserPostMasterSearchFields => ['email'],
CustomerUserNameFields => ['salutation', 'firstname', 'lastname'],
CustomerUserEmailUniqCheck => 0,
# # show now own tickets in customer panel, CompanyTickets
# CustomerUserExcludePrimaryCustomerID => 0,
#generate auto logins
AutoLoginCreation => 1,
# # generate auto login prefix
# AutoLoginCreationPrefix => 'auto',
# # admin can change customer preferences
AdminSetPreferences => 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
[ 'UserSalutation', 'Salutation', 'salutation', 1, 0, 'var', '', 0 ],
[ 'UserFirstname', 'Firstname', 'firstname', 1, 1, 'var', '', 0 ],
[ 'UserLastname', 'Lastname', 'lastname', 1, 1, 'var', '', 0 ],
[ 'UserLogin', 'Username', 'email', 1, 1, 'var', '', 0 ],
[ 'UserPassword', 'Password', 'department', 0, 0, 'var', '', 0 ],
[ 'UserEmail', 'Email', 'email', 0, 1, 'var', '', 0 ],
[ 'UserEmail', 'Email', 'email', 1, 1, 'var', '$Env{"CGIHandle"}?Action=AgentTicketCompose&ResponseID=1&TicketID=$Data{"TicketID"}&ArticleID=$Data{"ArticleID"}', 0 ],
[ 'UserCustomerID', 'CustomerID', 'contactid', 0, 1, 'var', '', 0 ],
# [ 'UserCustomerIDs', 'CustomerIDs', 'customer_ids', 1, 0, 'var', '', 0 ],
[ 'UserPhone', 'Phone', 'phone', 1, 0, 'var', '', 0 ],
[ 'UserMobile', 'Mobile', 'mobile', 0, 1, 'var', '', 0 ],
],
# default selections
Selections => {
# UserSalutation => {
# 'Mr.' => 'Mr.',
# 'Mrs.' => 'Mrs.',
# },
},
};Vielen Dank.
GeorgH
