MarketplaceListingsSolutionData Extraction Model for Etisalat Ebills

Data Extraction Model for Etisalat Ebills

by Naresh Kumar

0

6

Data Extraction Model for Etisalat Ebills

by Naresh Kumar

0

Solution

6

carouselImage0

Summary

Summary


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


Code Language

Visual Basic

Publisher

Naresh Kumar

Visit Publisher's Page

License & Privacy

Apache

Privacy Terms

Technical

Version

1.0.1

Updated

26 Jul 2021

Certification

Silver Certified

Tags

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

Application

Etisalat

Support

UiPath Community Support

Resources

Similar Listings