In this article

CSV Format: Meter Reading Data

Meter reading data can be exported from and then imported to the Charge Details page. To import or export data, use the following commands:

  • From the Charge Details page, select one of the following actions to import or export data for a single lease charge and meter:
    • PLM Import/Export > CSV File > Export > Meter Usage
    • PLM Import/Export > CSV File > Import > Meter Usage
  • From the home page, select one of the following actions to import or export data for several lease charges and meters for different leases: 
    • PLM > PLM > Import/Export > CSV File > Export > Meter Usage

      • When the dialog appears, select the lease number and the meter number that you want to export. Leave these values empty to export the data for all meters and leases.

    • PLM > PLM > Import/Export > CSV File > Import > Meter Usage

      • Imports the data for all meters and leases that is in the import file.

Tip: As a best practice before importing data, export data to the file in the format you want. This export file serves as a template or sample, so that you can ensure that the import file you have matches the correct format.

When data is imported and the same meter number appears multiple times, the line that has the largest reading or consumption value is imported.

Select Copy to copy the sample to the clipboard.

Copy

MeterReading.csv sample

Meter No.,Current Reading,Qty To Invoice,Reading Date
EMETER12,1,0,1/1/2021
EMETER12,2,0,2/1/2021
GMETER12,0,2,1/1/2021
GMETER12,0,3,2/1/2021

The following table shows the columns for the CSV formatted file: 

C S V Columns Table
Field Name Data Type Required Description
BssiPLMMeterNo String Required Meter number attached to the charge.
BssiPLMCurrentReading Number Required

For meters that are of Reading type, this value must be a positive non-zero number.

For lines that have the same meter number that are in different billing periods, this value must be greater than the previous value of the previous line entry.

For meters that are of Consumption type, a zero (0) value is required.

BssiPLMQtyToInvoice Number Required

For meters that are of Consumption type, this value can be greater than or equal to zero (0).

For meters that are of Reading type, a zero (0) value is required.

ReadingDate Date Required If multiple lines for the same meter number exist and have different dates within the same date range, only the line with the most current date is imported.