I want to get more customer info when i create ticket. I decide to use more than one customer backend. I did everything in documents at the below.
http://otrs.github.io/doc/manual/admin/ ... kends.html
Everythings are working well except turkish character problem. When i check customer info in ticket, turkish chars are not shown correctly. Anybody help me?
My source database encoding is utf-8
My destination charset must be ISO-8859-9 to shown correctly.
My code is;
Code: Select all
# 1. Customer user backend: DB
# (customer database backend and settings)
$Self->{CustomerUser} = {
Name => 'MySU Rehber',
Module => 'Kernel::System::CustomerUser::DB',
Params => {
# if you want to use an external database, add the
# required settings
# DSN => 'DBI:odbc:yourdsn',
Type => 'postgresql', # only for ODBC connections
DSN => 'DBI:Pg:dbname=xxxxx;host=xxxxxxxxxx',
User => 'xxxxxxxxx',
Password => 'xxxxxxxxx',
Table => 'xxxxxxxxxxxxxxx',
},
# customer unique id
CustomerKey => 'username',
# customer #
CustomerID => 'email',
# CustomerValid => 'valid_id',
CustomerUserListFields => ['first_name', 'last_name', 'email'],
CustomerUserSearchFields => ['username','first_name', 'last_name', 'email'],
CustomerUserSearchPrefix => '',
CustomerUserSearchSuffix => '*',
CustomerUserSearchListLimit => 25,
CustomerUserPostMasterSearchFields => ['email'],
CustomerUserNameFields => ['first_name','middle_name','last_name'],
CustomerUserEmailUniqCheck => 1,
SourceCharset => 'utf-8',
DestCharset => 'ISO-8859-9',
CharsetConvertForce => 1,
# CaseSensitive => 1,
# # show not own tickets in customer panel, CompanyTickets
# CustomerUserExcludePrimaryCustomerID => 0,
# # generate auto logins
# AutoLoginCreation => 0,
# AutoLoginCreationPrefix => 'auto',
# # admin can change customer preferences
# AdminSetPreferences => 1,
# # cache time to live in sec. - cache any database queries
CacheTTL => 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, http-link-target
# [ 'UserTitle', 'Title', 'title', 0, 0, 'var', '', 0 ],
[ 'UserFirstname', 'Firstname', 'first_name', 1, 1, 'var', '', 0 ],
[ 'UserLastname', 'Lastname', 'last_name', 1, 1, 'var', '', 0 ],
[ 'UserLogin', 'Username', 'username', 1, 0, 'var', '', 0 ],
# [ 'UserPassword', 'Password', 'pw', 0, 0, 'var', '', 0 ],
[ 'UserEmail', 'Email', 'email', 0, 1, 'var', '', 0 ],
[ 'UserCustomerID', 'CustomerID', 'email', 0, 1, 'var', '', 0 ],
[ 'UserPhone', 'Phone Number' ,'int_phone', 1, 0, 'var', '', 0 ],
# [ 'UserFax', 'Fax', 'fax', 0, 0, 'var', '', 0 ],
# [ 'UserMobile', 'Mobile', 'mobile', 0, 0, 'var', '', 0 ],
[ 'UserCity', 'Building', 'bldg_shortdesc_tr', 1, 0, 'var', '', 0 ],
[ 'UserStreet', 'Room Number', 'room_no', 1, 0, 'var', '', 0 ],
# [ 'UserZip', 'Zip', 'zip', 0, 0, 'var', '', 0 ],
[ 'UserCountry', 'Unit', 'unit_shortdesc_tr', 1, 0, 'var', '', 0 ],
[ 'UserComment', 'Profile', 'profile_name_tr', 1, 0, 'var', '', 0 ],
# [ 'ValidID', 'Valid', 'valid_id', 0, 1, 'int', '', 0 ],
],
# default selections
Selections => {
UserTitle => {
'Mr.' => 'Mr.',
'Mrs.' => 'Mrs.',
},
},
};