The CSV Uploader adds programming to a property from a CSV file. You can add to an existing property, replace its programming, or create a new property from the file.
Format your CSV file
The column headers in your file need to match the NextCentury format. Start from the template:
Main columns
BUILDING |
The building name. |
|---|---|
UNIT |
The unit name. |
UTILITY_TYPE |
The utility type: All Water, Cold Water, Hot Water, Commercial Water, Gas, Electric, Run Time or Thermal Usage. |
SERIAL_NUMBER |
The serial number of the Transceiver, Remote Reader or 3rd party device, in hexadecimal or decimal. |
SIGNAL_TYPE |
The meter signal type, Pulse or Encoded. Only for TR4, RR301-TR and RR4-TR devices. |
METER |
The meter type, written as Model Name (xMultiplier Unit of Measure), for example M201C (x10 Gallons). |
IMR |
The initial meter read. See How meter reads are calculated. |
Additional columns
DESCRIPTION |
Notes or comments about the unit. |
|---|---|
METER_ID |
The meter serial number or another unique ID for the meter. |
ACCESSORY_DEVICE |
Any accessory devices, such as pulse converters or 3rd party Remote Readers. |
CUSTOM_METER_ID |
Any custom field. |
Add to an existing property
Upload the file
On the property's Equipment page, select File, then Upload a CSV File.
Drag the CSV file onto the box, or select the box to choose the file on your computer.
Choose an upload option
- Add to Property adds the programming in the file and keeps the property's existing programming.
- Overwrite Property replaces the property's existing programming with the programming in the file.
- Upload File saves the file as a property document without changing any programming. See Upload the file as a document.
Review and save
To finish, select Save Programming.
Check the changes, then select Save Changes. With Add to Property, the new rows are green. With Overwrite Property, the replaced rows are red.
Create a new property
Upload the file
On the Properties page, select + Add Property, then Upload Property File.
Drag the CSV file onto the box, or select the box to choose the file on your computer.
Choose Create Property
Create Property creates a new property from the file. Upload File saves the file as a document on an existing property instead. See Upload the file as a document.
Enter the property details
Select Create.
Enter the property details and select Create Property. See Property details for what each field is for.
Review and save
To finish, select Save Programming.
Check the changes, then select Save Changes.
Upload the file as a document
Upload File saves the CSV as a reference document on a property. It doesn't change any programming.
If you started from the Properties page, choose the Billing Company and the property the file belongs to, then select Upload.
To find the file later, open the property's Details page and select Docs.