Help centre · For airline owners

Exporting your airline's data

Watch the video: Your data

This article explains the ways to download your airline's data: your setup and records in one ZIP file, the setup as a JSON file, and the activity log as a spreadsheet.

Export your setup and records (owner only)

  1. Open Staff → Airline settings → Settings, go to the Danger zone tab and press Transfer ownership. The Ownership and data page opens.
  2. In the Take your airline's data card, press Export your setup and records.

You get one ZIP file named after your airline and today's date. It contains:

  • setup.json: hubs, the airports you use, fleet, routes, ranks and SimBrief airframes. It can be imported into another airline.
  • content.json: pages and menu links, news, NOTAMs, documents (their links and details), email templates, application questions, award definitions, tours and challenges.
  • rules.json: your settings (without Discord webhooks or keys), the features you switched on, scoring rules and profiles, points rules and staff roles.
  • finances.csv: the finance ledger, when finances are on.
  • pilots.csv: pilot ID, name, status, whether they are staff, hub, join date, hours, points and flights.
  • pireps.csv: every PIREP with pilot, flight, airports, aircraft, date, status, time, distance, fuel, landing rate, points, source and network.
  • bookings.csv: bookings with pilot, flight, aircraft, status and when they were made.
  • events.csv: your events.
  • awards.csv: awards given to pilots.
  • application-answers.csv: answers to your join-form questions.
  • staff-notes.csv: the private notes staff wrote on pilots' records, with who wrote them and when.
  • sound-pack.csv: the cabin sound pack's versions, with their links, checks and which one is published.
  • activity-log.csv: the staff activity log.
  • README.txt: a short description of the files.

The CSV files open in any spreadsheet program. Pilots' email addresses are never included: they belong to the pilots. Also left out: flight tracks, Discord webhooks and API keys, charter routes, and files uploaded before links-only. Only setup.json can be imported into an airline again.

Every export is recorded in the activity log.

Export the setup as JSON

Staff with the Import and export airline data permission can download just the setup.

  1. Open Staff → Airline settings → Import & export.
  2. In the Export as JSON card, press Download followed by your airline's file name, for example my-airline.json.

The file holds hubs, the airports you use, the fleet (with liveries and SimBrief airframes), routes (with aircraft types, tags and dates) and ranks. Pilots and their data aren't included, and neither are charter flights.

Use it in another airline

On the other airline's Staff → Airline settings → Import & export page, use From a Vaeroly JSON export. Choose the file and press Preview, check what was found, then press Import this into that airline.

You can also choose the owner's export ZIP: the setup.json inside it is read. Existing aircraft, routes and ranks are updated, not duplicated. Nothing is deleted. Files can be up to 3 MB.

This is also a handy backup before big changes to your routes or fleet.

Download PIREPs (staff)

Staff who can review, correct or decide PIREPs, or view pilots, can download the airline's PIREPs from Staff › All PIREPs: press CSV or Excel above the list. The download has the flights the list shows with your search and filters (pilot, flight, airport, status, dates), oldest first, with the pilot's ID and name in front of the logbook's columns. Staff limited to some hubs get those hubs' pilots. One download holds at most the newest 50,000 PIREPs; narrow the dates for older ones, or use the owner's Export your setup and records. Each download is kept in the activity log.

Download the activity log

Staff with the Activity log permission can download it on its own.

  1. Open Staff → Reports → Activity log.
  2. Filter by person, kind of action or dates if you like.
  3. Press Download CSV.

The file lists the time (UTC), who did it, their email, the action and the details, for the filters you chose.

Entries are kept for two years, then deleted automatically. To keep a longer record, download the log now and then.

Excel files

Everything that downloads as CSV also comes as Excel (.xlsx): Download Excel next to Download CSV on the activity log, Excel next to the logbook's CSV and PDF on PIREPs & logbook, and one Excel file with a sheet per table inside the owner's export. The CSV import on Staff → Airline settings → Import & export and the logbook import on the Ranks page also take an Excel file: its first sheet is read, with the same columns as the CSV.

Your own data as a pilot

Every pilot can download their own data in the Your data card on their Profile page. That's separate from the airline export. It includes the staff notes on their record, without who wrote them.

Staff with the permission to see pilot records can also download the Staff → Pilots list as a CSV file. See Managing pilot records.

Was this helpful?