How to import meter readings in batch?

Meter values can be entered through individual records or in batch, by importing CSV files.

Import meter readings

To import meter readings in batch, follow these steps:

1. Go to Settings | General | File Imports, click on the MeterReadings template, in the Import Meter Readings row;

2. On the import screen, click on Download file to get the template file;

3. Fill in the downloaded file, according to the rules below;

4. In File to Import, click on Select and choose the filled-in file;

5. Click on Import.

Rules for filling in the import file

When filling in the file, the following rules apply:

• The columns MeterValueKey, Meter, AssetType, Asset and Date are required;

• Only one of the columns Increment or Reading must be filled in, according to the meter type;

• The AssetType column must contain one of the following values:

  • 1, if the asset is a location;

  • 2, if the asset is equipment;

  • 3, if the asset is a tool;

• The MeterValueKey column is only used to identify each record in the file and is not shown in the product. If there is more than one row with the same value in this column, only the last one is imported;

• The Company field should only be filled in if there is more than one company. To identify the intended company, check the company identifier in the left sidebar of the product;

• The file must be of type CSV, with the semicolon (;) as the separator;

• Decimal values must be separated by a dot (.);

• Values with leading zeros must be kept. Some editing programs may remove them, so it is important to check before importing;

• Each file must not have more than 1,000 records.

View the import result

When the import finishes, the Summary of imports shows the import date and the messages with details. If the import occurs without errors or warnings, the summary shows No messages. If there are errors or warnings, you can view them by clicking on the number of messages.