I specialize in aviation oriented messages, data transformation, and handling. There are numerous types of aviation file formats commonly used in the aviation travel industry. Airlines share data back and forth between reservation systems, passenger services systems (such as check-in and baggage handling), fare and tax management systems, and even accounting systems. The data formats are varied for various systems.
IATA is a company that helps standardize aviation and air travel messages throughout the world. IATA messaging standards allow air travel companies from all over to be able to talk to each other using standard message formats. IATA has standardized a set of INTERLINE messages, specifically designed for airlines and reservation systems to be able to communicate between each other. IATA Interline messages include PNR (Passenger Name Record), PNL and ADL (Passenger Name List) which are both used used for booking information and passenger manifest data.
UN/EDIFACT is another standard of communication which is governed by the United Nations. EDIFACT, or EDI (EDI EDIFACT) messages are used by US CBP (US Customs), as well as many other country’s governmental agencies.
I have developed systems that will convert and provide data transformation to CBP EDIFACT messages using EDI Mapping techniques specifically tailored to the aviation travel community. You can convert EDIFACT to XML, (EDI to XML), convert XML, perform XML parsing, and is able to convert to XML various interline messages as well as UN/EDIFACT CUSRES, PAXLST, and MCL message types.
I have developed systems designed to handle EDI and XML, perform XML parsing, and even rebuild manifests and other PNL/ADL IATA messages to and from various formats. I have web-based EDI software systems as well as windows custom software that offers EDI solutions and is a premier EDI tool for your message converting needs.
EDI and XML EDIFACT, interline messages, EDI and XML, XML parsing, interline message parsing and conversion, PNR and PNL to PAXLST, CUSRES… I can do it all!
I have also developed complete Airline e-Ticket Issuance and database systems that use EDI as well!
These systems were used and tested with GDS systems, International Customs and US CBP systems, and Homeland Security’s TSA systems.
Some Examples
|
|
|
INTERLINE MESSAGE |
.HDQRMD1 012128 PNL DA4519/09MAR IAG PART1 CFG/030Y RBD Y/DEFGHKTVFT AVAIL IAG MYR Y000 -MYR124Y 1ANDRZEJEWSKI/HENRYMR-N4 .L/HV8U45 .R/EPAY HK1 CC 1ANTINORE/KIMBERLY .L/P3UF9Q .R/EPAY HK1 CC 2BADGER/KARENJMRS/MARKWMR .L/5APEKB .R/EPAY HK2 CC 1BARRETT/IRENEMS-Q2 .L/M1GIUA .R/EPAY HK1 CC 2KENNEY/ALBERTMR/KAYMRS .L/WVAJL2 .R/EPAY HK2 CC 2KENT/AMYMRS/LUCASMR .L/NWH69Y .R/EPAY HK2 CC 1KEYSER/GAIL-H2 .L/EC7XPY .R/RQST HK1 14B .R/EPAY HK1 CC 1KLOC/DANIEL-M4 .L/HKUADK .R/RQST HK1 8C .R/EPAY HK1 CC .R/PNLT 2LICK/ROBERTMR/SUSANMR .L/3N371J .R/EPAY HK2 CC 1LINCE/EARLMR .L/DWVQ4Y .R/EPAY HK1 CC 1LYONS/DUANE-K2 .L/GYMWWN .R/EPAY HK1 CC 1MAJCHRZAK/JAMESMR-N4 .L/HV8U45 .R/EPAY HK1 CC 3MAMMOLETTI/BETTYANN/MARIAH/MARK .L/T6Y0ZZ .R/RQST HK3 3F 3E 3D .R/EPAY HK3 CC 3MANN/CHARLOTTE/DAVID/HEATHER .L/TQ28RR .R/RQST HK3 2D 2E 2F .R/EPAY HK3 CC 1MBDA/GUEST-J3 .L/F52C73 .R/RQST HK1 1B .R/EPAY HK1 ENDPART1 |
STRING LIST |
MESGSENDER=HDQRMD1 MESGTYPE=PNL FLIGHTCOUNT=1 FLIGHT1-CARRIER=DA FLIGHT1=03/09/2008 DA4519 IAG-MYR PAXCOUNT=23 001ACTION=ADD 001FIRSTNAME=HENRY 001LASTNAME=ANDRZEJEWSKI 001GENDER=M 001PNRREF=HV8U45 001BOOKINGGROUP=N4 001PAXRBD=Y 002ACTION=ADD 002FIRSTNAME=KIMBERLY 002LASTNAME=ANTINORE 002PNRREF=P3UF9Q 002PAXRBD=Y 003ACTION=ADD 003FIRSTNAME=KARENJ 003LASTNAME=BADGER 003GENDER=F 003PNRREF=5APEKB 003PAXRBD=Y 004ACTION=ADD 004FIRSTNAME=MARKW 004LASTNAME=BADGER 004GENDER=M 004PNRREF=5APEKB 004PAXRBD=Y 005ACTION=ADD 005FIRSTNAME=IRENE 005LASTNAME=BARRETT 005GENDER=F 005PNRREF=M1GIUA 005BOOKINGGROUP=Q2 005PAXRBD=Y 006ACTION=ADD 006FIRSTNAME=ALBERT 006LASTNAME=KENNEY 006GENDER=M 006PNRREF=WVAJL2 006PAXRBD=Y 007ACTION=ADD 007FIRSTNAME=KAY 007LASTNAME=KENNEY 007GENDER=F 007PNRREF=WVAJL2 007PAXRBD=Y 008ACTION=ADD 008FIRSTNAME=AMY 008LASTNAME=KENT 008GENDER=F 008PNRREF=NWH69Y 008PAXRBD=Y 009ACTION=ADD 009FIRSTNAME=LUCAS 009LASTNAME=KENT 009GENDER=M 009PNRREF=NWH69Y 009PAXRBD=Y 010ACTION=ADD 010FIRSTNAME=GAIL 010LASTNAME=KEYSER 010PNRREF=EC7XPY 010BOOKINGGROUP=H2 010PAXSEAT=14B 010PAXRBD=Y 011ACTION=ADD 011FIRSTNAME=DANIEL 011LASTNAME=KLOC 011PNRREF=HKUADK 011BOOKINGGROUP=M4 011PAXSEAT=8C 011PAXRBD=Y 012ACTION=ADD 012FIRSTNAME=ROBERT 012LASTNAME=LICK 012GENDER=M 012PNRREF=3N371J 012PAXRBD=Y 013ACTION=ADD 013FIRSTNAME=SUSAN 013LASTNAME=LICK 013GENDER=M 013PNRREF=3N371J 013PAXRBD=Y 014ACTION=ADD 014FIRSTNAME=EARL 014LASTNAME=LINCE 014GENDER=M 014PNRREF=DWVQ4Y 014PAXRBD=Y 015ACTION=ADD 015FIRSTNAME=DUANE 015LASTNAME=LYONS 015PNRREF=GYMWWN 015BOOKINGGROUP=K2 015PAXRBD=Y 016ACTION=ADD 016FIRSTNAME=JAMES 016LASTNAME=MAJCHRZAK 016GENDER=M 016PNRREF=HV8U45 016BOOKINGGROUP=N4 016PAXRBD=Y 017ACTION=ADD 017FIRSTNAME=BETTYANN 017LASTNAME=MAMMOLETTI 017PNRREF=T6Y0ZZ 017PAXSEAT=3F 017PAXRBD=Y 018ACTION=ADD 018FIRSTNAME=MARIAH 018LASTNAME=MAMMOLETTI 018PNRREF=T6Y0ZZ 018PAXSEAT=3E 018PAXRBD=Y 019ACTION=ADD 019FIRSTNAME=MARK 019LASTNAME=MAMMOLETTI 019PNRREF=T6Y0ZZ 019PAXSEAT=3D 019PAXRBD=Y 020ACTION=ADD 020FIRSTNAME=CHARLOTTE 020LASTNAME=MANN 020PNRREF=TQ28RR 020PAXSEAT=2D 020PAXRBD=Y 021ACTION=ADD 021FIRSTNAME=DAVID 021LASTNAME=MANN 021PNRREF=TQ28RR 021PAXSEAT=2E 021PAXRBD=Y 022ACTION=ADD 022FIRSTNAME=HEATHER 022LASTNAME=MANN 022PNRREF=TQ28RR 022PAXSEAT=2F 022PAXRBD=Y 023ACTION=ADD 023FIRSTNAME=GUEST 023LASTNAME=MBDA 023PNRREF=F52C73 023BOOKINGGROUP=J3 023PAXSEAT=1B 023PAXRBD=Y |
XML |
<?xml version="1.0" encoding="UTF-8" ?> <Message> <MesgSender>HDQRMD1</MesgSender> <MesgType>PNL</MesgType> <FLIGHTS count="1"> <FLIGHT> <Date>03/09/2008</Date> <FlightNumber>DA5419</FlightNumber> <DepartCity>IAG</DepartCity> <ArriveCity>MYR</ArriveCity> </FLIGHT> </FLIGHTS> <PAXLIST count="23"> <PAX> <ACTION>ADD</ACTION> <FirstName>HENRY</FirstName> <LastName>ANDRZEJEWSKI</LastName> <Gender>M</Gender> <PNRRef>HV8U45</PNRRef> <BookingGroup>N4</BookingGroup> <PAXRBD>Y</PAXRBD> </PAX> <PAX> <ACTION>ADD</ACTION> <FirstName>KIMBERLY</FirstName> <LastName>ANTINORE</LastName> <PNRRef>P3UF9Q</PNRRef> <PAXRBD>Y</PAXRBD> </PAX> <PAX> <ACTION>ADD</ACTION> <FirstName>KARENJ</FirstName> <LastName>BADGER</LastName> <Gender>F</Gender> <PNRRef>5APEKB</PNRRef> <PAXRBD>Y</PAXRBD> </PAX> <PAX> <ACTION>ADD</ACTION> <FirstName>MARKW</FirstName> <LastName>BADGER</LastName> <Gender>M</Gender> <PNRRef>5APEKB</PNRRef> <PAXRBD>Y</PAXRBD> </PAX> <PAX> <ACTION>ADD</ACTION> <FirstName>IRENE</FirstName> <LastName>BARRETT</LastName> <Gender>F</Gender> <PNRRef>M1GIUA</PNRRef> <BookingGroup>Q2</BookingGroup> <PAXRBD>Y</PAXRBD> </PAX> <PAX> <ACTION>ADD</ACTION> <FirstName>ALBERT</FirstName> <LastName>KENNEY</LastName> <Gender>M</Gender> <PNRRef>WVAJL2</PNRRef> <PAXRBD>Y</PAXRBD> </PAX> <PAX> <ACTION>ADD</ACTION> <FirstName>KAY</FirstName> <LastName>KENNEY</LastName> <Gender>F</Gender> <PNRRef>WVAJL2</PNRRef> <PAXRBD>Y</PAXRBD> </PAX> <PAX> <ACTION>ADD</ACTION> <FirstName>AMY</FirstName> <LastName>KENT</LastName> <Gender>F</Gender> <PNRRef>NWH69Y</PNRRef> <PAXRBD>Y</PAXRBD> </PAX> <PAX> <ACTION>ADD</ACTION> <FirstName>LUCAS</FirstName> <LastName>KENT</LastName> <Gender>M</Gender> <PNRRef>NWH69Y</PNRRef> <PAXRBD>Y</PAXRBD> </PAX> <PAX> <ACTION>ADD</ACTION> <FirstName>GAIL</FirstName> <LastName>KEYSER</LastName> <PNRRef>EC7XPY</PNRRef> <BookingGroup>H2</BookingGroup> <PAXSeat>14B</PAXSeat> <PAXRBD>Y</PAXRBD> </PAX> <PAX> <ACTION>ADD</ACTION> <FirstName>DANIEL</FirstName> <LastName>KLOC</LastName> <PNRRef>HKUADK</PNRRef> <BookingGroup>M4</BookingGroup> <PAXSeat>8C</PAXSeat> <PAXRBD>Y</PAXRBD> </PAX> <PAX> <ACTION>ADD</ACTION> <FirstName>ROBERT</FirstName> <LastName>LICK</LastName> <Gender>M</Gender> <PNRRef>3N371J</PNRRef> <PAXRBD>Y</PAXRBD> </PAX> <PAX> <ACTION>ADD</ACTION> <FirstName>SUSAN</FirstName> <LastName>LICK</LastName> <Gender>M</Gender> <PNRRef>3N371J</PNRRef> <PAXRBD>Y</PAXRBD> </PAX> <PAX> <ACTION>ADD</ACTION> <FirstName>EARL</FirstName> <LastName>LINCE</LastName> <Gender>M</Gender> <PNRRef>DWVQ4Y</PNRRef> <PAXRBD>Y</PAXRBD> </PAX> <PAX> <ACTION>ADD</ACTION> <FirstName>DUANE</FirstName> <LastName>LYONS</LastName> <PNRRef>GYMWWN</PNRRef> <BookingGroup>K2</BookingGroup> <PAXRBD>Y</PAXRBD> </PAX> <PAX> <ACTION>ADD</ACTION> <FirstName>JAMES</FirstName> <LastName>MAJCHRZAK</LastName> <Gender>M</Gender> <PNRRef>HV8U45</PNRRef> <BookingGroup>N4</BookingGroup> <PAXRBD>Y</PAXRBD> </PAX> <PAX> <ACTION>ADD</ACTION> <FirstName>BETTYANN</FirstName> <LastName>MAMMOLETTI</LastName> <PNRRef>T6Y0ZZ</PNRRef> <PAXSeat>3F</PAXSeat> <PAXRBD>Y</PAXRBD> </PAX> <PAX> <ACTION>ADD</ACTION> <FirstName>MARIAH</FirstName> <LastName>MAMMOLETTI</LastName> <PNRRef>T6Y0ZZ</PNRRef> <PAXSeat>3E</PAXSeat> <PAXRBD>Y</PAXRBD> </PAX> <PAX> <ACTION>ADD</ACTION> <FirstName>MARK</FirstName> <LastName>MAMMOLETTI</LastName> <PNRRef>T6Y0ZZ</PNRRef> <PAXSeat>3D</PAXSeat> <PAXRBD>Y</PAXRBD> </PAX> <PAX> <ACTION>ADD</ACTION> <FirstName>CHARLOTTE</FirstName> <LastName>MANN</LastName> <PNRRef>TQ28RR</PNRRef> <PAXSeat>2D</PAXSeat> <PAXRBD>Y</PAXRBD> </PAX> <PAX> <ACTION>ADD</ACTION> <FirstName>DAVID</FirstName> <LastName>MANN</LastName> <PNRRef>TQ28RR</PNRRef> <PAXSeat>2E</PAXSeat> <PAXRBD>Y</PAXRBD> </PAX> <PAX> <ACTION>ADD</ACTION> <FirstName>HEATHER</FirstName> <LastName>MANN</LastName> <PNRRef>TQ28RR</PNRRef> <PAXSeat>2F</PAXSeat> <PAXRBD>Y</PAXRBD> </PAX> <PAX> <ACTION>ADD</ACTION> <FirstName>GUEST</FirstName> <LastName>MBDA</LastName> <PNRRef>F52C73</PNRRef> <BookingGroup>J3</BookingGroup> <PAXSeat>1B</PAXSeat> <PAXRBD>Y</PAXRBD> </PAX> </PAXLIST> </Message> |