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',
# 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.
Thanks
Rebekah Hayes