Data Exchange

How the Data Exchange Specification Relates to Your Business Processes

The Data Exchange Specification is actually a family of specifications that spell out the precise column names, maximum character counts and formatting required to import, synchronize and update facility management data in AquaCUE, import current and historic reads and update and correct Account and Asset IDs. Another specification defines the billing read output of AquaCUE.

Data Exchange file spreadsheets in CSV format have fields for gathering information pertaining to:

Accounts – ID, account holder name and contact information, billing address and so on.

Locations – ID, service point address, geolocation data for the meter/service point and other details about the location such as number of occupants, evapotranspiration values, whether the location has a swimming pool and so on.

Service Points – ID used to distinguish multiple hookups at a single location (for example, someplace with meters for potable water and different meters for irrigation), geolocation data (used for greater accuracy when there is more than one service point at a single location) and so on.

Meters – Serial number, manufacturer, model, size, continuous flow/intermittent flow expected tag, unit of measure, resolution, installation date, removal date and so on.

Service Agreements – ID, service stop and end dates.

Endpoint Configurations – Serial number, type, installation date, removal date, resolution, billing resolution, billing offset and so on.

AMR and Manual Reads – Read sequence, alert codes and high/low read limits for meters.

The following sections of the AquaCUE User Guide will help you synchronize your CIS and SCADA systems with AquaCUE using Data Exchange files.


User Guide