Hi Ben,
Thank you for the tip!
The disable-filter-code was created long before version 6, but I will
definitely change this behaviour.
I have actually searched for something like this earlier, but I did not
find it.
The drop-index-call was created for three reasons:
1. speed (I have not seen any major improvements when testing though...)
2. making sure that the filters were evenly distributed after the
data-transfer
3. disabling any unique-index that might interfere with the order in which
the records was merged into the db
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,
>
>> > 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"
>
> --
> 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"
