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.
Field Order
Order |
Field Name |
Field Type |
Required |
Max Characters |
RMS Equivalent |
|---|---|---|---|---|---|
1 |
Legacy Res ID |
Alpha Numeric |
If no Username |
50 |
Legacy Reservation number code is attached to |
2 |
User Name |
Alpha Numeric |
if no Legacy Res ID |
20 |
User names for alternate user |
3 |
Access No |
Numeric |
Y |
10 |
|
4 |
Rego |
Alpha Numeric |
|
20 |
|
5 |
Expiry Date |
Date |
Y |
10 |
|
6 |
Expiry Time |
Time |
Y |
10 |
|
7 |
Note |
Alpha Numeric |
|
100 |
|
8 |
Access Type |
Numeric |
|
1 |
0 = IN | 1 = OUT | 2 = IN/OUT | 3 = Anti Passback |
9 |
Property Name |
Alpha Numeric |
|
20 |
|
10 |
Zone |
Alpha Numeric |
|
20 |
|