Importing Metrics Input Data

Metrics Input data can be imported manually.

Downloading an Import Template

To assist with the import process, users can export the data from the Outstanding Data Portal via Wrench Icon Export Data. The web application will generate a file named metricResultsOutstanding.csv.

This CSV file will

• be generated in the correct structure which is required for the Import (details below)
• contain all the outstanding records as displayed on the screen. I.e. users can reduce the list by applying a filter.
• exclude all Calculated Metrics (metrics which are being calculated by the system, using information in the database) and Formula Metrics.

The structure of the CSV file will be as follows - in this order:

• Location Code
• Location
• Time Period
• Company
• Metric
• Value
• Value Unit
• Actual/Estimate (defaulted to Actual)

Information in this CSV file needs to be provided as follows:

• Value: you must provide a value with the correct input type:
  • Integer
  • Decimal
  • Text
  • Yes/No
• Value Unit: you can change the Unit as long as the new unit can be converted to the original unit (e.g. kGh GWh)
• All other entries, including the header line, must remain unchanged.
• If the CSV file contains any invalid entries, the corresponding records will be rejected.
• Existing data can be exported from the Review Data and Completed Data tabs – the system will export only the data shown on the screen from the respective tabs.

Importing Data

To import, navigate to Metrics Management Data Entry Import Data.

Drag and drop the CSV file that contains the required information. You will receive a pop-up notification indicating that the import will now run and you will receive an email when it is complete.

Note: The import commences immediately after the file is uploaded.