Skip to main content

Forums

Activate your network - connect, collaborate & be inspired.

5522 Topics
A
AA360SnailGround Control | Tier 1
asked in Developers Forum
Couldn't find "" Sheet in Macro Excel Using Excel Advanced

I’m using Excel Advanced to open a macro file on version 21.112 or above. Recently, I’ve ben running into an issue where the macro file does open but the bot crashed saying it cannot find a sheet. “Unable to find sheet '' in file …” is the message I receive when attempting to run.The first time this issue appeared was on 12-20-2023, and ever since, the bot has continued to crash when being run manually or scheduled. I’ve attempted to select a specific sheet in the same Open Excel Advanced action, but it provide the same error, just with the selected sheet within the apostrophes of the message above. I’ve also tried unhiding all sheets, graphs, and everything in-between, but same issue.Does anyone have a similar issue or have a work around solution? I need the file to be a local excel session so I can manipulate the data within. 

1413
W
H
hemanth.vasanthCadet | Tier 2
asked in Developers Forum
Extract Historical data through control API using start and end date

Hi Team,Required to extract Historical data through control API using start and end date only like bot insight APIthanks in advance

651
H
B
blackpink93Cadet | Tier 2
asked in Community Edition
hello. I'm curious.

  Hello, my name is Rose who is studying RPA in Korea.I'm inquiring because I couldn't solve it while practicing A360.If you look at the captured ExcelI want to find the value in red in sheet2 and fill the sheet3 table with the appropriate value, but I don't know how to use the loop or find it.I want to know the loop, but it is difficult because there are not many lectures in KoreanI searched each item on the site and filled it up, but it's too long.Can you tell me how to make it easier?And I have another question.If I search it directly on the site and set it to import the value in Excel, the value is entered vertically.What is the reason?Thank you.      

752
B
G
gregbowersCadet | Tier 2
asked in Developers Forum
Integrating CPQ with Legacy Systems

Hello I'm exploring the integration of Salesforce CPQ with legacy systems using RPA (Robotic Process Automation) and seeking insights into the challenges and strategies involved in this process. Specifically, I'm interested in understanding how to overcome potential data silos and ensure seamless integration between modern CPQ solutions and older, legacy systems.Some key points for discussion include:Challenges: What are the main hurdles faced when integrating CPQ with legacy systems using RPA? Examples may include compatibility issues, data format discrepancies, and process complexities. Strategies: What strategies or best practices can be employed to address these challenges effectively? Are there specific RPA techniques or tools that prove particularly useful in this context? Data Silo Mitigation: How can organizations mitigate the risk of data silos arising from the integration of CPQ with legacy systems? What steps can be taken to ensure data consistency and accessibility across a

530
G
S
smanojkGround Control | Tier 1
asked in Developers Forum
Need for user presence while running bot inside the server and scheduling options.

Hi,I tried to run the bot inside the server using citizen license. while running the bot, i have minimize the server and bot has been stopped running. is it necessary to keep the screen without disturbing while running even inside the server ?Do we have scheduling options to schedule the bot  or something like listener option to trigger the bot once file is placed into the folder.  

190
S
P
prasadnGround Control | Tier 1
posted in Developers Forum
'LIMIT' SQL query not working in A360

Limit sql query not working in A360 .Please help 

300
P
Ganesh Bhat
Most Valuable Pathfinder
Ganesh BhatMost Valuable Pathfinder
posted in Developers Forum
Seamlessly Switch Between Runner/Creator Devices in Automation Anywhere Control Room Without Uninstalling Bot Agents 😊

Switch Bot Agent to a Different Control Room Are you tired of constantly switching between devices for your Control Room login, only to be greeted by the frustrating error message, "This device is already registered with another Control Room"? It's a common hiccup we encounter when juggling Control Room logins on the same device. But fear not, for there is a solution at hand! Understanding the Issue:Before we delve into the fix, let's dissect why this error occurs in the first place. The Control Room associates each device with a unique registration, allowing only one Control Room per device at any given time. So, how do we resolve this issue and effectively delete the device registration? Deleting or Renaming registration.properties File: Here's the answer: Navigate to the Registration properties File Path: C:\Windows\System32\config\systemprofile\AppData\Local\AutomationAnywhere. Once there, locate and either delete or rename the "registration.properties" file. With this step complet

1640
Ganesh Bhat
Most Valuable Pathfinder
S
Semih 3318Pathfinder Advocate | Tier 6
asked in Developers Forum
Why can't I send png file visible in email body?

I did this many times, and it worked.Now i created a task.In attachment I added “C:\Users\botcreator1\Desktop\invoiceKumulatifKontrol.png”and in email body, <img src="cid:invoiceKumulatifKontrol.png">but it sends it in attachment. What should I do?

721
S
D
Deepak BasarCadet | Tier 2
asked in Developers Forum
unable to read latest files from the folders

hi i am using file folder trigger to run the bot .when new file is added in folder bot has trigger and read newly added xml file .but somtimes two or more files are added in the folder at same time  (suppose 5 files added at same time the bot is triggered 5 times but it reads only same file each time .I need read those 5 files one by one). i just want to read newly added latest files not exesting files how i overcome this problem . (Note: latest file is comes at first index always)

1491
S
S
Sergio SouzaGround Control | Tier 1
asked in Developers Forum
Handle sessions in a custom package

Hello,We are creating a special package that will have actions to connect and disconnect from the database and some actions that will manipulate data in a table. For the actions that will manipulate the data I need to pass the handle of the connection created in the connect action. how do I do this?The explanation "Handle sessions in a custom package" in the documentation gives some light but does not have some clear points. Does anyone have working example code?I need it to be a customized package because we will manipulate data that cannot be visible in the automation. Thank you for any helpSergio Souza

240
S
A
AnalystCallenCadet | Tier 2
asked in Developers Forum
What is the best way to compare versions between what is in Public compared to Production Control Room?

We currently do not have a Sandbox environment. Most of the time, our Public Control Room matches the Production Control Room. There have been times where we have noticed the two CRs have bots with different versions unexpectedly (e.g., we did not push something to Production so it sat in Public). What is the best way to compare tasks/module versions in Production versus what is in Public?

763
K
A
AegisGround Control | Tier 1
asked in Developers Forum
File trigger, unattended

Hi, I have a problem with trigger.Last week I created a bot with file trigger, moved it to prod CR and created Event trigger. For few days, the bot worked almost as it should. It really ran after the file appeared, there just were in history some weird task with failed status on the same VM.I did not care about the error much, because the bot ran as it should. But this week the trigger stopped working. It is weird, because noone changed anything. I still use same folder, same bot, same trigger. Now, if there is new file in the folder, trigger is not activated and the bot does not start.Does anyone please know, why the trigger stopped working?

1521
K
Q
Quentin 721
asked in Developers Forum
API Syntax to look for job(s) in the last 1 hour

Below is the Body syntax of an API call for Bot Execution Orchestration (v3/activity/list) to return Completed jobs with StartDateTime greater than 3/23/24 17:43:53.373733600. Is it possible to write similar to return Completed jobs with StartDateTime greater than one hour ago (current time - 1 hour)? Could someone share sample syntax for that?{  "filter": {    "operator":"and",    "operands":[        {            "operator": "eq",            "value": "COMPLETED",            "field": "status"        },        {            "operator": "gt",            "value": "2024-03-23T17:43:53.373733600Z",            "field": "startDateTime"        }      ]  },  "sort": [    {      "field": "startDateTime",      "direction": "desc"    }  ],  "page": {    "offset": 0,    "length": 10  }}

280
Q
mandarB
mandarBNavigator | Tier 3
asked in Developers Forum
Error connecting to ms sql server

Hi, I’m trying to connect Ms sql sever to AA . i have used connection string: jdbc:sqlserver://localhost;databaseName=Test;integratedSecurity=true;Im getting error : 

1266
Tamil Arasu10
Most Valuable Pathfinder
K
khondokerNavigator | Tier 3
asked in Developers Forum
AARI FORMS Display Integer

Hi , I am currently trying to build an AARI form and I want an element where integer should be displayed without any decimal points.However, I only see the option for the number element which displays integers with a decimal point by default .There is no option to select 0 decimal places in the formatting options of the number element.Is there a any workaround so that an integer like 5 will be displayed as 5 and not 5.0

352
K
P
Prashant MCadet | Tier 2
asked in Developers Forum
Bot Deployment Issue on Production Server

Hi Team,I am currently attempting to deploy the bot on our production server using a different machine(VM). However, I am encountering an issue during run the process.is it necessary to have access of that Production Server?Please refer to the attached document for more details.Regards,Prashant M 

521
Tamil Arasu10
Most Valuable Pathfinder
R
Raghuvir.CCadet | Tier 2
asked in Developers Forum
How to pass and retrieve the result from SQL Stored Prodecure in AA360

If anyone has experience with using stored procedures, please assist me. They save me a lot of time writing SQL queries on the Automation Anywhere command line dashboard. I've successfully created Stored procedure in sql database, and they return the correct results. However, when attempting to run them in Automation Anywhere, the results are not as expected. Is there a specific way or syntax for using SQL in Automation Anywhere? If so, could you please provide a snippet to help me understand? Thank you in advance.

3623
R
P
Automation Anywhere Team
prasad.keshava.krishnaAutomation Anywhere Team
asked in Developers Forum
WLM API - Add WorkItems using file

Hi, anyone tried to use the WLM API to add worktimes to the queue using the fil?https://docs.automationanywhere.com/bundle/enterprise-v2019/page/wlm-api-supported.html#tag/Workitems/paths/~1queues~1%7Bid%7D~1file/postThis API needs the binary encoded format of the file to upload. Can anyone post the request body sample to be used in BOT to achieve this? 

450
P
Automation Anywhere Team
N
nickrpadelaCadet | Tier 2
asked in Developers Forum
Element exists clause in Automation Anywhere

QuestionElement exists clause in Automation AnywhereI have a scheduled bot to run a process and it encounters errors every now and then due to not being able to interact with a webpage element that is still loading. Currently I am using wait delays to let the element load, but is there a way for Automation Anywhere to wait for an element to appear? Similar activities are available in other RPA tools such as UiPath/Power Platform. 

14389
P
P
priyankapriyaCadet | Tier 2
asked in Developers Forum
Calender Date picker issue

Hi Team,I have 25, 26, 27, 28 twice in single month If there is one date iam able to select through click on cellBut if there are 2 dates - It is selecting the previous montha but not current monthPlease help on this

842
Aaron.Gleason
Automation Anywhere Team
A
Aravindh483Navigator | Tier 3
asked in Developers Forum
outlook sending multiple emails at when it executes send email line

When I run the bot first time.it is sending 1 email.2nd time running it's sending same email 2 times3rd time running it's sending same email 3 times I am using send email outlook option

823
A
L
lambert901Ground Control | Tier 1
asked in Developers Forum
How to Assign a runtime string variable to File Variable

In A360 How do i convert or assign a string containing a filename into a file variable. I do see one post with an answer but it is not correct. thanksjimmy

580
L
P
Pinky 8574Navigator | Tier 3
asked in Developers Forum
Unable to connect to the Control Room database.

Unable to connect to the Control Room database, which may affect some functionality. This may be for a number of different reasons: There may be no internet connection or the server that the database is on may be offline. Please check your internet connection.If the problem persists, please contact your system administrator.Code: db.connection.exception

450
P
C
ceso93Ground Control | Tier 1
asked in Developers Forum
ServiceNow authentication

Hi,I am trying to use the package servicenow​​​​​The action is executed but the output dictionary is empty, doesn’t seem normal, right?

250
C
V
Virendrasing RajputGround Control | Tier 1
asked in Developers Forum
I am fetching details from excel and stored in Dictionery variable as key-value pair and want to pass this variable as parameter to another bot? Kindly anyone help me on this scenario.

I am fetching details from excel and stored in Dictionary variable as key-value pair and want to pass this variable as parameter to another bot? Kindly anyone help me on this scenario. I want to get single dictionary variable in child bot.

1081
A
Terms & ConditionsCookie settings