MarketplaceListingsSolutionData Extraction Model for Etisalat Ebills

Data Extraction Model for Etisalat Ebills

Bronze Certified

Solution

0 reviews

2

Data Extraction Model for Etisalat Ebills

Bronze Certified

Solution

0 reviews

2


Summary

Extracting Utilization data from Etisalat Monthly bills using Regex and UiPath PDF Activities.

carouselImage0

Overview

This workflow can be used to extract the required utilization data from the Etisalat bills. It works as follows:
  • Reads all the PDFs from a predefined location.
  • Converts them to TEXT using PDF Activities one by one.
  • Extracts Local Calls Details including date, time, duration, and called number and populates the DataTable.
  • Extracts International Details including date, time, duration, and called number and populates the DataTable.
  • Extracts Special SMS (Parking SMS, Contest SMS, and Playstore, App store Purchase) including date, time, and sent to SMS number and populates the DataTable.
  • Exports them to Excel in 3 different Sheets (Local, International, and SMS) for a deep-dive view of the bills.
  • In conjunction with this workflow, you can automate the PDF download using the below two options:
- Using the mail Activity to access and download the PDF attachment or
- Using Screen Recorder or manually capture the steps from Login to Etisalat website, searching for the account no and until downloading the PDFs for each and every account in your company.

Benefits

Using this solution you can start right away extracting utilization data from Etisalat bills. Normally it takes a person a minimum of 1 week to manually extract data from PDF in the middle of other tasks they have to do, with this template for example you can extract all the utilization data in less than and 30 minutes for 250 PDFs.

Published: 30 Jul 2021 | Updated: 05 Jul 2021

Naresh Kumar
RPA Developer

Dubai - United Arab Emirates


License

Apache 2.0


Code Language

Visual Basic


Runtime

.NET Core


Tags

PDF Data Extract
Uipath.PDF.Activity
PDF Analytics
Data Extract Model
Etisalat

Compatibility

Studio: 2021.4.4+


Dependencies

UiPath.PDF.Activites UiPath.Excel.Activities


Documentation


Similar Listings