Java Client Application Table Data Extraction

Help
1

Hi All,

Unable to fetch all the data from the table in Java Client Application, Since there is no specific Row and Column index in the selector, The window has only cell index which appears regardless there is a data in the grid or not.

image
image749×296 3.09 KB

image
image441×582 7.7 KB
image

Please help with this.
Thanks in advance.

Regards,
Shree

2

Hi @ShreeJnanesh

Welcome to uipath community
is the column or column name or any of the cell in the table is accessible as element…
if its accessible we can use data scrapping option from design menu
or if its looking as a image, use Screen scrapping option from same design menu
That would work for sure
and also make sure that java extension is installed
https://studio.uipath.com/docs/installing-the-java-extensions

Kindly try this and let know for any queries or clarification
Cheers @ShreeJnanesh

3

Is Java extension enabled in studio

4

Hi @Palaniyappan and @AshwinS2

The Java extension has been successfully installed.

@Palaniyappan

The column names are Present in the grid and can be accessed. But it has no column or row index, also the cell index is as below

image
image730×222 5.89 KB

Irrespective of the data in the grid i:e single row or more than 12 the cell index remain the same.

Regards,
Shree

5

Hi @ShreeJnanesh

Try to do data scrapping and stored in extract datat table before using write range use build data table activity and bind the data

Thanks
Ashwin.S

6

Hi @AshwinS2

Since it is not a web application, The data scrapping method is not able to extract the data.

It shows the following error.

image

Thanks,
Shree

7

Fine then use screen scrapping as suggested before and in that use Full text or OCR text to get the details, in a unstructured form, get the output with a variable of type string
–then use generate datatable activity and pass the above variable as input and get the output as datatable
–now we can use this datatable wherever we want
Cheers @ShreeJnanesh

8

Hi @Palaniyappan,

Thanks for your review,

The visible part of the grid is only 8 columns out of 14, and only 10 rows. There is data outside the visibility area, so those data won’t get extracted.
Is there any methods to extract all those data, by looping through attributes.

The way I thought to process is grouping
(Final cell no-Initial cell no)/No of columns gives the no of row items. Then, put it to a DataTable, but if the data exceeds the no of rows i:e 10 it won’t extract the remaining data.

Thanks,
Shree

9

Hi All,
Since there were no Reliable selectors in the application and no specific activity to extract the data table from the java application, I did manage to find a solution.
The solution for this table extraction is,
Since there were each cell index and 12 rows, Using Get Text activity to copy the data, Send hotkey activity to scroll down and add the extracted values to the created data table with their specific column.

Thanks, @Palaniyappan @AshwinS2 for guiding me,

Regards,
Shree

1 Like
10

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.