Task pauses for 20 seconds extracting data

[moorebrothersmusic]

I'm extracting a single field of data (stock availability) from a webpage to a variable after performing a search on the product code from an excel sheet. I then paste the extracted field into the excel sheet and move to the next record. The task hangs on the extract data line for about 19 seconds with each loop. I believe it goes quick on the first extract then hangs on each subsequent extract.

Any thoughts as to why it's so slow to extract a single field and update the variable with the new value?

Thanks!
Scott

[forumsupport]

Hello,

Is it possible for you to upload your task so that we can look into it and suggest viable solution?

You can locate your task by selecting your task from Task List, right clicking that particular task and selecting 'Locate on disk' from context menu.
It would help us investigate further.

[moorebrothersmusic]

Here's the atmn file attached. Below is some test data for the excel sheet lookup beginning in cell A12 and spanning 3 columns: A -C:
HMG EXL10 6193
HMG EXB10 6199
HMG EXB15 6206
HMG EXL16R 6214
HMG TUBE12 7483
HMG KBA16X 7485
HMG KBA65X 7487
HMG KBA100X 7488

Thank you very much!
Scott

[moorebrothersmusic]

I forgot to mention it hangs in Line 39 (extract data) after the first extract. Line 40, which is currently disabled, acts the same.

[forumsupport]

Hello,

The task is moving one cell right instead of one cell down in excel to get next product id. We have amended the task for your convenience.

Please copy it under location, 'C:\...\My Documents\Automation Anywhere\Automation Anywhere\My Tasks' folder.

Please let us know how it goes.

[moorebrothersmusic]

The issue is the data extract line from the website. After the initial data extract is assigned to the $availability$ variable and posted to excel, it sits on the data extract line for 20 seconds each and every time it comes up in the loop.

What do I need to do differently to speed up the data extract from the website?

Note:
The navigation around the excel file works fine. I noticed you changed the IF statements to Loop While statements. I wasn't able to get your Loop While $productid$ Not Equal to "" to work. I wish the Variable Manager would display the current value of the variables. I'll incorporate these changes after the data extract speed issue is resolved.

Thanks,
Scott

[forumsupport]

Hello,

To speed up task execution, insert 'Extract Table' command instead of Extract data and using 'Loop for each row in Internet Explorer table command' fetch the desired column value. For some reason website is giving database error after clicking Search button so we are unable to amend the task.

The task that we uploaded works fine for us. Can you upload the task that you amended at your end? As we said in previous post before end loop you need to move one cell own instead of one cell right.

Hope that helps.

[moorebrothersmusic]

Extract table is MUCH faster. I've gone from 20 seconds per record down to 6 seconds. A couple of issues:

1) First and foremost: I have the task working well chugging away at data until around 30 records AA crashes completely.

2) Secondly, if my search query results in a single record returned, the table number on the page is 7. If multiple records are returned, the table number is 8. I have some long-winded logic including a variable that switches back and forth between 7 and 8 depending on whether or not multiple records were returned. It works but it is not elegant by any means. Is there a better way to extract a table without referring to the number?

Attached is the latest version of the task.

Thank you very much!
Scott

[moorebrothersmusic]

I ran it a few more times and the error I get is:

Run time error '28"
Out of Stack Space

Any idea what this means?

-Scott

[forumsupport]

Hello,

This is very strange as we are not able to reproduce the issue. However, let us investigate.

Can you try running the same task from main screen of Automation Anywhere and not from the Task Editor?

Hope that helps.