Basic meter data import interface

The basic meter data interface imports basic (also known as deemed, dial or accumulation data) meter reads in a generic file format.

1. If the file is successfully processed it is placed in "Interfaces\Basic Meter Data Import\Archive".
2. If it is not able to be processed it is placed in the "Interfaces\Basic Meter Data Import\Error" folder with an error file explaining why.

This interface can also be manually run at any time from the Scheduled Tasks screen.

File Format

We accept three formats for this interface (all formats must be .csv files):

• NEM13 files (Australia only)
• Utilmate "simple" format
• Utilmate "advanced" format.

A simple file must have the following columns (Bold = Mandatory):

site_identifier - the site identifier must be a valid site identifier in Utilmate. If a site cannot be found, the file will error with an error message explaining the site cannot be found.

meter_code - the meter code and register must be ACTIVE for the site in Utilmate. If a meter and register cannot be found for the site, the file will error with an error message explaining the meter cannot be found.

meter_register - the meter register within Utilmate

meter_read - must be numeric with any "," separators for thousands removed. 

read_date - the read date must be a valid date in DD/MM/YYYY format.

audit_notes - Any meter reader or other notes you would like stored against the meter read.

In addition to the column above, an advanced file can also have the following columns:

estimate_read - Can be used to indicate if the read is an estimated or customer meter read.  Must be one of the following:

1. C = Customer Read
2. Y or E = Estimated Read
3. N = actual meter reading.

next_scheduled_read_date - On some invoices the next scheduled read date is shown for the customer.  This can be entered as DD/MM/YYYY

temp_factor - for gas meters a temperature factor can be used to convert mJ to kWh.

cv_factor - for gas meters a conversion factor can be used to convert mJ to kWh.

Once imported the meter reads will appear in the Import Meter Reads screen for further validation and processing.

See below sample meter read import file.