4.03.1 Data Validation for Template Spreadsheets

  1. Each Template spreadsheet downloaded comes with a corresponding Legend.xls spreadsheet. This spreadsheet shows the field types and values (Selection) required for each field in the Template shapefile:image089
  2. Use the rules in Table 4.1, along with the Legend.xls, when populating the Template spreadsheet attributes:
    Table 4.1 Spreadsheet Data Validation Rules for Legend.xls

    Field Type/ Validation Format/ Data Entry Rule Additional Information
    String (Text) Text field up to 254 characters
    Date yyyy/mm/dd e.g. 2014/06/21
    Selection Choose a value for the corresponding field name from Legend.xls The value entered must match exactly the value given in Legend.xls including format and structure (i.e. “Track” not “track”)
    Number Integer or decimal i.e. 1200 or 1200.00
    Image Imagename.jpg Can take only one image for each record (can only be .jpg or .png image files)
    File Filename.zip or Filename.pdf .zip can take multiple images or files when zipped together
    Mandatory fields Must be completed otherwise you will not be able to save your data.
    “ID” field (CRITICAL) Must be populatedMust be a unique integer.Must be unique between templates of the same activity. i.e. 1,2,3…
    “Easting” field Must be an integer
    “Northing” field Must be an integer
    “Latitude” field Must be decimal degrees i.e. 116.4532   -32.56454
    “Longitude” field Must be decimal degrees i.e. 116.4532   -32.56454

    Note: – Once data is uploaded, “Area” and “Length” fields for polygons and polylines are added and calculated automatically.