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.
A breakdown of each field in the Data Exchange Spec for Accounts and Assets.
- CSV Files and Excel
Tips for opening CSV files in Microsoft® Excel®.
- Quick Reference Guide to IDs
Unique identifiers and when to change them.
- Syncing AquaCUE and Your CIS
Step-by-step instructions on importing Data Exchange files into AquaCUE.
- Validation Errors and Warnings
Understanding the errors and warning in an Exceptions Report.
- Understanding the Starter Spreadsheet
A quick start guide to provisioning for ORION Cellular 10-pack Customers.
- Where Data Appears in AquaCUE
See where Data Exchange data shows up in the AquaCUE User Interface.
- Data Exchange Specification
Download the Data Exchange Spec from this page.
- Data Exchange Template
Download a blank Spreadsheet Template from this page.
- AquaCUE-to-CIS Schema Mapping
A workbook to help you match CIS data to columns in Data Exchange files.
- Importing Meter Reads
Understanding and using the Billing Meter Reads Specification.
- Importing Interval Meter Reads
Understanding and using the Interval Meter Reads Specification.
- Billing Read Export Specification
Download the Billing Read Export Specification.
- Rules for Creating, Updating and Changing Data
How to update Account and Asset IDs.
- Manually Provisioning Endpoints
Step-by-step instructions on provisioning endpoints one at a time.
- Endpoint Installation Form
Download the endpoint installation form here.