Choose the right link for download

Feedback StudioX
,
1

Would appreciate it if you can help me with the followng query. I am new to Automation and have StudioX 2023.4.2 installed

With my automation process, I am trying to extract and download a report from a web app. The report that I have created has my name (Daniel) and the date and the time stamp when created, and I have to wait until the report download is available (refer to row 8). I want to extract this report as soon as its availble i.e. it takes about 6mns and the COMPLETED AT and DOWNLOAD becomes active. The issue I face is the automation process clicks on any download and not the one that i have created. Note that I have the unique fields in the report list i.e. Scheduled At as well as the Unique Key (cell B8) of the report. I used Check App state activity with proper anchors and it didnt work and some other activity features too but failed to get the desired output.

I have attached a screen shot of the report page. Any help will be appreciated

Report Capture
Report Capture1707×454 41.1 KB

3

@Oscar_Dsouza

first use get attribute activity and get the tablerow property using unique key

selector example : <webctrl tag='TD' tablecol='2' innertext='List of item shopping ...etc' />

Now use the output tablerow in the next selector to get correct download

Selector example : <webctrl tag='TD' tablecol='7' tablerow='{{varTablerow}}' />

for selectors use ui explorer and find selectors similar to above

cheers

4

Thank you Anil for your reply and getting back to me. The terms that you have used is going over my head. Let me give it a try by self-learning what you have provided and will get back to you.
Appreciate your help. Will reply soon
Oscar

5

Hi Anil
Wil the tablerow property work knowing that reports get added to the table by other clients every moment and the row where my report existed gets changed?
Will using a variable to store the unique key of the report and then using the variable to search and download the report when its available work?
Googling on how I can do this and your comments and help will be appreaciated too.
Regards Oscar.

6

@Oscar_Dsouza

So when you load the report that is when the get attribute and all will work…so tomorrow if the report changes to row 5 from row 2 then as you are getting the attribute again it would guve the new table row

I hope your application is a web application

If it is excel based then use look up activity in excel or datatable

Cheers

Cheers

7

Thank you Anil for giving me your time. Yes, its a web based application which gets refreshed every minute and new links (reports) gets added to the page.
Once I run the process, the report name shows up immediately but I have to wait for around 6-8mns for the download option to appear. In the meantime, other clients go on adding more reports and the row changes. I have used Check App State inside the Retry Scope activity refreshed every minute running for 9mns but it doesnt work.
I hope I am not messing you up and making sense. If you can give it a try, good or no worries, I will keep discovering and trying. God bless for your help and effort. Oscar.

8

@Oscar_Dsouza

These are the steps to be followed

  1. While loop with condition as true and max iteration as 20 or so
  2. Inside userefresh to refresh the pge and then use get attribute with the required name
    In innertext and get the tablerow property
  3. Use the taberow and use check app state for checking the download button for the corresponding row
  4. On the then side the item is found so click on download and proceed and then break the while loop
  5. On the else side use delay to wait before checking

Cheers