E N D
RPA Welcome to Automation Anywhere A360 Training session
Agenda • Recorder • Custom Dom xpath • Loop • Excel packages • Database packages • CSV/txt packages
Recorder • Recorder works on Both Web applications and Desktop application. • It captures interactions such as Mouse clicks and Keystrokes. • It is Object oriented as it records object controls such as text boxes, Buttons, check boxes etc. Recorder Supports? Applications :- • HTML Applications • JAVA applications that runs in JRE 5,6,7 • Microsoft active accessibility • SAP Browser :- Google Chrome Internet Explorer
XPath • We use Xpath to identify object in web applications based on HTML Tag and Attributes. When we Use? • When properties are keeps on changing and object position is keeps on changing in web application on that time we write xpath to identify object. • We can write xpath in two ways by using Absolute and Relative xpath.
Excel Packages Excel Basic Excel Advance We use Excel advance packages when excel is installed in our system If we need to perform front end operations. Contains more excel operation related commands like Create work book, work sheet, delete Duplicate rows. Excel advance package Supports Version:-Microsoft office 2000 through Microsoft office 2016 Formats:- .xls, .xslx, .xlsm, .xlam, .xltm, and .xltx • We use excel basic packages when excel is not installed in our system • If we need perform backend operation. • It contains less commands compare to Excel advance. Format Supports:- Xlsx
Data Base Packages • We use Data base generally to store Bot Status(Error details , Success and Failed Details) in Data Base and to work on Excel as data base. • Data base commands:- connect, Disconnect, Insert, Delete, read From. Excel as Data Base:- • If you are working on huge Excel dataset using Excel Package, you might face • Slowness in Bot execution • Errors(HR Result error, Excel is not responding Error) • Processing of data is fast since bot reads data from excel as back end. • Even if excel application is not installed in the application bot will work • This process only work on files stored locally or on network drives , not for use for control room stored files.
CSV/TXT • CSV Packages:-We use CSV commands to read data from text file mainly comma separated, tab separate…etc