Data scrapping pattern/Data table forming when scrapped

Help Studio
, , , , , , , , ,
1

Hey guys, so I’ve ran into a problem that I can’t figure out. Is it possible to somehow define the pattern that automatically goes on in the activity “Extract Table Data”?

image
image1906×1042 224 KB

When I click to scrape lets say the “Prekės kodas: 0005521” it automatically pics all the data near it. What can I do?

And another question, is it possible that when I scrappe the whole box of text, it usually comes out in 3 different rows. Can I somehow put it all in one row?

image
image1306×860 74.9 KB

2

Hello @Povilas_Jonikas, Try the Get Text activity to Get all data of Text box

1 Like
3

Hi and thanks for the response Gokul, but I’ve tried it with get text activity but it is problematic for me. When he gets the text to a variable, he doesn’t paste it to excel. He creates a new sheet, but doesn’t paste it, any ideas?
image

image
image1148×507 25.7 KB

4

After Get text, Print it using the message box to check whether it scrap data or not

1 Like
5

Hey!

The easiest method is screen scraping and choose the Native Text…

This will give you the data…

Regards,
NaNi

1 Like
6

Is it possible to provide me some sort of an example for this? I’m so confused :smiley:

7

Hi NaNi, thanks for the response. I did it, but it still wont paste nothing to excel, any tips?

image
image1517×552 45.2 KB

8

Hey!

Have you checked it in the debug mode whether we’re extracting the data or not?

Regards,
NaNi

9

Looks like we’re not.
How is it possible?

image
image1579×986 69.9 KB

10

@Povilas_Jonikas

image
image1353×502 101 KB

Pass the Extracted Text variable to the message box and let’s See the Message is Print or not
Note:Variable type should be the string

1 Like
11

Ok, thanks a lot! I’ll try it and let you know! :slight_smile:

12

Hey!

Use Output Data table activity and input is ExtrctedDataTable Output is strText

Pass this strText in the message box or AppendLine or Write text file…

Let’s see we’re able to extract and display the data in the provided output methods

Regards,
NaNi

1 Like
13

Hey guys, so it looks like I just don’t get any data to the DataTable.

image
image756×547 22.4 KB

But I don’t understand how, it finds the pattern, but has nothing

14

Hey,

Could you please show us the entire webpage with data wants to extract?

Regards,
NaNi

1 Like
15

I basically want to extract the same data from different pages. For example:

image
Every time it’s the same, I want to get the info which is in the same place. I tried with Extract Table data. For the first page it extracts data ant puts it in excel, but when he goes to another page, he get’s an error and shuts down.

16

Hey!

Try like this:

From where we’re getting the URL’S?

If it is getting from Excel try like this

  1. Build one Template DataTable and create the temp columns(Text)… output as - DtTemp
  2. Read range - DtOut
  3. Take one for each row in data table and pass the DtOut
  4. Take one open browser activity and pass the URL Like this
CurrentRow("WebsiteURLColumName").ToString.Trim

Now use screen scraping like this

ScreenScrape
ScreenScrape1322×977 24.9 KB

I am able to get the Output Like this

ScrapedMessageCapture
ScrapedMessageCapture1257×429 57 KB

This is in studio

OutputScrape
OutputScrape1615×716 49 KB

Take one add data row and pass the variable dt as DtTemp

That’s it

Regards,
NaNi

1 Like
17

Ok thanks! Ill try my best and let you know :slight_smile:

EDIT: and yes, it is taking the website url’s from excel, and should paste it in the same excel file but different sheet

1 Like
18

Im sorry, but why am I getting this result from scrapping that.
image

image
image877×652 13.1 KB

19

Few questions.

image
image1147×485 15.5 KB

What should be here? I dont understand.

And is my data table correct?

image
image1027×563 20.3 KB

20

Hello @Povilas_Jonikas

Do you have any other patterns to extract from the page? Table extraction can be used to extract tables and pattern based data.

1 Like