Hi,
The RRR|LoginConv worked just fine, but it is written in ARSperl which has
kind not been recently updated. So there is a problem when getting the field
list from some forms in ITSM (not data, just info about the fields)...
I am looking for a sponsor to be able to rewrite it in C or Java. Please let
me know if that could be you. It is not a big program, and might take around
40 hours or so to re-write.
Using the API, as RRR|LoginConv does, takes considerable time to complete. But
by prioritizing the order in which forms and records are converted, you should
be able to do the important stuff during a weekend. Then the tool can munch on
to convert historical data in a more leisurely manner.
RRR|LoginConv exchanges text fields up to 254 characters in length. It does
fix the lists in the 112 and 60xxx fields, as well as Status-History and
Diary-fields. If it finds a quoted match in a char-field, that will be
exchanged as well.
It performs one read and one write per record, regardless of the number of
fields/logins that is converted on that record, and you should be able to run
several in parallel to speed things up.
Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011)
Ask the Remedy Licensing Experts (Best R.O.I. Award at WWRUG10/11/12/13):
* 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.
> I would recommend
>
> https://rrr.se/cgi/tools/main?tool=rrrLoginConv
>
> On Mon, Sep 29, 2014 at 11:02 AM, Frank Caruso <[email protected]>
> wrote:
>
>> ITSM 764 sp2, Oracle, Weblogic
>>
>> We have been asked to determine the difficulty/feasibility in converting
>> all Login IDs and Corporate IDs to new values. The unique values currently
>> used must be eliminated from "every" field in the application: Submitter,
>> Last Modified By, contained within a notes/description field and all custom
>> forms. We have over 1 million HPD records and millions of other ancillary
>> tables; audit, work log, assignments, searches, etc. I looked at the Data
>> Wizard Console (DWC) and it does allow Login IDs to be changed; it appears
>> to search across 408 tables in ITSM. But it does not handle corporate id,
>> can only be run for a single ID, does not search inside text fields and
>> does not handle custom forms. It also looks like a process that will take a
>> very long time to run.
>>
>> Looking for any thoughts on performing such a task; maybe some tricks
>> other have come up?
>>
>> Thank you.
>>
>> Frank Caruso
>>
>>
>> _______________________________________________________________________________
>> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
>> "Where the Answers Are, and have been for 20 years"
>>
>
> _______________________________________________________________________________
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> "Where the Answers Are, and have been for 20 years"
>
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"
