How do I load batch meter readings?

How do I load batch meter readings?

The meter values can be fed information from individual records or through batch records by importing .csv files.
To load batch meter reading, select the option Definitions | General | File Importation or using the meter reading list (Assets | Meters and Monitorings | Meter Readings ) by selecting the option Import Meter Readings.
  1. The import screen is presented;
  2. Download the model file on the upper side of the screen and fill in the file;
  3. You must fill in the file according to the rules
    1. The fields MeterValueKey, Meter, AssetType, Asset, Date e Company must be defined.
    2. Only one of these columns, Increment or Reading, must be filled on and must be according to the meter type.
    3. The column AssetType must contain one of the values:
      1. In case the asset is a location
      2. In case the asset is an equipment
      3. In case the asset is a tool
    4. When the import is finished, the import date will be presented that might (or not) contain messages with import details; if an import occurrs with no errors/warnings no information on the import details will be presented; if the import records errors/warnings, you can see the errors by clicking on the number of messages.
    5. The upload is performed by company and as a transaction. That is, all records regarding the company must be inserted successfully, otherwise, no record for that company is recorded.
  4. You must fill in the file, load it on the section "Select file to import"
  5. Press the button "Import"
When filling in the file, you must consider the following points:
  1. The file must always be of the CSV type and the separator character must be “;” (semicolon);
  2. Check if all values with zeros on the left are kept. Some editing software products can remove the zeros;
  3. The field MeterKeyValue is used exclusively to identify each record in this file and will not be reflected on the backoffice;
  4. If there is more than one row with the same value in the field MeterKeyValue, only the last value will be imported;
  5. The decimal values must be separated by “.” (dot).
​Each file cannot have more than 1000 records.

    • Related Articles

    • How to import parts?

      The parts can be inserted from individual records or through batch records by importing .csv files. To load batch parts, select the option Settings | General | File Import or using the parts list ( Parts and Inventory | Parts ) by selecting the ...

    • How do I import tasks?

      The tasks can be inserted from individual records or through batch records by importing .csv files. To load batch assets, select the option Definitions| General | File Import: The import screen is displayed; Select the option Import Tasks; Download ...

    • How to load batch locations?

      The locations can be inserted from individual records or through batch records by importing .csv files. To load batch locations, select the option Settings| General | File Import: The import screen is displayed; Download the template file to be ...

    • How to import maintenance plans?

      The maintenance plans can be introduced using individual records or by using batch records, by importing .csv files. To batch load maintenance plans select the option "Definitions| General | File Import": The import screen is presented; Select the ...

    • How do I import parts entry?

      The parts entries in stock can be fed from individual records or through batch records by importing .csv files. To load batch parts entries, select the option Definitions | General | File Import or using the parts entries list ( Parts and Inventory | ...