Upload Meter Reads

Create the MeterReads CSV File

For the file to upload properly, it must be formatted in a specific way. 

1. You must create the file in Excel (or similar software). Web jet files can be used; just cut and paste the information into a different file.

2. You must save the file in .csv or .txt format. If it is a .txt file, it must be comma delimited.

3. Each asset must have unique serial number or ID. IP addresses cannot be used because they may not be unique.

4. The file must have columns for each of the following categories. If the category doesn’t apply (i.e., the asset only prints B&W, not color) use a zero (“0”) as a placeholder for that field.

• Copy Color
• Copy B&W
• Print Color
• Print B&W
• Meter Read Date/Date Input

5. The asset must have the same meter read fields (i.e. Copy Color) set up during the initial site configuration.

6. You must have a value in each cell, even if zero (0).

7. Include the site name and date in the file name for easier management of files and data. An example of an effective file name is “ABC Corp - 2007 06 01.txt”

Upload the MeterReads CSV File

After creating the file, you can upload.

1. Navigate to Asset > Meter Reads.

2. Click the upload meter reads link.

2. Click the upload meter reads under the Actions column.

3. Click the Choose File button.

4. Navigate to and select the file.

5. Click the Upload button to load the meter reads file.

6. For serial number and meters, map the Map the data columns .

7. Click the Next button.

The data is then listed and validated to ensure the uploaded data has the correct serial number, meter date, and meter reads.