MarketplaceStudioSolutionData Extraction Model for Etisalat Ebills

Create your first automation in just a few minutes.Try Studio Web

Data Extraction Model for Etisalat Ebills

Data Extraction Model for Etisalat Ebills

by Naresh Kumar

StarStarStarStarStarStarStarStarStarStar

0

Solution

Downloads

<100

back button
back button
carouselImage0
next button
next button

Summary

Summary

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

Overview

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.

Features

Features

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.

Additional Information

Additional Information

Dependencies

UiPath.PDF.Activites UiPath.Excel.Activities

Code Language

Visual Basic

Publisher

Naresh Kumar

Visit publisher's page

License & Privacy

Apache

Privacy Terms

Technical

Version

1.0.1

Updated

July 26, 2021

Works with

Studio: 21.4.4 - 22.10

Certification

Silver Certified

Support

UiPath Community Support

Resources

Similar Listings