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

 

(missing or bad snippet)