Auto export new bookings / luggage on sFTP
You will need an FTP / sFTP / FTPs server to set up an automatic routine. If you don't have sFTP enabled for your account, contact email@example.com and ask to have your account configured and receive a username/password.
Uploaded files onto the server
Every new booking will create two files on your FTP server:
- one for PNL, formatted as follows: "pnl_BOOKINGID_FLIGHT_NUMBER_ORIGIN_IATA-DESTINATION_IATA_YYYY-MM-DD_NPAX"example: "pnl_39847_5O123_CDG-DJE_2019-07-22_1PAX"
- one for luggage, formatted as follows: "luggages_BOOKINGID"example: "luggages_123456"
All files are created in . csv format, with a comma as a delimiter.
The format of the PNL CSV is strict and should follow the example below:
When one or more optional parameters are not available (such as passport_number when APIS are not needed), we just leave them empty but we don't change the structure of the file (same columns), so you can process them the same way.
The format of the luggage CSV is strict and should follow the example below:
Multiple checks will be performed on each file to ensure data consistency. Make sure to read the following instructions and verify your files follow our restrictions before uploading.
Here are the list of columns along for PNLs:
Here are the list of columns along for luggage:
Should you need to change any other information, please login onto your personal dashboard on citizenplane.com or contact firstname.lastname@example.org.