Data scraping not working PLEASE help me

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

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

Thanks,
AK

2 Likes

@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

@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

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

Thanks,
AK

1 Like

@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

Try using Append range instead of write range. @Seem

1 Like

inside the code

image
this is the status info extracted here

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

1 Like

i am click on the search button only

1 Like

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

1 Like

@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

@Skyman did it in debug mode too

1 Like

@AnandKumar26
I omitted the title.

Still the same issue … :frowning:

1 Like

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

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

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

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

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

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

1 Like