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 |