why do you want to create vendor forms. You can just save as original form with a different name and use that as archive data holder. You can write the escalation to do a push field create entry to the new form and a delete entry on the old form.
On Jan 28, 6:54 am, Viki_kulkarni <[email protected]> wrote: > hi Listers, > > We are trying to enable archiving on ARS 5.01. Yes we are aware that we dont > have archiving functionality on ARS 5.0.1 (correct me if wrong). So here is > how I am planning to do it and would like you guys to have a look at and > with all the experience you have it will be great review. > > The purpose of archiving is to increase performance while searching and to > reduce database size. > > Hence what I am suggesting is to create a new database with tables same as > in AR database. (the T Tables). Then I will create vendor forms for all the > forms that I need to archive and map them to the new database tables that I > have created similar to the AR T tables using ARDBC plugin. Now I will run > an esclation that will move the records from AR server forms to the new > vendor forms by a special user AR_ARCHIVER just as it does with the inbuilt > archiving.All other users will have only read only access to the archive > form as per the inbuilt functionality. > > Now this will reduce the number of records on the AR Server forms and move > it to the archive vendor form. (At least that is the idea) > > Now I am aware that I will need to keep an eye on all the changes that > happens to the base form in terms of field addition and need to replicate on > the vendor archive form. But thats ok with us as there wont be any change we > guess. > > So let me know if you guys think this will work? I am currently trying for a > small POC for the same will update for the same once I pass/fail and what > would be the pros and cons for the same. > > Just trying to think OOTB :) > > Thanks, > Viki > -- > View this message in > context:http://old.nabble.com/Data-Archiving-to-Vendor-form%21%21-will-it-wor... > Sent from the ARS (Action Request System) mailing list archive at Nabble.com. > > ___________________________________________________________________________ > ____ > UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org > attend wwrug11www.wwrug.comARSList: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
