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