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
• Metric
• Value
• Value Unit
• Actual/Estimate

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 Wrench Icon Import Data.

Select the CSV file which contains the required information, you will receive a pop-up notification indicating that the import will now run in background and you will receive an email when it is complete.

Click on OK button to resume using the application.