06-24-2015 09:25 AM - edited 03-19-2019 09:44 AM
Hi,
We have migrated users from an older IMP 8.6 to 10.5. As part of this, we wanted to move their contact lists but the original CSV file seemed to formatted incorrectly so has inserted users in the wrong way (nickname is showing group name instead).
We now have the CSV in the correct format, but when importing into Presence, it hasn't overwritten the old ones, and instead has created two entries, e.g.
User: jsmith@domain.com Nickname:IT Group:IT
User: jsmith@domain.com Nickname:John Group:IT
Other than ask the users to delete all these duplicate contacts, is there a way we can delete them from the server side? - it doesn't appear to be a feature within the Bulk Admin (although you can import, export, and modify...). Is there a SQL query I can run to clear out the tables?
I've also tried unassigning the users for Presence and adding them back in again, but this doesn't seem to affect / update the contacts.
Thanks
Sean
Solved! Go to Solution.
06-25-2015 12:28 AM
Hi Sean,
You can try the below procedure:
1. Have a copy of CSV file which has the set of correct contact list to import
2. Stop important services like XCP router, PE and SP
3. You can verify on the existing contacts using the sql query in IMP CLI:
run sql select * from rosters
4. To delete all the contacts:
run sql delete from rosters ---> This will delete contact list of all the jabber users. Should be run only when there is a need to delete all of them
5. Now import the CSV file to IMP via bulk administartion
6. Start all the services
Regards
06-25-2015 12:28 AM
Hi Sean,
You can try the below procedure:
1. Have a copy of CSV file which has the set of correct contact list to import
2. Stop important services like XCP router, PE and SP
3. You can verify on the existing contacts using the sql query in IMP CLI:
run sql select * from rosters
4. To delete all the contacts:
run sql delete from rosters ---> This will delete contact list of all the jabber users. Should be run only when there is a need to delete all of them
5. Now import the CSV file to IMP via bulk administartion
6. Start all the services
Regards
06-25-2015 02:20 AM
Thanks. It seems to delete them correctly, but they still show in Jabber. Is there a difference between contacts and contact lists in this regard?
If I now run select * from rosters, the results are blank. I added a new user manually and there was one result. I did an export of contact lists and there was only 1 exported. Yet, when I log the users into Jabber, the other contacts are still there in the list.
I have reset Jabber and deleted all caches and appdata, so this must still be pulling the list from the server side somewhere.
06-25-2015 03:00 AM
Actually all working, just needed a restart of the server. Thanks for your help!
08-03-2018 09:48 AM
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide