I have 3 user data like this in osticket Version 1.18.2 Jhon A Jhon B Jhon C
When i try to search user with word "Jhon" only Jhon A show in lookup user. how to make show 3 jhon in lookup. I try search with wildcard jhon* but no luck. any suggestion are appreciate.
genx88
Can you show what you mean?
Cheers.
any 3 Jhon name, when i add new data in table ost_user with import ost_user table. then search jhon word, it shows like this . no other jhon user in lookup result
I must type complete spell then lookup show the data
You got something weird going on.. do you have any plugins or mods or anything installed?
for this item no mod or plugins. it only happen when i import /replace new ost_user tabel to existing table. when using existing table (default osticket, ost_user) it works normal when i type Jhon, 3 jhon A, Jhon B, Jhon C show correct.
Why are you importing a table like that instead of importing them through the UI via the CSV (or copy/paste) import feature (Agent Panel > Users > User Directory > Import)? Making it more difficult on yourself. If you do it manually you have to drop the cdata table completely and run cron a bunch of times until it’s rebuilt and fully repopulated with data.
there are many contact more than 6000 users must be import. but there is no export template must be download as csv guidance format to upload data. I try to many import but fail while use format as shown in import display. so I think short step is replace ost_user table with new ost_user with complete user.
forget it for solution, i found the solution for my problem. thanks for your help
I mean, I already posted what you should do above:
… If you do it manually you have to drop the cdata table completely and run cron a bunch of times until it’s rebuilt and fully repopulated with data.
But glad you worked it out.
