Uploading flights through sFTP

Connecting to CitizenPlane's FTP server

Beforehand

You will need your sFTP username and password to set up a connection to CitizenPlane's FTP server. 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.

Connecting to the server

Several tools can be used as FTP client. We will be using CyberDuck as an example for this guide.

CyberDuck

Once you have installed the software, click on the top left of the application's main window and select Open Connection.

Enter the following information:

Protocol: FTP or sFTP

Server/Host / Username / Password: Ask us for it at support@citizenplane.com! 

and click on Connect.

You will be prompted a warning if you choose to use FTP, click on continue.

Once connected you will have access to a single directory: data, which you'll use to upload files.

Note: You can only upload files in the data folder

Your screen should now look similar to the following:

Uploading files onto the server

File format

All files must be in .csv format (other formats won't be processed), with a comma as a delimiter. Other formats and delimiters will not be taken into accounts.

Note: File name must not contain spaces. Otherwise, there are no naming conventions for the files you upload.

The format of the csv is strict and should follow the example below:

origin_airport,origin_terminal_airport,date_local_takeoff,hours_local_takeoff,destination_airport,destination_terminal_airport,date_local_landing,hours_local_landing,via_airport,airline,flight_number,luggage_options,available_seats,price,need_apis,end_selling_date<br>AMS,,2019-03-18,07:55,SID,,2018-03-18,14:10,,HV,6845,1-15-0,9,129,FALSE,48<br>BRU,,2019-03-19,13:45,ACE,1,2019-03-19,16:55,,SN,3787,1-23-20,10,79,FALSE,10<br>LYS,1,2019-03-21,17:55,TUN,,2019-03-21,19:50,,BJ,573,1-20-0,7,150,FALSE,24

When one or more optional parameters are not available (such as origin_terminal_airport or via_airport), just leave them empty but don't change the structure of the file, otherwise, your file won't be processed.

File size must be limited to 150Kb. If the file size exceeds 150Kb (approximatively 1600-1800 rows of data), your file won't be processed and be kept in your folder.

Note: you can upload multiple files, we will treat them sequentially, from least recent to most recent file.

Validity checks

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 is the list of columns along with the different checks:

Columns