Export Air Rules

The Export function exports all or select rules to a csv file.

  1. Click the Export Rules button .

  2. You can export all rules or choose a specific rule type to export.

  3. 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

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

Bytes

Information

Details

Bytes 1-2

Version

Version of the structure

Byte 3

Frequency

Daily=D or Weekly=W

Bytes 4-6

Interval

Every Nth Day of the week). By default, this value is 1 which means every day of the week. If the value is 2, it would be every 2nd day of the week based on the choice of Weekly(W) in byte 3.

Bytes 7-13

Days of Week

This goes with Week selection in byte 3. One byte for every day of the week (Sunday to Saturday). Y on first byte means apply the rule on Sunday, Y on second byte means apply on Monday and so on.

Byte 14

Start of Week

0=Monday; 1=Tuesday; 2=Wednesday; 3=Thursday; 4=Friday; 5=Saturday; 6=Sunday

Byte 15-16 (optional)

Count (optional)

Number of Start and End Time items

Byte 17-20 (optional)

Start Time 1 (optional)

HHMM

Byte 21-24 (optional)

End Time 1 (optional)

HHMM

Byte 25-28 (optional)

Start Time 2 (optional)

HHMM

Byte 29-32 (optional)

End Time 2 (optional)

HHMM

Byte 33-36 (optional)

Start Time 3 (optional)

HHMM

Byte 37-40 (optional)

End Time 3 (optional)

HHMM

Byte 41-44 (optional)

Start Time 4 (optional)

HHMM

Byte 45-48 (optional)

End Time 4 (optional)

HHMM

Byte 49-52 (optional)

Start Time 5 (optional)

HHMM

Byte 53-46 (optional)

End Time 5 (optional)

HHMM

Column S

RollingTravelDate

Column T

TravelDateScheduler

Bytes

Information

Details

Byte 1

Rolling Start Date

Always D (Day)

Bytes 2-4

Number of days

Three numbers

Byte 5

Rolling End Date

Always D (Day)

Bytes 6-8

Number of days

Three numbers

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:

  • A = Excludeonly fares without account codes

  • B = Excludeall fares with or without account codes

  • C = Excludefares without account codes, and also Excludethe specified account code(s)

  • D = Excludeall fares with or without account codes, except the specified account code(s)

  • E = Excludeonly fares with the specified account code(s)

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:

  • A = Exclude only fares without account codes

  • B = Exclude all fares with or without account codes

  • C = Exclude fares without account codes, and also exclude the specified account code(s)

  • D = Exclude all fares with or without account codes, except the specified account code(s)

  • E = Exclude only fares with the specified account code(s)

  • F = Exclude fares from the specified supplier code(s)

  • G = Exclude all fares, except those from the specified supplier code(s)

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:

  • A = Exclude only fares without account codes

  • B = Exclude all fares with or without account codes

  • C = Exclude fares without account codes, and also exclude the specified account code(s)

  • D = Exclude all fares with or without account codes, except the specified account code(s)

  • E = Exclude only fares with the specified account code(s)

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:

  • A = Exclude only fares without account codes

  • B = Exclude all fares with or without account codes

  • C = Exclude fares without account codes, and also exclude the specified account code(s)

  • D = Exclude all fares with or without account codes, except the specified account code(s)

  • E = Exclude only fares with the specified account code(s)

  • F = Exclude fares from the specified supplier code(s)

  • G = Exclude all fares, except those from the specified supplier code(s)

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

  • Y = Both Net and Selling

  • N = Net Only

  • S = Selling Only

Column AE

Airline Private Account Code application: 

  • A = Exclude only fares without account codes

  • B = Exclude all fares with or without account codes

  • C = Exclude fares without account codes and also Exclude the specified account code(s)

  • D = Exclude all fares with or without account codes except the specified account code(s)

  • E = Exclude only fares with the specified account code(s)

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: 

  • A = Exclude only fares without account codes

  • B = Exclude all fares with or without account codes

  • C = Exclude fares without account codes and also Exclude the specified account code(s)

  • D = Exclude all fares with or without account codes except the specified account code(s)

  • E = Exclude only fares with the specified account code(s)

  • F = Exclude fares from the specified supplier code(s)

  • G = Exclude all fares except those from the specified supplier code(s)

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:

  • A = Exclude only fares without account codes

  • B = Exclude all fares with or without account codes

  • C = Exclude fares without account codes, and also Exclude the specified account code(s)

  • D = Exclude all fares with or without account codes, except the specified account code(s)

  • E = Exclude only fares with the specified account code(s)

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:

  • A = Exclude only fares without account codes

  • B = Exclude all fares with or without account codes

  • C = Exclude fares without account codes, and also Exclude the specified account code(s)

  • D = Exclude all fares with or without account codes, except the specified account code(s)

  • E = Exclude only fares with the specified account code(s)

  • F = Exclude fares from the specified supplier code(s)

  • G = Exclude all fares, except those from the specified supplier code(s)

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:

  • A = Exclude only fares without account codes

  • B = Exclude all fares with or without account codes

  • C = Exclude fares without account codes, and also exclude the specified account code(s)

  • D = Exclude all fares with or without account codes, except the specified account code(s)

  • E = Exclude only fares with the specified account code(s)

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:

  • A = Exclude only fares without account codes

  • B = Exclude all fares with or without account codes

  • C = Exclude fares without account codes, and also exclude the specified account code(s)

  • D = Exclude all fares with or without account codes, except the specified account code(s)

  • E = Exclude only fares with the specified account code(s)

  • F = Exclude fares from the specified supplier code(s)

  • G = Exclude all fares, except those from the specified supplier code(s)

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:

  • A = Exclude only fares without account codes

  • B = Exclude all fares with or without account codes

  • C = Exclude fares without account codes, and also exclude the specified account code(s)

  • D = Exclude all fares with or without account codes, except the specified account code(s)

  • E = Exclude only fares with the specified account code(s)

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:

  • A = Exclude only fares without account codes

  • B = Exclude all fares with or without account codes

  • C = Exclude fares without account codes, and also Exclude the specified account code(s)

  • D = Exclude all fares with or without account codes, except the specified account code(s)

  • E = Exclude only fares with the specified account code(s)

  • F = Exclude fares from the specified supplier code(s)

  • G = Exclude all fares, except those from the specified supplier code(s)

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:

  • A = Exclude only fares without account codes

  • B = Exclude all fares with or without account codes

  • C = Exclude fares without account codes, and also Exclude the specified account code(s)

  • D = Exclude all fares with or without account codes, except the specified account code(s)

  • E = Exclude only fares with the specified account code(s)

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:

  • A = Exclude only fares without account codes

  • B = Exclude all fares with or without account codes

  • C = Exclude fares without account codes, and also Exclude the specified account code(s)

  • D = Exclude all fares with or without account codes, except the specified account code(s)

  • E = Exclude only fares with the specified account code(s)

  • F = Exclude fares from the specified supplier code(s)

  • G = Exclude all fares, except those from the specified supplier code(s)

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.