A 2 A 2 A 2

C 2 C 2 C 2
D 2 D 2 D 2
E 3 E 3 E 3
F 2 F 2 F 2
I 5 I 5 I 5
L 3 L 3 L 3
M 2 M 2 M 2
O 3 O 3 O 3
P 3 P 3 P 3
R 3 R 3 R 3
S 7 S 7 S 7
T 2 T 2 T 2
v 1 v 1 v 1
W 2 W 2 W 2
X 1 X 1 X 1

1. A – 2 – Active Directory, App 1. A – 2 – Active Directory, App

Integration. Integration.
2. C—2—Clip board, Comment. 2. C—2—Clip board, Comment.
3. D—2—Data base, Delay. 3. D—2—Data base, Delay.
4. E—3—Email Automation, Error 4. E—3—Email Automation, Error
Handling, Excel. Handling, Excel.
5. F—2—File/Folder, FTP/SFTP. 5. F—2—File/Folder, FTP/SFTP.
6. I—5—Else/IF, Image Recognition, Insert 6. I—5—Else/IF, Image Recognition,
Key Stroke, Insert Mouse click, Internet Insert Key Stroke, Insert Mouse click,
Connection. Internet Connection.
7. L—3—Launch Website, Log File, Loop. 7. L—3—Launch Website, Log File, Loop.
8. M—2—Manage Windows control, 8. M—2—Manage Windows control,
Message box. Message box.
9. O—3—Object Cloning, OCR, Open 9. O—3—Object Cloning, OCR, Open
Program File. Program File.
10. P—3—Pdf Integration, PGP, Prompt. 10. P—3—Pdf Integration, PGP, Prompt.
11. R—3—Read From CSV/Text, Rest Web 11. R—3—Read From CSV/Text, Rest Web
Services, Run script. Services, Run script.
12. S—7—Screen Capture, Send Email, 12. S—7—Screen Capture, Send Email,
Services, SNMP, Soap Web services, Services, SNMP, Soap Web services,
String Operation, System. String Operation, System.
13. T—2—Task, Terminal Emulator. 13. T—2—Task, Terminal Emulator.
14. V—1—Variable Operation. 14. V—1—Variable Operation.
15. W--3—Wait, Web Recorder, Window 15. W--3—Wait, Web Recorder, Window
actions. actions.
16. X—1—XML. 16. X—1—XML.

Internal to Wipro
 App Integration. App Integration.
Browsers, such as Microsoft Internet Browsers, such as Microsoft Internet
Explorer and Mozilla Firefox. Explorer and Mozilla Firefox.
DOS command prompts. DOS command prompts.
Java applications. Java applications.
Java Applets. Java Applets.
Telnet Unix Shell. Telnet Unix Shell.
Windows applications. Windows applications.
Other. Other.
Database. Database.
Connect. Connect.
Disconnect. Disconnect.
SQL Query. SQL Query.
Insert/Update/Delete. Insert/Update/Delete.
Run Stored Procedure. Run Stored Procedure.
Delay/Wait. Delay/Wait.
Email Automation. Email Automation.
Get All Messages. Get All Messages.
Delete All Messages. Delete All Messages.
Email Automation. Email Automation.
Get All Messages. Get All Messages.
Delete All Messages. Delete All Messages.
Delete Message. Delete Message.
Host Name. Host Name.
user name. user name.
Password. Password.
Server Type /Port no . Server Type /Port no .
IMAP(993)/ POP3(995). IMAP(993)/ POP3(995).
Read / Unread. Read / Unread.
HTMl / Plain text. HTMl / Plain text.
Save attachment. Save attachment.
Error Handling. Error Handling.
Begin error handling /End error handling. Begin error handling /End error handling.
Continue. Continue.
Take Snapshot. Take Snapshot.
Run Task. Run Task.
Log data into file. Log data into file.
Send Email. Send Email.
Variable assignment. Variable assignment.
Set task status - Pass/Fail. Set task status - Pass/Fail.

Excel Command. Excel Command.

Open Spreadsheet. Open Spreadsheet.
Close Spreadsheet. Close Spreadsheet.
Activate Sheet. Activate Sheet.
Get Cell. Get Cell.
Set Cells. Set Cells.
Go To Cell. Go To Cell.
Run Excel Macro. Run Excel Macro.
Delete Cells. Delete Cells.
Save Spreadsheet. Save Spreadsheet.

Internal to Wipro
 Find/Replace. Find/Replace.
Files and Folders. Files and Folders.
File. File.
Copy/ Rename files. Copy/ Rename files.
Delete/ Create file. Delete/ Create file.
Zip / unzip files. Zip / unzip files.
Print / Print multiple files. Print / Print multiple files.
Open file. Open file.
Create file shortcut. Create file shortcut.
Folder. Folder.
Copy / Rename folder. Copy / Rename folder.
Delete / Create folder. Delete / Create folder.
Open / Create folder shortcut. Open / Create folder shortcut.
IF/Else. IF/Else.
File exists / File does not exist. File exists / File does not exist.
Folder exists / Folder does not exist. Folder exists / Folder does not exist.
Window exists / Window does not Window exists / Window does not
exist. exist.
Application Running/ not running. Application Running/ not running.
Script Successful / Unsucessful. Script Successful / Unsucessful.
Task sucessfu / unsucessful. Ping sucessfu / Task sucessfu / unsucessful. Ping sucessfu /
unsucessful. unsucessful.
Web Control. Web Control.
File date. File date.
File Size. File Size.
Service Running / Not running. Service Running / Not running.
Image Recognition. Image Recognition.
Windows Control. Windows Control.
Object Properties. Ping successful/ nsuccessful. Object Properties. Ping successful/ nsuccessful.
Web Control. Web Control.
File date. File date.
File Size. File Size.
Service Running / Not running. Service Running / Not running.
Image Recognition. Image Recognition.
Windows Control. Windows Control.
Object Properties. Object Properties.
Loop. Loop.
Times. Times.
List. List.
Condition - (Loop while) if condition. Condition - (Loop while) if condition.
Each row in an Excel Dataset. Each row in an Excel Dataset.
Each row in an IE table. Each row in an IE table.
Each row in a SQ Query Dataset. Each row in a SQ Query Dataset.
Each File in a Folder. Each File in a Folder.
Each Folder in a Folder. Each Folder in a Folder.
Each row in a CSV/Text file. Each row in a CSV/Text file.
Each Email Message on Server. Each Email Message on Server.
Each Node in an XML Dataset . Each Node in an XML Dataset .
End loop. End loop.
Exit Loop. Exit Loop.
Continue Loop. Continue Loop.

Internal to Wipro
 OCR. OCR.
Capture . Capture .
window / Area. window / Area.
Image by Path / Image by URL. Image by Path / Image by URL.
Select Window. Select Window.
OCR Engine . OCR Engine .
View captured text. View captured text.
Assign to variable. Assign to variable.
Filter / Trim text. Filter / Trim text.
PDF Integration. PDF Integration.
PDF to Image. PDF to Image.
Extract Form Fields. Extract Form Fields.
Extract Text. Extract Text.
Merge Documents. Merge Documents.
Split Document. Split Document.
Encrypt Document. Encrypt Document.
Decrypt Document. Decrypt Document.
Prompt. Prompt.
Prompt for Value. Prompt for Value.
Prompt for Yes/No. Prompt for Yes/No.
Prompt for File. Prompt for File.
Prompt for Folder. Prompt for Folder.
Read from CSV/Text. Read from CSV/Text.
Read from CSV. Read from CSV.
Select file. Select file.
Delimiter - comma / tab. Delimiter - comma / tab.
Contains header. Contains header.
Trim spaces. Trim spaces.
Session.. Session..
String Operation. String Operation.
Before/After. Before/After.
Compare. Compare.
Find. Find.
Join. Join.
Length. Length.
Lowercase . Lowercase .
Replace. Replace.
Reverse. Reverse.
Split. Split.
Sub-String. Sub-String.
Trim Trim
Uppercase . Uppercase .
Terminal Emulator. Terminal Emulator.
Connect. Connect.
Disconnect. Disconnect.
Send Text. Send Text.
Get Text. Get Text.
Set Field. Set Field.
Get Field. Get Field.
Get All Fields. Get All Fields.

Internal to Wipro
 Wait. Wait.
Control. Control.
Share Session. Share Session.
Variable Operation. Variable Operation.
Web Recorder. Web Recorder.
Open /Close Browser. Open /Close Browser.
Manage web control. Manage web control.
Download File. Download File.
Extract Table. Extract Table.
Find Broken links. Find Broken links.
Extract Data /Table /Source. Extract Data /Table /Source.
Navigate URL. Navigate URL.
Search by caption. Search by caption.
Go back. Go back.
Execute java script function. Execute java script function.
Windows Actions. Windows Actions.
Activate Window. Activate Window.
Close Window. Close Window.
Maximize Window. Maximize Window.
Minimize Window. Minimize Window.
Re-size Window. Re-size Window.
XML. XML.
Start XML Session Start XML Session
End XML Session. End XML Session.
Insert Node. Insert Node.
Delete Node/Attribute. Delete Node/Attribute.
Update Nodes. Update Nodes.
Validate XML Document. Validate XML Document.
Get Node(s). Get Node(s).
Save Session Data. Save Session Data.
Execute XPath Function. Execute XPath Function.

LEAST FRIENDLY. LEAST FRIENDLY.

1. Scanned PDF. 1. Scanned PDF.
2. Handwritten PDF. 2. Handwritten PDF.
3. PowerPoint. 3. PowerPoint.
ODERATELY FRIENDLY. ODERATELY FRIENDLY.
1. Word Document. 1. Word Document.
2. Typed PDF. 2. Typed PDF.
MOST FRIENDLY MOST FRIENDLY
1. Excel Worksheet. 1. Excel Worksheet.
2. CSV File. 2. CSV File.
3. Text File. 3. Text File.
Backend CSV. Backend CSV.
1. Link data together for use in your 1. Link data together for use in your
automations automations
2. A- A reads the CSV without opening it. 2. A- A reads the CSV without opening it.

Internal to Wipro
 Standardizing Excel.
Rule 1: Create Excel templates that encompass all possible scenarios.

 Ensure the column headers are in a static location (e.g. Name, Email, Address and Phone #
go in cells A3:D3).
 Ensure the ‘Title’ is in A1 every time.
 If the ‘Address’ column may be filled out in some cases, keep Column C and the automation
can delete it after all logic statements are complete.

Rule 2: Unmerge all cells .

Rule 3: Remove all filters

Easy. Easy.
 Simple Objects.  Simple Objects.
 Text / Combo boxes.  Text / Combo boxes.
 Labels.  Labels.
 Radio buttons / Check Boxes.  Radio buttons / Check Boxes.
 Menus ( 1st tier).  Menus ( 1st tier).
 Efficient use of Keystrokes.  Efficient use of Keystrokes.
 Screens that the <TAB> key works.  Screens that the <TAB> key works.
 Hot keys.  Hot keys.
 Tables.  Tables.
 Excel, CSV, Txt, Databases.  Excel, CSV, Txt, Databases.
 Copy/Paste/Using the clipboard.  Copy/Paste/Using the clipboard.
 Error handling, Screen shots.  Error handling, Screen shots.
 Importing/Exporting text, log files.  Importing/Exporting text, log files.
 Logic - If/Then and Loop.  Logic - If/Then and Loop.
 Log to File.  Log to File.
 File Folder Commands.  File Folder Commands.
Harder. Harder.
 Multiple windows with the same title.  Multiple windows with the same title.
 Varying screen resolutions.  Varying screen resolutions.
 Different OS/IE Versions/MS Office  Different OS/IE Versions/MS Office
Versions. Versions.
 Multiple monitors.  Multiple monitors.
 Interactive flash forms.  Interactive flash forms.
 Machine or data driven  Machine or data driven
 Slowness /variance.  Slowness /variance.
 Asynchronous .exe task execution  Asynchronous .exe task execution
Hardest. Hardest.
 Windows without titles.  Windows without titles.
 Usually these are embedded as  Usually these are embedded as
2nd or 3rd level sub windows, like 2nd or 3rd level sub windows, like
popup windows popup windows
 Drag-and-Drop functionality.  Drag-and-Drop functionality.
Must use mouse moves / clicks. Must use mouse moves / clicks.

Tips & Tricks: Windows,

Internal to Wipro
 WINDOWS,
Know the window title/name in advance,
Use the Wildcard ‘*’ to represent sections of the title name that are subject to change.
MS Excel 2013-- “Book1 – Excel” --> “Book1*”.
MS Excel 2010-- “Book1 – Microsoft Excel” --> “Book1*”
MS Excel 2003 -- “Microsoft Office Excel - Book1” --> “*Book1”.
Solution for all versions-->“*Book1*”.
 Note: Window title must be uniquely identify a window.
 Note: One missing or misrepresented character can cause not to recognize that window.
 Note: ‘Currently Active Window’ can be used .
Use ‘Maximize Window’ command on all windows and applications to increase portability.
Alternatively utilize multiple variables to quickly update all window titles from one location.

Tips & Tricks: Tips & Tricks:

Recorders and Session Names. Recorders and Session Names.
RECORDERS. RECORDERS.
 Record short support tasks and merge  Record short support tasks and merge
the support tasks with main task the support tasks with main task
 Especially useful when reading data  Especially useful when reading data
from a pop-up or mouse\over event.. from a pop-up or mouse\over event..
 For Object Recorder and Web  For Object Recorder and Web
Recorder, use mouse clicks to navigate Recorder, use mouse clicks to navigate
rather than keystrokes. rather than keystrokes.
SESSION NAMES. SESSION NAMES.
 A session name represents a data  A session name represents a data
stream. stream.
 By default the session name is ‘Default’.  By default the session name is ‘Default’.
 Session Names become relevant when  Session Names become relevant when
there are multiple connections to open there are multiple connections to open
simultaneously. simultaneously.
 Cannot have 2 sessions with the same  Cannot have 2 sessions with the same
name open simultaneously even across name open simultaneously even across
different tasks. different tasks.
Error Handling. Error Handling.
Use Stop Task or Continue Option. Use Stop Task or Continue Option.
 Continue will resume script at end of  Continue will resume script at end of
error handling block. error handling block.
Send Email Options. Send Email Options.
 Send screen shot or custom message.  Send screen shot or custom message.
 Variable Assignment.  Variable Assignment.
 Filename for Print Screen.  Filename for Print Screen.
 Use system variable Date instead of  Use system variable Date instead of
Add Timestamp. Add Timestamp.
 Write to Log Filename.  Write to Log Filename.
 Use system variables: Day, Month,  Use system variables: Day, Month,
Year, Hour, and Minute. Year, Hour, and Minute.
Special to remember Special to remember
 Separate Text section with commas.  Separate Text section with commas.

Internal to Wipro
  A Task Status.  A Task Status.
 Final Hands-on Exercise .  Final Hands-on Exercise .
 Utilize a Backend CSV.  Utilize a Backend CSV.
 Create a standardized Excel  Create a standardized Excel
spreadsheet (Input or Output). spreadsheet (Input or Output).
 Make your own counter.  Make your own counter.
 Use a Loop.  Use a Loop.
 Make a Success Log File.  Make a Success Log File.
 Create an Error Log File.  Create an Error Log File.

Task bot-- Front end automation, repetitive, role based, relays on structured data

Meta bot—Integration, complex, multisystem, depends on Process

IQ Bot—Thinking bot, Extracts Unstructured data

Click—Click triggers the Javascript

Left click—it wont trigger Java script.

Variable Manager Variable Manager

Show System Variables. Show System Variables.
1. Commonly Used: 1. Commonly Used:
 $Counter$,  $Counter$,
 $Filename$,  $Filename$,
 $Extension$,  $Extension$,
 $Excel Column$,  $Excel Column$,
 $Filedata Column$,  $Filedata Column$,
2. $Error Line Number$, 2. $Error Line Number$,
 $Error Description$,  $Error Description$,
 $Clipboard$,  $Clipboard$,
 $Date$,  $Date$,
 $Hour$,  $Hour$,
 $Minute$,  $Minute$,
 $Second$,  $Second$,
 $Day$,  $Day$,
 $Month$,  $Month$,
 $Year$.  $Year$.
Variable Operation. Variable Operation.
 Output Variable  Output Variable
 New Value for Output.  New Value for Output.
 Use existing variables.  Use existing variables.
 Perform mathematical functions.  Perform mathematical functions.
 Add/subtract calendar days.  Add/subtract calendar days.
 Used to populate initial variable  Used to populate initial variable
assignments. assignments.
 Used for making custom counters.  Used for making custom counters.
 Overwrites existing data in variable  Overwrites existing data in variable
TIP: Use Variable Operation to populate all TIP: Use Variable Operation to populate all
local variables. local variables.

Internal to Wipro