Help! Looping through Data Row Array produces Duplicate Rows at Random when adding to Data Table

Learn Academy Feedback
1

Hello - I’ve been wrestling with this issue for later half of the day today. Here’s a screenshot from my Debug environment. This is what I’m trying to do:

Navigate to the Work Item page. Parse the Account Information details. And then add that into a pre-built Data Table.

As you can see, the Robot has navigated to the correct WIID on the right side at marker 1.
However, when it added the row to the Data Table at marker 3, it has put in values from the previous iteration!
At marker 2, it can be seen that the values on the Web page are totally different!

image
image1326×476 161 KB

When I Debug using “Step into” (terribly slow), it seems to work fine. However, if I hit “Continue” on the Debugger, the very next step runs into this problem.

This also happens when I run the process normally. The robot produces the first two rows as duplicates despite navigating to the correct WIID page. Here below is screen grab from the output Excel:

image
image322×561 21.5 KB

Has anyone had this issue before?

2

Resolved! I had to use a FindImage with a custom selector to wait for the page before parsing the information. Tested it twice, and got identical results with no dupes. Results below for another set of eyes to see. Data is sorted on Cols B and H. However, none of the rows are duplicates

Sharing the fix here, just in case. The custom selector at Marker 1 below will wait for the page with the matching WIID to load before proceeding to parse the client information.

"<html app='chrome.exe' title='ACME System 1 - Work Items' /><webctrl tag='P' innertext='*WIID:*" + WIID + "*Type*'/>"

image
image547×654 45.6 KB

Results of 2 post-fix tests:

image
image729×590 35.4 KB

3

Marked as solution. Ported the project and ran the process from a completely different Robot machine . Results are correct!

4

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.