Revision History ================ ----------------------------------------------------- See "Release Notes 3.3.19.txt" for earlier revisions. ----------------------------------------------------- 13/02/2001 Fixed a problem in SHOW_ERRORS where it was not necessarily loading the correct window template in which to show the problem row. Now uses XM_DATA, WINDOWS to get the name and table from which to read the window template. ----------------------------------------------- Latest version of Recorder = 3.3.20 Latest version of Recorder_3_Import = 1.0.1.41 ----------------------------------------------- 28/02/2001 Substrate code from RECORDS now exported to taxon_occurrence. Substrate keywords export as taxon measurements with a measurment type of "Substrate" and Units of "p/a" (presence/absence). ---------------------------------------------------------------------------------------- NOTE: This requires update to nbndata.mdb to add measurement_unit and measurement_type. ---------------------------------------------------------------------------------------- 01/03/2001 Fixed a problem in exporting Land parcels for SITES which occurred if: a) the string of parcel numbers had a trailing comma b) more than one grid square was listed, but not all had parcel numbers listed against them Added new function XML_PARCELS to fix this. 02/03/2001 Fixed a problem in bulk move with SITE_CODE longer than 16 characters. Fixed problems exporting "-Y" and "Y-" type dates ----------------------------------------------------------------------------------------- NOTE: The following changes REQUIRE Rec2K 1.0.8 and won't work with earlier versions! ----------------------------------------------------------------------------------------- 06/03/2001 Modified Bulk export to use new LOCATION_NAME fields (Rec2K 1.0.8). Also export of substrate keyword. This requires addition of a measurement_type and measurement_unit to Rec2K. 12/03/2001 XML export modified to use LOCATION_NAME. 13/03/2001 Added a check to CLEAN to ensure that single valued fields do not contain multilple values or sub-values. 14/03/2001 Found strings containg the character "|" cause exception on import. Modified exporter to change this character to space in text fields. 27/03/2001 Found that removing duplicate biotope_occurrences takes a long time with a big dataset. Modified Rec_3_importer to show this as a seperate step and report progtress (to a very limited extent!). Also found "S" (Season) and "M" (month with no year) vague dates are stored differently in Rec2K. Added code to modify exported dates appropriately. 29/03/2001 Added validation for RECORD grid vs SITES GRID list. Added, new tool FIX_SITE_GRIDS to fix problem cases by extracting a 1km square from the record and adding it to the list in the SITE. 30/03/2001 Added a tool to ensure that all grids listed for subsites are propogated up the site hierarchy and are also listed in their parents. ----------------------------------------------- Latest version of Recorder = 3.3.22 Latest version of Recorder_3_Import = 1.0.1.48 ----------------------------------------------- 04/04/2001 Check for RECORDS with no location information. Must have at leat one of grid, SITE_CODE or location name. Export REFS in RECORDS to Taxon_occurrence_sources - how did I miss that one! 05/04/2001 Logic for validating date ranges slightly changed to take into account cases where the date to be tested is less precise than the dates it is tested against. Small changes to grid fixing routines to deal properly with Irish tetrads. Modified SURVEY window to: 1. remove NE and SW grid since these are not used! 2. support the distinction between dates used for validation and dates over which the survey was operated 3. provide option on earliest and latest date prompts to find the earliest and latest dates actually present in the RECORDS. 06/04/2001 Very subtle bug in assigning Survey_events fixed which very occasionally led to records with a vague site, no grid ref and no location name ending up attached to the wrong survey_event. 10/04/2001 All data cleaning integrated into FIX - just one menu item. This gives user series of options which can be selected/deselected via a "check-box". 11/04/2001 Cleaning routine can now report to a file which shows what changes were made. Fixed a bug in Record Selection (purely Rec3.3 - nothing to do with data transfer) where species name appeared in species key column after a multiple-selection (e.g. from a Species Pop-up). ----------------------------------------------- Latest version of Recorder = 3.3.23 Latest version of Recorder_3_Import = 1.0.1.48 ----------------------------------------------- 20/04/2001 Improved error handling in OpenDOSFile, XML_Writeline, XML_GUI, etc. Added "Internal error: " prefix to all error messages. The user should, hopefully, never see these! 23/04/2001 Overhauled REDUCE logic in XML_EXPORT_TABLE and improved the progress display logic (test @REDUCTION.DONE to see whether @RECCOUNT can be used following the call to REDUCE). There are now fewer cases when a progress bar cannot be shown. (These occur because a latent, rather than a resolved, select list is produced. Latent select lists are only resolved as the file is read, so it is not possible to know beforehand how many rows need processing.) 26/04/2001 Small changes to NBN_EXPORT_TABLE so that Taxon_occurrence and Taxon_determination use previously saved select list. May be slight gain in performance, but it won't make a big difference! ----------------------------------------------- Latest version of Recorder = 3.3.24 Latest version of Recorder_3_Import = 1.0.1.48 ----------------------------------------------- 01/05/2001 Tested XML transfer. Fixed SUBSTRATE_CODE and VAGUE_LOCATION_NAME which gave XML syntax errors. Reported that Irish SITES are assigned to wrong VCs on import. The translation table (in SS) was completely wrong. Rebuilt for ADMIN_TYPE Irish Vice-county (from nbndata.mdb v1.1). 02/05/2001 Help for Survey window updated and checks added for Start date vs earliest date and date completed vs latest date. 14/05/2001 Modified bulk export so that errors don't produce a screen message (which then require the user to press ) but dumps them to a file (EXP_ERRS.TXT). This allows the routine to run unattended (e.g. overnight) even if errors are found. 17/05/2001 Added export for Altitude in RECORDS to Sample data to bulk export. ----------------------------------------------- Latest version of Recorder = 3.3.25 ----------------------------------------------- 11/06/2001 Problems with data from CEDaR and Lothian LRC where it did not export biotope_occurrences fixed by recompiling the symbolic dictionary fields in the RECORDS table. Update rebuilt including updated RECORDS symbolics. ----------------------------------------------- Latest version of Recorder = 3.4 Latest version of Recorder_3_Import = 1.0.1.50 ----------------------------------------------- 19/06/2001 Recorder_3_Import.ocx. Fixed a problem where it was taking forever to remove duplicate biotope_occurrences from large datasets. In the case where the problem was reported there were c. 140,000 duplicates, this is now processed in a couple of minutes (instead of c. 5 days!). 20/06/2001 Fixed a problem in bulk export with "Treat subsites as sample" option selected where records from District/Parish vague sites produced an error for survey_events with LOCATION not allocated. The error message (in EXP_ERRS.TXT) showed, for example, LOCATION*P41 for vague site P41/02/004 - the vague site code was being treated as a subsite only the first item from the hierarchical code was being lookeed up. ----------------------------------------------- Latest version of Recorder = 3.4.1 Latest version of Recorder_3_Import = 1.0.1.58 ----------------------------------------------- 17/07/2001 Fixed a problem whereby not all LOCATION_DESIGNATIONS were exported. The first one was always exported and then any other up to the last row in which OTHER_CODES had an entry. Any following rows (with OTHER_CODES empty) were not exported. ----------------------------------------------- Latest version of Recorder = 3.4.2 ----------------------------------------------- 27/07/2001 TAXON_COMMON_NAME was not exported for user added SPECIES. This has been implemented. Note that this requires a change in nbndata.mdb which will be implemented in the next maintenance release of Recorder 2000. Rec_3_Import updated to deal with new table. 01/08/2001 Fixed problem with Organisation as Collector or Determiner along the lines suggested by Sally Rankin. Following CHECK, there is a Softkey on the Show Errors window which picks up all error of this type. For each organisation causing a problem, a new PERSONAL entry is created with the organisation name prefixed with "Recorder at" - this new entry is marked as an individual. Records are then updated so that the Collector/Determiner points to this new entry rather than to the orignial organisation. 22/08/2001 Fixed a very obscure problem in CLEAN whereby keywords consisting only of the character '_' caused import errors in Rec_3_Import (Location_feature rejected because ITEM_NAME ended up Null). Also modified the process of ensuring record and subsite grids are in the list of grids in the SITE they are attached to so that 10km squares are always included in this list. This avoids any lingering problems with Rec2K rejecting records because "Spatial ref does not fall in specifed Location grid", but it does considerably increase the number of grid_squares generated! 23/08/2001 Fixed problem with user-added species association types not transferring correctly. ----------------------------------------------- Latest version of Recorder = 3.4.3 Latest version of Recorder_3_Import = 1.0.1.59 ----------------------------------------------- 18/12/2001 Modifications to cope with changes in Recorder 2000 v1.1.3 in which measurement qualifier has become a term list. NOTE this requires version of Recorder 2000 later than 1.1.1. 27/03/2002 Modified XML_SORT so that a sample is generated for unique combinations of SITE_CODE GRID and LOCATION_NAME as well as DATE and RECORDERS. This fixes problems were several records at a site by the same person on the same date, but with different detailed grid refs, ended up as duplicate taxon occurrences in a single sample with the grid ref from the first record falling in the sample. 13/04/2002 Incorporated some internal changes from Dorset Software into Recorder_3_Import addin. These stream in the CSV files in 1mb chunks (instead of loading the whole file), therefore avoiding memory problems for very large files. May also marginally speed up the process in all cases. 30/04/2002 Testing import of MEASUREMENT_QUALIFIERS found that habitat areas imported into LOCATION_DATA was not being converted from internal format (e.g. area of 3.52Ha imported as 352). Added conversion to fix this. 08/05/2002 Rebuilt ADMIN_AREA table in Arev to reflect changes in Rec2k. ----------------------------------------------- Latest version of Recorder = 3.4.4 Latest version of Recorder_3_Import = 1.0.1.61 ----------------------------------------------- 10/10/2002 LAT_LONG modified to return 9 decimal places as used internally in Rec2002. 15/10/2002 Corrected a problem in nSquares which was giving incorrect square count for grid squares other than 10km (not related to transfer to Rec2002). ----------------------------------------------- Latest version of Recorder = 3.4.5 Latest version of Recorder_3_Import = 1.0.1.64 ----------------------------------------------- 11/06/2003 Minor modification to SITE_ID to remove special characters like comma and full stop before BASE is called. This avoids "Non-numeric where numeric required" errors when using CHECK. 26/06/2003 Modified the importer so that it is based on TAutoObject rather than TComObject. This allows it to be initialised properly by Rec2002 v2.2. Note that its name has also changed (Recorder_3_Import_v2.ocx) to avoid compatibility problems and that its major version number has been incremented to 2. ------------------------------------------------- Latest version of Recorder = 3.4.6 Latest version of Recorder_3_Import_v2 = 2.0.0.3 -------------------------------------------------