ARCHIVED
The jncc.defra.gov.uk website has now been archived. For the latest information from JNCC, visit jncc.gov.uk

12 Importing data

 
 
 
 

In Recorder 2002, users wanting to import records from Excel spreadsheets, csv files, text files or MapMate had to install the Import Wizard, but in Recorder 6 there is no need to install it as it is built into the system.  To use it, select Tools – Import Data on the main menu, navigate to the folder containing the file to be imported, set ‘Files of type’ to the required file type, and select the file to be imported.  This will start the Import Wizard.  Selecting NBN Data (*.xml) or NBN Access Database (*.zip) will enable you to import data from another copy of Recorder 6 or Recorder 2002.

 

The Import Wizard in Recorder 6 contains many enhancements that are not in the Recorder 2002 version.  It will import:

 

  • data from a wider variety of file types than Recorder 2002 – see the ‘Files of type’ drop down box;
  • more different types of data – see Help – Tasks on the Contents tab – Exchanging data – Import data – Import Wizard – Data format.  Note that the list of supported columns isn’t complete as more were added after the last round of changes to the Help;
  • multiple recorders for observations;
  • multiple sets of abundance data for observations – see Help – Tasks on the Contents tab – Exchanging data – Import data – Import Wizard – Abundance data.

 

It also allows users to import selected rows from an import file and to filter on rows containing errors.  The later makes invalid data easier to locate and correct.  In Recorder 6 more data can be corrected in situ.

 

The help has been updated to provide more information on importing data generally, e.g. handling duplicate and invalid items when importing data from other copies of Recorder 6 or from Excel files etc. – see Help – Tasks on the Contents tab – Exchanging data – Import data – Analysis and Import / Duplicate items / Invalid items.  Analysis and Import also contains information on rejected items.

 

 
 

 

<<<Back to Introduction