Developers Forum

Novice question here,  Got an IF action in my bot which is looking at an excel row, for the index value I want it to always be a certain column (in this instance it's column G) My question is, would the index number be 6 (suggesting that column A and the index starts from 0) or would it be 7 (suggesting that column A and the index starts from 1)? ThanksJonny

Hello, I have to implement a component and I have some problems.I tried to used the Excel basic commands in order to check but the components are not working as expected.the component I need to implement is:•From the external Excel file, tab “Sheet1”, if two new fields (A1 and A2) are filled, then their contents need to be copied over to the internal excel file•If the prior condition is met, then the successfully uploaded contract number will be located on 3rd line in the SAP verification screen instead of the 2nd line (when the prior condition is not met then it remains the 2nd line) I tried to save the values in a variable and check the first but without any success.any ideas?

Hi, i'm having trouble at importing CA cer to the Control Room Server.  I have follow the instruction at https://docs.automationanywhere.com/bundle/enterprise-v2019/page/enterprise-cloud/topics/deployment-planning/on-prem-install/cloud-config-control-room-https-import-cert.html But i can't find the jdk11\bin\java folder anywhere in my Control Room installation folder  My control room's version is Automati

This is for A360 cloud version

@Training and Certification​ Hi, I have successfully completed my v11 professional certification last thursday. I am able to download verify the certificate in accredible site, however, I have not received in my email yet. Can someone please help me with details, if I need to do any further steps if I want it to be emailed

Hello,I am looping through each file in folder where i am getting this error --> The directory '' does not exist. Enter a valid directory.while accessing the path of the folder which is in groupsharealso this wont come for each run Please suggest 

I tried the date action/substract/then variable to string and all that but I need your help my Friends. I did like that but the system is giving me an error today is 03/01/2022 and it is giving me 02/59/2022 when should be 02/28/2022 I do not know what else to do could you help me?

I am trying to install a bot from the Bot Store and once it finishes loading I get an error saying "Do not have sufficient permissions.". What is causing that?

Is there any package or C# code is available to interact with AWS S3 (to upload place the file) in A360 version.

I need to download files from SharePoint, is there any bot available in bot store for V11 Version or how to download the files.Anyone Explain in Detail? 

Using the Application: Open program/file commandI fill in the Location of the program/file andParametersfor a batch file.  The batch file then calls a powershell file. I need to modify the powershell file to return an error code.Then I need the returned error code from the powershell to be passed to the batch file. Then in the bot, add an IF command to see if the error code exists.  Is this something that can be done in Automation Anywhere?If so can someone please let me know how it can be done?  Task bot calls batch file.Batch file calls powershell file. Powershell file returns exit code to batch file. Task bot uses exit code from batch file to make decisions.  I currently have the batch file and the powershell file working but the powershell isn't returning an exit code. There doesn't seem to be a way for

I would like to click "chart' button in a row in a dynamically generated table using Capture but not sure how to do it. The goal is to run a patient search in an EHR system and select the correct patient chart in accordance to the first name, last name, and DOB. I will be using an .xlxs file to loop through patient lab results to add into their chart records.See image attached for example. In an instance where the Bot encounters a duplicate patient, I would like for it to break/skip the duplicated patient and move on to the next record.  XPath for Patient : Bev Test, 01/01/1981 //*[@id="patientSearchResultsApp"]/div/div[3]/div[1]/table/tbody/tr[3]/td[8]/div/span[2]/aThe position of row to click differs based on search result. 

Hi, Can we extract the data from a word document? I need to extract the data with a "*" in POS number from the attached document. Thanks!

Hi Team,I am working on one of the use case where on webpage there are multiple Select buttons and when I captured the object,all the properties of the object looked same(except the height,width etc).Hence bot is not able to identify which one to click on.Is there any way we can differentiate between the object properties.

Hi Team, I am getting the below error while the "IT Bricks" exercise. If I click the refresh in the "Application" section to get the website link, it throws the error.

責任者アカウントを変更する方法を知りたい

 (I've also tried using keystrokes to navigate to the button, but no use)Also I did try changing the DOMXpath but I don't understand where it's going wrong.   buttons to select   inspect NEXT  Xpath in A360 the bot says successful completion. but the button isn't getting clicked. 

We have a question about how we would move an SQL Database and their connection configurations to a new environment. Do you have any procedures regarding how this would be done?

We are facing issues in running bot on UAT machines in unattended mode and also we are facing a excel conflict issue when bot is trying to close a specific excel window through "Close window" activity when multiple excel windows are opened on all the belo

I started a process two days ago, and it has been stuck 'in progress' state ever since (see attached). There is no option anywhere to stop the process. I have tried deleting the actual process that I tried executing - removing the bot from my local device - but nothing seems to be working. Now I can't remove my current device from the control room as it says that the device is part of an active bot deployment. PS. I have removed the bot agent from my local machine - and now it's not allowing me to reinstall/connect to the control room again. I would appreciate if someone could assist.Thanks!    

I want to update an address field in an excel with a comma(,) in it by connecting the Excel As Database.Steps Tried:1) Placed a backslash in front of the comma. (Ex: 'New Street\, Mumbai')2) Used both single and double quotes to enclose the string value. Is there any other way to escape the comma?

Can we automate using automation anywhere For Google Authentication? please give the solution with link or code....

Does anyone has any insight in above issue . Thanks for your help

Migration CR and Bot Agent servers from Windows Server 2016 to Windows Server 2019 I would to know if could be affected our CR or Bot agents servers after OS Migration from Windows Server 2016 to Windows Server 2019. Thanks

did anyone tried to capture object in Chrome Incognito mode ? Seems its not working I am using A-360.v23