Badge Import/Export

The Badge importer and exporter let you bulk manage pilot achievement badges. Badges can be awarded automatically based on rules or manually by staff.

Accessing Import/Export

In Orwell, go to Data → Exports to download your badges 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	Badge name. Must be unique within your airline.
Category	Yes	Category for grouping badges
Description	No	Badge description shown to pilots
Order	No	Display order (lower numbers appear first)
Rules (JSON)	No	Auto-award rules in JSON format. Leave empty for manual-only badges.
Page Content (JSON)	No	Custom page content in JSON format
_delete	Yes	Set to TRUE to delete, FALSE otherwise

JSON Format

The Rules (JSON) and Page Content (JSON) columns expect valid JSON strings. When exporting, these are output as JSON. When importing, ensure the JSON is properly formatted and escaped for CSV.

Creating Badges

1. Leave the ID column empty

2. Fill in required columns: Name, Category

3. Add Rules (JSON) for automatic awarding, or leave empty for manual

4. Set _delete to FALSE

Updating Badges

1. Export existing badges

2. Modify the columns you need to change

3. Keep the ID column intact

4. Ensure _delete is FALSE

Deleting Badges

1. Export the badges you want to delete

2. Set _delete to TRUE for those rows

3. Import the file