Forums

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’m exploring a Help Desk use case with Automation Co-Pilot (AA360).The idea is that a user types a prompt (e.g. “How do I set up the VPN?”) and Co-Pilot searches through uploaded user manuals, then either returns the answer or triggers a bot to perform an action (like password reset or ticket creation).Has anyone implemented or tested something similar?I’d love to hear your thoughts on feasibility, performance, and integration with IQ Bot or document repositories.Thanks in advance for any insights or experiences you can share! 🙌

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.

Hi Techies,I would like to know is there any way that we can retrieve the failed massages (due to invalid email) from outlook using loop in AA360.  regards, 

I am trying to run a python script to parse some data and run some API calls. As soon as the first line of the function is reached, the bot fails, but the script does keep running in the background and completes. I’ve put a return statement in the first line and it does return, but as soon as it hits the json.loads, it fails.def myFunction(jsonString):       jsonData = json.loads(jsonString)    .    .    . Any help would be appreciated. 

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.)

When I am running the bot in a Debug Mode Suddenly Getting The session closed error and I am not able to debug any more But bot running window stays without closing  

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?

Hi All, Is there a way to hide the Bot Running… tile when running bot manually. I am trying to compare a scree capture so it will be more accurate if I can exclude the tile in the capture action. Thanks! 

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

My version of community edition is not including element API Task. How do I upgrade the edition I am using for university training?  

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?