[otrs] customer backend

16 Jul 2007


      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