Skip to content. | Skip to navigation

You are here: Home → Setting Up and Maintaining Your Organization → Meter Route Administration → Overview: Importing RouteSTAR Meter Readings
 

Overview: Importing RouteSTAR Meter Readings

Energy CAP Enterprise currently supports the export and import of meter reading data for Datamatic.com's RouteSTAR MVP® Meter Reading System. Energy CAP Enterprise uses the RouteSTAR MVP® EXP (export) file to import route data. RouteSTAR MVP® uses the Energy CAP Enterprise EXP (export) file to import data.

An initialization file, dmconv.ini, is required to import the route data and must be placed in the Energy CAP Enterprise program directory.

RouteSTAR MVP® files are ASCII format, sequential text files. The records contained within the file are processed one at a time by the import operation. The file must contain a header record, device records, and a trailer record. The header record includes billing cycle number and route code. Device records include the detail information for each meter. The trailer record includes the billing cycle number, route code, and a total count of meters in the route.

A virtual channel equation is used to calculate the usage/demand values for a meter. This function performs a calculation using the reading delta. The previous meter reading is subtracted from the current meter reading and then multiplied by a multiplier to obtain the correct usage and demand values. The actual meter readings are stored in the Route Manager for verification purposes, while the usage/demand and other channel data is accessed via the Facility Manager.

Meter route channels differ from other import channels in that the channels are not automatically created during the import process. The channels must be created prior to import.

In order to import meter reading data into Energy CAP Enterprise, first verify the following:

  • The initialization file contains the key, METERKEY which is set to either IMPORTID (the tag assigned that Energy CAP Enterprise looks for when importing data) or CODE (the unique, self-defined identifier).

  • If the METERKEY is set to IMPORTID, the EnergyCAP meter import ID (Meter Properties/Specific tab) matches the ID used in the import file.

  • The meter channel type is manual (real data) whose interval frequency is set to 0 (zero) minutes.

Refer to Datamatic.com's RouteSTAR documentation for additional information on importing/exporting data and supported file formats.

Below is a sample import file format (comma-delimited text) that is compatible with the EnergyCAP Importer:

ImportID,TimeStamp,kWValue,kVARValue
KZG002614057,08/01/2003 00:00,27.936,13.872
KZG002614057,08/01/2003 00:15,23.328,9.6
KZG002614057,08/01/2003 00:30,22.896,9.408
KZG002614057,08/01/2003 00:45,22.608,8.592
KZG002614057,08/01/2003 01:00,22.704,8.88
KZG002614057,08/01/2003 01:15,22.848,8.88

Document Actions
Add comment
(Required)
Tell us your name.
(Required)
(Required)
(Required)
Enter the word