Contact Support

    Meter Reading Import

    Information on the requirements for the Meter Reading Import available in RMS.

    Import Information

    • The file to be imported must be in a comma delimited .csv format.
    • Microsoft Excel is able to save using a .csv format that should match these requirements.
    • The fields within this file must not contain commas
    • RMS is able to determine whether the first record is a header record or not, thus it is not necessary to strip the header record (field names) prior to the import
    • All Date Time fields must be supplied in yyyy-MM-ddHH-mm-ss (2014-07-19 23:55:00) format. If a Time is not supplied then midnight (00:00:00) will be used.
    • Area's must already be created in RMS and names must match exactly. (not case sensitive)

    Field Order

    Order Field Name Field Type Required Max Characters RMS Equivalent
    1 Area String Y 50 Room/Site Number E.g. 02
    2 MeterType String Y 1 Type of meter
    3 LastReadDate Date Time Y   Last date the meter was read
    4 LastMeterValue Number Y   The last value on the meter
    5 MeterNo String N 50 The serial/tag number on the meter
    6 Tariff Number N 1 Tariff 1, 2, 3 or 4
    7 Multiplier Number N    
    8 Active Y/N Y 1 1 = Active | 0 = InActive

    Meter Type Values

    • E = Electricity
    • W = Water
    • G = Gas

    Sample File

    Meter Reads.csv

    Was this article helpful?

    Send Feedback

    Can’t find what you’re looking for?

    Contact Support