Export Air Rules
The Export function exports all or select rules to a csv file.
-
Click the Export Rules button .
-
You can export all rules or choose a specific rule type to export.
-
Click Export.
File Format
The columns from A to T are common for all rules, except Rule Authorization.
Column A |
Rule name |
|||||||||||||||||||||||||||||||||||||||||||||||||||
Column B |
SID / PCC / Group ID Examples
1111-1G 2222-1G,3333-1V,4444-1G GROUPNAME-## 5555-1P,GROUPNAME-## |
|||||||||||||||||||||||||||||||||||||||||||||||||||
Column C |
ChannelID |
|||||||||||||||||||||||||||||||||||||||||||||||||||
Column D |
GeographyFromValue |
|||||||||||||||||||||||||||||||||||||||||||||||||||
Column E |
GeographyFromType |
|||||||||||||||||||||||||||||||||||||||||||||||||||
Column F |
GeographyToType |
|||||||||||||||||||||||||||||||||||||||||||||||||||
Column G |
GeographyToValue |
|||||||||||||||||||||||||||||||||||||||||||||||||||
Column H |
Both Ways Y/N |
|||||||||||||||||||||||||||||||||||||||||||||||||||
Column I |
RuleEffectiveDate |
|||||||||||||||||||||||||||||||||||||||||||||||||||
Column J |
RuleDiscontinueDate |
|||||||||||||||||||||||||||||||||||||||||||||||||||
Column K |
TravelEffectiveDate |
|||||||||||||||||||||||||||||||||||||||||||||||||||
Column L |
TravelDiscontinueDate |
|||||||||||||||||||||||||||||||||||||||||||||||||||
Column M |
UserName |
|||||||||||||||||||||||||||||||||||||||||||||||||||
Column N |
LastUpdateDate |
|||||||||||||||||||||||||||||||||||||||||||||||||||
Column O |
Notes |
|||||||||||||||||||||||||||||||||||||||||||||||||||
Column P |
RuleID |
|||||||||||||||||||||||||||||||||||||||||||||||||||
Column Q |
GeographyException |
|||||||||||||||||||||||||||||||||||||||||||||||||||
Column R |
RuleScheduler Detailed description
|
|||||||||||||||||||||||||||||||||||||||||||||||||||
Column S |
RollingTravelDate |
|||||||||||||||||||||||||||||||||||||||||||||||||||
Column T |
TravelDateScheduler Detailed description
|
Columns U onward differ depending on the rule type. Expand the rule type below to view the columns specific to that rule.
Column A (Rule name) |
Availability - Demote |
Columns B to T |
... |
Column U |
AirlineCode |
Column V |
Flight Type |
Column W |
Marketing / Operating Airline Options (Y/N) |
Column X |
Demote the above Marketing Operating Airline (O=Only / E=Except) |
Column Y |
When Marketed / Operated by |
Column Z |
Flight Category |
Column AA |
Flight Number or Range |
Column AB |
Weight |
Column A (Rule name) |
Availability - Promote |
Columns B to T |
... |
Column U |
GeographyException - For this specific rule, for each geography exception it will limit the number of promoted flights. It will be exported in the last character of each geography exception. Example 1 - default / market is excluded, will be 0: City$ATL$Airport$DFW$0 Example 2 - limiting 4 promoted flights: City$ATL$Airport$DFW$4 |
Column V |
AirlineCode |
Column W |
Flight Type |
Column X |
Marketing / Operating Airline Options (Y/N) |
Column Y |
Promote the above Marketing Operating Airline (O=Only / E=Except) |
Column Z |
When Marketed / Operated by |
Column AA |
Flight Category |
Column AB |
Flight Number or Range |
Column AC |
Weight |
Column AD |
Rank |
Column AE |
Max Flights |
Column A (Rule name) |
Exclude Undesirable Connection Points |
Columns B to T |
... |
Column U |
Connection Points |
This rule has 7 different conditions (what to Exclude):
- Fare Basis Code(s)
- Fare Basis code(s) & Booking code(s)
- Booking Code(s)
- Cabin
- Tariff and/or Rule
- Fares - Public/Private
- Industry Fare Types
Expand the section below for details of each condition.
Column A (Rule name) |
Exclude Fare or Fare Family |
Columns B to T |
... |
Column U |
What to Exclude: Fare Basis code(s) |
Column V |
AirlineCode |
Column W |
Flight Number |
Column X |
Fare Basis codes |
Column Y |
Tariff |
Column Z |
Rule |
Column AA |
All Fares (Y/N) |
Column AB |
Public (Y/N) |
Column AC |
Airline Private (Y/N) |
Column AD |
Airline Private Box (Y=Both Net and Selling / N=Net Only / S=Selling Only) |
Column AE |
Airline Private Account Code Application:
|
Column AF |
Airline Private Account Code(s) |
Column AG |
Airline Private (Y/N) |
Column AH |
Airline Private Box (Y=Both Net and Selling / N=Net Only / S=Selling Only) |
Column AI |
Airline Private Account / Supplier Code Application:
|
Column AJ |
Airline Private Account/Supplier Code(s) |
Column AK |
Fare Search/Shop (Y/N) |
Column AL |
Fare Quote/Pricing (Y/N) |
Column AM |
Fare Display (Y/N) |
Column A (Rule name) |
Exclude Fare or Fare Family |
Columns B to T |
... |
Column U |
What to Exclude: Fare Basis code(s) & Booking Code(s) |
Column V |
AirlineCode |
Column W |
Flight Number |
Column X |
Fare Basis and Booking codes |
Column Y |
Tariff |
Column Z |
Rule |
Column AA |
All Fares (Y/N) |
Column AB |
Public (Y/N) |
Column AC |
Airline Private (Y/N) |
Column AD |
Airline Private Box (Y=Both Net and Selling / N=Net Only / S=Selling Only) |
Column AE |
Airline Private Account Code Application:
|
Column AF |
Airline Private Account Code(s) |
Column AG |
Airline Private (Y/N) |
Column AH |
Airline Private Box (Y=Both Net and Selling / N=Net Only / S=Selling Only) |
Column AI |
Airline Private Account / Supplier Code Application:
|
Column AJ |
Airline Private Account/Supplier Code(s) |
Column AK |
Fare Search/Shop (Y/N) |
Column AL |
Fare Quote/Pricing (Y/N) |
Column AM |
Fare Display (Y/N) |
Column A (Rule name) |
Exclude Fare or Fare Family |
Columns B to T |
... |
Column U |
What to Exclude: Booking Code(s) |
Column V |
AirlineCode |
Column W |
Flight Number |
Column X |
Booking codes |
Column Y |
Tariff |
Column Z |
Rule |
Column AA |
All Fares (Y/N) |
Column AB |
Public (Y/N) |
Column AC |
Airline Private (Y/N) |
Column AD |
Airline Private Box
|
Column AE |
Airline Private Account Code application:
|
Column AF |
Airline Private Account Code(s) |
Column AG |
Airline Private (Y/N) |
Column AH |
Airline Private Box
|
Column AI |
Airline Private Account / Supplier Code application:
|
Column AJ |
Airline Private Account/Supplier Code(s) |
Column AK |
Fare Search/Shop (Y/N) |
Column AL |
Fare Quote/Pricing (Y/N) |
Column AM |
Fare Display (Y/N) |
Column AN |
Sell (Y/N) |
Column AO |
Exclude Availability (Y/N) |
Column AP |
Availability (Y=Exclude / N=Zero) |
Column A (Rule name) |
Exclude Fare or Fare Family |
Columns B to T |
... |
Column U |
What to exclude: Cabin |
Column V |
AirlineCode |
Column W |
Flight Number |
Column X |
Cabin Type |
Column Y |
All Fares (Y/N) |
Column Z |
Public (Y/N) |
Column AA |
Airline Private (Y/N) |
Column AB |
Airline Private Box (Y=Both Net and Selling / N=Net Only / S=Selling Only) |
Column AC |
Airline Private Account Code Application:
|
Column AD |
Airline Private Account Code(s) |
Column AE |
Agency Private (Y/N) |
Column AF |
Agency Private Box (Y=Both Net and Selling / N=Net Only / S=Selling Only) |
Column AG |
Agency Private Account / Supplier Code Application:
|
Column AH |
Airline Private Account/Supplier Code(s) |
Column AI |
Fare Search/Shop (Y/N) |
Column AJ |
Fare Quote/Pricing (Y/N) |
Column AK |
Fare Display (Y/N) |
Column AL |
Sell (Y/N) |
Column AM |
Exclude Availability (Y/N) |
Column AN |
Availability (Y=Exclude / N=Zero) |
Column A (Rule name) |
Exclude Fare or Fare Family |
Columns B to T |
... |
Column U |
What to Exclude: Tariff and/or Rule |
Column V |
AirlineCode |
Column W |
Flight Number (not used for this type of rule) |
Column X |
Tariff |
Column Y |
Rule |
Column Z |
All Fares (Y/N) |
Column AA |
Public (Y/N) |
Column AB |
Airline Private (Y/N) |
Column AC |
Airline Private Box (Y=Both Net and Selling / N=Net Only / S=Selling Only) |
Column AD |
Airline Private Account Code Application:
|
Column AE |
Airline Private Account Code(s) |
Column AF |
Agency Private (Y/N) |
Column AG |
Agency Private Box (Y=Both Net and Selling / N=Net Only / S=Selling Only) |
Column AH |
Agency Private Account / Supplier Code Application:
|
Column AI |
Airline Private Account/Supplier Code(s) |
Column AJ |
Fare Search/Shop (Y/N) |
Column AK |
Fare Quote/Pricing (Y/N) |
Column AL |
Fare Display (Y/N) |
Column A (Rule name) |
Exclude Fare or Fare Family |
Columns B to T |
... |
Column U |
What to Exclude: Fares - Public/Private |
Column V |
AirlineCode |
Column W |
Flight Number (not used for this type of rule) |
Column X |
All Fares (Y/N) |
Column Y |
Public (Y/N) |
Column Z |
Airline Private (Y/N) |
Column AA |
Airline Private Box (Y=Both Net and Selling / N=Net Only / S=Selling Only) |
Column AB |
Airline Private Account Code Application:
|
Column AC |
Airline Private Account Code(s) |
Column AD |
Agency Private (Y/N) |
Column AE |
Agency Private Box (Y=Both Net and Selling / N=Net Only / S=Selling Only) |
Column AF |
Agency Private Account / Supplier Code Application:
|
Column AG |
Airline Private Account/Supplier Code(s) |
Column AH |
Fare Search/Shop (Y/N) |
Column AI |
Fare Quote/Pricing (Y/N) |
Column AJ |
Fare Display (Y/N) |
Column A (Rule name) |
Exclude Fare or Fare Family |
Columns B to T |
... |
Column U |
What to Exclude: Industry Fare Type |
Column V |
AirlineCode |
Column W |
Flight Number (not used for this type of rule) |
Column X |
Industry Fare Types |
Column Y |
All Fares (Y/N) |
Column Z |
Public (Y/N) |
Column AA |
Airline Private (Y/N) |
Column AB |
Airline Private Box (Y=Both Net and Selling / N=Net Only / S=Selling Only) |
Column AC |
Airline Private Account Code Application:
|
Column AD |
Airline Private Account Code(s) |
Column AE |
Agency Private (Y/N) |
Column AF |
Agency Private Box (Y=Both Net and Selling / N=Net Only / S=Selling Only) |
Column AG |
Agency Private Account / Supplier Code Application:
|
Column AH |
Airline Private Account/Supplier Code(s) |
Column AI |
Fare Search/Shop (Y/N) |
Column AJ |
Fare Quote/Pricing (Y/N) |
Column AK |
Fare Display (Y/N) |
Column A (Rule name) |
Maximum Number of Connections |
Columns B to T |
... |
Column U |
Connection Count |
Column V |
AirlineCode |
Column A (Rule name) |
Maximum Number of Results |
Columns B to T |
... |
Column U |
Solution Count |
Column A (Rule name) |
Display only online solutions |
Columns B to T |
... |
Column U |
Bias Value |
Column A (Rule name) |
Permit Multi-Airport Connections |
Columns B to T |
... |
Column U |
Connections |
Column V |
Airline(s) |
Column A (Rule name) |
Direct Flights only |
Columns B to T |
... |
Column U |
Bias Value |
Column A (Rule name) |
Exclude Airport or City Locations |
Columns B to T |
... |
Column U |
Locations |
Column V |
Airline(s) |
Column A (Rule name) |
Exclude airlines |
Columns B to T |
... |
Column U |
AirlineCode |
Column V |
Fare Search/Shop (Y/N) |
Column W |
Fare Quote/Pricing (Y/N) |
Column X |
Fare Display (Y/N) |
Column Y |
Sell (Y/N) |
Column Z |
Availability (Y/N) |
Column A (Rule name) |
Exclude marketing/codeshare airlines |
Columns B to T |
... |
Column U |
Marketing Airline |
Column V |
Operating Airline |
Column W |
Fare Search/Shop (Y/N) |
Column X |
Sell (Y/N) |
Column Y |
Availability (Y/N) |
Column A (Rule name) |
Exclude connections between airlines |
Columns B to T |
... |
Column U |
Airline/Operating Airline Combinations |
Column V |
Exclude Cities/Airport Connections One |
Column W |
Code One |
Column X |
Exclude Cities/Airport Connections Two |
Column Y |
Code Two |
Column Z |
Exclude Cities/Airport Connections Three |
Column AA |
Code Three |
Column A (Rule name) |
Exclude marketing airlines for time window |
Columns B to R |
... |
Column S |
AirlineCode |
Column T |
Connections |
Column U |
Unit Time |
Column V |
Time Value |
Column A (Rule name) |
Maximum Connection Times |
Columns B to T |
... |
Column U |
Max Time |
Column V |
AirlineCode (Required) |
Column A (Rule name) |
Bias/exclude multi-airport connections |
Columns B to T |
... |
Column U |
Bias Value |
Column V |
AirlineCode |
Column A (Rule name) |
Maximum Overnight Connection Times |
Columns B to T |
... |
Column U |
Max Time |
Column V |
Airline(s) |
Column A (Rule name) |
Exclude flight / flight ranges |
Columns B to T |
... |
Column U |
AirlineCode |
Column V |
Flights |
Column W |
Fare Search/Shop (Y/N) |
Column X |
Sell (Y/N) |
Column Y |
Availability (Y/N) |
Column A (Rule name) |
Exclude Undesirable Connection Points |
Columns B to T |
... |
Column U |
Connections |
Column V |
AirlineCode |
Column A (Rule name) |
Validating Airline Override |
Columns B to T |
... |
Column U |
AirlineCode |
Column V |
Override Application |
Column W |
Marketing Airline Code |
Column A (Rule name) |
Rule Authorization |
Columns B to T |
... |
Column U |
Exclude Fare or Fare Family (Y = Rule is always applied / N = Specific inputs supersede rule) |
Column V |
Exclude Marketing/Codeshare Airlines (Y = Rule is always applied / N = Specific inputs supersede rule) |
Column W |
Maximum Connection Times (Y = Rule is always applied / N = Specific inputs supersede rule) |
Column X |
Maximum Overnight Connection Times (Y = Rule is always applied / N = Specific inputs supersede rule) |
Column Y |
Exclude Undesirable Connection Points (Y = Rule is always applied / N = Specific inputs supersede rule) |
Column A (Rule name) |
Public/Private/Net Split |
Columns B to T |
... |
Column U |
Private Fares Only (Y/N) |
Column V |
Public Fares Only (Y/N) |
Column W |
Net Fares Only (Y/N) |
Column X |
Combo Private/Net Fares Only (Y/N) |
Column Y |
Return Lowest Option per Itinerary Only (Y/N) |
Column Z |
Return Expanded Number of Solutions (Y/N) |
Column A (Rule name) |
Exclude/Only Include Branded Fares |
Columns B to T |
... |
Column U |
Rule Application |
Column V |
Include or Exclude |
Column W |
Airlines |
Column A (Rule name) |
Specified Airline |
Columns B to T |
... |
Column U |
AirlineCode |
Column A (Rule name) |
Unbundled Fare Split |
Columns B to T |
... |
Column U |
Unbundled Fare Split (Y/N) |
Column V |
Unbundled Fares Only (Y/N) |
Column W |
Bundled Fares Only (Y/N) |
Column X |
Expanded Number of Solutions (Y/N) |
Column A (Rule name) |
Commercially Important Airline |
Columns B to T |
... |
Column U |
Airline Code |
Column V |
Number of Solutions (1-9) |
Column W |
Backfill with Airline After Standard Diversity Procedures Indicator (Y or N) |
Column A (Rule name) |
Minimum Connection Time |
Columns B to T |
... |
Column U |
Airline Code |
Column V |
Minimum Connection Times and Airports |
Column A (Rule name) |
Maximum Journey Time |
Columns B to T |
... |
Column U |
Airline Code |
Column V |
Journey Time |
You can download an Excel template file that has all fields mapped.
Note: In Google Chrome you may have to click Keep to fully download the spreadsheet.