In addition to manually entering meter reads, iOffice allows the upload of electronic files that contain meter reads for a specific date. It is important to have the same building and assets as listed on the Meter Read screen. Any discrepancies will cause reporting complications.
Note: The user interface to upload meter reads is a preference that must be enabled during initial configuration.
For the file to upload properly, it must be formatted in a specific way. Follow these guidelines.
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.
You must save the file in .csv or .txt format. If it is a .txt file, it must be comma delimited.
Each asset must have unique serial number or ID. IP addresses cannot be used because they may not be unique.
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
The asset must have the same meter read fields (i.e. Copy Color) set up during the initial site configuration.
You must have a value in each cell, even if zero (0).
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”
Figure: Sample Effective File Name
Upload a File
After creating the file, you can upload it to the TRAC Solution website.
Click upload meter reads under the Actions column of the Meter Reads screen.
Figure: Upload Meter Reads
Locate and upload the file.
Click Choose File to open a file search box.
Locate the file on your computer.
Click the Choose button to select the file.
After attaching the file, click Upload.
Figure: Upload File
Note: The upload speed depends on the file size and your connection speed.
Map the data columns for serial number and meters.
Figure: Data Columns for Serial Number and Meters
The data is then listed and validated to ensure the uploaded data has the correct serial number, meter date, and meter reads.
Any bad data is marked with a warning icon.
When you hover over the icon, you can read details about the error.
Cancel the upload process and fix the data or you can proceed with the remaining good data.
After the upload, a count of the meter reads added displays.