...
Spreadsheet column | Data Type | Where it needs to end up on Shuttle Booking Screen | Other things that May happen from this |
|---|---|---|---|
Date of Travel (date) | Date of Travel dd/mm/yy or dd/mm/yyyy or dd/mm | Date of Travel | |
Flight number (text) | Flight Number (Text) | Flight number | Implies Direction of Travel Implies Destination and Terminal Implies Flight time |
Flight Time (time) | Flight Time (hh:mm) | Flight time | |
Direction of Travel (lookup list) | Direction of travel lookup list. | Direction of travel | Need a list of possible data passed by the customer and the resulting meaning. Eg “outbound” = From Destination. etc |
na | Direction from flight number | Direction of travel | Infer from flight number history + lookup table |
na | Destination and Terminal from flight number | Destination and Terminal | Need to get this by looking into system history (last 3 bookings with this flight number) |
Destination and Terminal (lookup list) | Destination and Terminal | Need a list of possible data passed by the customer and the resulting meaning. eg: sydney domestic = Domestic Terminal | |
PAX (number) | Travellers | ||
na | PAX default (number) | Travellers | Default value |
Extra luggage (number) | extra luggage | ||
Passenger name (text) | Passenger Full Name | Passenger name | |
Fname (text) | Passenger First Name | Passenger name First part | combine first and last name to single field |
Lname (text) | Passenger Last Name | Passenger name end part | combine first and last name to single field |
Passenger email (text) | Passenger Email | booking email | |
passenger phone (text) | Passenger Phone | booking phone | |
Address in single cell (text) | Full Address | Multiple columns (address, post code, suburb) | Decompose address into line 1,2, suburb, postcode |
Address line 1 (text) | Address1 | Build Address | |
Address line 2 (text) | Address2 | Build Address | |
address post code (text) | Postcode | Build Address | find in suburb / postcode list |
address suburb (text) | Suburb | Build Address | find in suburb / postcode list |
Their reference (text) | External Reference | Their Reference | |
Hotel Name (text) | Hotel Name | Address | Find Hotel name and compare with customer and with hotels in the system |
na | Use Customer Address | Address | Choose from default customer addresses |
Logical Flow
Travel Date provided (is mandatory)
Date is today or in the future
Flight number provided
Yes
Infer other fields > by looking at shuttle booking history (at least 5 bookings prior to today)
Destination
Direction of Travel
Flight Time
No
Destination must be provided
compare with lookup table for this customer
Terminal must be provided
yes - use lookup for terminal
no - default terminal setting
Flight time must be provided
Direction of Travel must be provided
Will need a lookup table that converts text provided to direction
PAX
if not provided then use default value
Excess Bags
Only if provided
Passenger name options
Single field
combine Fname / Lname fields
Passenger phone
may not be provided
passenger email
may not be provided
Address
May be provided line by line
May be provided in a single field > decompose
Hotel name may be provided
Look up in customer name fields (all customers) > use address found
May not be provided = use customer address on the booking
External Reference
May not be provided
Inbound Delegate company > always the customer used
...