Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How to parse Amadeus AIR ticket reservation file
Message
De
24/08/2013 12:13:33
 
 
À
24/08/2013 06:28:37
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows Server 2012
Network:
Windows 2008 Server
Database:
MS SQL Server
Application:
Web
Divers
Thread ID:
01581031
Message ID:
01581335
Vues:
65
>It looks like PNR record locator (=record id in Amadeus database = reservation number) is stored at start
>and near end of line starting with MUC1A :
>
>MUC1A 2JW8HW022;0101;TLLEE2310;63320320;TLLEE2310;63320320;TLLEE2310;63320320;TLLEE2310;63320320;;;;;;;;;;;;;;;;;;;;;OV 2JW8HW;TK RJ3ZZ7
>
>probably it is 2JW8HW
>
>I need also to retrieve ticket numbers from this file.
>How to do this ?

You're right - 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.


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 :-{
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform