Developers Forum

Hi,In Automation anywhere if we want to right headers in to excel, without manually writing how we can provide? Which activity we can use for this...?

Scenario:Open URL - https://www.nseindia.com/market-data/live-equity-market?Extract the whole table data into Excel (xslx)Code Snapshot:Connection String: Provider=Microsoft.ACE.OLEDB.12.0;Data Source="C:\RPA\Test\ExtractedDetails.xlsx";Extended Properties="Excel 12.0 Xml;HDR=YES";SQL Query:INSERT into [Sheet2$$] values ('$StockTableRow[0]$','$StockTableRow[1]$','$StockTableRow[2]$','$StockTableRow[3]$','$StockTableRow[4]$','$StockTableRow[5]$','$StockTableRow[6]$','$StockTableRow[7]$','$StockTableRow[8]$','$StockTableRow[9]$','$StockTableRow[10]$','$StockTableRow[11]$','$StockTableRow[12]$')   Error: how to proceed further

I am Facing Issue in AARI form like i am unable to give form rule for table and buttons, so for that in table some mandatory fields are there also next process is continuing without showing any error.

Hi Team,I recently started using Automation Anywhere and trying to run my first Bot but while running everytime its giving Device error while downloading dependencies though my Bot agent is up and running. Pls help. Attached error screenshot. Regards,Hirak

Hi,Instead of writing cell by cell in excel (set cell) is there is any activity to write in single shot...?  

Hi teami am using open program/file command in AA2019 to open a program called SAPi pasted the full dir to location text box and run the bot,  but after the bot finished, the SAP is not openedhowever when i try to click browse button to select SAP exe file,  the button of select path is not useful as below image: how to fix the issue?

Setup:I have a BOT with a data table which has pre-defined columns (11 columns) I have a user form with a data table which has three columns I’m using a process to display the initial form to a user (AARI) and they fill in as many rows as they want I have the data table variable from the form mapped to the data table in my BOT Columns names match the first three columnsResults:I am able to loop through the data table in my BOT and see the data in each row for the first three columns (although the first row 0 is blank). I am not able to access the other pre-defined columns in the table in any way. I can’t use the “set value of a single cell” on column 4, 5, 6 etc. as I loop. I can’t include any columns beyond the three columns from the form when writing to a log file.What’s happening here? Does mapping a table in AARI wipe out the pre-defined columns in my data table variable?What I need to do:Accept three columns of data from a user Loop through the data and add additional related data

Where can I find the badges I have earned?

Hi All,I built a bot that “can” click on links on a webpages using the keystroke function and [TAB] to the link. However, this method is unreliable as there are 50+ [TAB]s to get to the link and the bot rarely is able to click on the correct link on the static webpage. I’ve tried increasing the time between keystrokes, but that hasn’t helped.With that said, is there way to click on a link on a webpage by accessing the link through another way, perhaps how it is labeled in the browser inspect function? Any starting points would be appreciated. Using the AA Click function with screen coordinates is not going to work in this instance.Thank you,Brobert

Good day!, I have an automation anywhere 360 version a270 in an Azure virtual machine, I'm trying to connect my local machine to the CR, I already installed the agent on my local machine but it can't find it from the control room, it could be a configuration problem ports?

https://docs.automationanywhere.com/bundle/enterprise-v2019/page/enterprise-cloud/topics/aae-client/bot-creator/using-the-workbench/salesforce-authentication-action.html in the article information 8.2 says "Authorization returns a token, which is hidden as it is a credential type, this token can be passed directly in the Rest Web Services command." Problem with using the authorization in Rest Web Service is the credential datatype. Typically, the header auth of SF API is done like "Authorization / Bearer <Token>", because the token from Salesforce Authentication Action is Credential Datatype the auth header can only be "Authorization / <Token>" which is failing in the Rest Web Services command.Any thoughts on how to make this work? Is there an example on how to use the Authorization token from Salesforce Authentication Action in Rest Web Services Command?

Good Afternoon - I am having an issue where i have a loop, wherein I do some processing to a series of pdfs. After Im done processing, I move the files to an archive folder, and delete from that current folder. This works, except for the last pdf file in the queue. When the bot encounters the delete task for the last file, I receive an error stating: “Unable to delete the file(s) ‘**file location omitted for post**’ because they are being used by another process. Try after sometime.I have tried entering a delay, but to no avail. Every other file is deleted successfully.Any ideas?

Hello. I need more help, I have a problem where there are not as many version recorders in the enterprise and community as there are in the community, causing robots that were made by me in the previous enterprise version to be unable to be imported into a different control room, can I add more? recorder version without downgrading the A360 Recorder IN AA enterprise Ver 25 Recorder IN AA Community Ver 27

Hi, I am using Automation 360 build 16685 (on-prem) I am trying to run a bot with a queue but the queue is not listed to select it, the bot is already configured with the work item template, tried all users and assigning various roles, but I don't know what is left to do. Queue status is "not in use"

 Hi, All I am facing this issue continuously in the V11 environment, below is the error, i have checked my database connection as well everything is working properly. Below is the error. I am using Workbench db.“mysql odbc 5.3(w) driver mysqld-5.7.33 query execution was interrupted”  

Description: I'm currently working on a bot that uses the Step action multiple times, and I have a question regarding its behavior when an IF condition inside the loop fails in the 2nd STEP. Specifically, I'm wondering if the bot will continue to execute the next step in the sequence, or if it will simply complete without executing the 3rd step?I would appreciate any insights or guidance on this matter, as I want to ensure that my bot is functioning as intended. Thank you in advance for your help!

please help me, I have a problem when I want to import from a local computer and upload it to the enterprise control room successfully, while in the audit log there is an error that I can't find out from the forum or from the web, for example Google and YouTube,I am using A360 version 25

When I try to run from public environment unattended mode, I am getting error like deployment failed. But I can run in private environment.Please find the attached error screenshot for your reference. 

Can Automation 360 Pure Cloud license be used in the Automation 360 Pure Cloud -Enterprise Pack?

How can I use the Loop action in order to create a variable for index, and create a variable for item?For example, in Python, it would be like iterrows: https://www.w3schools.com/python/pandas/ref_df_iterrows.aspIn RPA, doing the following would only allow for creating a variable for the item, there is no option here for also creating a variable for index. Thanks

Hi All,I am using Automation Anywhere 360 and I have question related to VBS function in AA. I need to receive many outputs from script, but “VBScript: Run function” allows to assign only one string variable as output. I found not perfect workaround where I:In VBScript create one string output made from many values separated by specific sign (e.g. “/”). Assign the VBS output to string variable Use “String: split” to create list with needed outputs. As a result I received: This is not perfect workaround because I could have value which includes my delimiter (in this case “/”) and then I receive wrong outputs.Do you have any suggestions how I can get many outputs form VBS function in AA 360?Thank in advance for help!Michal

Hi everyone,  Is there a way for me to build an interactive form with a dropdown that can enable user’s to select multiple options within the dropdown? I’ve tried this by making use of a checkbox with the various options a user can select, however I’m struggling with reading the actual value/name of the checkboxes selection as I need to store it in a variable to be used at a later stage.  Is there a way I can go about this on the interactive form? Below is the checkbox list I’ve created and added into the form and I need to get the value eg: SRV00871  Kind regards,Nokuthula Mkhize

Good Afternoon ,I need to study a large code with hundreds of code made by my friend. He developed in A360 Enterprise  and I need do print these code do implement in my Community version.Is there any way to share the code developed in Commumity or Enterprise version of A360?

Hey guys,I’m currently working on something that requires me to extract text which I can do but when there’s a new it messes it up so I want to manipulate it so that I can remove \n.I’m not too sure on how to do it right now elegantly but I’m sure there’s an easy solution I’m just not seeing. Any help would be greatly appreciated 🙂

I’ve the below menu structure in MS Edge (IE based website) where I need to click on the triangles to open their menu, lets take the example for DepartmentsBelow is the inspected element for the triangle button of Departments. How to create a generic xPath so that it works even if there is an addition or removal of items in the list & Departments sequence gets changed So here, img tag is for the triangle icon but it doesn’t have any identifier for Departments. span has the identifier but it’s pointing to the label only