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
