Wednesday, 12 July 2017

PDF - Data Extraction Using Automation Anywhere

Hi All


Data Extraction using Automation Anywhere is very easily if we compare with other tool such as Blue Prism , Work fusion , UI path it's not so easy


In  Work Fusion  we can read the PDF by converting the PDF to HTML extra cost and extra effort .




 Use case


1. Extract some data from the PDF such as  First Name , Last Name etc


2 Pass these Information to another system may be Windows's, Web , Mainframe etc.




Automation Anywhere


1 . Open the AA client -- double click the PDF Integration


2   Select the option  Extract Form field


3 Provide the PDF file path ( We can set this to be dynamic using variable


4 If PDF is password protected provide the user name and password we can also set the variable


5 Click on Add Button


6 PDF file will be uploaded and selected the value you want to extract and save it into variable


5 Pass the extracted value of variable in another application


AA code








Thanks
Abhishek










Monday, 5 June 2017

What is Scaling of Robot in Robotic Process Automation?

Scaling of Robo / Bot is very critical process regarding designing the RPA solution . If the solution is not well designed, we will not able scale the solution and get the full ROI of RPA tools.




Let comes back to work estimation theory


Let’s estimate work for 80 Hrs


If x every day work for 8 hours x requires 10 days  to complete the task (80/8 =10)


if X Manager want to decrease the time line to compete the task He / She deploy 2 resources for 80 hrs. works   


80 Hrs /2Person = 40 Hours  


40 Hrs /8 Hrs  = 5 Days


if X Manager will deploy 2 resources the work will be to completed in  5 days


Same in RPA world –


If one robo/ Bots everyday process 100 Invoices in 8 Hrs and requirements is to process 1400 Invoices in 5 day what will be do


100 * 8 = 800


1400 / 800 = 1.75


We will deploy 2 Bots for Process of 1400 invoices
So adding the new Robo/ Bots as the Volume of work increases is known as scaling of Robot.


Note : I have selected one  reason for scaling of Robo / bots their are other reason also for scaling the robo i.e. Access , Security,  



Thanks
Abhishek

Analaytics in RPA tool --Automation Anywhere



Hi All,


Analytics in RPA tool --Automation Anywhere


  • BOT Insight
  • BOT Farm


Technical Architecture Diagram


 




Thanks & Regards
Abhishek

Tuesday, 23 May 2017

Pattern Based Data Extraction Using AUtomation Anywhere

Hi All,


Pattern Based Data Extraction Using Automation Anywhere is one of the good features of Automation Anywhere Tool .


Use Case

1 Open Any web site
2 Extract the Content from the site - In AA tool we have to set that Pattern in the website and extract the data and Save in CSV file  for eg --  Title of the Book , Phone Number, Address etc .


3 Pass the Extracted value to other application or send the file as Email


Benefit

Easily extract the content from the website and further apply any business rule or input to another application as per requirements


Note : If we extract the data  such as Title of the Book , Phone Number , Address from the website we can apply  Filter , search specific data etc  very easily




Web site




Extracted CSV File






Automation Anywhere Task BOTs


Thanks & Regards
Abhishek Lohani





Friday, 19 May 2017

Roles In RPA world

Hi All,


Roles In RPA world




1.Process Architect - (Business Analyst ) - Who will design AS-Is design of Process.


2. Technical Architect - Who will perform the feasibility study of the process and do perform the estimation as per AS- IS design and do the tool selection which suits best as per ROI and requirements.


Note: In some case tool selection, will be done by client team as they have the existing license with them or client wants the solutions should be design in their comfortable product


3. RPA developer - Develop the Bots as per Technical design and tool selected such as AA, BP, Work fusion, UI Path etc.


4 RPA Tester - Test the Bots as per requirement. If Team will be big then there will be segregation between developer and tester otherwise developer need to test their requirements .


5 Admin / RUN time / Developer -- Deploy the code in Production or staging environment.


6 Support --RPA Developer provides the supports as per requirement changes in BOT in future .

Thanks
Abhishek Lohani



Wednesday, 17 May 2017

Web Data Extaraction using Automation Anywhere Tool




Hi All,


Web Data Extraction (Web scrapping) is one of the good features of Automation Anywhere Tool .


Use case


1. Open any Site
2. Get the Content from site / Extract the Content
3. Save into variable or Pass into another application


Benefit


Don't require a resource who will extract the data from the website and send or enter into next application


Automation Anywhere Task Bots







Thanks & Regards
Abhishek











Tuesday, 16 May 2017

RPA Now Free : Work Fusion RPA Express



Hi All,




RPA Tool is now free : work fusion RPA Express




Register below link :-https://www.workfusion.com/rpaexpress






Click to get more details




Thanks & Regards
Abhishek

Robotic Process Automation Tools



Hi All

Some Robotic Process Automation Tools which capture the current Market .


1 Blue Prism -- Paid Tool
2 Automation Anywhere - Paid Tool - 1 Month Free license
3 UI Path - Paid Tool - Some week free license
4 Work Fusion - RPA express -- Free


https://www.linkedin.com/feed/update/urn:li:activity:6266609977419489281/

Thanks & Regards
Abhishek