<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Can you want to post a pic… in Product Forum</title>
    <link>https://community.blueprism.com/t5/Product-Forum/Identifying-End-of-Table/m-p/89905#M40224</link>
    <description>Can&amp;nbsp;you want to post a pic of HTML path generated when you spy one cell of the table?</description>
    <pubDate>Tue, 17 Jul 2018 19:09:00 GMT</pubDate>
    <dc:creator>NarendraMundwad</dc:creator>
    <dc:date>2018-07-17T19:09:00Z</dc:date>
    <item>
      <title>Identifying End of Table</title>
      <link>https://community.blueprism.com/t5/Product-Forum/Identifying-End-of-Table/m-p/89904#M40223</link>
      <description>I have a HTML page which has a table in it. I need to read the table data and process it. When I spied the HTML table, blue prism is not identifying it as a table element but is identifying as a HTML Element. so when I used get table action to get the table data, I am not getting the table data in rows in collection but am getting entire data as a single row which I cannot process.
To resolve the issue, I got the HTML path of first row and used a counter in the logic to increment the HTML tag which would read each row data sequentially. At the end of table, when I try to read the next element, since the logic reached end of the table, I will get a time out at which point, I know that I read all the data in the table. Once I get the timeout, I will process the read data.
This logic is working fine but I am trying to see if there is a better way to achieve this solution instead of depending on the timeout, the reason being, timeout is causing the overall bot execution time to increase. Currently, when I run the bot in debug mode, the timeout action is taking about 8 seconds to timeout. I am not sure if the bot would take the same time when executed from control room, but either way, if I can identify the end of table without timing out, it would speed up the bots execution time.

Attached the screenshots of table source and blueprism logic. Appreciate any thoughts on this.</description>
      <pubDate>Mon, 16 Jul 2018 16:04:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/Identifying-End-of-Table/m-p/89904#M40223</guid>
      <dc:creator>Venkata_Sreedha</dc:creator>
      <dc:date>2018-07-16T16:04:00Z</dc:date>
    </item>
    <item>
      <title>Can you want to post a pic…</title>
      <link>https://community.blueprism.com/t5/Product-Forum/Identifying-End-of-Table/m-p/89905#M40224</link>
      <description>Can&amp;nbsp;you want to post a pic of HTML path generated when you spy one cell of the table?</description>
      <pubDate>Tue, 17 Jul 2018 19:09:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/Identifying-End-of-Table/m-p/89905#M40224</guid>
      <dc:creator>NarendraMundwad</dc:creator>
      <dc:date>2018-07-17T19:09:00Z</dc:date>
    </item>
    <item>
      <title>Please find the attachment…</title>
      <link>https://community.blueprism.com/t5/Product-Forum/Identifying-End-of-Table/m-p/89906#M40225</link>
      <description>Please find the attachment having the HTML path. As you can see, I am not getting the element type as a table.</description>
      <pubDate>Thu, 19 Jul 2018 12:13:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/Identifying-End-of-Table/m-p/89906#M40225</guid>
      <dc:creator>Venkata_Sreedha</dc:creator>
      <dc:date>2018-07-19T12:13:00Z</dc:date>
    </item>
    <item>
      <title>attached the syped table</title>
      <link>https://community.blueprism.com/t5/Product-Forum/Identifying-End-of-Table/m-p/89907#M40226</link>
      <description>attached the syped table</description>
      <pubDate>Thu, 19 Jul 2018 12:13:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/Identifying-End-of-Table/m-p/89907#M40226</guid>
      <dc:creator>Venkata_Sreedha</dc:creator>
      <dc:date>2018-07-19T12:13:00Z</dc:date>
    </item>
    <item>
      <title>here is the output of get…</title>
      <link>https://community.blueprism.com/t5/Product-Forum/Identifying-End-of-Table/m-p/89908#M40227</link>
      <description>here is the output of get table action</description>
      <pubDate>Thu, 19 Jul 2018 12:14:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/Identifying-End-of-Table/m-p/89908#M40227</guid>
      <dc:creator>Venkata_Sreedha</dc:creator>
      <dc:date>2018-07-19T12:14:00Z</dc:date>
    </item>
    <item>
      <title>HTML Element is fine. It…</title>
      <link>https://community.blueprism.com/t5/Product-Forum/Identifying-End-of-Table/m-p/89909#M40228</link>
      <description>HTML Element is fine. It works for me. With your HTML path, delete the last part of it until you reach table and highlight to see if that matches what you are looking for.If not keep going back in the path till you find another table tag.
For eg:
If this is original path
/HTML/BODY(1)/DIV(1)/DIV(1)/DIV(1)/DIV(1)/DIV(1)/DIV(2)/DIV(1)/DIV(1)/DIV(1)/DIV(2)/DIV(2)/DIV(1)/DIV(1)/DIV(3)/DIV(1)/TABLE(1)/TBODY(1)/TR(3)/TD(1)/TABLE(2)/TBODY(1)/TR(2)/TD(1)/DIV(1)/DIV(1)/DIV(1)
You delete the last part so that it looks as below
/HTML/BODY(1)/DIV(1)/DIV(1)/DIV(1)/DIV(1)/DIV(1)/DIV(2)/DIV(1)/DIV(1)/DIV(1)/DIV(2)/DIV(2)/DIV(1)/DIV(1)/DIV(3)/DIV(1)/TABLE(1)/TBODY(1)/TR(3)/TD(1)/TABLE(2)/
Now highlight or try with even shorter path like below
/HTML/BODY(1)/DIV(1)/DIV(1)/DIV(1)/DIV(1)/DIV(1)/DIV(2)/DIV(1)/DIV(1)/DIV(1)/DIV(2)/DIV(2)/DIV(1)/DIV(1)/DIV(3)/DIV(1)/TABLE(1)/</description>
      <pubDate>Thu, 19 Jul 2018 13:38:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/Identifying-End-of-Table/m-p/89909#M40228</guid>
      <dc:creator>NarendraMundwad</dc:creator>
      <dc:date>2018-07-19T13:38:00Z</dc:date>
    </item>
    <item>
      <title>Vsnalam, HTML table is not…</title>
      <link>https://community.blueprism.com/t5/Product-Forum/Identifying-End-of-Table/m-p/89910#M40229</link>
      <description>Vsnalam, HTML table is not in the drop down?&amp;nbsp; I usually check in the drop down and if its a table, HTML table would be one of the options.</description>
      <pubDate>Fri, 20 Jul 2018 20:08:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/Identifying-End-of-Table/m-p/89910#M40229</guid>
      <dc:creator>Anonymous</dc:creator>
      <dc:date>2018-07-20T20:08:00Z</dc:date>
    </item>
    <item>
      <title>I faced a similar issue…</title>
      <link>https://community.blueprism.com/t5/Product-Forum/Identifying-End-of-Table/m-p/89911#M40230</link>
      <description>I faced a similar issue before - except that BP was able to identify my element as a table, but there was some issues in the retrieved data.
Not sure if this will work for you but you can try.
Look into the HTML code of the table, and find an identifier for each row. For example, my table was a result of searching for a particular policy number. Hence, if there are 5 rows of data, there will be 5 instances of ""searchvalue=P1034I32"" in the HTML code.
Use 'Get HTML' action to retrieve the HTML of the element.
Use Len() function to get the&amp;nbsp;number of characters&amp;nbsp;of the (1) table identifier (2) HTML code of the element.
Use&amp;nbsp;Replace() function&amp;nbsp;to replace the table identifiers in the HTML code to&amp;nbsp;blanks. Get the number of characters using Len() again.
Number of table rows = ([Count of HTML]-[Count of Amended HTML])/[Count of Table Identifier]
This saved me up to 2 minutes, as the timeout was taking around that much time. The above steps took only a split second when used in control room.</description>
      <pubDate>Sun, 22 Jul 2018 15:47:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/Identifying-End-of-Table/m-p/89911#M40230</guid>
      <dc:creator>BellaKoh</dc:creator>
      <dc:date>2018-07-22T15:47:00Z</dc:date>
    </item>
  </channel>
</rss>

