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