From the Crew/Pax tab it is possible to download and batch upload a list of crew/pax details from an Excel file. Batch uploading crew/pax details saves time for bigger manifests compared to manually adding each record individually.

Contents:

Instructions:

Downloading the crew/pax excel template for upload

From the Crew/Pax Tab: Clicking the 'Download crew/pax template' button, an Excel file is generated using the FBO location and order number, along with the crew/pax entries shown on the order screen.

Entering the correct format

Entering the correct information in each row is important to ensure that the crew/pax details are uploaded successfully. To help ensure that the correct format is inputted, drop down lists exist on the following columns:

• ArrDep:

  • 'Arrival' - for inbound leg only ('Arr' also accepted)

  • 'Departure' - for outbound leg only ('Dep' also accepted)

  • 'Both' - for both inbound and outbound legs.

• Crew/PaxType: List of crew and passenger types defined from Crew types (Administration).

• Gender: 'Unknown', 'Male', 'Female'

• Nationality: List of countries defined from Countries (Administration).

• TravelDocumentType: List of travel documents 

• PassportCountryOfIssue: List of countries defined from Countries (Administration).

• Email: If present, it must be a valid email

• Delete Row: 

  • 'NO' - row is kept and uploaded (if blank then 'NO' is the default)

  • 'YES' - row is deleted when uploaded. 

Note: Deleting the row without adding 'YES' will not delete the entry in the order.

Uploading and updating

To update the existing list of crew/pax entries first choose a file, by clicking the "Choose File" button, then click the "Upload and update crew/pax" button:

Upload Summary

A summary will show after upload showing in bold the count of each crew/pax type successfully uploaded.