I've used Misi's tool several times in the past and it worked great every time. My only "gotcha" was that I did have to go back and change a few table qualifications and workflow items to match the new values.
This is a much better solution than mucking around in the database directly; I have first-hand knowledge since before I took over my predecessor had added values in the middle of the Status list directly in the database and as a result the Status History is out of sync on older tickets. -Rick -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Misi Mladoniczky Sent: Tuesday, May 02, 2006 10:49 AM To: [email protected] Subject: Re: Changing Value Order in 'Status' field Hi, I think that the big difference between rrrSelectionChange and archgsel is that the Status-History is also "fixed" with my tool. It will also let you do multiple swaps/inserts/removals in a single pass. Finally, it can either do the exchange directly to your DB (through the API), or it can create an ARX-file with the old data (backup) and the new data that you can later import with ARImport. Best Regards - Misi, RRR AB, http://www.rrr.se > There is a program in the developer community downloads called > archgsel which I have used many times in the past with great success. > It allows you to insert, delete, and reorder items. > > I believe that Misi also has a similar program (for free as well) on > his > website: http://www.rrr.se. It's called rrrSelectionChange and is in > the rrrTools section. I haven't used it, but everything else of > Misi's that I've tried has worked... :) > > Good luck! > > Matt Reinfeldt > > -----Original Message----- > From: T Wang [mailto:[EMAIL PROTECTED] > Sent: Tuesday, May 02, 2006 7:28 AM > To: [email protected] > Subject: Changing Value Order in 'Status' field > > Hi List, > > I had a request to change the order of the selection list for the 'Status' > field and would like to know what people have done in the past to > accomplish this task successfully. I know that there are probably > couple of ways to do this and I know that there might not be an easy > clean way to do it. If you won't mind sharing the experience I am > pretty sure that other would benefit from this as well. > > Thank you. > > ______________________________________________________________________ > ______ > ___ > UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org > > ______________________________________________________________________ > _________ UNSUBSCRIBE or access ARSlist Archives at > http://www.wwrug.org > ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
