Web Automatation

#1

Video shows an example of Zappy automation created to obtain a list of companies’ stock prices from London Stock Exchange (LSE) website.

User creates an excel sheet with desired company codes and respective price columns need to be updated from LSE.

Step 1: Right click on Zappy icon select Start learning .

image

Step 2: User has to manually copy the company code from second row, first column of the excel sheet and enter in search box of LSE. Click on search to see the results.

image

Step 3: Copy the price of searched Company Code and paste it in Price Column (Column 2, Row 2) of the Excel sheet. Place cursor on the second company code (Column1, Row 3).

image

Step 4: Right click on Zappy icon select Stop learning .

image

Step 5: Click on Z icon that appears on top of Excel window

image

Select all learned activities. From drop down list select how many times you want to run the task & Click on Run.

image

Step 6: After running Learned activities, you will see Custom Activity displayed in Zappy Context menu.Select all custom activities.

image

Then click on Open On Task Editor Icon.Task editor will opens.

image

Step 7: When you select CustomActivity, Zappy automatically adds For Loop Start & For Loop End actions. Now you can change For Loop Initial & Final Value as per your requirement by clicking on For Loop Start.

image

Step 8: Now click on Execute button .Zappy will automatically search each company code and enter the price in Excel sheet.

image

Step 9: Once the task is executed, Zappy gives “Successfully Executed Task” message on Right hand corner of your window.

image

In this way zappy has extracted data from Web & entered it in excel.