Area Import
Information on the requirements for the Area Import in RMS.
Import Information
- Categories must be setup or imported in RMS prior to attempting an Area import.
- The file to be imported must be in a comma delimited .csv format (Field Delimiter).
- If a data field within this file contain commas, it should be surrounded with "double quotes" (Text Delimiter).
- Microsoft Excel is able to save using a .csv format that should match these requirements.
-
RMS is able to determine whether the first record is a header record.
Field Order
| Order |
Field Name |
Field Type |
Required |
Unique |
Max Charaters |
RMS Equivalent |
| 1 |
Category |
Alpha Numeric |
Y |
N |
50 |
Exact Category Name (in RMS) |
| 2 |
Name |
Alpha Numeric |
Y |
Y |
50 |
Area / Site Code or Name |
| 3 |
LongDescription |
Alpha Numeric |
N |
N |
Unlimited |
Long Description |
| 4 |
Length |
Numeric |
N |
N |
7 |
Length |
| 5 |
Width |
Numeric |
N |
N |
7 |
Width |
| 6 |
Addr1 |
Alpha Numeric |
N |
N |
50 |
Address Line 1 |
| 7 |
Addr2 |
Alpha Numeric |
N |
N |
50 |
Address Line 2 |
| 8 |
Addr3 |
Alpha Numeric |
N |
N |
50 |
Address Line 3 |
| 9 |
Town |
Alpha Numeric |
N |
N |
50 |
Town |
| 10 |
State |
Alpha Numeric |
N |
N |
20 |
State |
| 11 |
PostCode |
Alpha Numeric |
N |
N |
15 |
Postcode |
| 12 |
StatsEnabled |
Yes/No Field |
N |
N |
1 |
Statistics (On by default) |
| 13 |
Spare1 |
Alpha Numeric |
N |
N |
100 |
Area Spare Field |
| 14 |
Spare2 |
Alpha Numeric |
N |
N |
20 |
Area Spare Field |
| 15 |
Spare3 |
Alpha Numeric |
N |
N |
20 |
Area Spare Field |
| 16 |
Spare4 |
Alpha Numeric |
N |
N |
20 |
Area Spare Field |
| 17 |
Spare5 |
Alpha Numeric |
N |
N |
20 |
Area Spare Field |
| 18 |
Spare6 |
Alpha Numeric |
N |
N |
20 |
Area Spare Field |
| 19 |
Spare7 |
Alpha Numeric |
N |
N |
20 |
Area Spare Field |
| 20 |
Spare8 |
Alpha Numeric |
N |
N |
20 |
Area Spare Field |
| 21 |
Spare9 |
Alpha Numeric |
N |
N |
20 |
Area Spare Field |
| 22 |
Spare10 |
Alpha Numeric |
N |
N |
20 |
Area Spare Field |
| 23 |
Client Description |
Alpha Numeric |
N |
N |
50 |
Area Client Description |
| 24 |
Max Occupancy |
Numeric |
N |
N |
7 |
Max Area Occupancy |
Sample File
Area Import.csv
How could we improve this answer?