Program a property with the CSV Uploader – Support Center

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:

NextCentury CSV Headers TemplateView

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.

Web portal Equipment page for a property, with Equipment selected in the left menu. The File button at the upper left is open, showing Upload a CSV File and Download a Backup File. The + Add button is next to it.

Drag the CSV file onto the box, or select the box to choose the file on your computer.

A gray box with a file icon and the words Drop or Select Property File.

Choose an upload option

The Request Property Upload window, opened from a property's Equipment page. It reads: Uploading: File.csv. Would you like to upload this file, or use this file to create a property? The buttons are Cancel, Upload File, Add to Property and Overwrite Property.

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.

The Program page after the upload, for a property. It's in edit mode, with Save Programming, the blue button at the upper left, then Cancel and the toolbar. The table lists building 1255, Units 1 to 6, each with Cold Water and a serial number in the Serial Number column.

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.

Web portal Properties page, with Properties selected under Home in the left menu, between Dashboard and Reports. The + Add Property button at the upper left is open, showing Add Property and Upload Property File. A property is in the list behind the menu.

Drag the CSV file onto the box, or select the box to choose the file on your computer.

A gray box with a file icon and the words Drop or Select Property File.

Choose Create Property

The Request Property Upload window, opened from the Properties page. It reads: Uploading: File.csv. Would you like to upload this file, or use this file to create a property? The buttons are Cancel, Upload File and 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.

The Property Creation Upload window, 1 of 1. It reads: Uploading: File.csv. You will need to Create a property before uploading this csv. The word Create is a gray button. Cancel and Upload are at the bottom.

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.

The Program page for the new property (named Property Name in this example), in edit mode with Save Programming at the upper left. The table shows building 1149, Units 1 to 5, all Cold Water. In the left menu, Program is selected under the property name.

Check the changes, then select Save Changes.

The Changes window for the new property, with Meters and Network tabs. All five rows are green: building 1149, Units 1 to 5 (in this example), Cold Water, M201C (x10 Gallons), with the IMRs from the file and the custom ID D234593 on Unit 2. Close and Save Changes are at the bottom right.

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.

The Property Docs Upload window, 1 of 1. It reads Uploading: File.csv, then Billing Company: NextCentury and Where's the file going?: the property's name. Cancel and Upload are at the bottom.

To find the file later, open the property's Details page and select Docs.

A property's Details page, with Details selected in the left menu. Under Contact Info are the Contact Name, Title or Job Description, Phone and Email fields, and below them the Comments button and the blue Docs (3) button.

The Property Docs window. At the top is a Drop or Select File box. Under Property Documents is the uploaded File.csv, added by support@nextcenturymeters.com a minute ago (in this example).