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
314-787-0681 x39
314-565-0868