Home > Downloads & Services > RRR|SelectionChange


updated 2009-04-14 06:26:13

Changes your data when addding/removing values from Status fields or other Selection fields

Download RRR|SelectionChange

usage: rrrSelectionChange

rrrSelectionChange { -insert | -remove | -exchange "list" }
-s server -u user -p passwd -tcp tcpport
-form "formname" -field fieldid -numvalue n -textvalue "value"
[ -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 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. This especially apply if you have set Custom IDs and want
to retain Status-History.

Old values: New(0), Assigned(1), Fixed(2), Closed(3), Rejected(4)
Temp values: xNew(0), xAssigned(1), New(2), xClosed(3), xRejected(4),
Assigned(10), WIP(20), Closed(30)
Final values: New(2), Assigned(10), WIP(20), Closed(30)
When the system has Temp-values set, use flag -exchange "0>2, 1>10, 3>30".

If using -insert or -remove, the index and value need to be supplied.
The numvalue is the numeric value of the data to be inserted/removed.
The textvalue is the name of the new/old selection value.
You are required to supply both numeric and text versions of the value as
a safeguard against misstakes.
If you do not supply numvalue and/or textvalue, the possible choises are printed.

If using -exchange, you will supply a conversionlist instead of the -numvalue
and -textvalue 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' < "2009-02-18""

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.