How to place order from the List of customers for only 3 fixed customers

[Sisay_Dinku (Sisay YDG)]

Hi @fernando_zuluaga , @Anil_G and team,

I have a list of customers in the website. I am able to do data scapping and filter the customer I needed. However, I have to go back and write Puchase Order number and place order to each of the 3 companies. Can any one help on how to proceed with this? Thanks a lot

[Anil_G (Anil Gorthi)]

@Sisay_Dinku

As mentioned earlier…data scrapping might not be necessary as you have steps to perform after identifying

Please check this

How to Take only a limited list out of changing List of customers from a website

@Sisay_Dinku The peocess will be like this Have a array of items… for 3 customers For loop on the array For loop to navigate through each page Element exists to check the customer Get attribute to get the tablerow Click to click on order form Fill This repeats for each customer If all the values of table are available on same page and are loaded then elemnet exists will recognize from all… If you have a next button to move to next page then …the second for loop is for that navigation …

Cheers

[fernando_zuluaga]

Well, did you try using for each Ui element activity?
it might be useful there

[Sisay_Dinku (Sisay YDG)]

First of all, sorry for the belated response. Thanks a lot @Anil_G for the help. Yes, the UI element works . Here is what it looks like

My next question is how can I do the iteration for all the three customer. Meaning how to come back to the second customer after processing the first customer?

[Sisay_Dinku (Sisay YDG)]

@fernando_zuluaga yes the UI works.
I am interested into both your option and @Anil_G option.
If I have to follow your (@fernando_zuluaga) option, what is the next step after being able to get the 3 customers from the list?
Meaning, how can I go back and process for each customer? How can I use the data of 3 customers and proceed with the iteration. Please let me know if you need more clarification. Thanks

[Anil_G (Anil Gorthi)]

@Sisay_Dinku

That is the reason we are having a loop on the customers names… the first loop is for each customer…and inside that you would loop for checking each page…

So basically if you have build the code for one customer…then keep that code inside the loop again and this loop will be the one which will change the customer name

Cheers

[fernando_zuluaga]

Hi @Sisay_Dinku

what do you really need to perform? any kind of click in the web page?
will the web page redirect to another URL?

[Sisay_Dinku (Sisay YDG)]

@Anil_G and @fernando_zuluaga

I am back

[Sisay_Dinku (Sisay YDG)]

@fernando_zuluaga

In my process I have to go back place order for each of the three customers. Under each three we have PO pasting clicking on the continue and choosing the shipping destination. Under one customer there are a lot of activities carried out. Please let me know if you need screen shot for more info. Thanks!

[Sisay_Dinku (Sisay YDG)]

@Anil_G
I want to understand what the next steps are. Here is what it looks like.

[Anil_G (Anil Gorthi)]

@Sisay_Dinku

For loop on customer list will be the first loop after open browser…

Then inside that we use element exists to find the customer name and then use get attribute to get the table row of the found customer…which can later be used to perform click on order form

Please change the order thsie way

1. Open browser
2. For loop on customer list
3. For loop for checking each page
4. Inside the loop elemnet exists…
5. If trye…on true side of if use get attribute with customer name as innertext and get table row property
6. Use the table row in the click activity to click

Cheers

[Sisay_Dinku (Sisay YDG)]

@Anil_G

1. If trye…on true side of if use get attribute with customer name as innertext and get table row property
2. Use the table row in the click activity to click

I did not fully understand these two last steps from your response.

1. Where do I get the table row property?
2. Using table row in the click.

Can you please elaborate a little more. Thanks a lot for your help.

[Anil_G (Anil Gorthi)]

@Sisay_Dinku

First you will use a get attribute activity with a selector containing the innertext of the customer name you want to search…and in get attribute you will get the tablerow property…this is where you get the tablerow…which will be same value for all the elements in that row…

So as the next activity you can have a click activity on a different table col …you can change the table col value also use order form innertext and then use the table row property obtained in yhe previous step to click on the corresponding rows table row where the customer name is present

Hope this is clear

Cheers

[Sisay_Dinku (Sisay YDG)]

Hi @Anil_G

I see the following and there is not table row property I can see.
I feel like I have missed some steps or did not get it correctly. Please see this screenshot.

If you could, can you also comment on the steps you see in the screenshot?

Thanks!

[Anil_G (Anil Gorthi)]

@Sisay_Dinku

Can you please check this

How to Take only a limited list out of changing List of customers from a website

@Sisay_Dinku Did you try directly using check app state or elemnet exists with some selector which includes your required customer names…then you can get the tablerow value using the get attribute if it is found and use that table row property in the next selector to click on the order form For example…you selector for identifying name can be as below <webctrl tag=‘tr’ tablecolumn =‘1’ innertext=‘can add variable here for passing each name’ /> And your next selector after getting tablerow pr…

I want you to explore the customer name field in ui explorer and see the different attributes present for it

Cheers

[Sisay_Dinku (Sisay YDG)]

@Anil_G thank you so much

and I see aaname

[Anil_G (Anil Gorthi)]

@Sisay_Dinku

Exactly this is how you can use

instead of spaces you can use a wild character * or can use regex match to match multiple spaces

<webctrl tag='TD' innertext=' *{{Yourvariable}} *' matching:innertext='regex' />

This can be used in get attribute and then in the subsequent one use the tablerow property obtained here

Cheers

[Sisay_Dinku (Sisay YDG)]

@Anil_G

{{Yourvariable}}

Hi @Anil_G

When you say {{Yourvariable}} I assume you;re referring to the variable that passes the customer name which is under save to in the get attribute, right? When I do the selector validation. it does not seem working

[Anil_G (Anil Gorthi)]

@Sisay_Dinku

No in the selector you can right click and give the customer name variable…

and the attribute name would be “tableRow” and the value you save is the tablerow value from the get attribute

This is how it looks

here str is the variable containing your customer name

to add it you need to right click in the selector window and it would prompt with the available variables to replace the string with

cheers

[Sisay_Dinku (Sisay YDG)]

@Anil_G I am sorry for the multiple questions but I do not thing I got this thing right!
Here what I see

and I did not understand the part you shared with me.