IIRC, you can select which user to merge the others into. I do not know, off the top of my head, if it permanently deletes the users, but from what I can recall, if you view a merged user, it ultimately takes you to the user you merged into.
That is rather circular and may not be correct, since it has been a while since I went through and did our merging. Kenneth Crocker wrote: > Drew, > > > That sounds like a good idea. Should save a lot of SQL coding. How > does the merge work? Does it ultimate delete the old USER records or > disable them? > > > Kenn > LBNL > > On 9/14/2007 9:14 AM, Drew Barnes wrote: >> Or, if they have any tickets associated with the other IDs, use >> http://search.cpan.org/~jesse/RT-Extension-MergeUsers-0.02/ to merge >> them as far as the system in concerned. >> >> Roy El-Hames wrote: >>> Hi Kenneth; >>> >>> I am guessing you mean the Name column and not the Id column within >>> the Users table, (if its the Id column then you need to check the sql >>> engine, that field is pri auto_incremented and the sql engine should >>> n't be allowing duplicate to happen) .. >>> I have seen a duplicate Name, in my case it was due to someone >>> changing things from mysql (which is wrong), it may also happen with >>> some sort of import. >>> what I did to fix is by using sql I changed the name: >>> update Users set Name = x where Name = Y (for each one you do not want >>> to keep); then used RT to remove group membership if any exist then >>> disable the users .. >>> then if you wish delete them from the database using sql or better >>> still use rtx-shredder (if it works for you). >>> >>> Roy >>> Kenneth Crocker wrote: >>>> To all, >>>> >>>> >>>> I've noticed that RT, in this case 3.4.4, allows duplicate >>>> UserIds. I've got a user that is in the system with 3 Ids that ALL >>>> look exactly the same. One with an E_mail address, the other 2 >>>> without and they were ALL created by the system. I have three >>>> questions: >>>> 1) Is this normal or OK? >>>> 2) what can I do to stop this behavior? >>>> 3) How can I get rid of the two USerIDs I do NOT want? (SQL?) >>>> >>>> Well, maybe that's 4 questions. Anyway, does anyone have any >>>> experience in this situation and can you give me some advice on the >>>> above? Thanks. >>>> >>>> Kenn >>>> LBNL >>>> _______________________________________________ >>>> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users >>>> >>>> Community help: http://wiki.bestpractical.com >>>> Commercial support: [EMAIL PROTECTED] >>>> >>>> >>>> Discover RT's hidden secrets with RT Essentials from O'Reilly Media. >>>> Buy a copy at http://rtbook.bestpractical.com >>>> >>> _______________________________________________ >>> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users >>> >>> Community help: http://wiki.bestpractical.com >>> Commercial support: [EMAIL PROTECTED] >>> >>> >>> Discover RT's hidden secrets with RT Essentials from O'Reilly Media. >>> Buy a copy at http://rtbook.bestpractical.com >> _______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
