Data scrapping pattern/Data table forming when scrapped

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”?


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?

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

1 Like

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

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

1 Like

Hey!

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

This will give you the data…

Regards,
NaNi

1 Like

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

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

Hey!

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

Regards,
NaNi

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

@Povilas_Jonikas


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

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

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

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


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

Hey,

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

Regards,
NaNi

1 Like

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


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.

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

I am able to get the Output Like this

This is in studio

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

That’s it

Regards,
NaNi

1 Like

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

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

Few questions.


What should be here? I dont understand.

And is my data table correct?

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