Batch Updates

 

Batch updates are xml files which are run in order to make specific changes to the database. As these make changes to the database it is generally recommended that the database is backed up prior to running the batch update. There are currently five major sections which group similar batch updates together. These are:

  • Delete (eg deletes Records with a specified determination type)
  • Designations (eg assigns taxons to a designation)
  • Determination Updates (eg creates a new determination for a specified taxa)
  • Location Updates (eg move locations where the system is not the custodian)
  • Updates (eg corrects duplicate preferred determinations).  

 

The batch updates are run from the Tools Menu by choosing Run Batch Updates. To add a batch update to your system for use in Recorder 6 simply download the file and save it in the Batch Updates folder of the User Files folder (usually C:\Program Files\Recorder 6\User Files\Batch Updates).

 

System supplied batch updates

The following batch updates are now available for download - note that they are all system supplied with version 6.14 onwards.

 

Please note that since these are xml files: you need to right-click and choose 'Save Target As...' to download them (double-clicking will simply open them in a new window).

 

Name of Batch Update Description Provider Date last modified
JNCCBDET1CorrectDates Corrects situations where biotope determination dates are not compatible with the sample dates System supplied Jul 2010
JNCCTDETDates1CorrectDates Corrects situations where taxon determination dates are not compatible with the sample dates System supplied Jul 2010
JNCCDel1TDET

Deletes Records with a specified determination type

System supplied Apr 2009
JNCCDel2TCOM

Deletes Records which start with the specified text within the Occurrence comments

System supplied Apr 2009
JNCCDel3SENoSamp

Deletes Survey Events which do not have any Sample

System supplied Apr 2009
JNCCDel4SNoOcc

Deletes Samples which do not have any Occurrences

System supplied Apr 2009
JNCCDel5Records

Deletes observation records including all the observation structure below the selected level

System supplied Apr 2009
JNCCDes1CreateSets

Sets up or maintains a Taxon Designation Set based on a CSV file containing a list of ShortName and Taxon_Designation_Type_Key

System supplied Jul 2009
JNCCDes2AssignTaxonsToDesignationRuck

Uses a rucksack containing a list of taxa and assign them a designation

System supplied Jul 2009
JNCCDes3AssignTaxonsToDesignation

Uses a CSV file containing a list of taxon list item keys to assign them all to a designation

System supplied Jul 2009
JNCCDes4DeleteSet

Removes a designation set from the database

System supplied Jul 2009
JNCCDes5DeleteDesignation

Removes a designation from the database

System supplied Aug 2009
JNCCDet1Determinations

Creates a new determination for a specified taxa using the Determination details from the original preferred Determination

System supplied Apr 2009
JNCCDet2Determinations

Creates a new determination for a specified taxa

System supplied Apr 2009
JNCCDet4Determinations

Creates a new determination to the recommended taxa

System supplied Jul 2009
JNCCDet5Determinations

Creates a new determination to the original taxa for a selected survey where the system custodian is not

the custodian of the current determination

System supplied Jul 2010
JNCCLoc1Locations

Moves the top level of all imported Locations

where the system owner is not the Custodian of the Location, to a selected Location

System supplied Apr 2009
JNCCPref1DuplicatePref

Corrects situation where the import of data results in a Taxon Occurrence having multiple preferred determinations

System supplied Apr 2009
All Batch Updates Single zipped file of all system supplied batch updates outlined above