Unable to View Customers on AgentTicketEmail.tt, OTRS v4.0.8

Moderator: crythias

Locked
smuwanga
Znuny newbie
Posts: 27
Joined: 31 Dec 2014, 10:57
Znuny Version: 5.0.22
Real Name: Simon Peter Muwanga
Company: UgandaSoft
Contact:

Unable to View Customers on AgentTicketEmail.tt, OTRS v4.0.8

Post by smuwanga »

Hello,

I am unable to view customers after configuring Config.pm as below;

Code: Select all

   #--------CustomerUserConfig ------------------------#
$Self->{CustomerUser} = {
    Name => 'Database Datasource',
    Module => 'Kernel::System::CustomerUser::DB',
    Params => {

            Table => 'tester',
           # CaseSensitive will control if the SQL statements need LOWER()
            #   function calls to work case insensitively. Setting this to
         CaseSensitive => 0,
        },
# customer unique id
    CustomerKey => 'username',

# customer #
    CustomerID => 'customer_id',
    CustomerValid => 'valid_id',
    CustomerUserListFields => ['customer_name', 'customer_id', 'email'],
    CustomerUserSearchFields => ['customer_name', 'customer_id'],
    CustomerUserSearchPrefix => '',
    CustomerUserSearchSuffix => '*',
    CustomerUserSearchListLimit => 250,
    CustomerUserPostMasterSearchFields => ['email'],
    CustomerUserNameFields => ['customer_name'],
    CustomerUserEmailUniqCheck => 1,

    Map => [
        # note: Login, Email and CustomerID needed!
        [ 'UserFirstname',  'Customer',        'customer_name',  1, 1, 'var', '', 0 ],
        [ 'UserLogin',      'Username',        'customer_id',  1, 1, 'var', '', 0 ],
        [ 'UserPassword',   'Password',        'customer_id',  0, 0, 'var', '', 0 ],
        [ 'UserEmail',      'Email',           'email',          1, 1, 'var', '', 0 ],
        [ 'UserCustomerID', 'id',        'customer_id', 0, 1, 'var', '', 0 ],
        [ 'ValidID',          'Status',       'valid_id',     0, 1, 'int', '', 0 ],
          ],
    # default selections
    Selections => {
        UserTitle => {
            'Mr.' => 'Mr.',
            'Mrs.' => 'Mrs.',
        },
    },
};
#---------end customer config----------------------#

NB: The above configurations work well with OTRS v3.3.x
I also get [Kernel::System::CheckItem::CheckEmail][191] Jupiter Ltd has no mail exchanger (MX) or A resource record defined

What am I not doing right?
Locked