Data scraping not working PLEASE help me

Help
1

Hello there…

I am having a website.
In which i am entring the - Container number.
This container number i am entring from the Excel

For 1st Container number it scrapes the data perfectly.

But from 2nd onwords its not scraping- its taking the same 1st time scraped data

Please help

1 Like
2

Hi @Seem - Check the selector of Data Scrapping. Initialized the Datatable? If yes then clear datatable every time and scrap.

Thanks,
AK

2 Likes
3

@AnandKumar26
yes i checked the Data table and also cleared it using Clear Dt activity.

selector is - <webctrl parentid='statusInfo' tag='TBODY' />

Here is the - website
https://ecomm.one-line.com/ecom/CUP_HOM_3301.do

u need to select the container from dropdown and enter the - container number
image

there is a 1st table
Status Info.

If i dynamically pass the Container number from my code.
Its working only and only for 1st number…

1 Like
4

@Seem Where you want to store the coming data to?
if in excel then try using “Append Range” activity in “For Each”

Regards
shivam

1 Like
5

@Seem - When you Datascrap did you give that Next Page Button for navigation to move next page?

Thanks,
AK

1 Like
6

@shivam_rao
@AnandKumar26

I have done the complete code…
So here is the .xaml file - you can just run it.
Here is the excel file - please change the path as per ur computer location

SQLConnectProcessed_Excel_File -RPA_03_07_2019_02_34_08.xlsx (917.2 KB) All_Containers looping.xaml (51.2 KB)

No next page…

1 Like
7

Try using Append range instead of write range. @Seem

1 Like
8

inside the code

image
image388×504 14.3 KB

image
this is the status info extracted here

9

Are you using a [Enter] or a mouse click to verify that the next container is being executed?

1 Like
10

i am click on the search button only

1 Like
11

are you walking thru your code in a debug mode to see if the value is being executed?

1 Like
12

@Seem - If you see your Attach Browser Selector the Title is mentioned. I think Title gets changed each time for each container. If that is an issue then try to pass the variable name accordingly for each container.

Thanks,
AK

1 Like
13

@Skyman did it in debug mode too

1 Like
14

@AnandKumar26
I omitted the title.

Still the same issue … :frowning:

1 Like
15

Do not omit the title. Rather pass the a variable name of each container to that selector. Hence the BOT would be able to find the page with the title.

Thanks,
AK

1 Like
16

how to pass the variable name…?

Can u please send me the selector , which you have mentioned…
And did it work for you?
I have given the complete .xaml…
No need to do further any code…
So if u are able to get it…
Please help me out

1 Like
17

I am unable access the website due to security issue. In your workflow you have used a variable called “Container_Name” what is the output of that variable? If it is “ONE : Cargo Tracking” then change the title as “html title='” & Conatiner_Name &“’ />”

Thanks,
AK

1 Like
18

No u can access the web site.

Just can u try again
Open the web site:
https://ecomm.one-line.com/ecom/CUP_HOM_3301.do

Yes “Container_Name” should always be ONE

1 Like
19

Could you please scrap the First Container and note the selector. Then scrap the Second Container and note the selector. Then please validate both the selectors and identify the difference.

Sorry, I am not able to access it.

Thanks,
AK

2 Likes
20

first Compare 1 container selector with 2nd container selector so that we can identify the difference.

1 Like