Reservation Import File Specifications
Field |
Field Sequence |
Max Width |
Data Type |
Format |
Optional or Required |
Example |
---|---|---|---|---|---|---|
Date |
1 |
10 |
Date |
mm/dd/yyyy |
Required |
03/15/2018 |
Event Start Time |
2 |
4 |
Numeric |
hhmm |
Required |
0800 |
Event End Time |
3 |
4 |
Numeric |
hhmm |
Required |
1300 |
Building |
4 |
50 |
Alphanumeric |
Left Justified |
Required |
Adams |
Room |
5 |
50 |
Alphanumeric |
Left Justified |
Required |
Arapahoe Conference Room |
Event Name |
6 |
255 |
Alphanumeric |
Left Justified |
Required |
Staff Meeting |
Group Name |
7 |
50 |
Alphanumeric |
Left Justified |
Required |
Accounting Department |
Contact Name |
8 |
50 |
Alphanumeric |
Left Justified |
Optional |
Mindy Brady |
Setup Count |
9 |
5 |
Numeric |
## |
Required |
8 |
Reservation Reference |
10 |
20 |
Alphanumeric |
Unique identifier that is used to group bookings into one reservation |
Optional |
R1 |
Billing Reference |
11 |
100 |
Alphanumeric
|
Left justified |
Optional |
Training for new system deployment |