Example 3: To enter data from a comma separated (.csv) file into an application.
- Open the application you want to enter data into.
- Open the Task Editor from Tools -> Task Editor.
- Double Click the Excel->Open Spreadsheet command to open the comma
separated (.csv) file having the data.
-
Double Click the Excel->Get Cells (Multiple) and specify the 'From Specific Cell' as the first cell in your csv file & the 'To Specific Cell'
as the last cell.
- Insert a loop 'Each row in an Excel Dataset'.
- Depending on the controls in your application double click on the relevant 'Manage Windows Controls' command. Select
the application window from the list. Click on 'Capture'
and hold and drag your mouse on the control. Then select the required action
to set the value of the control to that from the Excel dataset.
-
Click on 'Save' button.
- Repeat steps 6 to 7 for all the fields in the
application.
- Click 'Capture' and hold and drag your mouse on the button to
be clicked to save the data entered in your application. (Steps 6 to 8 should be within the loop)
- Click on 'Save' button.
- Double click the Excel->Close Spreadsheet command.
-
Click on 'Save' button.
Example 4: To select options required to generate a report from an application.
- Open the application you want to generate the report from.
- Open the Task Editor from Tools -> Task Editor.
- Depending on the controls in the report generation options
window of your application double click on the relevant 'Manage
Windows Controls' command. Select the report generation options window from the list. Click on 'Capture'
and hold and drag your mouse on the control. Then select the required
action to set the value of the control.
- Click on 'Save' button.
- Repeat steps 6 to 7 for all the options to be set for the report.
-
Click 'Capture' and hold and drag your mouse on the button to be clicked to
save the options entered and start processing the report.
- Click on 'Save' button.
Example 5: To extract a table from a web page after it is loaded.
- Open the Task Editor from Tools -> Task Editor.
- Double click on the Internet->Web Recorder command and select the 'Open
Browser' command and specify the URL of the site to be opened.
- Click on 'Save' button.
- Double click on the 'Manage Windows Controls' command and select
the 'Status Bar' control. Select the relevant Internet Explorer window from the list. Click
on 'Capture' and hold and drag your mouse on the status bar. Then select
the variable to which the value in the status bar has to be assigned.
- Click on 'Save' button.
- Double click the Conditions/Loops->If/Else
command and select the option 'Variable'. Click 'Edit' button and
select the variable specified in Step 4. Select 'Equal To(= )' and then select the option 'Fix' for which the value should be
'Done'. Click on 'Save' button.
- Double click the Internet->Web Recorder command
and select the option 'Extract Table'. Specify the URL of the website
to launch and capture the required table after the page is loaded. Specify the name of the csv file to
which the table data has to be saved. The 'Extract Table' command should be within the 'If' and 'End If'.
- Click on 'Save' button.
- Double click the Internet->Close Browser' command.
- Click on 'Save' button.