topic RE: Get data from table in a windows application in Product Forum

Get data from table in a windows application

Anonymous — Wed, 17 Oct 2018 17:48:00 GMT

I tried win 32 mode, UI automation mode and AA mode to extract the data from table in the windows application, but I am not able to extract the data using any of these. When i try AA mode i got an option of Get Table but all the row data are extracted into single column as "Column 1 Row() Column 2 Row()......" in one single column. After sometime I am completely unable to spy using AA mode, it throws an error stating "There was an error during spying operation." Can anyone suggest any other method where i can extract the right data from the table

You can also try UI…

AnitejaKota — Wed, 24 Oct 2018 20:42:00 GMT

You can also try UI Automation Mode which can fetch tables. I hope this fixes your issues.

RE: Get data from table in a windows application

Bryant.backus — Thu, 04 Jun 2020 19:23:00 GMT

Hi Tejaswini ,

Were you able to solve your problem? I am facing the same one.

Thanks

------------------------------
Bryant Backus
------------------------------

RE: Get data from table in a windows application

MarkusPulliaine — Sun, 16 Aug 2020 13:36:00 GMT

Hi,

I am facing the same issue. Not able to get values from Windows application with application modeller(HTML mode to available there). Which application modeller mode should I use for spying, that I would be able to get values from Windows Application list table?

With best regards,
Markus

------------------------------
Markus Pulliainen
------------------------------

RE: Get data from table in a windows application

james.man — Mon, 17 Aug 2020 08:12:00 GMT

If you're unable to spy a table completely, you may be able to spy just one element, and use Dynamic Attributes to capture the rest of the rows/columns using counter variables. Alternatively, Surface Automation can be considered, if you are can't find a reliable way to use Dynamic Attributes to capture the table.

Some documentation on Dynamic Attributes can be found here:
https://portal.blueprism.com/documents/attribute-matching-guide

Two guides to surface automation can be found here:
https://portal.blueprism.com/documents/training-document-surface-automation-basic-training-v6
https://portal.blueprism.com/documents/training-document-surface-automation-advanced-training-v6

Also, it is worth checking the Application Navigator or UI Automation Navigator to see if you can find the table elements there.
https://bpdocs.blueprism.com/bp-6-8/en-us/uia-navigator-form.html?Highlight=%22application%20navigator%22

------------------------------
James Man
Professional Services
Blue Prism
Asia/Hong_Kong
------------------------------

RE: Get data from table in a windows application

MarkusPulliaine — Mon, 17 Aug 2020 12:50:00 GMT

Thank you for the reply , the problem is , that I am not able to spy columns / rows. I am only able to spy the table as total. Now I would need to read the table rows and columns from application view to excel or to blue prism collection. Should I do this with Grid View , the get table is not available? All the help / tips are more than welcome! 🙂

With best regards,
Markus

------------------------------
Markus Pulliainen
------------------------------

RE: Get data from table in a windows application

james.man — Tue, 18 Aug 2020 02:24:00 GMT

It wasn't clear, but did you mention that HTML mode is available to you, meaning that this is a website?

If so, I'd recommend looking at the source code of the website (CTRL+U) to see if you can capture the full path of the desired table elements to spy. If not, then I'd recommend looking at Surface Automation.

It would help if you could provide a screen capture of what you are able to spy using what mode, and an image of what you are trying to spy.

------------------------------
James Man
Professional Services
Blue Prism
Asia/Hong_Kong
------------------------------