Developers Forum

I am facing an issue with the Excel Database connection operation with one of the processes where repeatedly getting the error message as “Could not connect to Database. External table is not in the expected format” while trying to connect to the Master file. The same file, being able to open through Excel Advanced Open command at the same time. This issue came across only after combining all Child BOTs into the Main BOT. The issue is not facing when I run that process separately.

Which SAP Command to be used - In case in SAP GUI I get ".key="Z010", I have Used Select Item & Click Menu & Both Failed, Earlier using SAPGUI Script , we have ExecuteSelectComboBoxItem in DLLs , so AA team have developed any command for drop down ?

Object capturing is not working in production, Where as in Dev environment it's working fine both the machine have same configuration 

Hi folks,Looking at integrating a task bot with one of my external APIs in order to trigger the /v4/automations/deploy endpoint. The task bot accepts an input string and input file, but I’m struggling to find any docs on how to handle the file and content inside the task bot. The task triggers successfully using the following botInput object:"botInput": { "sClient": { "type": "STRING", "string": client }, "fFile": { "type": "FILE", "string": encoded_file, "fileName": file.filename } }Am I understanding this correctly? The file is strictly xls/xlsx, content is Base64 encoded.Thanks!Nick

Hi everyone,I have a question. I would appreciate it if someone who knows answer. I have an Excel list with a variable number of rows (sometimes over 1000). I want to loop through each row and check four different variables against four specific columns:Variable1 → Column AVariable2 → Column BVariable3 → Column CVariable4 → Column DIf all four variables match the values in their respective columns, I want to identify which row matches and retrieve the number row of that row.Currently, I am using separate loops for each of the four columns, storing each cell value in a list variable, and then using IF > List Variable condition to compare. This works, but I cannot get which specific cell/row was matched. Thanks in advance

The meeting will be conducted on the specified date

 I am using the Automation 360 Community Edition and repeatedly encountering the error message shown in the screenshot when trying to record a desktop application (Automation Anywhere - Order Fulfillment Manager). The error message specifically states: "An unexpected problem occurred while activating the window 'Automation Anywhere Order Fulfillment Manager'. Please refresh the window list and try again."The Problem Behavior:I can see the window listed correctly after refreshing the browser/window list, but when I click the Capture button, the same error pops up immediately. The critical issue: Reinstalling the Bot Agent or specific packages allows me to successfully capture only one action instance. When I try to Run the entire bot, it fails immediately at the first step that uses a capture action; it doesn't enter any details or interact with the application window at allSteps Already Taken (Troubleshooting Done):Restarted the local Bot Agent service Performed standard uninstall/rein

I am unable to connect excel as DB, getting this error “Could not Connect to Database. Provider cannot be found. It may not be properly installed.”. I have used connection string as “Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Users\msour\Documents\Book1.xlsx;Extended Properties="Excel 12.0 Xml;HDR=YES";” connection mode “Default”. and Microsoft Access Database Engine 2016 64 bit i have installed. when i am going to download 32 bit I am getting error my system already has office 2024 64 bit version so i can't download 32-bit database engine. and 2010 database engine is not found in Microsoft site. anyone can please help me in this issue. Thanks in Advance.

Hello, I encountered a problem with my project where I am trying to set a value in a data table. Due to the project requirements, I am using the current date (i.e. 10/11/2025) as column. When I am testing in attended mode, this works as intended, but when I tried to run it in unattended mode, the bot suddenly cannot find the column I want to set the value to (i.e. 10/11/2025). The error message I am encountering is (Key '10/11/2025' not found in record.)

What I want to do sounds like it should be simple and straightforward, but I can’t think of how to do it in an elegant way.I am iterating through a list of files and scraping field data from each file within the iteration.After I scrape all the info from the file, I just want to add the list of values as a row (record) after the last row in the Datatable.How can I go about this as simply as possible? Or is it possible?

I am trying to execute chrome clear cache python script , but its not working. it’s working in python compiler not in AA tool. Having python version is 3.x and AA python in latest package

I’m having an issue with recorder capture being misaligned, and on running my bot other aspects of the screen are being clicked when they shouldn’t be. The properties of the capture all look correct, I have uninstalled & reinstalled the bot agent, all screens and browsers are set to 100% scaling and no joy. The only way I can get things working is to unplug my monitors (running with a laptop and two monitors), things work a lot better on just my laptop but this isn’t ideal. Are there any other solutions?

Hello everyone, Does anyone know if there is a way to force the use of “HTML technology” for capturing web objects? In the Recorder package, you can select any technology for the capture action, but in my experience, “HTML technology” is the safest and most reliable technology available.Unfortunately, you cannot select this option manually. Perhaps someone knows a trick or has a tip for forcing the Recorder to use HTML technology, or is there an official way that I am not aware of? I look forward to your feedback. Many thanks,Benjamin

Hi,I would like to insert a variable in place of the highlighted static value. (All the other contents of URL are fixed just have to have change the highlighted part with my variable).This would help me read the value from my excel file and change the URL value based on the variable. I would really appreciate your help on this. 

I want to build an invoice extractor for free , in which I can get desired details when I upload my invoice pdf, in a JSON format, I have tried many things like hard code approach, pre trained models on hugging face , docling , donut and layoutlmv3 too , but I am not getting accurate results , the structure and contents of my invoices are different.If anybody can help me it would be great.

Hi,I've noticed a couple of changes in the Control Room interface: The status bar for "In Progress Activity" seems to have been removed and replaced with just a percentage indicator. Is there a way to restore the original status bar view?  the "Hide Bot Run Window" option is selected by default when sending a bot to run unattended. Is there a way to change this default setting so that the bot run window remains visible? Thanks

Hello,Whenever I run a bot that uses Python on my local machine, I run into the following error:Either Python may not be installed correctly, or the Path environment variable may not be set.I have ensured that the latest python is installed on my device and the path environment variable is properly set up, but I still get this error.Has anyone encountered this or know what could possibly be going wrong?

We ran into an “opportunity” yesterday whereas a bot that typically behaves encountered a pop-up that the developer didn’t account for which ultimately lead to the bot executing for over 9 hours. That is being addressed…… however it lead me to question how I, as Administrator, can monitor/manage bot execution times. In our deployments, if a bot runs longer than 3 hours it is pretty indicative of an issue.I’ve been playing around with the APIs but haven’t found a suitable answer.Anybody else think of something?

On one of the webpage  Haing multiple tables with different header and having selectAll checkbox .I have created selector which identifying the elements when we inspect webpagge manually,but when bot tries it can only identify first table checkbox for second one it is neither clicking nor throwing any error.need suggestion on this 

I have developed a bot which would be triggered when an email is received to a specific email inbox. Have developed this bot and checked in the code in public to test this automation in UAT.Under Mange → Event trigger i have added a trigger for this Task bot and its automatic deployment is in enabled state. Yet when i send email to that mail id my automation is not getting auto triggered.What should i do in this case ? My expectation is the bot should be triggered when an email is received to its mail box.Am i missing out any other settings ? How should i make this configurations to deploy a bot with auto trigger ?

Hi !! I have noticed that since last week, two processes that perform clicks on two sites are not working for me. It looks as if the action is being performed, but it is not being applied. I noticed that changing it to the “Click” option in some cases does cause the site to load and display the content, but in other cases, the same action shades the entire site even though the button or an option from a list has been selected. Is the same thing happening to you? Note: I haven't made any changes, but I noticed that since last Thursday, I've had this issue in my Automation 360 with processes that were working normally.

A customer is facing an issue where two different automation anywhere bots assigned to the same device pool are not running simultaneously. When one bot is in execution, the other bot in the same device pool remains in queue until the first bot finishes, instead of running in parallel as expected.

Newer bot builder here, and I just created a Learning Instance in Document Automation where I can extract First Name, Last Name and Case Number for a document. An output file is created successfully for each file I process. I cannot figure out how to extract the PDF file name into the same output file. Is there a way to do this? I need the file name to be extracted into the same output file so the next step in the process it can match up the proper file with the first name and last name to docket the correct file with it in the case management system. 

I am using a recorder in AA 360. My first capture I am using Get Property >>>HTML Inner Text and have this in my inner text list [ Portfolio, Accounting, Contacts, Reports]. Can I use Web Automation: Click Action to search a specific Inner Text? If yes please elaborate. I am new to the platform. Thank you!