Data Exports

Data Exports 2017-09-11T03:59:11+00:00

Info and Concepts

This section allows the user to export data directly from the database to a file which can then be opened using any spreadsheet program. The data export can be specified by the user and tailored to suit each individual customer. Aerotrack charge a small fee for the installation of these queries.

Each query will have its own parameters that need to be entered and these can also be specified and tailored for an individual client.

Where

The queries can be accessed form within the System Admin menu.Screen Shot 2016-02-22 at 12.25.23 PMScreen Shot 2017-06-08 at 10.56.51 AMScreen Shot 2016-02-22 at 12.25.23 PMIt is important to note that each user that requires access to the query must be granted access by the Application Manager, seeĀ  the guide on adding a new user for more information on adding a query to an account.

Walkthrough

  1. Open the Data Export module via the System menu.
  2. A list of all the available queries will be displayed in the table.Screen Shot 2016-02-22 at 12.25.23 PMScreen Shot 2017-06-08 at 11.07.03 AMScreen Shot 2016-02-22 at 12.25.23 PM
  3. Click the “Run” icon to open the query. Screen Shot 2017-06-08 at 11.08.14 AM
  4. Enter the required parameters for the selected query. Dates must be entered in this format dd-mm-yyyyScreen Shot 2016-02-22 at 12.25.23 PMScreen Shot 2017-06-08 at 10.59.03 AMScreen Shot 2016-02-22 at 12.25.23 PM
  5. Click an export option and select a location for your file to be saved.
  6. Open the file in your spreadsheet program and format as required.

 

Screen Shot 2017-06-08 at 10.58.17 AM