Auto export new bookings / luggage on sFTP

Beforehand

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 support@citizenplane.com and ask to have your account configured and receive a username/password.

Uploaded files onto the server

File format

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:

"origin","destination","flight_number","departure_date","booking_date","booking_ref","price","pnr_reference","first_name","last_name","gender","nationality","date_of_birth","birth_country","passport_number","passport_expiry_date","passport_country_of_issue","is_infant","status"

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:

"booking_ref","quantity","weight","price"<br>26101,1,20,0