That's pretty good advice Ben, If there is a way of disabling the merge workflow without modifying workflow that would be preferable.
The option to drop and re-create indexes is probably one that shouldn't be used unless the extra performance is absolutely necessary. It's quite easy to terminate the transfer and then lose the indexes. Disassociating the audit form is not as risky as the dropping and re-instating of indexes as it can usually be repaired without too much hassle. Rod On 01/10/2009, Ben Chernys <ben.cher...@softwaretoolhouse.com> wrote: > Hi Misi, > > > > The danger with this, as with the disable-merge-filter option and > > > drop-index-option, is when the ARServer or RRR|Chive is turned off > > > in the middle of the transfer. The form currently processed may not > > > be restored automatically. You have to check the logs to see what > > > happened, and if anything was turned off before the process was halted. > > The disable-merge-filter should be just a bit you add to the merge options. > It affects only that single merge call. That bit was added in rel 6.0 and > is: AR_MERGE_NO_WORKFLOW_FIRED. You need not touch any filters for this. > > Unfortunately, this does NOT disable the audit "filter" which is an implied > server filter and disassociation may be the only way to achieve this. > > Drop index etc has no equivalent in ARS and is indeed dangerous when a > process that has done so has been terminated prematurely. > > Good luck in Vegas. > > Cheers > Ben > www.softwaretoolhouse.com > > > -----Original Message----- > From: Action Request System discussion list(ARSList) > [mailto:arsl...@arslist.org] On Behalf Of Rod Harris > Sent: October 1, 2009 8:31 AM > To: arslist@ARSLIST.ORG > Subject: Re: OT: Update of free RRR|Chive data migration tool > > Hi Misi, > > So far so good. Now I don't have to add extra conditions in the audit > qualification to stop the unnecessary audit data from being generated. > > I'm using rrrChive frequently during development to reset my test data each > time I run a test. > > This is how I'm using it. > 1. Develop > 2. sync data from prod to dev > 3. run test > 4. Examine results > 5.Go to step 1 > > Thanks for this excellent utility. I'm still discovering new uses for it > and I have an ever growing number of rrrChive config files for various > things. It's so simple yet so powerful. > > Rod > > > > > On 29/09/2009, Rod Harris <r...@smapps.com.au> wrote: > > Hi Misi, > > > > Excellent work. I will let you know how it goes. > > > > Rod > > > > On 26/09/2009, Misi Mladoniczky <m...@rrr.se> wrote: > > > Hi Rod and others, > > > > > > I have now added the functionality to handle audit- and > > > archive-forms in version 2.06 of RRR|Chive. > > > > > > I have added an option called target_disableaudit=YES, which turns > > > off the audit of data when records are updated. This is to prevent > > > generation of a lot of meaningless audit data caused by the > data-transfer. > > > > > > The other thing was to allow copy of data to audit- and archive-forms. > > > This does not require any special switch, but is automatic. Whenever > > > an audit-form or archive-form is encontered, the audit or archive > > > option is removed from the parent-form. It is added again when the > > > data has been copied. > > > > > > The danger with this, as with the disable-merge-filter option and > > > drop-index-option, is when the ARServer or RRR|Chive is turned off > > > in the middle of the transfer. The form currently processed may not > > > be restored automatically. You have to check the logs to see what > > > happened, and if anything was turned off before the process was halted. > > > > > > Let me know how it works for you, or if you have any thoughts or > suggestions! > > > > > > Best Regards - Misi, RRR AB, http://www.rrr.se > > > > > > Products from RRR Scandinavia: > > > * RRR|License - Not enough Remedy licenses? Save money by optimizing. > > > * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy > logs. > > > Find these products, and many free tools and utilities, at > http://rrr.se. > > > > > > > Hi Misi, > > > > > > > > How about having an option to disassociate/associate with an > > > > optional sync of the related audit records? This would be the best > > > > scenario for me. Can it be done easily? It would make a great > > > > product even better if you could do that. > > > > > > > > One thing most users wouldn't want is for the sync to be slowed > > > > down or broken by generating lots of useless audit records that > > > > then need to be cleared or overwritten by the real ones. > > > > > > > > Rod > > > > > > > > > > > > > > > > > > > > > > > > On 23/09/2009, Misi Mladoniczky <m...@rrr.se> wrote: > > > >> Hi, > > > >> > > > >> That should be a simple enough thing to implement. It is a > > > >> spearated option to ARSetSchema(), which makes it isolated. The > > > >> ARAuditInfoStruct also seems stable enough between versions. > > > >> > > > >> What about Archive and Audit Forms? You can not merge data into > > > >> these forms, making them impossible copy data to. > > > >> > > > >> The only solution I can think of is to disassociate the > > > >> Archive/Audit-Form first, and then reassociate it. It is harder > > > >> to do, but quite straight forward. > > > >> > > > >> Any thoughts on this? > > > >> > > > >> Best Regards - Misi, RRR AB, http://www.rrr.se > > > >> > > > >> Products from RRR Scandinavia: > > > >> * RRR|License - Not enough Remedy licenses? Save money by optimizing. > > > >> * RRR|Log - Performance issues or elusive bugs? Analyze your > > > >> Remedy logs. > > > >> * RRR|Translator - Manage and automate your language translations. > > > >> Find these products, and many free tools and utilities, at > > > >> http://rrr.se. > > > >> > > > >> > Hi Misi, > > > >> > > > > >> > I love rrrChive. I was wondering if you already have, or are > > > >> > considering, an option to disable form auditing during a sync. > > > >> > I know you have features for disabling workflow and indexing > > > >> > but would a similar feature to disable auditing be a useful > addition? > > > >> > > > > >> > I am saying that having just had an error syncing a form where > > > >> > it reports a missing column in the audit form. > > > >> > > > > >> > Rod > > > >> > > > > >> > On 23/09/2009, Misi Mladoniczky <m...@rrr.se> wrote: > > > >> >> Hi, > > > >> >> > > > >> >> I just wanted to let everyone know that I have just release a > > > >> >> new version of RRR|Chive with two significant improvements. > > > >> >> > > > >> >> 1. Compiled against the 7.0 API for maximum forward/backward > > > >> >> compatibility 2. Significant speedup when copying/syncing all > > > >> >> records in large > > > >> forms > > > >> >> > > > >> >> The new version has been compiled for Windows, but works > > > >> >> against any server. > > > >> >> > > > >> >> Let me know if you need versions for other platform. > > > >> >> > > > >> >> Download and configuration at: > > > >> >> https://www.rrr.se/cgi/rrrchive/main > > > >> >> > > > >> >> See you at WWRUG09! > > > >> >> > > > >> >> Best Regards - Misi, RRR AB, http://www.rrr.se > > > >> >> > > > >> >> Products from RRR Scandinavia: > > > >> >> * RRR|License - Not enough Remedy licenses? Save money by > optimizing. > > > >> >> * RRR|Log - Performance issues or elusive bugs? Analyze your > > > >> >> Remedy logs. > > > >> >> Find these products, and many free tools and utilities, at > > > >> >> http://rrr.se. > > > >> >> > > > >> >> ______________________________________________________________ > > > >> >> _________________ UNSUBSCRIBE or access ARSlist Archives at > > > >> >> www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net > > > >> >> ARSlist: "Where the Answers Are" > > > >> >> > > > >> > > > > >> > _______________________________________________________________ > > > >> > ________________ UNSUBSCRIBE or access ARSlist Archives at > > > >> > www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net > > > >> > ARSlist: "Where the Answers > > > >> Are" > > > >> > > > > >> > -- > > > >> > This message was scanned by ESVA and is believed to be clean. > > > >> > > > > >> > > > >> _________________________________________________________________ > > > >> ______________ UNSUBSCRIBE or access ARSlist Archives at > > > >> www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net > > > >> ARSlist: "Where the Answers Are" > > > >> > > > > > > > > __________________________________________________________________ > > > > _____________ UNSUBSCRIBE or access ARSlist Archives at > > > > www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: > > > > "Where the Answers Are" > > > > > > > > -- > > > > This message was scanned by ESVA and is believed to be clean. > > > > > > > > > > ____________________________________________________________________ > > > ___________ UNSUBSCRIBE or access ARSlist Archives at > > > www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: > > > "Where the Answers Are" > > > > > > > ____________________________________________________________________________ > ___ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum > Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are" > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are" > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
