How to extract output rows when the UiPath is reading the screen as a whole table


#1

Hi All,

I am running into an issue which is when i try to extract the data from ImageNow application. i want to select the output of a query as row by row.
i have tried to use the screen scraping, table scraping, selectors but for some reason. UIpath is not able to separate the rows. its selecting the whole page as one entity. is there any work around for such scenarios?

Thank You


#2

Hi,

Is this an iFrame? if yes then you can use Get attribute activity and grab the src of the iframe and store it in a variable, which will give data of the iFrame.

Also, if that is not the case you can use , Get Text to extract the entire data into a string and then using string manipulation (split,replace etc) you can create a datatable as there will be some pattern to the extracted data.

Try and let me know if it works.

Regards,
V


#3

Hi @Vikas.Jain

Thank you for your response, i have tried both approaches. looks like they are not going to work.

when i tried the IFrame approach, the output in the selector is:
"“
when i tried the Get text activity, the output is:
”"

the problem that UIpath is not able to read inside the frame. please advice.

Thank You


#4

Can you try Get Visible Text too? Screen Scraping Wizard configured with the Native method.


#5

Hi @badita

Still the same issue, not picking anything inside the frame up


#6

That’s bad. It means that only OCR/Citrix techniques will work. What application is that? Would it be possible to get an installation kit in UiPath?


#7

@badita

i tried the OCR and found out that while the font is white Uipath is not able to read anything. The application is ImageNow.
there is no package in Uipath for this tool, is that your question ?

thansk


#8

The question was how to obtain a kit of that application so to play with it and test myself.


#9

i am not able to find link to install it, i will ask the client if they can provide the installation kit


#10

Hi

I want to scrape a table from the web using the whole table method, and define customized the column headers. At the moment, the table output has column-1, column-2 etc. In this example:

I want to the headers to be first_name,last_name,age,city instead of 1-2,Column-1,Column-2,Column-3. Advice would be appreciated.


#11

In the above example, the best will be to download the file and then read it using Read Range activity, which will give you a data table.

For any other web scrapping , it will automatically figure out the table and extract it as a datatable for example, go to the below link :
http://finance.yahoo.com/quote/GOOG/history?p=GOOG
and by using the data scarping, you can extract the entire historical data in a single data table.

Regards,
V


#12

Thank you @Vikas.Jain
I wanted to avoid downloading to ensure that I am not working with files on a local drive. I also have a table with many columns. I therefore built on your suggestion by:

  • scraping the first few columns 1 by 1, assigning the column header
  • adding the rest of the columns by editing the ExtractMetaData

#13

if this is a frameset-layout app, you should check the entire tree structure… typically this sort of apps have nested framesets.

another approach would be to select all text from the table, copy and paste it into an excel worksheet (excel usually parses html content correctly)


#14

@theo500, the sheet was published from Google sheets. Thanks for the suggestion.

@Vikas.Jain , I have come back to your suggestion. For some reason I could not get the ExtractMetaData to work. The easiest way to generate the table is to scrape the html to excel (without headers which eliminates the column-1, column-2 row) and write a new data table from the excel sheet. Thank you.


#15

Hi @Yan

Did you resolve the issue?