I have a website that I have to navigate through and deal with only three customers from the list of changing number of customers. Please see the following screenshot for your visibility.
The list of customers is changing. I want to work with only 3 fixed customers from the list. Is there any suggestion you’d give on how to select those 3 customers and create order ticket in each of them. My problem is the sequence of customers change as the number of list change; either increase or decrease.
If you have questions, please let me know. Thanks!
Could you try checking if there is Filter option available in the application itself to filter for only the required customer that you need ? Or maybe also a Sort option ?
@supermanPunch thank you for your response, but unfortunately, I do not see any filters in the app (website) so that I can filter out the three customers. Summary: there is no filter option.
Could you try performing a Data Scraping /Table Extraction on the table present ?
Also, Check what is the Selector of any one of the Retailer Name values. We might be able to substitute the customer required in place of the aaname / innerText attribute and then perform a Simulate Click to see if that is able to work.
Let us know if you were able to check the methods suggested.
Hi @supermanPunch thank you for your response. Unfortunately, I was not able to see the data that contains list od retailers. I’d like to know what the next step could be after the data scrapping?
@Sisay_Dinku , I believe you have checked the Header/ column name. It was mentioned to check with the Retailer Name values that is present in the column (any one of them).
@supermanPunch my apologies. there was an error I made. I am able to extract the list of items. My question is how to filter theose three customers, I’d like to process. Thanks!
you know the three customers you want? we can use a single linq query to filter them
(From d In dtInput.AsEnumerable()
Where d("Retailer Name").ToString().Trim().Equals("Customer1") Or
d("Retailer Name").ToString().Trim().Equals("Customer2") Or
d("Retailer Name").ToString().Trim().Equals("Customer3")
Select r = d).CopyToDataTable()
(From d In dtInput.AsEnumerable()
Where d(0).ToString().Trim().ToUpper.Equals("CUSTOMER1") Or
d(0).ToString().Trim().ToUpper.Equals("CUSTOMER2") Or
d(0).ToString().Trim().ToUpper.Equals("CUSTOMER3")
Select r = d).CopyToDataTable()
@fernando_zuluaga I appreciate the continous support, really. I want to know how to make my assign ready from my data table and I select the three customers from there. Just wanted to comprehend. Thanks!!
(From d In ExtractDataTable.AsEnumerable()
Where d(0).ToString().Trim().ToUpper.Equals("CUSTOMER1") Or
d(0).ToString().Trim().ToUpper.Equals("CUSTOMER2") Or
d(0).ToString().Trim().ToUpper.Equals("CUSTOMER3")
Select r = d).CopyToDataTable()
Left Assign Part
variable you want as datatabletype
i edit the extractdatatable variable, you should edit the part like “CUSTOMER1” “CUSTOMER2” “CUSTOMER3” and change that values from yours also in Upper case
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 property would be
@Anil_G Is this after data scrapping or just from the get-go? FYI - list of customers is long, it could be as many as 10 pages, Is there any other approach than data scraping?
Thanks!
