[otrs] Custom CustomerUser Data affecting New Ticket Form

[Alexander Scholler]

Hi,

it's difficult helping you without testing your scenario...


Rebekah Hayes schrieb:
> I’ve altered the customer_user table to reflect our customer base.  I
> added hotel, city, state, etc.  I also changed the map in Config.pm to
> use these fields to search and reference customers.
> 
>  
> 
>         # customer uniq id
> 
>         CustomerKey => 'login',

You customer-unique-id is "login".
Is this field unique within your customer_table and always set?

> 
>         # customer #
> 
>         CustomerID => 'customer_id',
> 
>         CustomerValid => 'valid_id',
> 
>         CustomerUserListFields => ['customer_id', 'hotel', 'city'],
> 
>         CustomerUserSearchFields => ['customer_id', 'hotel', 'city'],
> 
>         CustomerUserSearchPrefix => '',
> 
>         CustomerUserSearchSuffix => '*',
> 
>         CustomerUserSearchListLimit => 250,
> 
>         CustomerUserPostMasterSearchFields => ['email'],
> 
>         CustomerUserNameFields => ['hotel'],
> 
>         CustomerUserEmailUniqCheck => 1,
> 
>         Map => [
> 
>             # note: Login, Email and CustomerID needed!
> 
>             # var, frontend, storage, shown (1=always,2=lite), required,
> storage-type, http-link, readonly
> 
>             [ 'UserHotel', 'Hotel', 'hotel',  1, 1, 'var', '', 0 ],
> 
>             [ 'UserCustomerID', 'Building Code', 'customer_id', 1, 1,
> 'var', '', 0 ],
> 
>             [ 'UserCity', 'City', 'city', 1, 1, 'var', '', 0 ],
> 
>             [ 'UserState', 'State', 'state', 1, 1, 'var', '', 0 ],
> 
>             [ 'UserCountry', 'Country', 'country', 1, 1, 'var', '', 0 ],
> 
>             [ 'UserPostalCode', 'Postal Code', 'postalcode', 1, 1,
> 'var', '', 0 ],
> 
>             [ 'UserPhone', 'Phone Number', 'phone', 1, 1, 'var', '', 0 ],
> 
>             [ 'UserLogin',      'Username',   'login',       1, 1,
> 'var', '', 0 ],
> 
>             [ 'UserPassword',   'Password',   'pw',          0, 0,
> 'var', '', 0 ],
> 
>             [ 'UserEmail',      'Email',      'email',       0, 1,
> 'var', '', 0 ],
> 
>             [ 'ValidID',         'Valid',     'valid_id',    0, 1,
> 'int', '', 0 ],
> 
>  
> 
> This has led to an error on the creation of a new Phone-ticket.  When I
> type a customer_id or hotel in the From field and click Search Customer
> it displays the customer_id hotel city correctly but after that field is
> the following: 
> 
>  
> 
> invalid TBC (Invalid syntax)! invalid Test (Invalid syntax)! invalid
> Hotel (Invalid syntax)! invalid and (Invalid syntax)! invalid Suites
> (Invalid syntax)! invalid Test (Invalid syntax)! invalid City (Invalid
> syntax)!
> 
>  
> 
> Can someone point me in the direction of why this would cause an error
> and where this page is generated.

I suggest you to reuse the original configuration and DB-setting and
then modify this to suit your needs step-by-step.

> 
>  
> 
> Thanks
> 
>  
> 
> Rebekah Hayes

Bye, Alex