Two questions in StudioX

Help StudioX
1

Hello All…

I am working on an automation to my company and i need some help on some parts that i am stuck in:

1- I need to read some words from a column, copy each and look for it in an intranet page that has two frames(left and main), the words will be on the left side and when we click on it, the main will open a page with some data that i need to read and copy to the excel-sheet (and then continue with the rest of the words). how to copy from excel rows and then search in a web and click?

2- how can i run an ORACLE query and save the results in EXCEL using StudioX?

2

Welcome to the Forum @firas !

Going step by step, you will do the following

  1. Get data from the excel, in an structured way
  • This can be done with the “Use Excel File” activity
  1. Combined with another activity called "For each Excel row, you will have an automatic way to iterate through all the rows, all the way until the end:

image
image483×569 13.2 KB

  1. Inside the For Each Row, the activity itself will create a new variable called “CurrentRow” which can be accessed from the “+” button on the activities such as type into, or log message (in your case, it will be type into), and in there, you’ll need to select what value to type:

image
image815×600 30.3 KB

To write this data into a website, check this example:
1- Open browser
2- Use excel file
3- For each row in excel, type value from FirstColumn, in search box

TestWriteExcel.zip (328.1 KB)

For your second topic, regarding Oracle query, you need to first install a package to connect to DataBases:

image
image812×107 6.35 KB

And when the package is installed, you’ll see a “Connect to database” activity, that with the details provided, will allow you to generate the connection, to be used later on to send queries, by using the activity “Run Query”

image

Hope this helps!

Best Regards,
Ignasi Peiris

3

Thank you @ignasi.peiris on your kind reply.

it seems that i could not explain it correctly. for the first question, example:
let’s say that we have 10 products that are displayed as a list on the Left frame of the page and once you click on that product, a table with different feature and information is displayed on the center frame of the page. the aim is to extract the data for each products on one table…example is in the below photo

example
example2000×1365 130 KB

for the second part, i already managed to setup the query but my issue is saving the query results in Excel.

4

Got ya now,

There are multiple ways to work with this: 1st one would be by iterating selectors → Could you scan 2 of that selectors, to see if for example they have an iterator that can be modified, to click on one after the other?

For example: if “Product 1” is on the selector, you could place a variable in it, and by changing its value, it should click on “Product 1”, then “Product 2” (1+1), “Product 3” (2+1) and so on until 100

In terms of extracting the data from the inside, did you try using “Table Extraction” to see if it identified as a structured datatable? if so, on each iteration you could extract it, write into excel, and then follow the structure above to iterate through rows

5

thank you again for your kind assistance.

please excuse my question but i am not a developer and don’t know a lot about these terms.

can you elaborate more about the selector thing if possible?

6

I found something that i wanted to test and see if it helps but i could not do it as i don’t see the gear that he is referring to; am i having something in the version installed?

7

Hello All,

thanks for everyone tried to help here.

I managed to resolve both issues,

the first one was resolved by adding a group activity and define a variable inside it and then iterate using the for each row while calling the variable,

the second one resolution was so easy; all what i needed to do is to add the excel file name inside the properties of “Run Activity” activity

8

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.