Getting connected through sFTP

This feature allows you to upload flights CSVs onto our FTP server, where they'll be automatically read and sent to the CitizenPlane platform to be either created, updated or turned into a new flight (i.e undergoing a schedule change).

Supplier set up

First, we'll have to open an access to our FTP server for you. Just ask us and we'll send you your credentials:

  • host: ftp-server.citizenplane.com
  • a username
  • a password.

Once you've made settings on your side, our system will check every 10 minutes if there is a file in your FTP folder and then process it.

File formatting

Here are all the steps needed to set up the connection, send the file and how to properly format it.

Flight creation vs update vs schedule change

The routine handles:

  • the creation
  • the update
  • the schedule change of a flight,

under the conditions listed below.

Updates

Here is a list of the parameters which, changed through a FTP update, will update the flight but not create a new one.

Schedule Changes

Here is a list of the parameters which, changed through a FTP update, will create a new "child" flight, with a new flight ID.

  • Some schedule changes are "silent", meaning they do not warn passengers
  • Some are "warning" changes, meaning they will send a notification to passengers
  • Some are "hard" changes, meaning they will send a notification and passengers will be allowed to ask for a refund.

Note: flights need to be OPEN to undergo a schedule change. PENDING flights cannot.

Silent schedule changes

If the following fields are updated AND the flight status is PENDING, all corresponding fields will be updated (i.e it won't result in a child flight creation, only an update of the current pending flight).

"Warning" Schedule changes

If the following fields are updated AND the flight status is OPEN:

→ The flight will be closed

→ A new PENDING flight will be created, with the pax re-attached to the new flight.

→ All pax will be warned by email that their flight is undergoing a schedule change but they CAN'T ask for a refund.

"Hard" Schedule changes

If the following fields are updated AND the flight status is OPEN:

→ the flight will be closed

→ a new PENDING flight will be created, with the pax re-attached to the new flight.

All pax will be warned by mail that their flight is undergoing a schedule change, and they can ask for a refund.