Case study, from a previous role

Flight tickets read and logged by AI

A system that reads flight tickets from email, adds every trip to the travel log and alerts the team in Microsoft Teams. A 76 second film with no sound.

A 76 second film with no sound. A flight ticket email arrives in a shared mailbox. Every word on the ticket is read, and AI picks out the traveller, the flights and the dates. Each traveller gets a row in the travel log, and the real Teams alert card asks a person for the passenger email. The full transcript is below the film.

Systems our team members built and handed over in previous roles.

What the film shows

The film has no sound. Here is every scene, in order. Select a time to play the film from that scene.

Organisation
An international health charity
Scope
All organisational travel
Tools
Outlook (Microsoft 365), Azure Logic Apps, Azure AI Document Intelligence, Azure OpenAI, Excel Online, Microsoft Teams
About the film
The Teams alert card is the real card from the handed over system. Names, routes and emails are replaced with sample data.
  1. 0:00

    Opening

    Flight tickets read and logged by AI. A case study from Automy Consulting, about a system built by a member of our team in a previous role.

  2. 0:04

    The job

    The job: copying flight tickets into a spreadsheet by hand, one field at a time, while more tickets arrive.

  3. 0:09

    The mailbox

    Instead, flight ticket emails arrive in a shared mailbox, and the system watches that mailbox (Outlook, Microsoft 365).

  4. 0:13

    Reading every word

    First, every word on the PDF ticket is read and turned into text a computer can use (Azure AI Document Intelligence).

  5. 0:18

    Picking out the details

    Then AI picks out the details that matter for each traveller: passenger, departure airport and date, final destination and date, flight numbers, e-ticket number and the stopover. The advert printed on the ticket is ignored (Azure OpenAI, a GPT-4o model). The system also picks out departure and landing times, and up to three stopovers.

  6. 0:23

    One journey

    Connecting flights are kept as one journey. Flight XX 101 from Airport A to a stopover at Airport C, then XX 202 on to Airport B, is one trip, not two.

  7. 0:28

    No PDF attached

    No PDF attached? There is no PDF to read, so the details are picked out of the email text itself.

  8. 0:33

    One ticket, two rows

    One ticket can hold several travellers. Each traveller gets their own new row in the travel log, an Excel Online workbook. The email cell in each new row is still empty.

  9. 0:38

    The Teams alert card

    For each new trip, an alert card is posted in the Travel channel in Microsoft Teams. This is the real alert card, with personal details replaced by sample data. Each part is labelled in turn: it asks a person for one detail (the title), details from the ticket (passenger name, departure date, departure point and final destination), so departure and arrival checks can go out (the request to "update Column C of the flight tracker and send out the departure and arrival checks"), type the email here (the box) and sends it to the travel log (the Submit Email button).

  10. 0:50

    One email, one Submit

    A team member types traveller.a@example.org and presses Submit Email.

  11. 0:54

    The log is complete

    The card changes to its real update text, "Email Registered For TRAVELLER A-XX 101", shown on a redrawn card. The email is written into Column C of the travel log, and the row notes whether the traveller is staff.

  12. 0:57

    The whole chain

    The whole chain: mailbox, read, picked out, travel log and Teams alert. Every flight ticket logged in the travel log automatically. A live log of all travel.

  13. 1:03

    Built and handed over

    Built and handed over by a member of our team in a previous role, at an international health charity. Handed over working, in the organisation's own Azure account.

  14. 1:10

    Let's work together

    Keep it simple. What is slowing your team down? Book a free 30 minute call at automy.co.uk.