RPA - Tourism company case - Tickets vs IATA web
**Situation:** A tourism company that resells airline tickets needs to verify its information against the International Air Transport Association (IATA) website, ensuring accuracy in passenger details, destinations, flight schedules, and fares. A frequent issue arises when discrepancies occur between the company's system and IATA's data, which adversely affects their finances, leading to monetary losses.
**Solution:** Using RPA with UiPath, a robot monitors the email inbox for any messages from IATA that initiate the automation process. Upon finding such an email, a Python script extracts the ticket sales data from the attached PDF, converting it into a structured format. The robot processes this data, visits the IATA website, and retrieves details for each ticket sold, including booking references, passenger information, destinations, flight schedules, and prices. It compares this data against the company’s records, using the booking reference as a reference point. The robot compiles a list in an Excel file of each ticket reviewed, noting any discrepancies for prompt manual correction by administrative staff. Furthermore, the report is emailed to stakeholders and stored in Dropbox.
**Status:** Currently in production
**Technology:** Python, RPA, Bookingmotor system (web platform), IATA website, Excel, Outlook SMTP Email, and Dropbox.
**Benefits:**
- Saves over 10 hours with each IATA email by automating data gathering and discrepancy checking.
- The robot operates autonomously, providing updates through Excel and email upon completion.
- Ensures 100% accuracy.
- Prevents financial losses due to price inconsistencies.