topic RE: BP cannot read web table using chrome in Product Forum

BP cannot read web table using chrome

NingshengXu — Wed, 02 Jun 2021 12:26:00 GMT

I am in the process to convert an existing bot for IE to Chrome but have an issue to read web table into collection.
Someone posted a work around solution to read table as a string and then use regex to sort it into a collection.

I would like to know how to do it in detail.
In addition, any other solutions are welcome.

Thank you in advance!

------------------------------
Ningsheng Xu
------------------------------

RE: BP cannot read web table using chrome

ConradoMeli — Wed, 02 Jun 2021 22:24:00 GMT

Hi,

Weird you shouldnt have problems if the table is HTML, any way, have you tried other types of identification besides web browser? (UAI or Accesibility)
I this does not work, try using the Application navigator or UI navigator to find the element and get the table data.

If this does not work, then you could just READ the "html value" with "Get Html" action from a parent element that contains the table, and then use a code stage to parse into collection. ( just look around on Stack Overflow, im sure you will find something).

Let me know if you get to the solution.

Regards,
Conrado

------------------------------
Conrado Meli
Managing Partner
Primus IA
America/Santiago
------------------------------

RE: BP cannot read web table using chrome

bruce.liu — Thu, 03 Jun 2021 03:05:00 GMT

Hi Ningsheng,

Before devising a workaround, I would hope you can have a go at the following:

Use a different element type, as Get Table sits on the Web Table element type only.
One thing I have had success in the past is to spy on the TBODY element as opposed to TABLE. This will give you a Web Element type. What you may need is to manually change the element type from Web Element to Web Table to get the Get Table action.

------------------------------
Bruce Liu
Senior Product Consultant, Professional Services
Blue Prism
Australia/Sydney
------------------------------

RE: BP cannot read web table using chrome

_Amlansahoo — Thu, 03 Jun 2021 04:21:00 GMT

1 - I would like to know which version Blue prism you are using. If more than 6.9. Get table will work. If it is prior to that you may not able to read the table even after changing Element Type to Web table.

2 - You have to get Table name or Table path to highlight whole table. Once you can able to highlight then only you can get values Get table. Prior to that as I mentioned above you need to change Element Type Web Table.

Still you have question feel free to connect I will be happy to help you more.

------------------------------
Amlan Sahoo
RPA Consultant
Equinix
------------------------------