Misi:
Thank you for the update and I would expect your company to start working on the paying part first and then move to the 'free' programs last.
James McKenzie
-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:[email protected]]On Behalf Of Misi Mladoniczky
Sent: Wednesday, April 19, 2006 7:38 AM
To: [email protected]
Subject: Re: Question: ARCHGSEL Utility
James,
It works fine with ARS 6.x and earlier versions. As rrrSelectionChange
only handles selection-fields and status-history, there has been no
problem compiling it against newer versions of ARS.
In version 7, I have heard rumors that you can reserv gaps between values
in your selection fields for future use. This will probably require some
work on rrrSelectionChange.
I will certainly upgrade rrrSelectionChange and all my other tools to
version 7 when it is available. I will start with the non-free-stuff first
though...
Best Regards - Misi, RRR AB, http://www.rrr.se
> Misi:
>
> Thank you. I wondered if this type of program existed for ARS 6. Are you
> going to upgrade it for ARS 7?
>
> James McKenzie
>
>
> -----Original Message-----
> From: Action Request System discussion list(ARSList)
> [mailto:[email protected]]On Behalf Of Misi Mladoniczky
> Sent: Tuesday, April 18, 2006 10:12 PM
> To: [email protected]
> Subject: Re: Question: ARCHGSEL Utility
>
>
> Fred,
>
> You can use the free tool rrrSelectionChange to accomplish this. It works
> fine against version 6.x of ARSystem:
> https://www.rrr.se/cgi/tools/main#rrrSelectionChange
>
> It will also change your Status-History information if needed.
>
> It has some additional features:
> - Multiple value inserts and rearranges in a single pass
> - Either immediate modification on the server data or creation of
> ARX-files that you can import after
> - Backup ARX-file to enable you to restore the old data if something goes
> wrong
>
> Best Regards - Misi, RRR AB, http://www.rrr.se
>
> usage: rrrSelectionChange
>
> rrrSelectionChange { -insert | -remove | -exchange "list" }
> -s server -u user -p passwd -tcp tcpport
> -form "formname" -field fieldid -index n -value "newvalue"
> [ -noupdate ] [ -arx file.arx ] [ -backup file.arx ]
> [ -log file.log ] [ { -verbose | -silent } ] [ -Y ]
> [ -split ] [ -rununtilrec recno ] [ -contafterrec recno ]
> [ -qual "Normal ARUser advanced qualification" ]
>
> rrrSelectionChange -config file.cfg
>
> rrrSelectionChange -help
>
> This tool can be used when you want to add (insert) or remove a selection
> field value, or do some other rearranging of the selection values.
> The tool changes the values of the specified field in all records.
> If the Status-field (field id 7) is specified, the Status-History is also
> changed to match.
>
> If you insert a value, the value should be added to the selection field
> via ARAdmin BEFORE you run this program.
> If you remove a value, the value should be removed via ARAdmin AFTER you
> have run this program.
>
> The index is the 0-based position where the value should be
> inserted/removed.
> The value is the name of the new/old selection value.
> You are required to supply both index and value as a safeguard against
> misstakes.
> If you do not supply index and/or value, the possible choises are printed.
>
> If using -exchange, you will supply a conversionlist instead of the -index
> and -value parameters.
> Example: -exchange "NULL>1, 1>0, 3>5, 5>3"
> This will do the following:
> - Clear the contents of index 1
> - Copy contents of index 1 to index 0
> - Swap the contents of index 3 and index 5
> - Leave index 2, 4 and 6-n intact
> Note that the order of the list is not important.
>
> The -noupdate flag will do everything but not update any records what so
> ever.
> Use -noupdate together with -arx if you wish to export a file to be
> imported with ARImport instead of updating data immediately, or if you
> want to test your parameters before you do the real update.
>
> Specify -arx to create a file with the updated data.
>
> Specify -backup to create a file with the original data.
>
> The -verbose flag prints information about all changed records and values.
>
> The -silent flag will only print errors and a summary.
>
> The -Y flag will default Y to any warning questions listed below:
> 1.Enabled Merge Filters
>
> The -split flag creates 100 small searches to the server instead of one
> big.
>
> The -rununtilrec is mainly used to test a small number of records, or to
> reverse records that was changed and the program then exited due to an
> error.
>
> The -contafterrec will have the program skip continue after the specified
> record. This is also used when you want to continue after an error is
> fixed.
>
> The -qual will let you specify what records to update, one example could
> be to only update old records: -qual "'3' < "2004-01-31""
>
> With -config all other parameters can be put in a file instead.
> Use one line for each dash parameter.
> Use "" for an empty string. Example: -p ""
> Comments start with a #-character.
>
> It is highly recommended that you backup your data before running the
> script, misstakes are easy to do.
>
> Filters, escalation, active links, macros, reports etcetera that reference
> the field must be manually changed through ARAdmin.
>
> Note that you may have to disable any merge filters that could change
> data.
>
> The tool has been compiled against the 6.3 API, but will work fine for
> version 5.x of ARSystem as well.
>
>> I would not use the archgsel 4.5 version against an ARS 6 server. I
>> believe the archgsel 5.1 version will work against ARS 6. It is also
>> available in the community downloads.
>>
>> Fred
>>
>> -----Original Message-----
>> From: Action Request System discussion list(ARSList)
>> [mailto:[email protected]] On Behalf Of T. Dee
>> Sent: Tuesday, April 11, 2006 8:35 AM
>> To: [email protected]
>> Subject: Question: ARCHGSEL Utility
>>
>> Has anyone used the utility "ARCHGSEL ver. 4.5" successfully on ARS
>> 6.00.01 (patch 1394), running SQL 2000, Windows 2000?
>>
>> Thanks.
>>
>>
> ____________________________________________________________________________
> ___
>> UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
>>
>
> ____________________________________________________________________________
> ___
> UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
>
> _______________________________________________________________________________
> UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
>
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
