Hi, RRR|Chive has the ability to MOVE things, which is good when you do archiving. If the forms are identical, it is very easy, and you can retain the original Request ID, which the built in archiving does not support.
You can also use RRR|Chive to archive things to ARX-files. If you then use RRR|ArxToHTML, you get a very simple way of accessing your old data from a web server or a file share. Here is a sample database dump done with RRR|Chive and RRR|ArxToHTML of a newly installed ITSM 7.6.04 Stack Installer: http://rrr.se/itsmdoc/itsm764arxhtml/ This sample rrrchive config will archive between two forms after 3 months: source_server = myserver source_user = Demo source_password = source_form = HPD:Help Desk target_server = myserver target_form = HPD:Help Desk Archive qual = '7' = "Closed" AND '6' < $TIMESTAMP$ - 3*30*24*60*60 transfertype = MOVE logfile = AUTO progressbar = YES This sample rrrchive config will archive to ARX-files after 6 months: source_server = myserver source_user = Demo source_password = source_form = HPD:Help Desk Archive target_dir = C:\archive target_form = HPD:Help Desk Archive qual = '7' = "Closed" AND '6' < $TIMESTAMP$ - 6*30*24*60*60 transfertype = MOVE logfile = AUTO progressbar = YES This RRR|ArxToHTML call will create HTML pages based on an ARX-file and a DEF-file with the form definition: rrrArxToHTML.pl -suppressnull -d "c:\archivehtml\schema.def" -a "c:\archive\HPD_Help_Desk_Archive.arx" -t "c:\archivehtml\html" ADV: If you want a supported solution, you can always sign up for support on RRR|Chive, which is otherwise free to use. Just ask for a quote. Best Regards - Misi, RRR AB, http://rrr.se > Robin, > Both of these could be handled by RRR|Chive. > www.rrr.se > > Misi's tools are very straight forward. > > Thank you, > --- > John J. Reiser > Remedy Developer/Administrator > Senior Software Development Analyst > Lockheed Martin - MS2 > The star that burns twice as bright burns half as long. > Pay close attention and be illuminated by its brilliance. - paraphrased by > me > > > -----Original Message----- > From: Action Request System discussion list(ARSList) > [mailto:[email protected]] On Behalf Of Robin > Sent: Tuesday, August 07, 2012 3:07 AM > To: [email protected] > Subject: EXTERNAL: Help on archiving data. > > Hi all, > > Can you please let me know your suggestions/solutions on requirements 1 > and 2? > > 1) Transfer records from a regular form to an archive form and delete > records from the regular form. I don't want to use built-in remedy archive > feature as it consumes lot of resources and takes long time to complete. > > 2) Transfer records from an archive table to a different database table > and delete records from the archive table. > > The AR System database is oracle. > > > Regards > Robin > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 > www.wwrug12.com ARSList: "Where the Answers Are" > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are" > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
