UB> Meter Management> Meter Data Export

Meter Data Export

Summary

The Meter Data Export window allows users to export meter data in a format that is compatible with third-party smart metering systems that provide real-time meter reading data, such as AMI Technology. This export file includes data related to the connection, customer account and lot information.

Step by Step

1 Open the Meter Data Export window (UB> Meter Management> Meter Data Export).

2 Complete the Export Settings section.

Select the meter read routes that should be included in the data export in the Routes field.

Press CTRL+A to highlight all of the routes. Press SPACE to check or uncheck all of the highlighted toggles.

The Configuration drop-down menu is used to select a user-configured data export file or to select Meter Data to use the standard data export.
- User-configured export files are created and maintained on the Export Configuration Maintenance window (SS> Maintenance> Export Configuration). Click here for information on Export Configuration Maintenance.
- Click the Display Report Layout icon at the top of the window to display the format of the file that will be created. This will open a window that displays the fields included in the data export file, the length of each field and the position of the field on the data export file. Click here for information on the File Layout window.
Select the status of the customer accounts you would like to include in the data export file in the Account Status field. Only the meters attached to customer accounts of the selected statuses will be included on the data export file.
- Meters attached to inactive lots will not be included in the exported meter information (Lot icon> Open a lot> Lot tab> Status drop-down menu) unless the Include Inactive Lots toggle is checked below.
Check the Include Inactive Connections toggle to if you would like to include inactive connections in the export file.
- Connection status is set on the Connections tab of the Device Maintenance window (UB> Maintenance> Device> Connections tab> Status drop-down menu).
Check the Include Inactive Lots toggle to include inactive lots in the data export file.
Click the Confirm icon when complete to generate the data export file immediately or enter a date and time in the field next to the Confirm icon to schedule the data export file to generate at a later time. You can view the progress of the data export on the Job Viewer window (SS> Utilities> Show Scheduled Jobs).
- The Schedule icon can be used to set up a daily automated export of the meter data that automatically generates every 24 hours. The system will generate the export file at midnight local time each day and the export file will be saved to your agency SFTP exports folder.
- NOTE: This feature requires an agency SFTP site in order to function. Please contact Springbrook Support to activate.
Once the export has finished processing, the Export Settings window will open. This window is used to specify the export path for the file.
- Check the Open toggle if you would like to open the exported file after it is saved locally.
- Enter the export path location and click the Save icon to export the file to the local path.