I am trying setup my customer access, but am having some issues.
Customer with multible IDs (Company tickets)
mySQL Columns from customer_user table:
+--------------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+--------------+--------------+------+-----+---------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| login | varchar(100) | NO | UNI | | |
| email | varchar(150) | NO | | | |
| customer_id | varchar(200) | NO | | | |
| pw | varchar(50) | NO | | | |
| salutation | varchar(50) | YES | | NULL | |
| first_name | varchar(100) | NO | | | |
| last_name | varchar(100) | NO | | | |
| comments | varchar(250) | NO | | | |
| valid_id | smallint(6) | NO | | | |
| create_time | datetime | NO | | | |
| create_by | int(11) | NO | | | |
| change_time | datetime | NO | | | |
| change_by | int(11) | NO | | | |
| customer_ids | varchar(250) | YES | | NULL | |
| phone | varchar(250) | YES | | NULL | |
+--------------+--------------+------+-----+---------+----------------+
Config added to Config.pm
***************************************************************
# CustomerUser
# (customer user database backend and settings)
$Self->{CustomerUser} = {
Name => 'Datenbank Quelle',
Module => 'Kernel::System::CustomerUser::DB',
Params => {
Table => 'customer_user',
},
CustomerKey = 'login',
CustomerID = 'customer_id',
CustomerValid = 'valid_id',
CustomerUserListFields => ['first_name', 'last_name', 'email'],
CustomerUserSearchFields => ['login', 'last_name',
'customer_id'],
CustomerUserSearchPrefix => '',
CustomerUserSearchSuffix => '*',
CustomerUserSearchListLimit => 250,
CustomerUserPostMasterSearchFields => ['email'],
CustomerUserNameFields =>
['salutation','first_name','last_name'],
CustomerUserEmailUniqCheck => 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, 1,
'var', '', 0 ],
[ 'UserLastname', 'Lastname', 'last_name', 1, 1,
'var', '', 0 ],
[ 'UserLogin', 'Username', 'login', 1, 1,
'var', '', 0 ],
[ 'UserPassword', 'Password', 'pw', 0, 1,
'var', '', 0 ],
[ 'UserEmail', 'Email', 'email', 0, 1,
'var', '', 0 ],
[ 'UserCustomerIDs', 'CustomerIDs', 'customer_ids', 1, 0,
'var', '', 0 ],
[ 'UserCustomerID', 'CustomerID', 'customer_id', 0, 1,
'var', '', 0 ],
[ 'UserComment', 'Comment', 'comments', 1, 0,
'var', '', 0 ],
[ 'UserPhone', 'Phone', 'phone', 0, 1,
'var', '', 0 ],
[ 'ValidID', 'Valid', 'valid_id', 0, 1,
'int', '', 0 ],
],
# default selections
Selections => {
UserSalutation => {
'Mr.' => 'Mr.',
'Mrs.' => 'Mrs.',
},
},
};
***************************************************************
Apache2 states error around the ( CustomerKey = 'login', ) line
Andrew Meyer
Unix Systems Analyst
Precision Practice Management
1300 Hampton Ave., Ste 200
314-787-0681 x39
314-565-0868
BEGIN:VCARD
VERSION:2.1
N:Meyer;Andrew
FN:Andrew Meyer
ORG:;Information Technology
TITLE:Unix Administrator
TEL;WORK;VOICE:314-277-3307
TEL;HOME;VOICE:314-277-3307
TEL;CELL;VOICE:314-565-0868
ADR;WORK:;Hampton;11549 Templar Dr.;Creve Coeur;MO;63141;United States
LABEL;WORK;ENCODING=QUOTED-PRINTABLE:Hampton=0D=0A11549 Templar Dr.=0D=0ACreve Coeur, MO 63141=0D=0AUnited States
EMAIL;PREF;INTERNET:[EMAIL PROTECTED]
REV:20070712T170709Z
END:VCARD
_______________________________________________
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/
