topic Failed to Get table data in to Collection in Product Forum

Failed to Get table data in to Collection

ZhimingLiu — Thu, 29 Oct 2020 03:06:00 GMT

I am go through the exersice in Morden Browser Atomation lession, and try to get table item into collection.
I did identified a table element , but i get bellow error to read and get the table item, i want to know the root cause.

------------------------------
Zhiming Liu
------------------------------

RE: Failed to Get table data in to Collection

NrupalJoshi — Thu, 29 Oct 2020 16:08:00 GMT

Hi Zhiming

Can you post a pic of the actual table you have identified? Also, see if there is "match index" attribute, select it.

------------------------------
Rup Joshi
------------------------------

RE: Failed to Get table data in to Collection

ZhimingLiu — Fri, 30 Oct 2020 02:28:00 GMT

Hi Nrupal

Yes there is "match index" attribute.But same error popup even i seleted "match index".
Bellow is your requested pic. Pls help to investigate.

------------------------------
Zhiming Liu
------------------------------

RE: Failed to Get table data in to Collection

NrupalJoshi — Fri, 30 Oct 2020 12:52:00 GMT

Hi, can you make sure when spying the table you hover near the scrollbar of the table on the right. It should look something like this. It is working for me. Kindly test this and see if this helps.

Hope this helps

------------------------------
Rup Joshi
------------------------------

------------------------------
Rup Joshi
------------------------------

RE: Failed to Get table data in to Collection

NrupalJoshi — Fri, 30 Oct 2020 13:36:00 GMT

You can also try to spy with UI mode like this.

If this does not work, go into the application modeller, identify drop down and click on open UI automation navigator. This will give you a tree structure of the entire page thru which you will be able to identify your table. I tried this way and I was able to get the entire table with "Get Rows" (there is no get table). Including first column

------------------------------
Rup Joshi
------------------------------

RE: Failed to Get table data in to Collection

ZhimingLiu — Tue, 03 Nov 2020 02:16:00 GMT

Hi Rup,

Thanks a lot for you help.
the UI automation navigator method works for me.
While other spy mode such as IE HTML Mode or UI Mode all failed. I tried very hard but i just not able to achieve the same iditification result as yours.
Maybe some compatibility issue there for some version browser.

Any way thank your again.

------------------------------
Zhiming Liu
------------------------------

RE: Failed to Get table data in to Collection

vivek.kumar.goel — Thu, 05 Nov 2020 04:48:00 GMT

Glad that you got your answer. However my ONE cent for you:

When using IE HTML mode, do make sure your screen resolution is set to 100%. Else the elements spying becomes difficult.

------------------------------
Vivek Goel
Submit Your Built solution for "The" RPACULT 2020- The Unique RPA Hackathon of 2020.
http://therpacult.com
------------------------------

RE: Failed to Get table data in to Collection

NrupalJoshi — Thu, 05 Nov 2020 14:28:00 GMT

@Zhiming Liu I am glad that I was able to help a little. And, you are welcome :)

------------------------------
Rup Joshi
------------------------------

RE: Failed to Get table data in to Collection

AndreyKudinov — Fri, 06 Nov 2020 11:33:00 GMT

You need to make sure you spied table in html mode. If you spy with a mouse, you might get tbody or somethign else.
Check path attribute, it should end with /TABLE, possibly with brackets. You can edit it manually and recheck.

------------------------------
Andrey Kudinov
Project Manager
MobileTelesystems PJSC
Europe/Moscow
------------------------------

RE: Failed to Get table data in to Collection

NileshJadhavBP — Thu, 19 Nov 2020 10:21:00 GMT

Correct

------------------------------
Nilesh Jadhav
Senior RPA Specialist
ADP
India
------------------------------