Developers Forum

 I have a header in a dynamic row, after finding the header I have to read and write data from specific columns to output an excel file. I am able to transfer data. But not able to stop iteration through all rows after finding the header.         

The new feature "Automatically select the number of Bot Runners users" announced in the v.27 release is a great solution.However, there is one troubled case.When a Bot is registered in multiple Botrunners and tries to execute a task in an available BotRunner,If even one of the registered BotRunners is disconnected, the bot itself will not be executed.Ideally, even if there is a Bot Runner that is disconnected, I'd like them to execute bot by rest available BotRunner.Is this feasible?v.27のリリースで発表された新機能「Automatically select the number of Bot Runners users」は素晴らしいソリューションだと思います。ただし、試したところ、困ったケースがあります。Botを複数のBotrunnerに登録して、利用可能なBot runnerでタスクを実行しようとした際に、登録したBotRunnerの内に１つでも接続が切れているものがあると、Bot自体が実行されない、という動きになります。理想は接続が切れているBot Runnerがあっても接続されているBotRunnerで実行されてほしいです。実現可能でしょうか？

I could not find a list of all supported python libraries when using python scripts with Task bots (not in IQ Bot!). Is there such a list? Or a different way to find out? :) I am using Cloud version of Automation Anywhere 360.

I'm trying to map the fields on the Power Apps website, but when using the normal recorder, it loses the reference when running, I tried using the AISense recorder but it's not working, does anyone know any other way to map this screen ? 

Hi all, I am receiving the below error during bot running in v11, The database query is running accurately manually but showing an error during the process, don't know about this.“ you have an error in your SQL syntax check the manual that corresponds to your MySQL server version for the right syntax to use near " "1” 

This is Automation 360 build 16685, I am migrating a task from A11 to A360 build 16685.I try to use recorder:capture and wait for window actions, but it doesn’t load windows, it seems always loading.says “notifying device”...Can you help?

I am using A360 V26 and when I tried to use recorder to capture HTML element in edge IE mode, it always capture the whole screen instead of element I want, but when I switch back to original IE page, it works fine again. I know that only version after V24 will be able to use recorder in edge IE mode but I already updated my A360 to the latest version so it seems like there’s some kind of bugs that don’t allow user to record them in edge IE mode. Thanks for all of your support in advance.  

If I have an excel sheet with column Employee ID, this column has got 1000s of values. I wish to display these values on AARI form so that user can select 1 of them and then on selection that value is sent downstream to the bots built(say just show message box on value selected and sent back). Key here is , how do we show those 1000s of Employee IDs from excel or say even reading from WLM queue on AARI form.

how to compare empty with a string   

I have uploaded  IQ learning instance from Dev to AT environment after migrating from 11.3 to 360. import and deployed in UAT. Now I am trying to take backup and download.Backup was successful, I am able to see the file in output folder but when i try to download i am getting  404 Error ( Error while downloading file) Request URL: https://URL/IQBot/api/backups/1bda1385-a40b-4171-82f7-b6105d3a98a8/download Request Method: GET Status Code: 404 Not Found I can see file in output folder with 1bda1385-a40b-4171-82f7-b6105d3a98a8-ATPRODMIGRATION_20230215_183015.iqba Let me know if any one having same issue with A360… 

Hi everyoneI found an error about create workbook in google sheet “An unexpected error occurred. null Please contact system administrator.”  So how can i solve this error 

Issue :: A360 - Control room is down due to DB issue Error ::connect timed out. Verify the connection properties. Make sure that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port. Make sure that TCP connections to the port are not blocked by a firewall. This issue related to DB, password may change, DB serer may rebooted during maintenance window or networking issue to reach DB. Resolution:Restart A360 Services :  Restart the Control room services in the following sequence -Automation Anywhere Control Room Elastic Search service Automation Anywhere Control Room Caching Automation Anywhere Control Room Service Automation Anywhere Control Room Bot Compiler Service Automation Anywhere Control Room Storage Service Automation Anywhere Control Room IQBot Service Automation Anywhere Control Room Robotic Interface Service

Bot Insights/Analyze is failing to grab data. I have a bot that runs a bunch of smaller bots and when the smaller bots are run individually the data will populate in the dashboard. However, when run with the larger bot, the data isn’t populated and is completely lost. Is there a reason for this?I would appreciate any help that anyone can give

Hi, I’m a student who’s trying do assignment in Automation anywhere there’s some table data i have extracted from a pdf as a string variable.100 Clear front covers $0.49 $49.00 100 Black rear covers $0.99 $99.00 100 Color copies (pages 1-2) $2.99 $299.00 1000 Black and white copies $0.25 $250.00  I want to manipulate this string and get data separately I'm thinking if I can loop this string and get one by one rows to manipulate and get Like 100, Clear front covers, $0.49, $49.00. Thank you :)

Hi,I want to execute an sql select query, which will return a single value and use that value for the next step in automation. Can I directly get that value after the query execution or store that value in a variable.

Hello,I’m trying to do the following authenticate using the post method instructed here - Authenticate with username and password (automationanywhere.com)And while the following works:{ "username": "your-domain\\jdoe", "password": "mypassword@123" }I want to use my credential variables from my locker instead but that throws up an error:{  "username": "DOMAIN\\$TEST(Username)$",  "password": "$TEST(Password)$"} The resulting error is - {"code":"UM1110","details":"This may be due to a misspelling or because your Caps Lock is on. To continue, please retype your username and password.","message":"Either your

Hi,Just wanted to know how to convert the message in message box into text file.Please help me.

I am just curious if others have given up on this action working, or have found any scenarios where it is useful? I have had a ticket in since last year and keep hearing “that technology is not fully implemented yet, it will be someday”. Makes me wonder why it is included in the product if it is not ready for prime-time, as I have lost count of the number of customers this causes frustration for.So far it seems anchors only work if you are using AISense Recorder. Otherwise, you get the error below when you click on any element as an anchor, whether you’re using auto-detect or MS UI Automation options:  

Hi Team,I am looking for resources to integrate and automate business processes which have been using Sharepoint site files system.  I am interested to know the ways to integrate Sharepoint sites using AA Independent Bot Components i.e. (Without using any script language support like C#, Python, VB Script etc) .  Would you be able to advice in this . Many Thanks 

I could not able to add my device credentials in A360 control room

I am trying to run a python script. It runs on my computer, the bot runner, but nothing happens when I try to run it in Automation Anywhere. It produces no errors but does not function as if I ran it on my machine. Why is this happening?

While executing the bot I am facing below issue..Could you please help me on this.. 

New to AA so forgive me, spent too many hours trying to troubleshoot this, have seen posts from google search that also had it but no definitive solution and most of those old questions seem to have been purged from AA (sure wish they had not been removed or it could help!).Meticulously went thru this tutorial:https://docs.automationanywhere.com/bundle/enterprise-v2019/page/enterprise-cloud/topics/aae-client/bot-creator/advanced-bots/cloud-build-bot-python.htmlHowever, get “bot error” returned from the python function on line 4.Have also tried the simplest possible function returning just a string - same “bot error”.  How do you properly troubleshoot and resolve this thing?  Have looked at logs in C:\ProgramData\AutomationAnywhere\BotRu

Hello team,I was trying to change the emails status from read to unread from outlook. I am getting an error. error  message “The requested action is not supported for the selected Email connection type - Outlook. Please choose a supported Email connection type and try again”

How to get AA 360 enterprise trail version?