Update channels with a spreadsheet

Update spreadsheets save time and allow you to update multiple items at once.

Update spreadsheets typically display two columns for each attribute, updates should be entered in the white columns.
Always download a new spreadsheet before you begin adding information because each sheet is populated with data from the database.

Formatting rules

All information should be entered as text or dates.
You can add sheets if needed, UtilityManagement only processes the sheet named DataEntry.
Do not remove columns.

In the Create dialog, click Setup Spreadsheets.

From the Setup Spreadsheets Log, click Download.
Under Update Spreadsheets, choose Channels.
Set the filters as needed to limit the amount of data in the setup spreadsheet.
Download the spreadsheet.
Name format is yyyymmdd-UPDATE_Channels.xlsx.
Add your information and save.
Use Import to upload your spreadsheet.
The Setup Spreadsheets Log reports the results and any errors. You can download the error (kickout) spreadsheet from the hyperlink, fix any errors, and upload the error sheet.

Column	Rules
Meter Code	Populated in an update sheet.
Channel Import ID	Optional.
Interval	Choose an item from the drop-down. If your interval isn't listed select the closest option.
Channel Type	Choose an item from the drop-down.
Channel Description	Optional.
Channel Version Effective Date	Required when adding or updating a version. * See rules for channel versions and creating chargeback bills.
Channel Multiplier	Is a multiplier needed for this data? If yes, enter it here. If blank this field defaults to 1.
Output Unit	Choose an item from the drop-down. *To save time when creating multiple objects, after you select an entry from a drop-down you can copy and paste it into subsequent rows rather than access the drop-down each time.
Odometer or Trip	Choose an item from the drop-down.
Maximum Reading	Only needed for odometer channels. Enter the rollover value. The highest value accepted is 9,999,999,999. Enter whole numbers only.