Developers Forum

How to extract data from 2nd table in IQ Bot based matching a column with tbale1 and update a column in Table1 

Can someone please help me with this. In below image i have 2 tables in IQ Bot, where I need to match Item_Total of 1st table with Itemtax1 of second table and update Item_Tax_Rate of 1st table with itemtax2 of table2.Ref Image 1 attached.   I tried executing the code shared by you but getting error as it says table2 not recognizable.Can you review below and suggest.Ref Image 2 attached  Thanks in AdvanceRegardsAman

Can I wildcard the value of Assign String variable? Example:filepath1 = Users\Desktop\File1.csv (Declared as true value)thenAssign String filepath1 = (Wildcard Path) If yes, how?If not, do you have any workarounds? Thank you!

Hi,Please help me to clarify below questions about A360 AARI5.1.The workflow steps can be dynamically added. For example, a manager may be able to route the transaction to additional levels.2.A specific high level invoice may need two levels of approval. The steps in a workflow should be configurable. 3.Is AARI allowing non English languages4.Steps of the workflow may be done manually (by people) or by service end points (APIs) or bots.5 In Invoice processing (AP) Status of each invoice request must be traced through the whole transaction6.Should have ability to pull comprehensive status of each transaction - covering -- Reporting status of each transaction- Time it took at each step of the workflow- Delinquent users who held up the workflow- SLA reporting7.Notifications like email and stuff on completion of parts of workflow8.Allowing other organizational users also to act (e.g. approve, confirm,

 Hi All,I am getting the above error, I am already restarted bot agent again facing same issue.any one help us  RegardsKrishna

Data is not getting exported after expecting the Stored procedure using run stored procedure command in A360. Can someone please help on this issue? (Database connection and connection strings are working fine) 

"How can I copy information from different Excel files and paste it into another file?

Every time all web elements will changeDomx path will not work Please suggest me how can do this!!

Hi,I am using Run Stored Procedure command to execute a SP and get the results in CSV.However the connection and SP is working fine but the results are not populating in CSV File.Can someone please help on this ?Note: Connection is perfectly fine, manually SP giving the results in SQL. No additional parameters passed Thanks,

Hi, I have a bot that is logging into an application.When I execute a process trough the control room on closed session, the process is failing at entering the credentials. It only types 4 caracters out of 16 . But when I connect to the remote resource and looks at the screen it works. In both cases it is executed trough a bot runner.What are the common reasons for which it does not work on closed session?  Kind regards

The title sums it up. I have a data table with 5 columns and 125 rows. I know that the value I need is located in the first column in the first row (not header row). The cell location would equate to “0, 0”. Is there a quick way to do this in A360? I would like to avoid a loop as it requires more code/variable overhead than I want.

Hi,Please help me to clarify below questions.we require some infra structure for Control room like 64 bit window server.What all infra are required for Bot creator, Unattended and attended bot runner,AARI Desktop,AARI web,IQ bot and document automation Thanks,Ardra 

I have one excel file with config values. How to loop through the excel file from which I will get the following result. Attached sample excel file.so i will be creating three variables- vWayneID, vDavidID, vBrunoID after looping vWayneID should get assigned with 10, vDavidID with 7 and vBrunoID with 8

it is showing an that “error bot is running in the system for further inquiry contact system administrator”.

Hi,After the deployment of a bot in production, is that require VM/server to set up Bot runner.What all all servers we need?What are the bot runner requirements in production.?Can we run the bot without the bot agent in Production.?Thanks,Ardra  

Hello, I would like to know if it is possible to extract the code of a bot or an entire bot as a .txt document in AA360?

When bot trying to capture a table by using recorder - capture or universal recorder a pop-up message arrived as “load library failed with error 126: the specified module could not be found” Requesting you to please suggest some solutions on it. Thanks & regadrs,Shivam Jagga 

Hi, I am trying to fetch the status of a device if the device is executing a job.Using the API link “v2/devices/list”. Below is the response:{    "page": {        "offset": 0,        "total": 1,        "totalFilter": 1    },    "list": [        {            "id": "48",            "type": "SINGLE_USER",            "hostName": "ALMDBSSAA6024",            "status": "CONNECTED",            "poolName": "",            "updatedBy": "62",            "updatedOn": "2023-08-16T15:46:52.917400200Z",            "botAgentVersion": "21.222",            "nickname": "",            "description": "",            "maxCount": 1,            "defaultUsers": [                {                    "id": "62",                    "username": "bot084",                    "domain": ""                }            ],            "lifespan":

Hi everyone,I’m facing an issue and I wanted to know if anyone has faced it before and have some advice.In one of my bots I use an “If file exists” command checking a folder for any PDF file. Line would be: If File Exists \Path\*.pdf.And then I’m using a loop while file exists \Path\*.pdf and in both cases the automation spends several minutes evaluating the conditions, which hinders bot productivity.Does anyone have an idea that could help me solve this? Thanks.

  Hi.I’m using automation anywhere.When I try to capture a INPUT using the Recorder for some reason looks like it moves o simply recognize the control lower.The funny part is that just happen in one server, when I tested in my end it works fine, when I tested in the QA server, It also work fine but It’s deploy in productive I got this error.During the execution everything goes fine but when the control is reach and the robot sends a backspace something happen that make it lost focus and the value is not updated. 

Hello, Is there a way to be notified of when a bot fails to deploy or when a bot times out?   Thank you!

We’re leaning into what our customers need from us in through training and enablement at Automation Anywhere.Good, bad, indifferent - I want to hear about your experience with Automation Anywhere University and more broadly, your journey in learning how to use Automation Anywhere. What has helped you learn the most?What learning style has best helped you get up to speed quickly on new topics?What did you like/not like about going through AAU materials?100% Just trying to understand feedback from our Pathfinder Community so all future content we create can be as effective as possible in helping you accelerate in your learning.

You may or may not be aware of the inline variable shortcuts that exist within the A360 bot editor. For instance, if you want to convert a number variable to a string so you can display it in a message box, you could add a “Number: To string” action into your task, like so:Added Number to String ActionYou just added 1 additional action and 1 additional variable to your task. However, you could simply skip this step altogether and just type the following straight in your message box: “myNumberVar.Number:toString”. Voila! You just eliminated a line of code and an extra variable that would otherwise clutter your task.

A team member just shared with me that A360 is capable of making quick variable conversions without having to use additional actions. For example, finding the length of a list as that returns a number type: $lst_Categories.List:size$. This is very similar to Microsoft’s Power Automate Desktop, which I find extremely useful.  Can someone point me to A360 documentation that outlines these types of variable conversion capabilities?Thank you!

I’m trying to connect to AS400, but ‘Driver is Not Loaded’ appears.