Forums

Excelから読込み作成したデータテーブルをBot内のアクションで、ある項目(文字列)を昇順でソートしています。その項目で、空白で始まる内容があった時に、Excelでは最初にきていたのですがデータテーブルで並び替えた時は、空白を無視してソートされてしまいます。(例) 「 VX1」「ABCD」と2つ項目(「」はこの記述のためのものなので実際には入っていません)があった時、Excelでの並び順→「 VX1」「ABCD」Botでの並び順→「ABCD」「 VX1」Excelのように空白も含めて並び替える事はできないのでしょうか。

Hello, As we noticed that Zulu Platform x64 Architecture has high memory usage.Hence we are considering to stop the relevant service which is Automation Anywhere Bot Insight services to release the memory used by Zulu Platform x64 Architecture. Before stopping Automation Anywhere Bot Insight services , we want to know that will it affect the process of history log on Control room as shown below  

I need to extract the data from a table in Microsoft access and insert it in a csv file, however, I am required to use log to file command for the csv file. Also when the bot runs again it should append the new information into the same file but with no hearders since they will already be there

How to automate a shared mailbox in A360? Is it possible to save a email from shared mailbox in .msg format?

Hi everyone. I am trying to run a task with an unattended Bot runner. However, I am unable to select the available bot runner since the status is depicted as “Autologin not set”. Here is what I did beforehand:1) Created a Task and put it in Public2) Created a Bot Runner User and assigned the following Roles: AAE_Basic, AAE_Locker Admin, AAE_Bot Migration Admin3) Assigned a Unattended Bot Runner License to the Bot Runner User4) Went to Administration → Settings → Devices → Auto Login Settings and followed this Guide: https://docs.automationanywhere.com/bundle/enterprise-v2019/page/enterprise-cloud/topics/control-room/administration/settings/cr-auto-login-settings.html5) Went to  Users and made sure that Auto Login Attributes from my Bot Runner is stated as “Can auto login”6) Went to Automation → Run Bot → Run Bot Now → Task → Next → Available Bot RunnersHowever now I can’t pick the Bot Runner since the status is “Autologin not set”.Did I miss something?Any advice would be helpful.Thank

Hi Team,We have implemented a bot that will work on the Oracle DB, which support only in IE. So we have created the bot as same.Now we could not run the bot because of IE disabled as per recent update. So we want to migrated the code in automation anywhere from IE to MS edge(IE mode)Kindly help us on how to work on this issue ?

good morningwhen exporting the bot, i find it in historical tab with run fail status,and get the following error message“An unexpected problem occurredUNKNOWN: Error in exporting the BI BLM Dashboards”error image is attachedany help is appreciated. thanks

Hi all,We are trying to access a xls file from one of the automated mail and saving it in local location.While we try to access the xls file using excel commands, one of the Add-in program script which was added is getting diappeared. But when we open the file manually, we can see the Add-in ribbon visible.We even tried to check the ‘Load Add-in’ option in the Excel Open command. But still the issue is there.Can anyone help us get a solution for this issue? Thanks & Regards,Gopinath S

FolksHave a scenario, trying to cleanse the table data in iqbot for the below scenario can anyone help me with the python code.Table Data will have space followed by any special character, wherein we need to remove the space.Ex:Input : ( USA )Output : (USA)Friendly Note: Have already gone through all the forms and no getting right solution for this

Hi all Is any alternative for commit record in terminal (ANSI ). In putty ctrl +v used to save / commit the record but terminal emulator it is not working.

For some reason there are lapses on clicking a page in GSuite by the bot.  Looks like the bot is not able to click on the page?    Am i missing something on the code?  Also the Webpage Title is Dynamic per user accounts being configured. (<User Account> Admin Console) 

Hello, I am using A360 v27 (on-prem). Whenever I try to create a folder the bot gets stuck (infinitely running) and it does nothing. Any ideas why this could happen? (it happens same thing no matter which Folder package version I use)

Hey, I am new around here . I started to use Automation Anywhere today. I have a problem.When I start my bot , my pc can’t open web page. It might be easy problem but I couldn’t solve the problem. If anyone could help I would be appreciated. I put photo but language is Turkish It says “Hmm… Can’t reached the web page”

I have an excel sheet where there around 20 filled rows and rest of the rows are blank(Till the end of the sheet). I tried to delete the blank rows by using 'remove blank row' command but it is continuously loading since 15 mins and not getting executed so I stopped the task

I’m trying to build a dictionary which has strings as keys, but uses a record as the value.I’m trying to convert a csv table into this dictionary, so I’m looping through the table to add each row as a record based on a column in the table. (Release date) The reason for this method is to perform an easy check if a key in one dictionary exists in a second dictionary. If it does, I want to use the record value in the dictionary to take further actions. I’m open to other options if there is a better way. It seems like each time the table loop happens, EACH key/value pair in the dictionary gets updated to the latest record values. Is there a bug going on here, or is there something I’m not doing correctly with my setup?Or is this an intended functionality? (hopefully not) I’ll try demonstrating what I’m seeing here with screenshots. Here is the setup I have for this.I’m reading a CSV file into a table, then looping through this and adding it to a dictionary.My first dictionary is setting th

Hi, I’m using a python script which sends an Email via SMTP for a specific process. I wanted to pass the credential variables to my script, but it’s not allowed to pass a credential variable to a function. Is there a way to solve this issue?So basically I want to fetch the username and password from Automation Anywhere Credentials and pass it to my python script.Best RegardsEmil

I have some custom app with some data from (input) directory D:\…, then I manually process with result (output) D:\... but when I tried open application with created bot, then the custom app suddenly triggered Input  to directory C:\Program Files\Automation Anywhere\Bot Agent\…. and the custom app cannot be process. With the Image Attached belowI tried to active security permission at the C:\Program Files\Automation Anywhere\Bot Agent\…. but the data will be bulked at that same folder to C:\Program Files\Automation Anywhere\Bot Agent\…. Can this custom app solved back to directory D:\… so the custom app generate with bot with Input and Output data with the same manual process?

Cuando intento iniciar sesion en el control room me sale el siguiente mensaje y no me deja ingresarCode: generic.server.exception Reinicio los servicios SQL del servidor de BD y ya el problema se solventa Alguien sabe que puede pasar ya que es un ambiente que queremos poner productivo y deseamos que no presente ningun problema en el log del control room da el error 2023-Mar-17 Fri 15:10:53.447 ERROR - com.automationanywhere.oauth.organization.service.OAuthOrganizationServiceImpl - {} - callGetOrgIdApi(OAuthOrganizationServiceImpl.java:264) - HTTP Client start exception: java.io.IOException: Unable to establish loopback connection Saludos  

i am using community version ..Git integration is possible in community verstion.Please tell me process how to use enterprise version with trail basis? 

Hello,I’m trying to replace the content of two worksheets from different workbooks. But i would like to replace only the content , not the whole worksheets, because the name of the worksheet which should be replaced is already formatted and is on the specific index in the workbook. I would like to ask for your suggestions. Best Regards,Teodora

OK, I know V11 extremely well. I am learning AA2019 360 Community Addition.2 Silly questions that I can’t seem to wrap my head around:How the heck do you get the Excel Row Number you are on to use as a counter? I want the row number I am currently on during a loop? Say i want to increment the counter by +1. In aa V11 there were variable operations to do so, Is there an equivalent in V2019 360? 

Does the role assigned to Admin and Other users in the Automation 360 user report provide any indication of the type of license they are using?

Hi ,Could someone help me understand if outlook has to be opened to get mails from Outlook in AA360 version.Appreciate your responses

Hi,i would like to convert excel data into json payload? Is this possible? if yes, could someone please help me?i have three columns with multiple rows.

Please share your knowledge or example with me.