topic RE: It is not possible to map "table" that varies in google chrome in Japan Community

It is not possible to map "table" that varies in google chrome

Jrwork — Fri, 26 Nov 2021 19:47:00 GMT

皆さん、こんにちは！

グーグルクロームで「テーブル」の情報をキャプチャするのに問題があります。このテーブルは情報に応じて変更されます。場合によっては1行、5行、30行になり、マッピングすると、マッピングされた方法でキャプチャされます。たとえば、2行でマッピングした場合、より多くの行またはより少ない行をキャプチャせず、単にエラーが発生します。誰かがガイドできますか？

ブラジルからの抱擁


Hello friends!

I'm having difficulties for the information of a "table" in google chrome, this table is changed depending on the information, sometimes it's a line, again five lines, again 30 lines and when mapping it ends up capturing just how it was mapped, example , if I mapped it with two lines it doesn't capture more lines or fewer lines, it simply gives an error, can someone guide?

hugs from Brazil

------------------------------
José Francisco Bezerra Nunes Júnior
------------------------------

RE: It is not possible to map "table" that varies in google chrome

devneetmohanty07 — Sat, 27 Nov 2021 06:27:00 GMT

Hi José,

Here the first thing I noticed is that your entire table is in the form of a <DIV> tag. I would first suggest you to check the HTML structure of this table by going to Google Chrome and press either Ctrl+Shift+C or try to right click on the page and select "Inspect". This will give you a panel where you can view the HTML structure of your page. I would suggest you to first check if there is any <TABLE> tag or not. If it is not there you can't directly use your application modeler to get the data. You can also try to see if you get the inner paths by using the Application Navigator in your Application Modeler itself. It should be a button which will showcase you a wizard with the entire tree structure of the elements present in your website.

In this case you need to first locate the path of your parent div and then based on the rows available within that you need to create a dynamic logic to traverse through each div tag that indicates a individual row in that table. This is something similar that we also have done a lot while selecting values from date picker and calendar elements as well in the past. Here using X-Paths and creating a dynamic X-Path expression can also help you a lot if it pretty much dynamic in nature and has a pattern to it. Otherwise other attributes such as Match Index, Ordinal and Ancestor Counts can also be made dynamic in such a way that by sending different counter values you can extract the corresponding data as well.

To be honest, there is no fixed answer to your question as every table might have a different structure internally unless you can perhaps find that pattern or give us a sample URL to check further. But the traversal logic is pretty much the common thing here on which you can form your logic while extracting data. Hope this information helps you out.

------------------------------
Regards,
Devneet Mohanty
Intelligent Automation Consultant
Blueprism 6x Certified Professional
Website: https://devneet.github.io/
Email: devneetmohanty07@gmail.com
------------------------------

RE: It is not possible to map "table" that varies in google chrome

Jrwork — Mon, 29 Nov 2021 17:47:00 GMT

Hello Mohanti!

I followed your instructions and it worked! Thank you very much, it is now capturing information from the correct table.

Regarding the URL, it's an internal private site that can only be accessed by corporate login, but it worked, so I'll keep an eye out for that tip next time.

Thank you!

------------------------------
José Francisco Bezerra Nunes Júnior
------------------------------

RE: It is not possible to map "table" that varies in google chrome

devneetmohanty07 — Tue, 30 Nov 2021 02:59:00 GMT

Hi Jose,

Glad I could be of some help to you and happy to see you resolve the issue. Also, please do mark the response as the best answer if you feel the answer solves your issue so that other people facing similar issue can directly get some help from it.

------------------------------
Regards,
Devneet Mohanty
Intelligent Automation Consultant
Blueprism 6x Certified Professional
Website: https://devneet.github.io/
Email: devneetmohanty07@gmail.com
------------------------------