Release Notes

Release 14.0

January 2023

This release adds two new database tables: DuePaidTextSeg and ItineraryRemark.
DuePaidTextSeg table captures TUR segment information. ItineraryRemark table captures RIA/RIU remarks.
SQL database update is REQUIRED for new TBF Adapter v14.0. If this is not complete, then the adapter WILL NOT operate. This script can be run manually by using sql script found inside the installation directory at \sql_scripts\SQL Server\TBF_DB_Update_Script.sql.

Release 13.0

SQL Server Authentication capability

March 18, 2022

Updated Travelport Booking Feed Adapter to allow the user to enter an optional database User Login ID and Password for connecting to the database. User Login ID and Password fields have been added in the Configuration window.

Release 12.0

Logo update

March 3, 2021

Travelport logo updated.

Release 11.1

JDK upgrade

August 3, 2020

Upgrade Travelport Booking Feed Adapter from JDK 1.8 to JDK 1.8.0_251 for Federal Information Processing Standard 140-2 compliance.

Release 11.0

JDK upgrade

October 1, 2019

Upgrade Travelport Booking Feed Adapter from JDK 1.7 to JDK 1.8.0_211.

Release 10.1

Updates to Travelport Booking Feed Installation

November 17, 2018

To receive the new data, you must install version v10.1 of the Travelport Booking Feed installation package. The new TBF.xsd file is part of the Product Installation for Adapter version v10.1. XML users will need to replace their old GID.xsd with the new GIDS.xsd file.

The new version of the adapter, as well XML Schema version 15.0, are available on the following link;

https://eportal.travelport.com/sites/GSWS/APS/softlib/Pages/Travelport%20BF_DocsSoftware.aspx

A new SQL script called ‘TBF_script_v10.1.sql’ is required to update the SQL tables. If this is not run, then the adapter WILL NOT operate. This script is found during installation of the new TBF Adapter 10.1.
Customers that use TBF XML schema for validation also need to update to version 15.0 of the schema. Customers validating TBF/GIDS XML using TBF/GIDS XML schema need to upgrade to the new TBF/GIDS XML schema version 15.0.

To check to see what version of the adapter is currently installed, and for installation instructions, click on this link.

Documentation Updates

Travelport Booking Feed will now be able to capture data pre-ticketing on a fare event for baggage, endorsements and tour codes.

Customer benefits

Travelport Galileo and Travelport Apollo users will now be able to capture baggage, endorsements and tour codes on any fare event pre- and post-ticketing.
Provides the source data with which customized, and ad-hoc reports can easily be created in any report writer tool, to assist in making crucial travel management related decisions / pre- and post-booking data is available

Detail

To support Tour Code, IT/BT Indicator, Endorsement Text, and Baggage Allowance during Fare Quote events in Travelport Booking Feed (TBF), the following data will be added when triggered by a related Fare Quote event:

New data fields (TourCode and ITBTIndicator) were added to the existing AirFareQuo table for fare quote events. These fields correspond to Structured Data updates from KLRs DPAP_03 to DPAP_04 and DPMP_03 to DPMP_04.
A new data field EndorsementText was added to the existing FareCmpnt table for fare quote events. The table corresponds to a new DPES_01 KLR in Structured Data.
A new data field BaggageAllowance was added to the existing FareCmpntRte table for fare quote events. This field corresponds to Structured Data updates from KLR DPSG_02 to DPSG_03.

Release 9.5

Updates to Travelport Booking Feed Installation

December 09, 2017

Customers validating TBF/GIDS XML using TBF/GIDS XML schema need to upgrade to the new TBF/GIDS XML schema version 15.0.

To receive the new data, you must install version v9.5 of the Travelport Booking Feed installation package. The new TBF.xsd file is part of the Product Installation for Adapter version v9.5.

The new version of the adapter, as well XML Schema version 15.0, are available on the following link;

https://eportal.travelport.com/sites/GSWS/APS/softlib/Pages/Travelport%20BF_DocsSoftware.aspx

XML users will need to replace their old GID.xsd with the new GIDS.xsd file.

A new SQL script called ‘TBF_script_v9.5.sql’ will also be required to update the SQL tables. If this is not run, then the adapter WILL NOT operate. This script is found during installation of the new TBF Adapter 9.5.
Customers that use TBF XML schema for validation also need to update to version 15.0 of the schema.

To check to see what version of the adapter is currently installed, and for installation instructions, click on this link.

Documentation Updates

This release adds the following new fields to TBF.

Updates were made to the Data Definitions to support the new database fields and tables.

New TBF data fields in:
- ‘AirFareQuo’ table - Base Fare Amount; Total Tax Amount; Equivalent Fare Amount; Equivalent Fare Currency Code; Bank Settlement Rate
- ‘PTCInfo’ table - Passenger Base Fare Amount; Passenger Equivalent Fare Amount; Passenger Total Tax Amount
To receive new data fields in Travelport Booking Feed, you must first download the new Adapter version 9.5.

Release 9.4

April 03, 2017

Updates to Travelport Booking Feed Installation

To check to see what version of the adapter is currently installed:
1. Current (up to date) Travelport Booking Feed customers should see Travelport Booking Feed (TBF) icons on their desktop and TBF version 9.3 (version 9.3 is currently the latest prior to this enhancement) in the Control Panel\add-remove programs.
2. If a Travelport Booking Feed customer has installed the adapter as a Windows application a ‘Travelport Booking Feed’ icon, will appear on your desktop for the current version (as illustrated below).

No new TBF.xsd file will be required to receive the new data fields in the existing ‘HTLSEG’ and ‘AIRFAREQUO’ table that are introduced in this release.
New Adapter version 9.4, as well the current XML Schema version 14.0, will be available on the following link;
https://eportal.travelport.com/sites/GSWS/Pages/LoginPage.aspx?Source=http://eportal.travelport.com/sites/GSWS/ACSC/Pages/default.aspx
Customers that use TBF XML schema for validation will use the current TBF.xsd Version (Version 14) of the schema file. (below)
A new SQL script called ‘TBF_script_v9.4.sql script’ will also be required to update the SQL tables. If this is not run, then the adapter WILL NOT operate. This script is found during the installation of the new TBF Adapter 9.4.

To upgrade from 5.0, below script need to be run:
TBF_DB_Update_Script.sql

NOTE: TBF Adapter version 5 and above will be improved to allow upgrade of database using only oneTBF_DB_Update_Script.sql’script.

Installation Changes:
1. ‘SQL database Setup’ screen changes.
2. Removal of all previous version installation choices.
3. New screen will only offer the following two choices:
4. Upgrade TBF (GIDS) database
5. New installation with OK and Skip buttons

Documentation Updates

When a response from a Hotel Vendor contains Commission Indicator (CM) and/or Commission Percent (CP), Travelport will add new 'Hotel Commission Indicator' and 'Hotel Commission Percent' data fields into the existing 'HTLSEG' table in Booking Feed.

New ‘Base Fare Currency Code’ and ‘Base Fare Decimal Number’ fields will be added to the existing 'AIRFAREQUO' table. TBF will populate the new fields with the details of the base fare currency.

Updates were made to the Data Definitions to support the new database fields and tables.

New TBF data fields in:
- ‘HTLSEG’ table
- ‘AIRFAREQUO’ table (per PR1235769).
To receive new data fields in Travelport Booking Feed a customer must first download the new Adapter version 9.4.
TBF Adapter version 5 and above will be improved to allow upgrade of database using only one ‘TBF_DB_Update_Script.sql’ script.
Revisions to the Data Definitions Online Support Portal https://support.travelport.com/webhelp/tbf/TBF.htm
Customers validating TBF/GIDS XML, using TBF/GIDS XML schema, will not need to upgrade to the new TBF/GIDS XML schema version. No new TBF.xsd version will be required.
Installation Changes to ‘SQL Database Setup’ screens. Also, removed all previous installation choices

Release 9.3

September 01, 2016

Updates to Travelport Booking Feed Installation

1. To check to see what version of the adapter is currently installed:

Current (up to date) Travelport Booking Feed customers should see Travelport Booking Feed (TBF) icons on their desktop and TBF version 9.0(version 9.0 is currently the latest prior to this enhancement) in the Control Panel\add-remove programs.

If a Travelport Booking Feed customer has installed the adapter as a Windows application, a ‘Travelport Booking Feed’ icon will appear on your desktop for the current version.

2. To receive the new Hotel Segment table fields (RateChanges and TotalRateAmount), the renamed RateAmount field to RateGuaranteed, and the TBF Online Help icon, Travelport Booking Feed customers must install version 9.3 of the Travelport Booking Feed installation package. The new TBF.xsd file is part of the Product installation for Adapter version 9.3.

In addition, a bug is fixed to update the VendorRemarks table when non-programmatic SSR Information is available for a specific SSR Code.

The new version of the adapter, as well as XML Schema version 14.0, will be available on the following link; https://support.travelport.com/SGC/APS/softlib/Travelport+BF_DocsSoftware.htm

As part of the 9.3 Adapter release, TBF will now record time parameters in the logs for each transaction to measure performance statistics. Ex - Total time taken for each transaction. The adapter (when running) will have an additional text string.

3. A new SQL script called ‘TBF_script_v9.1-v9.3.sql’ will also be required to update the SQL tables. If this is not run, then the adapter WILL NOT operate. This script is found during installation of the new TBF Adapter 9.3.

To upgrade from 7.0, below scripts need to be run:

- TBF_script_v8.0.sql

- TBF_script_v9.0.sql

- TBF_script_v9.1-v9.3.sql

To upgrade from 8.0, below scripts need to be run:

- TBF_script_v9.0.sql

- TBF_script_v9.1-v9.3.sql

To upgrade from 9.0, below script needs to be run:

- TBF_script_v9.1-v9.3.sql

Time Parameters

As part of the 9.3 Adapter release, TBF will now record time parameters in the logs for each transaction to measure performance statistics. Ex - Total time taken for each transaction.

The adapter (when running) will have an additional text string (as shown below).

New Data Content

To receive new RateChanges and TotalRateAmount fields, the renamed RateAmount field to RateGuaranteed, and the TBF Online Help icon, you must install version 9.3 of the Travelport Booking Feed installation package.

New Fields

RateChanges and TotalRateAmount - Hotel Segment table

Renamed Field

RateAmount field renamed to RateGuaranteed in the Hotel Segment table.

Bug Fix

Update to the VendorRemarks table when non-programmatic SSR Information is available for a specific SSR Code.

Documentation Updates

Updates were made to the Data Definitions to support the new database fields and tables.

Release 9.0

May 26, 2015

Updates to Travelport Booking Feed Installation

1. To check to see what version of the adapter is currently installed: ODBC

Current (up to date) Travelport Booking Feed customers should see Travelport Booking Feed (TBF) icons on their desktop and TBF version 8.0(version 8.0 is currently the latest prior to this enhancement) in the Control Panel\add-remove programs.
If a Travelport Booking Feed customer has installed the adapter as a Windows application a ‘Travelport Booking Feed’ icon, will appear on your desktop for the current version.

2. To receive the new Change of Gauge and Ticketing Arrangements data, Travelport Booking Feed customers must install version 9.0 of the Travelport Booking Feed installation package. The new TBF.xsd file is part of the Product installation for Adapter version 9.0.

The new version of the adapter, as well XML Schema version 14.0, will available on the following link; https://support.travelport.com/SGC/APS/softlib/Travelport+BF_DocsSoftware.htm

Customers that use TBF XML schema for validation will need to replace their old TBF.xsd or GIDS.xsd with the new TBF.xsd version 14.0 of the schema file.(below)

Note: The XML element TicketingData/FlightCoupon/CouponStatus is now removed in the 14.0 version.

3. A new SQL script called ‘TBF_script_v9.0.sql’ will also be required to update the SQL tables. If this is not run, then the adapter WILL NOT operate. This script is found during installation of the new TBF Adapter 9.0.

To upgrade from 5.0, below scripts need to be run:

- TBF_script_v6.0.sql

- TBF_script_v7.0.sql

- TBF_script_v8.0.sql

- TBF_script_v9.0.sql

To upgrade from 6.0, below scripts need to be run:

- TBF_script_v7.0.sql

- TBF_script_v8.0.sql

- TBF_script_v9.0.sql

To upgrade from 7.0, below scripts need to be run:

- TBF_script_v8.0.sql

- TBF_script_v9.0.sql

To upgrade from 8.0, below scripts need to be run:

- TBF_script_v9.0.sql

New Data Content

To receive new Change of Gauge Indicator field, you must install version 9.0 of the Travelport Booking Feed installation package.

The following fields will be expanded into the latest release:

• Change Of Gauge information

• Ticketing Arrangements information

New Field

Change of Gauge Indicator - Air Reserved Segment table:

New Tables

Change of Gauge
Ticketing Arrangement
TAU Ticketing Arrangement
TAW Ticketing Arrangement
TL Ticketing Arrangement

Documentation Updates

Updates were made to the Data Definitions to support the new database fields and tables.

Release 8.0

January 27, 2015

Updates to Travelport Booking Feed Installation

With the installation of the TBF adapter 8.0 files/location, names are updated to reflect Travelport and TBF.

1. To check to see what version of the adapter is currently installed:

a. Current (up to date) Travelport Booking Feed customers will see Travelport Booking Feed (TBF) icons on their desktop and theTBF version in the Control Panel\add-remove programs.

b. If a Travelport Booking Feed customer has installed the adapter as a Windows application, a ‘Travelport Booking Feed’ icon will appear on their desktop for the current version.

2. To receive new Airline Class of Service, Aircraft Type, Mileage, XML Naming Conversion and changes to files/location name, you must install version 8.0 of the Travelport Booking Feed installation package. The new TBF.xsd file is part of the Product installation for Adapter version 8.0.

The new version of the adapter, as well as XML Schema version 13.0, is available on the followinglink: https://support.travelport.com/SGC/APS/softlib/Travelport +BF_DocsSoftware.htm

With this enhancement the XML file is labelled as TBF.xsd. XML users need to replace their old GID.xsd with the new TBF.xsd file.

3. A new SQL script called ‘TBF_script_v8.0.sql’ is also required to update the SQL tables. If this is not run, then the adapter WILL NOT operate. This script is found during installation of the new TBF Adapter 8.0.

To upgrade from 6.0, the below scripts must be run: - TBF_script_v7.0.sql - TBF_script_v7.1.sql

To upgrade from 7.1, the below scripts must be run: - TBF_script_v8.0.sql

Customers who use GIDS XML schema for validation also need to update to version 13.0 of the schema. (Schema is now labeled as TBF XML.)

The minimum required version for SQL CE is v3.5 SP 2. Below is the link for installing it. http://www.microsoft.com/en-us/download/details.aspx?id=5783

Enhanced Installation/Label Changes:

The installation of 8.0 has enhanced file/location labels. Prior to 8.0, files and locations were labeled as Galileo International and GIDS. These labels are replaced with Travelport and TBF.

**NOTE**: If you have applications dependent on the file path Galileo International or GIDS, you must change the path to reflect the upgraded labels.

For Example:

C:\Program Files (x86)\Galileo International

CHANGED TO

C:\Program Files (x86)\Travelport

C:\Program Files (x86)\Galileo International\GIDS

CHANGED TO

C:\Program Files (x86)\Travelport\TBF

Software Updates

There is improved MQ Exception handling.

XML – Naming Conventions

To receive new XML Naming Conversion and changes to files/location name, you must install version 8.0 of the Travelport Booking Feed installation package. Overall improved TBF XML naming conventions have been made. With the enhancements, the XML files are labeled with Record Locator, PNR/BF Creation Date, and an indicator to show if the file is from a Booking record or a Ticketing record.

Examples of Enhancements:

RecordLocator_PNRCreationDate_Version_BK

AA22BB_23AUG2014_5_BK.xml

RecordLocator_PNRCreationDate_TicketStatus_TKT

AA22BB_20140823_A_TKT.xml

The PNR Creation Date can be in either date format for either Ticketing or Booking record.

New Data Content

To receive new Airline Class of Service, Aircraft Type, and Mileage fields, you must install version 8.0 of the Travelport Booking Feed installation package.

New Fields in Air Reserved Segment:Airline Class of Service, Aircraft Type, and Mileage fields.
New Fields in Air Ticket Segment: Airline Class of Service and Mileage.
New Field in Fare Component Route: Airline Class of Service

Documentation Updates

Updates were made to the Data Definitions to support the new database fields and tables. For general support and production information:

https://developer.travelport.com/app/developer-network/data-feeds

Release 7.1

21 September 2014

Updated Data Content

Modified the following field to an existing table:

PassengerName field to EMDInfo has been increased to 55 var/char.

Software Updates

October 6, 2014 Fix added for MQ PropertyResourceBundle error - TBFAdapter: Can't find resource for bundle java.util.PropertyResourceBundle, key MQJE001b

MQ Time Out: MQ Time Out inside the adapter was modified from an unlimited time to 5,000 seconds (a little less than one hour and 25 minutes). This change was to resolve MQ disconnect issues that customers have been experiencing.

Access to log, XML, and config files: User Access Control (UAC) has been added to correct an issue with Windows 8.1. Before this addition, if UAC was turned ON, messages were not received. Now they are received whether UAC is On or Off.

New Data Content

New Table - Exchange Paid Tax.
New Fields in Form of Payment Exchange table: Full Partial Indicator, Unused Coupons, Commission Amount on Exchanged Document, Cash Fare Paid, Credit Card Fare Paid, Total Tax Amount Paid, Total Exchange Amount, Additional Collection Amount, Change Fee Penalty, and Commission Amount on Penalty.
New Fields in Ticket Transaction table: Airline Commission Amount, Airline Commission Percentage, and Invoice Number.
New options in Hotel Segment Meal Type table: in Hotel Optional Field Number there are new Allowable Values.
New Field in Air Fare Quote table: Record Locator, and new XML Element in Net Fare Indicator field.
New Fields in Travel Order Event table: Owning Agency Name, Transaction Agency Name, and Last Action Agent ID.
New Field in Air Reserved Segment table: Record Locator and Equipment Type.
New Field in Air Ticket Segment table: Record Locator
New Field in Hotel Segment table: Record Locator
New Field in Car Segment table: Record Locator
New Field in EMD Information table: Record Locator

Documentation Updates

Updates were made to the Data Definitions to support the new database fields and tables.

Release 6.0

01 April 2014

New Data Content

Added the following fields to existing tables:

HotelTeleNbr field to HtlSeg.
ArrivalTerminal and DepartureTerminal fields to AirRsrvSeg.

Added the following new tables:

EMDInfo to support Electronic Miscellaneous Documents.
ProfileClientFile to support PRO-File/Client File profiles.
CustomerID to support Client IDs.
AirQuoAuto to support Automatic Fare Quotes.
PTCInfo to support Passenger Type Codes.

Updated Data Content

In the CarSeg table, CarAddress field was updated to access the car pick-up address from an offline database and automatically add the date in the Associated Itinerary Remark field.

TBF Trigger Updates

Added a new Table Lock setting (TBFU), which locks the TBFA table so that only one update can be made at a time. If the table is locked, the FBFA screen displays with a warning message at the top of the screen and the tab stops are disabled.

Software Updates

Updated the Client Adapter (6.0) and GIDS.xsd (version 11) to support the new data content.
Added TBF_script_v6.0.sql to support updates.

Release 3.0

08 May 2013

Software Updates

GIDS/TBF versions earlier than Travelport Booking Feed 2.8.02 have been retired.

New Data Content

Added the RfndTrans table to support Air Ticket Refund transactions.
Added the RfndAirTax table to provide a record of refunded taxes.
Added the RfndAirTaxBrk table to provide a record of refunded taxes, broken down by airport/city code.
In the TktTrans table, the 'R' (Refund) value was added to Active/Void Status.
In the AirTktSeg table, the 'U' (Used) value was added to Flight Coupon Status.
The QueueFlagsType complex type was added to the XML schema, GIDS.xsd (version 8). This type is for internal Travelport use only. Any data returned in this element should be ignored by external customers.

Software Updates

Updated the Client Adapter (3.0) and GIDS.xsd (version 8) to support the new Net Remit data content.
Updated the Java version used with the Adapter to 1.6.0_29 (32-bit).

Documentation Updates

In the TktRemarks table, corrected the field length of RemarkText from 64 to 100 characters.
Added RfndTrans, RfndAirTax, RfndAirTaxBrk tables to support the new Air Ticket Refund functionality.
Updated the TkTrans and AirTktSeg tables to support Air Ticket Refund functionality.