Traveller Profiles Import
The BookingPad bulk import feature allows agencies to upload large volumes of traveler data into specific corporate accounts. This process requires a prepared CSV file and coordination with the AirGateway support team.
Prerequisites
Before initiating an import, the Corporate Section must be enabled for your agency.
Make sure to provide the exact Corporate Account Name where the profiles should be assigned. If the account is not yet established, our team will create it in BookingPad as part of the setup.
CSV Technical Standards
To ensure a successful data transfer, the CSV file must adhere to the following specifications:
Mandatory Fields: Every entry must include a first_name and last_name.
Data Integrity: Check for and remove any duplicated traveler data. The system does not merge records; it will create duplicate profiles if the same data is submitted multiple times.
Delimiters: The import tool supports files using either semicolon ( ; ) or comma ( , ) as delimiters.
Required Header Mapping
Use the following standardized headers in the first row of your CSV file:
| Field Name | Requirement | Details / Format |
|---|---|---|
| traveler_code | Optional | Unique internal agency identifier |
| first_name | Mandatory | Traveler’s legal first name |
| last_name | Mandatory | Traveler’s legal last name |
| Optional | email address | |
| phone | Optional | phone number |
| date_of_birth | Optional | Use format: DD/MM/YYYY, DD-MM-YYYY, YYYY/MM/DD, YYYY-MM-DD |
| gender | Optional | male or female |
| homebase | Optional | Preferred airport code |
Submission Procedure
To complete the traveler profile import, verify that no rows are missing mandatory names to avoid import errors and send the CSV file to the AirGateway team on our Support Platform, specifying the Corporate Account Name for the upload.
Our team will confirm once the list is successfully integrated into your Corporate Section.
To add travelers to an existing account later, submit a new CSV file containing only the new profiles.
Common CSV Formatting Errors
Before submitting your file to the AirGateway team, review these common issues that can cause import failures or data corruption:
Missing Mandatory Data: First and Last name are mandatory.
Header Mismatches: Headers must match the standardized list exactly.
Case Sensitivity for Gender: Ensure the gender field is strictly populated with either male or female in lowercase.
Hidden Characters: Opening CSV files in certain spreadsheet software can sometimes introduce hidden formatting characters. Ensure the file is saved as a Plain CSV.
Duplicate Entries: Re-check that no traveler appears twice in the list, as the system will create two separate profiles for the same person.
Access our Support Platform and open a new ticket to request the import.
