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
How could we improve this answer?