Hub Import/Export

Import and export pilot hubs with airport assignments.

Staff
Last verified: January 28, 2026

The Hub importer and exporter let you bulk manage pilot hubs. Hubs group airports together and can be assigned to pilots to define their home base or operating region.

Import Airports First

Airport codes in the import must match existing airports in your airline. Create Airports before importing Hubs.

Accessing Import/Export

In Orwell, go to Data → Exports to download your hubs as CSV, or Data → Imports to upload changes.

Column Reference

Column

Required

Description

ID

For updates

vAMSYS record ID. Leave empty when creating. Include when updating or deleting.

Name

Yes

Hub display name (e.g., "London Hub", "East Coast")

Is Default

No

TRUE to use as default hub for new pilots. Only one hub can be default.

Order

No

Display order (lower numbers appear first)

Airport Codes (ICAO/IATA)

No

Comma-separated airport codes belonging to this hub

_delete

Yes

Set to TRUE to delete, FALSE otherwise

Default Handling

When you set a hub as default, all other hubs are automatically set to non-default. Only one hub can be the default.

Creating Hubs

  1. Leave the ID column empty

  2. Fill in the required Name column

  3. Add airport codes (comma-separated) if desired

  4. Set _delete to FALSE

Updating Hubs

  1. Export existing hubs

  2. Modify the columns you need to change

  3. Keep the ID column intact

  4. Ensure _delete is FALSE

Deleting Hubs

  1. Export the hubs you want to delete

  2. Set _delete to TRUE for those rows

  3. Import the file

Pilot Assignments

Before deleting a hub, ensure no pilots are assigned to it. Reassign pilots to a different hub first.

Back to Documentation