How to export to merge duplicate data for reimport

[pctekk]

We have data in a helpdesk program(Trackit) that has duplicate userID names that we need to sync together, how is that done ?

example(UserID 10 = Bob Smith which has preassigned tickets already in the db)
then UserID 20 = Bob Smith which has no preassigned tickets in the db)


hope that explains but please let me know and i can further detail

 

[Corran007]

why do you need to export at all? is there a resason you cannot just deterime who has dups then update they keys of the second dup with the first dups key? based on name, phone, whatever method you are going to use to deterimne they are dups?

 

[pctekk]

cant w/ that software(trackit)
each name has cooresponding history of open/closed trouble tickets that need to go w/ that name