Newspaper Sun Res Import
Information on the requirements for the Newspaper Sun Res Import available in RMS
Import Information
- 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.
- Each line should have either a Group name or a Surname.
Field Order
| Order |
Field Name |
Field Type |
Required |
Max Characters |
RMS Equivalent |
| 0 |
BookingID |
Alpha Numeric |
Y |
20 |
Reservation ID Number |
| 1 |
AccomCode |
Alpha Numeric |
Y |
50 |
Category ID Number |
| 2 |
HolidayDate |
Date |
Y | No Max |
Arrival Date |
| 3 |
Nights |
Numeric |
Y |
No Max |
Number of Nights |
| 4 |
LeadTitle |
Alpha Numeric |
Y |
15 |
Primary Client Title |
| 5 |
LeadInitial |
Alpha Numeric |
Y |
20 |
Primary Client Given Name |
| 6 |
LeadSurname |
Alpha Numeric |
Y |
50 |
Primary Client Surname |
| 7 |
Addr1 |
Alpha Numeric |
Y |
50 |
Primary Client Address Line 1 |
| 8 |
Addr2 |
Alpha Numeric |
Y |
50 |
Primary Client Address Line 2 |
| 9 |
Addr3 |
Alpha Numeric |
Y |
50 |
Primary Client Address Line 3 |
| 10 |
Town |
Alpha Numeric |
Y |
50 |
Primary Client Town |
| 11 |
Country |
Alpha Numeric |
Y |
20 |
Primary Client Country |
| 12 |
PostCode |
Alpha Numeric |
Y |
15 |
Primary Client Post Code |
| 13 |
DayPhone |
Alpha Numeric |
Y |
21 |
Primary Client Business Hours Phone Number |
| 14 |
EvePhone |
Alpha Numeric |
Y |
21 |
Primary Client After-Hours Phone Number |
| 15 |
HeadCount |
Numeric |
N |
N/A |
|
| 16 |
Age1 |
Numeric |
N |
15 |
18+ = Adult 2-17 = Child 0-1 = Infant |
| 17 |
Age2 |
Numeric |
N |
15 |
18+ = Adult 2-17 = Child 0-1 = Infant |
| 18 |
Age3 |
Numeric |
N |
15 |
18+ = Adult 2-17 = Child 0-1 = Infant |
| 19 |
Age4 |
Numeric |
N |
15 |
18+ = Adult 2-17 = Child 0-1 = Infant |
| 20 |
Age5 |
Numeric |
N |
15 |
18+ = Adult 2-17 = Child 0-1 = Infant |
| 21 |
Age6 |
Numeric |
N |
15 |
18+ = Adult 2-17 = Child 0-1 = Infant |
| 22 |
Age7 |
Numeric |
N |
15 |
18+ = Adult 2-17 = Child 0-1 = Infant |
| 23 |
Age8 |
Numeric |
N |
15 |
18+ = Adult 2-17 = Child 0-1 = Infant |
| 24 |
Insured |
Alpha Numeric |
N |
N/A |
|
| 25 |
Filler1 |
Alpha Numeric |
N |
N/A |
|
| 26 |
ParkCode |
Alpha Numeric |
N |
N/A |
|
| 27 |
Title1 |
Alpha Numeric |
N |
15 |
Additional Client Title |
| 28 |
Initial1 |
Alpha Numeric |
N |
20 |
Additional Client Given Name |
| 29 |
Surname1 |
Alpha Numeric |
N |
50 |
Additional Client Surname |
| 30 |
Title2 |
Alpha Numeric |
N |
15 |
Additional Client Title |
| 31 |
Initial2 |
Alpha Numeric |
N |
20 |
Additional Client Given Name |
| 32 |
Surname2 |
Alpha Numeric |
N |
50 |
Additional Client Surname |
| 33 |
Title3 |
Alpha Numeric |
N |
15 |
Additional Client Title |
| 34 |
Initial3 |
Alpha Numeric |
N |
20 |
Additional Client Given Name |
| 35 |
Surname3 |
Alpha Numeric |
N |
50 |
Additional Client Surname |
| 36 |
Title4 |
Alpha Numeric |
N |
15 |
Additional Client Title |
| 37 |
Initial4 |
Alpha Numeric |
N |
20 |
Additional Client Given Name |
| 38 |
Surname4 |
Alpha Numeric |
N |
50 |
Additional Client Surname |
| 39 |
Title5 |
Alpha Numeric |
N |
15 |
Additional Client Title |
| 40 |
Initial5 |
Alpha Numeric |
N |
20 |
Additional Client Given Name |
| 41 |
Surname5 |
Alpha Numeric |
N |
50 |
Additional Client Surname |
| 42 |
Title6 |
Alpha Numeric |
N |
15 |
Additional Client Title |
| 43 |
Initial6 |
Alpha Numeric |
N |
20 |
Additional Client Given Name |
| 44 |
Surname6 |
Alpha Numeric |
N |
50 |
Additional Client Surname |
| 45 |
Title7 |
Alpha Numeric |
N |
15 |
Additional Client Title |
| 46 |
Initial7 |
Alpha Numeric |
N |
20 |
Additional Client Given Name |
| 47 |
Surname7 |
Alpha Numeric |
N |
50 |
Additional Client Surname |
| 48 |
Title8 |
Alpha Numeric |
N |
15 |
Additional Client Title |
| 49 |
Initial8 |
Alpha Numeric |
N |
20 |
Additional Client Given Name |
| 50 |
Surname8 |
Alpha Numeric |
N |
50 |
Additional Client Surname |
| 51 |
Filler2 |
Alpha Numeric |
N |
100 |
Primary Client Email Address |
Date Format
All date fields must use the format DD-MMM-YYYY.