Help me to find solution to do data scrapping from a website?

Help Activities
, , , ,
1

I am able to get texts of experience 1 company details like company name, job title and experience date by using get Text activity.

Same i followed to find the texts of second company experience. But the bot is stopped because experience 1 and 2 elements having classes which are same for both experience sections. Please refer the attached image.

I want to get texts from experience 1 and 2 in the experience list. The bot gets stopped if only one experience in the list when i scrapping data from two experience.

Please help me to fix this issue.

You can check the image.

image

2

@Gowthaman_Gajakutti

Use for eqch ui element of the experience section…that way you can loop through any number of experience fields dynamically and extract

Other way for the same would be to use find children and loop on it

Cheers

3

Hi @Gowthaman_Gajakutti ,
You can use for each element to extract all element
Or use data scaping
Regards,
LNV

4

Hello @Gowthaman_Gajakutti ,
You can use the For each UI element Acitiviy to loop through each Each Experience Rows.
Regards

5

HI @Nguyen_Van_Luong1
Thanks for your response.

Have used For each ui elements activity. As i preview i could see details in two rows. what activity should i use to get data from it?
In excel, i want to update like this format.
company 1 name | company 1 job title | company 1 exp date | company 1 name | company 1 job title | company 1 exp date

I already used write cell activity to update name, email and phone in column.

image

6

Hi @Akshay_B
Thanks for your response. I am new to RPA. I need your help. Can i get your skype id?

7

Thanks @Anil_G,

I have used for each ui element with limit 2 company experiences only.

What activity to capture data from the list and write this data in excel like this format

company 1 name | company 1 job title | company 1 exp date | company 2 name | company 2 job title | company 2 exp date

8

This excel format:

company 1 name | company 1 job title | company 1 exp date | company 2 name | company 2 job title | company 2 exp date

9

@Gowthaman_Gajakutti

You can first do for each ui element on whole of the experience card…

And inside that for different fields use find children with filters for example

If you need the role use <webctrl tag='DIV' class='contact-linked-in-data-section-data' />

Then use get tect on the returned element…

This way you can get eqch field and write to datatable first using add data row later can write to excel

Cheers

10

Hi @Anil_G I could not implement the steps you asked me to follow. I am new to RPA ui path. Can i get your skype contact?