Developers Forum

Can you please list the steps to convert xls file to xlsx.

Hello all, Is there an api to change runner or any user device credentials using api?

I have already reviewed the video ensure I did not skip any topics and still no luck unfortunately.  Would appreciate if someone could have some useful info on this for me, and Im working against the clock here to try and get through this training.

Dear All, I had a robot in a community edition running on a laptop. As i am new to Automation anywhere, what are the steps to both the robot to another machine ? the user login is the same. Thank you in advance

In Excel sheet diagonally I have to generate numbers from 1 to100.could you please help on this scenario. Example: 1st column 1st cell should be 1 2nd column 2 cell should be 2 3rd column 3 cell should be 3

Few of my team mates are not unable to complete their sign to Automation anywhere university. They are not getting their passwords.

How to apply for training?

Can anyone tell me what the arguments for .LegacyAutomation:getCellByIndexOrName are? I keep getting an error that I am missing an argument, but I don't even know what arguments the command needs. [0] does not work. I noticed that this command does not even appear in their Legacy Automation package web page.

SaaS Control Room is in EU, Bot Runners are in US EastNo private network in place1:1 between Bot and Bot Runner 

Hi Everyone,I am trying to use the update query with select statement in automation anywhere. I have 2 different tables(2 excel sheets). I need to update one column by comparing the colum names [client num]of first table with RAFT Client # column in the second table. If the client value matches, then bot needs to update optin columnFor this I have used the Insert/Update/Delete Command, and i used the below query : UPDATE [ASO Output$] SET [ASO Output$.Opt In?]=[Sheet1$.Max_ASO Vendor Fee Pass Through] FROM (SELECT [Sheet1$.Max_ASO Vendor Fee Pass Through],[Sheet1$.RAFT Client #] FROM[Sheet1$] AS [Sheet1$] WHERE [SHEET1$.RAFT Client #]=[ASO Output$.CLient_Number]; But I can't able to get the proper result, Syntatical error occured. Can anyone help me to resolve this issue Thanks,Gayathri M 

Is there a way to convert a Datetime variable to string-type in line? For instance, lets say I assign the current date to "Today-Date" variable. Can I then type $Today-Date:ToString$ or something like that in a message box action so that the date is converted to a string inline?

Hi, when i run the bot in community edition it stuck at deploying to your computer and one bot is showing in the in progress. can anyone help me.

Hi Everyone, when I am trying to update in excel while connecting excel as database it is showing error update is not working select is working any help will be appreciated

in the 1st image I am clicking on search and then entering text in the 2nd image using simulate key stroke. Below is the code for the above logic This is working when the VM is in presence but not able to enter the data in the 2nd image when the VM is not presence. I tried all the ways to fix but nothing works out. Please help me with the better approaches.

I am currently using Automation Anywhere version 11.3.0. How to upgrade Postgresql version?

Hello, I struggle with capturing the window. You can see the issue in the attached photo. I can't use the "Active window" option in Recorder because the window disappears when I click away.  I also tried to use Keystrokes. However, it didn't function because after selecting all the objects and pressing "[ALT DOWN]JPAA[ALT UP]" there was this new sub window without a title; therefore, the final keystroke for aligning to the top didn't work. I would be very grateful if there were someone who knew the solution. Thank you in forward! Best regards,Jaroslav Koďousek 

Is data manipulation faster when working with a List variable or a Table variable? For instance, I lets say I have a list of names and I want to compare it to a second list of names to see which ones match. Would it be faster to do these types of comparisons with Lists or Tables? My actual data will be closer to 100,000 rows, so I am concerned about performance. Note: in theory, my data will only contain one column, thus it could (again, in theory) be stored in either a Table or List variable.

I am reaching out to get your assistance resolving an issue with the AA360 program when I attempt to run a specific bot with the bot runner VDI closed. The bot I am developing uses mostly the screen capture function to click into and access a desktop application called Morningstar Direct. Whenever I run my bot on the bot runner VDI with the VDI opened and maximized, it works correctly with no issues. However, when I try to run the bot with the bot runner VDI closed or even opened but minimized, it fails. I have opened up the bot runner VDI in the middle of a run to try and assess the issue only to find that the bot has clicked incorrect sections of the desktop application. I have also opened up the bot runner VDI after failure (when it was closed) to find the same issue. This leads me to believe that the issue is related to screen resolution when the bot runner VDI is closed, since it is running without error when the bot runner VDI is maximized but fails when its closed. I have checke

So i tried to check in/check out a bot like i usually do and suddenly i couldn't check in/check out the bot. After checking i found that at my dashboard the elasticsearch failed to connect.  so i went surfing the community for the problem since i assume the problem is because the elasticsearch server failed to connect. but i saw an answer posted by AA team that if check in/check out doesn't work do not restart the elasticserver services. here is the details https://apeople.automationanywhere.com/s/question/0D56F000081pMLqSAM/failed-to-connect-to-elasticsearch-server?language=en_US/p> how can i fix this? and is the reason why i can't check in/check out my bot is because the elasticsearch server failed to connect?

Hi everyone;this is my first installation and bot agent doesn't start so I cant connect my local device.when I click on AARI icon first app starting but disappear in 2 seconds, I tried to remove and reinstall with administrator permissions but nothing changes. is there any logs that I can check ?

I need the application "Automation anywhere mobile app", but when I search for it in the Play store or App store I cannot find it, someone who can guide me and know if it is still available, thanks.

Why do I get the following "Invalid Expression" when using the "$" symbol for regex end of line? This is a very common and basic regex functionality. Am I doing something wrong?Thanks

i am trying to login QA CR with the active user credentials and using admin as well after clicking on login 3 to 4 seconds buffering in web page and it will show Your session expiredTo be safe, we logged you out. Please login again.

Hi there, I have an issue with the Device Credential. Also, I have an updated my bot agent with updated version but still facing the same issue. Please, help me with it!