Ok sure,
For the container no =TLLU5602141
(only for 1st tbl- Status Info)Here is the selector -
"<webctrl parentid='statusInfo' tag='TABLE' />"
for the 2nd container no=DRYU9477363
<webctrl parentid='statusInfo' tag='TABLE' />
1 Like
With the Title please
1 Like
yeah
<html app='chrome.exe' title='ONE : Cargo Tracking' />
for both i got same title- i.e realted to the attach window
1 Like
Hi @Seem
Why you are using data scraping for to get the two values status and weight directly you can get right by using get text activity?
1 Like
no i am scraping all 3 tables (there are totally 3 tables)
1 Like
yeah i have screen the web site but in code what you have shared there you are using two values so that’s why i got that doubt
yes for time being i just gave only one table.
Or else i thought it may confuse. So
1 Like
okay … got it
1 Like
All_Containers looping.xaml (94.9 KB)
Please check this one I have changed something and for each container use are taking, for example, status and weight right so i am printing in the logs check that for every container it is giving exact one check it and let know and for checking purpose i have removed the write range so if this process is working will do next that write range tell your requirement so that we can do perfectly.
1 Like
i AM getting this error
1 Like
Check whether the excel is having the data or not and columns SQLConnectProcessed_Excel_File -RPA_03_07_2019_02_34_08.xlsx (917.3 KB) and i have tested with this data and it works fine for me
see this and let me know
2 Likes
Well, I have added a comment for your logic with instructions on how to proceed - please check file and get back.
Container.zip (30.8 KB)
It has a skeleton of the loop and browser opening - include the steps mentioned in the comment at the exact position - it is pretty simple. Getting data from other SQL DB etc you can do it later. Let us see first what issues come up here.
PS : your issue was that the next container number wasn’t coming in as required instead you were getting the same first row that recurred. I guess that is fixed because your issue was
Row.item(yourcolumnname)
The above syntax I am not sure as to where you got it but it was causing the issue.
2 Likes
Please check the dependencies and update them. I just updated packages
UiPath.System, .Excel, .UiAutomation thats all
2 Likes
Did it work?
1 Like
the solution was very simple , i.e
Every time we open the web page and get data from the loop, we have o close the brower .
Or else it was taking/holding the previous data.
Thanks to everyone. 
1 Like
I hope this will help you see link for your reference 