Import travel and review guests' own bookings
Load flights and hotel rooms from a travel agency's spreadsheet, fix the rows that need a decision, and clear the review flag on bookings guests added themselves.
Travel is attached to guests who are already in the event. Importing never creates guests, so add the guests first. Imports are silent: guests get no email or push.
Bulk import
Use travel_import_edge__eventImportTravelFlights for flights and travel_import_edge__eventImportTravelLodging for hotels.
-
Map the spreadsheet to rows.
- Flights: one row per passenger per flight leg. Fields:
rowNumber;email, orfirstName/lastName/fullName(SMITH/JOHN MRis fine);direction(ArrivingorDeparting),pnr,airlineCode,flight(such asUA123);departDate,departTime,from,to,arriveTime(06:10+1means the next day);- optional
seat,bookingClass,ticketNumber,status.
- Hotels: one row per occupant. Fields:
hotel,confirmationNumber,checkInDate,checkOutDate;- optional
roomType,bed,specialRequests; roomShareRefto group roommates when there’s no confirmation number.
- Set
dateOrder(dmyormdy) when the dates are ambiguous. Send at most 500 rows per call, and keep all of a booking’s rows in the same call.
- Flights: one row per passenger per flight leg. Fields:
-
Dry-run with
dryRun: true. Each row comes back as one of:create,updateorunchanged;cancel;not-a-guest: no guest with that email or name in this event;needs-resolution: the name matches several guests;invalid,duplicate-in-fileorconflict.
The result also lists warnings.
LEGS_REMOVEDmeans an update would drop flight legs: an update replaces the booking’s whole itinerary with the file’s legs. -
Resolve. For each
needsResolutionentry, ask the organizer which guest is meant, or skip the row. Passresolutions: {<identity>: {action:"link", guestId}}or{action:"skip"}. -
Commit with
dryRun: false, the same rows and the resolutions. Re-uploading the same file is safe: existing bookings are updated or left alone, never duplicated. Only an explicitCancelledstatus cancels a booking, and a booking missing from a later file is left untouched.
The review flag
When a guest adds or edits their own travel, the row is flagged Needs review.
- Call
travel__listEventTravelfor the event’s whole travel list. Each row hasenteredBy(guest,stafforimport) andreviewState, andreviewCountstotals what’s still waiting. - Check the flagged rows with the organizer, then clear them with
travel__markTravelReviewed, passingkind(flight,lodging,groundorrental) and up to 500 ids from that list. Dry-run first. This doesn’t change the booking itself.
One-off changes
- One guest’s travel:
travel__listAttendeeTravel. - Add or update a booking:
travel__adminAddTravelFlight,travel__adminUpdateTravelFlight,travel__adminAddTravelLodgingandtravel__adminAddTravelGround. - Flight or transfer status (
scheduled,delayed,departed,arrived,cancelled):travel__setTravelStatus. - Arrival groups for transfers or chat:
chat__suggestFlightCohortssuggests groups of guests arriving together.
To chase guests who haven’t booked yet, use travel_missing in Message people who….