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.
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.
- 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.
- 0:04
The job
The job: copying flight tickets into a spreadsheet by hand, one field at a time, while more tickets arrive.
- 0:09
The mailbox
Instead, flight ticket emails arrive in a shared mailbox, and the system watches that mailbox (Outlook, Microsoft 365).
- 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).
- 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.
- 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.
- 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.
- 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.
- 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).
- 0:50
One email, one Submit
A team member types traveller.a@example.org and presses Submit Email.
- 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.
- 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.
- 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.
- 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.