Skip to main content

Forums

Activate your network - connect, collaborate & be inspired.

5045 Topics
P
Prashant MCadet | Tier 2
asked in Developers Forum
Database querry for CSV

can we update CSV file data using the query? UPDATE [MissingCustomers.csv]SET [PASS] = 'TARUNA'WHERE [PASS] = 'NA';

1153
S
6 months ago
C
chloeVCadet | Tier 2
asked in Developers Forum
Extracting Invoices into One Excel File in Document Automation

Hi everyone,I’m curious to know if it’s possible to extract all invoices processed through Document Automation and consolidate the extracted data into a single Excel file as its result? If anyone has experience or insights on how to achieve this, I’d greatly appreciate your guidance!Thank you!

692
C
6 months ago
T
thomas.gawda
asked in Community Edition
Loop through rows in table and assign values

I have a table with one input column and one output column. I would like to loop through each row in the table, feed the input column value (pre-populated) into an external bot (Task Bot: Run), and map the output into the output column for the row associated with the input. I’d like to loop through until completed.I’ve tried using ‘Loop - Data Table - For each row in table’. This works fine and the loop runs through each row. However, I need to keep track of which row to write into. I’ve assigned the current row a Record variable (‘CurrentRow’), however I can’t later refer to this as a number. Is there a ‘key’ I can use for ‘Multiple variables’ mapping? How else can I keep track of the row the loop is on? Is there a more elegant way than creating a variable that is increased by one every time the loop runs?I then use the ‘Data Table: Set value of a single cell’ action to write the Task Bot output into the table output column. Column by Name/Index works fine. I can also set the value of

3971
Aaron.Gleason
6 months ago
T
thomas.gawda
asked in Community Edition
Wait for URL change

How can I wait for a URL to change before moving to the next step? I know there is a “Wait for condition” Action but I’d need to find a way to extract the URL into a string and set up a Loop checking if the string has changed every so often. Is there an easier/simpler way of doing this? The page can take a variable amount of time to load which is why I need this rather than a Delay.

884
Aaron.Gleason
6 months ago
D
Daan 7112Cadet | Tier 2
asked in Developers Forum
Error SharePoint Update list item - illegal parameters

Hi all, hope you can be of help to help me continue with this bot.We create a bot that extracts data from a SharePoint list to create a .txt file to be uploaded in another program. It only extracts data that has the '’Pending upload'’ status.After the .txt file is created I want the bot to change the status to '’Upload completed'’.I try the action SharePoint: Update List Item and I want to use the SharePoint Discovery Assistant tool - I fill in all the parameters but instead of connecting I receive the following error:Please help me with the following steps - with what reason I should contact my system administrator?Is there a way around? Do I need to use this Discovery Asssitant? Many thanks in advance! 

200
D
6 months ago
M
mdsahilkaifNavigator | Tier 3
asked in Community Edition
How can I set color to excel sheet cell using excel advance action?

how can I set color to excel sheet cell using excel advance action, as their is not any action present to set color. It is only present to office 365 Excel action package.

7122
S
6 months ago
Polyana 8891
Polyana 8891Navigator | Tier 3
asked in Community Edition
Excel name conflict with _FilterDatabase when openSpreadsheet

I often have this problem when I need to open an Excel file that is manipulated a lot by people and bots. If the file is changed several times, there comes a certain moment when the file opens with this “Names in conflict” message and the “openSpreadsheet” action never ends, unless a new name is manually defined and thus the action continues normally. Unfortunately, it is not possible for the bot itself to define the new name, because as mentioned, the action of opening the base does not end until the new name is defined. Any ideas on how I can resolve this issue?  

16107
Dougras
6 months ago
S
SudineniCadet | Tier 2
asked in Community Edition
When is the deadline for upgrading AA360 applications to use v2 versions of the endpoints stops working?

"From Automation 360.33, the POST v1/authentication, POST v1/authentication/token, and v1/usermanagement API endpoints are discontinued and will stop working. Update your applications to use the v2 versions of these endpoints."Will it impact rest web api services and the automations where we use Api to connect to snow or any other processes if we don't upgrade the AA360. When is the deadline for upgrading AA360 applications to use v2 versions of the endpoints stops working?

1083
Aaron.Gleason
6 months ago
Stefanie
Most Valuable Pathfinder
StefanieMost Valuable Pathfinder
asked in Developers Forum
Sugestion for new group/role: RPA Infrastructure

Hi Pathfinder-Team,I miss the role RPA infrastructure and the corresponding group.In our RPA CoE we have three tasks: RPA lead, centralized development and infrastructure. For Automation Leaders and Developers the corresponding groups already exist. But not for RPA infrastructure.Our infrastructure team is responsible for the whole technical setting: Installation, configuration and administration of our controlrooms, user/role management, deployments from dev to prod, installation of bot agent on the botrunners, support of our citizen developers, support for production problems, set up schedules.An exchange of ideas and best practices would really help us to improve.Regards, Stefanie

432
Stefanie
Most Valuable Pathfinder
6 months ago
M
Mauritz.YCadet | Tier 2
asked in Developers Forum
Authentication API v2 issues

We have used the new V2 version of the authentication API post request however we are getting an error with the code UM1117. We then added X-Authorization to the headers and it complained it can't be empty but how can it have a value if we are doing the post request to get the token?Could you please assist?We have tried it with the username/password and username/apikey. We have also checked for special characters and we are using the once that are allowed. Not sure what the payload and the headers should be as the API document does not indicate it as with V1We have used the below link as guidance, but have been unable to connect successfully.https://docs.automationanywhere.com/bundle/enterprise-v2019/page/auth-api-supported-v2.html?_gl=1*17ppmdr*_gcl_au*MTcwNzQ1Nzg5LjE3MTgwMDY4NDA.*_ga*MTI0MDYyMjUyMy4xNzAxNzczNDAw*_ga_DG1BTLENXK*MTcyMTExNzUyMS44My4xLjE3MjExMjM2MzMuNDkuMC4w&_fsi=enqavaPd

1000
M
6 months ago
A
Ankireddy SudhaGround Control | Tier 1
asked in Developers Forum
Complexity Assessment Document

Hi team,Good morning/afternoon/evening.I am requesting to everyone, does anyone have Complexity Assessment template. If yes, I am requesting you, please share with me.Thanks & Regards,Anki 

250
A
6 months ago
R
RSANTOSGround Control | Tier 1
asked in Developers Forum
Requirements and Steps for Implementing Device Pool in AA360 18xx - On-Premises

I would like to know the steps to implement the Device Pool feature in my AA On-Premises infrastructure. I currently have 3 Bot Runner licenses, and each one always runs on the same device, but it would be more optimal to implement execution based on availability. Thank you in advance for your responses.

411
Tamil Arasu10
Most Valuable Pathfinder
6 months ago
K
KondreddyGround Control | Tier 1
asked in Developers Forum
Error while installing automation anywhere MSI download from boat store

HiI am getting error while installing Compare PDF Documents msi downloaded from boat store (https://botstore.automationanywhere.com/bot/compare-pdf-documents). in the bot store it was showing requirements as My current control room build is 22255. and Bot agent version : 22.40.20 do any one know solution to this problem.Thanks, 

461
Tamil Arasu10
Most Valuable Pathfinder
6 months ago
M
Mark MCadet | Tier 2
asked in Developers Forum
Run-As User only Runs on Runners 1, 3 & 4 but not Runner2

We have four runners named 1, 2, 3 & 4.  When running bots using the “Run-as User” option and select all four runners and tell a bot to run on “1” device, the bots will only deploy on Runners 1, 3 & 4.  If all three of these devices is in use and Runner 2 is available, it will simply queue up the bot and wait for 1, 3 & 4 to be available.   Runner 2 is set up the same as Runner 1, 3 & 4, and used to work previously this way, but no longer does.  Runner 2 will run bots if you specifically select Runner 2 as the only device to run on.   All four unattended runners have their own specific user/device assigned.  We do not utilize queues or device pools.   Anyone else run into this issue?  

500
M
6 months ago
L
lawrtan8Cadet | Tier 2
asked in Community Edition
Unable to launch software

I installed the community edition and was able to install the application successfully. My PC meets the hardware specs and I am on windows 11 and using trendmicro.I tried launching the apps a few times and was not successful. Have done the following:a) Reinstall and restarted the software. No reported errors.b) Disabled TM to ensure that this is not causing the issue.c) Tried to launch again.The apps just wont launch.Can anyone assist please?ThanksLawrence 

362
L
6 months ago
M
Mamatha 1214Cadet | Tier 2
asked in Developers Forum
API endpoints

Hello,“From Automation 360.33, the POST v1/authentication, POST v1/authentication/token, and v1/usermanagement API endpoints are discontinued and will stop working. Update your applications to use the v2 versions of these endpoints.”I’m getting this popup when I open control room. Will it impact the automations where we are using API’s in the  automations to connect SNOW or any other process, if we don’t upgrade the version.Could someone please give more info on this.

470
M
6 months ago
M
mumanohaGround Control | Tier 1
posted in Community Edition
I don't find Generate API key option in My settings page of Control Room.

I am new to A360, I created a Community Edition using my company email. I am trying to Calling Automation 360 bots from Apigee following this doc link - https://docs.automationanywhere.com/bundle/integrations/page/integrations/A360-Apigee-Integration/integration-json-files.html. I don't find Generate API key option in My settings page of Control Room. Could you please help?

1391
jshaji
6 months ago
K
KeetzNavigator | Tier 3
asked in Developers Forum
The Control Room license is expired - Not able to login to community CR

Hi Team, I’m getting “The Control Room license is expired” error in community edition. And some of my colleagues also experiencing the same. Please have a help on this.Error image attached below. 

663
karanlahase
6 months ago
T
TWGGround Control | Tier 1
asked in Community Edition
Device will not connect in Control Room

I am having difficulty connecting my device/laptop once I log into the Community Edition control room.As a new user, my device has never successfully connected.  Are there suggestions on what to try or support articles to review that will help getting past this issue?

491
Aaron.Gleason
6 months ago
A
Avinash PCadet | Tier 2
posted in Community Edition
Unable to reset password for community edition

Forgot Password and security questions to reset password. Please advise

473
rima.sengupta
6 months ago
L
LcondeGround Control | Tier 1
asked in Developers Forum
Community Edition license expired...

Having the same problem as many others. Started the training months ago and when I have some time I want to continue but every time I have the same problem. Can’t even open the control room on community edition. “License not found” the only option is logout.Many others posted the same issue. How can a company like this, providing the services that it’s providing, not being able to solve this issue for everyone.. it blows my mind.

400
L
6 months ago
P
Pinky 8574Navigator | Tier 3
asked in Developers Forum
creator ID has been deleted how can we restore

creator ID has been deleted how can we restore

50
P
6 months ago
B
BPK 2019Ground Control | Tier 1
asked in Developers Forum
How to resolve the issue if bot has struck while running and unable to run bots?

Hi all, I'm using Community addition A360. I have run the bot and it struck in the Middle of the process and its not getting fail or stop and I'm unable to resume that and unable to run other bots. It is showing already bot is in progress you unable to run another bot. I tried by uninstall the bot agent and installed but it wont work. Please give me solution for this. Thanks in Advance.. 

14084
W
6 months ago
A
ahmed 2049Ground Control | Tier 1
asked in Community Edition
Read Email in Automation Anywhere | Dictionary Variable Introduction - Automation Anywhere A2019 #06

 

231
Aaron.Gleason
6 months ago
M
maxcanavanGround Control | Tier 1
asked in Community Edition
Task Listed As Complete but Nothing Happened

New Community Edition AA User here. Every time I click “Run”, I end up with one of the following results:“Your bot has run successfully” but no matter what action(s) I choose, it does not actually execute. For example, trying to open a new window (IT Bricks from the Citizen Developer Basics) using “Browser: Open” I get the success message but nothing has actually happened. The bot is unable to run and just stalls out and continues to buffer.I have installed the AutomationAnywhereBotAgent and connected my Local Device already and have verified that these items have been done properly. Any solutions come to mind?Thanks!

170
M
6 months ago
Terms & ConditionsCookie settings