Developers Forum

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

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!

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! 

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

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 

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.

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, 

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?  

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.

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. 

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.

creator ID has been deleted how can we restore

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

I have been trying to write my files into a folder, Here how it does it; Creates zip folder after downloading files → Then starts sub routine to unzip → sub routine creates new folder within Property → then begins unzip to that folder → bot completes then resets to check for more downloads. Currently Within this process it will delete all folders inside of Property folder when creating the new folder. We had a large data corruption occur from this and took several hours to pull up backup logs. When I’ve used “Overwrite file” it deletes the files on occassion. If I don’t allow, the process fails as it sees files with the same naming path already. What can I do? Here is a reference to the file pathing looks like 123 Sesame St, New York - Bob Barker - 02-01-24 

Hello,In my use case, we have to process big data and need to clarify the input:Input data is less than 1000 records Input data is more than 1000 recordsSo, I create 2 queue: Queue for “Input data is less than 1000 records” : Processing time: not set  Queue for “Input data is more than 1000 records”: Processing time: from 7PM to 7AMI would like to deploy 2 queue in same device pool,  is it possible?Thanks. 

Please help anyone i couldn't solve the issue of capture its giving me to install plug in whether its in chrome,Firefox i tried everything developer mode,extensions its just not working out and again giving error google chrome plugin either not installed

We have a plug in error by Capture feature. The Plug in is installaled machine restarted but we still have this issue by system called DMS which is run in Edge browser. Other systems on Edge browser are working fine just this one not. The problem is that it appears after some time of bot running. It is working korrectly but suddenly it failes in middle of the run.

I’ve been doing some testing using the number package and math operations. According to the documentation, the number package “ holds values from -9,223,372,036,854,775,808 to 9,223,372,036,854,775,807, and up to 15 decimal digits.” Emphasis mine.I’ve been trying unsuccessfully to add, subtract, multiply and divide where the result should be a decimal. All I’m getting is whole numbers no matter what I feed in. Examples attached.How do you get the number package to recognize and return decimals? 

The bot runs fine all throughout but once a month or so I get the follow error in Email-Check if folder exists action.error - Illegal parameters to method 'execute'. Please contact your system administrator.As a solution I need to restart Outlook and the system and re-trigger the bot.Can someone please let me know why this is occurring and how can we avoid it?

Summary InfoCR Build 18371(On Premises) CR servers are divided into two locations CR connection itself is not lost The network in the Azure environment was also operating normally Some bots are installed and used in the Azure environment CR domain is not accessible only in some of the Azure being used, and device is disconnectedAs a result, I solved it by restarting CR, butI want to know the cause.

The logging module is not working when invoke from AA. Here is a simple code that I try to run but nothing gets log to log file. I did make sure that all privileges on the file are properly set. Any idea why this would not work? We do run a lot of python code without any problems but this small snippet is not working and not returning an error either and this is a pretty simple python script. import loggingdef log_test():logging.basicConfig(filename="C:/temp/test.log", level=logging.DEBUG)  logging.info('This message should also go to the log file')

Hi, Using A360 and have a number of task bots in production (Public) running on an unattended license. Reviewing all the options and articles, all suggest that by Checking out a bot in public folder, logging on a creator machine, i should be able to Rename the Task bot. - this is not the case. The only way i found this possible is by : cloning / copying in private the bot - renaming and checking it back in. - but by doing this the Bot ID changes and all the Monitoring(External BI) against the bots that have been running with the old name will not carry over with the new executions. Has anyone encountered this? if so / is there a box to tick somewhere to allow rename upon checkout?

I am trying to write a table to a csv file, but the contents of each row are being stored in a single cell. I’m using “Data Table action: Write to file”. Does anyone know how to fix this?   

Hi All,I need help with building an AARI Form that includes a table. The table should have 4 columns: the first 3 columns should be non-editable, and only the last column should be editable.Currently, to make the table editable, I have to select the checkbox “Include table action,” which provides a bunch options to add, delete and move rows. However, I don't need these options. I just want the last column to be editable.How can I set this up? 

🚀 Exciting Update! 🚀I am thrilled to announce that I have successfully renewed my Automation Anywhere Certified Advanced RPA Professional (Automation 360) certification for 2023! 🎓This certification represents my commitment to staying at the forefront of robotic process automation (RPA) technologies and honing my skills in Automation Anywhere's latest tools and innovations. 💡Looking forward to applying these advanced skills to drive efficiency, innovation, and transformative change in Health Care, Manufacturing and many other Domains. Let's continue to automate, elevate, and innovate! 💪I challenge my fellow developers and friends to join me in advancing their skills and exploring the limitless possibilities of RPA. Together, we can automate, elevate, and innovate! 💪