Reservation Import

data requirements csv utf 8 separator ; (semicolon) record spacer \n (new line) escape \ (backslash) e g \\; will escape a contained semicolon quotes no first record as header yes decimal separator dot fields field name description id unique identifier if another import contains the same id, the record will be updated recommended reservationid in case you want to reference a specific reservation in the hotelsoftware to be updated (use hotelsoftware internal room reservation ids only in this field) do not use guestprofileid only populate with hotelsoftware internal guest profile id if you want to associate this reservation with a specific guest profile do not use travelagentid only populate with hotelsoftware internal guest profile id if you want to associate this reservation with a specific travel agent profile do not use title firstname name last name street zipcode city countrycode iso 2 character country code phone preferably in international format (e g +43 660 737 88 90) email nationality iso 2 character country code language iso 2 character language code birthdate any valid date (unparsable dates will be skipped on import) requestexpirationdate any valid date (unparsable dates will be skipped on import) arrivaldate any valid date required departuredate any valid date either departuredate or numberofnights is required numberofnights any valid date (will only be used if no departuredate is set) either departuredate or numberofnights is required roomtype hotelsoftware internal room type id (will only be used if no roomnumber is set) either roomnumber or roomtype is required roomnumber if neither roomnumber nor roomtype is set we will default it to a random room type either roomnumber or roomtype is required rateplan hotelsoftware internal rate plan id (the default rate plan will be used if this value is not set) required internalcomment guestcomment numchildren childrenage comma separated list of children ages make sure to configure the age categories before doing the import if no age categories do exist at time of import, all children will be imported as adults reservationsource name of the reservation source we usually recommend inserting the name of the old pms into this field numadults required totalamount total reservation amount in english number format (e g 513 79) in the hotels default currency no currency signs, no currency codes, no commas prepaymentamount prepayment amount requested from the guest (for informational purposes only) confirmationcode can be used to group multiple reservations together to a single group reservation valid date formats dd mm yyyy dd/mm/yyyy yyyy mm dd dd mm yyyy