English
|
Japanese
Data Extraction Model for Etisalat Ebills
by Naresh Kumar
0
6
Data Extraction Model for Etisalat Ebills
by Naresh Kumar
0
Solution
6
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
License
Apache
Technical
Version
1.0.1Updated
26 Jul 2021Certification
Silver Certified
Tags
PDF Data Extract
Uipath.PDF.Activity
PDF Analytics
Data Extract Model
Etisalat
Application
Etisalat
Support
UiPath Community Support
Resources
Similar Listings
English
English
日本語