Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to parse Amadeus AIR ticket reservation file
Message
From
24/08/2013 16:52:31
 
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows Server 2012
Network:
Windows 2008 Server
Database:
MS SQL Server
Application:
Web
Miscellaneous
Thread ID:
01581031
Message ID:
01581352
Views:
66
>Amadeus is re-writing a pretty garbled version of the PNR - without getting proper documentation for the format I don't see how you can reliably parse the information.
>All I can glean (by guesswork) if that the record you posted relates to two flights:
>
>Tallinn to Vienna on flight no OV 0192 (Estonia Air) Departs 29th Aug 0725 Arrives 0845 (from U-001x))
>Vienna to Ankara on flight no TK 8726 (Turkish Airlines) Departs 29th Aug 1030 Arrives 1400 (from H-019)
>
>You could also try assuming that G-X gives departure and final destination airports (VIEANK = Vienna, Ankara)
>No idea where the reservation number is.

Document http://www.amadeus.com/corp/xml/documents/aco/gb/en/EMDAIROct2011.pdf
which I posted contains Amadeus terminal commands (whose documentation can found
in Amadeus client tutorials and user manuals in internet) and
corresponding AIR-BLK20x output.

By analyzing those samples I think I guessed PNR record locator position which I provided
in previous message.
No idea why this is duplicated in same line.

>FWIW:
>Fare was 144 Euros (or 2255 Estonian Kroon @ 15.64660) (from K-F)
>
>KFTF and TAX are obviously various taxes in Kroon (Airport tax, etc)
>Q- is probably the fare expressed as 'Neutral unit of construction' where ROE is the exchange rate for Euros.
>SSR is probably 'Special Service Request'
>
>A bigger sample might provide a better guess :-{

I havent found any such commands/ output sample which contains ticket numbers.
It looks like my AIR sample message contains in end ticket number request, maybe it does
not contain ticket numbers.
Google search for AIR-BLK206 returns some additional AIR format samples.
No idea do they contain ticket numbers or not.

My goal in to compare sold tickets from Amazon with BSP billing reports. Every ticket in billing report
must have corresponding invoice issued to customer by travel agency.
Andrus
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform