Exporting Data

Managing Exports

  1. Accessing the Exports Grid:
    • Click on the “Exports” option in the menu.
    • This grid displays exports generated via your login. You won’t see exports from other users.
  2. Export Details:
    • The Exports Grid lists your exports and includes the following details:
      • Date/Time of export generation
      • Export Type
      • App Name
      • Number of records exported
      • Status (explained below)
  3. Export Statuses:
    • There are four statuses for exports:
      • Constructing: The system is building the export data for processing.
      • Outstanding: Queued and awaiting processing.
      • In Progress: The export job is being processed.
      • Completed: The export is ready for download.
      • Failed: The export encountered an issue; please retry.
  4. Actions for Completed Exports:
    • When an export is in “Completed” status:
      • You can download it.
      • The file name includes the date/time of export generation and app name.
      • All exports are in CSV format (Comma-Separated Values) for use in systems or Excel.
  5. Download and Retention:
    • You can download an exported file multiple times.
    • Exported data is available for 30 days; after that, it’s automatically deleted.
  6. Large Exports:
    • If your export has many records, it may take time to generate.
    • Exports run in the background, and server resources are managed to allow concurrent exports.
  7. Refresh Option:
    • Use the “Refresh” option on the grid to update progress.

GPS co-ordinates in Exports (Latitude, Longitude, Easting, Northing)

When exporting Data Collector records with a ‘Location’ field type, the CSV export includes separate columns for Latitude, Longitude, Easting, and Northing coordinates. Here’s how it works:

  • The column header label combines the field name with the coordinate indicator.
  • For instance, if your Location field is named ‘Hazard Location,’ the four coordinate columns will be:
    • Hazard Location_Lat: Latitude
    • Hazard Location_Long: Longitude
    • Hazard Location_East: Easting
    • Hazard Location_North: Northing

Important Note: We use the WGS 84 datum for Northings and Eastings conversion. WGS 84 is the reference coordinate system used by the Global Positioning System (GPS).

Scroll to Top