There are many similarities between XML
Reports and XML Batch Updates. The ways in which the parameters are entered is
the same in both systems as is the T-Sql used for the queries. The main differences are :-
- Batch updates modify data or add data to
the database.
- Batch updates do not produce output. They
can display the total number of records affected.
- The Batch Update XML files
need to be in the Batch Updates folder of your system (in a standard
installation C:\Program Files\Recorder 6\User Files\Batch
Updates)
- Batch updates can only be run by users
with Recorder systems manager access level.
- Batch updates are run from Tools/Run Batch
Updates menu not from reports.
The following uses of XML batch updates are
possibilities
- Maintaining consistency of data
- Verification and Validation routines
- Updating Taxon_List_Item keys for Dictionary
changes
- Manipulating data input made through the Recording
Card
- Removing unwanted records
- Tidying merges
- Removing duplicated data.
Note:-
If you have existing (pre 6.13 ) XML
reports which update the database these will need modifying and moving to the
Batch Updates folder.