Developers Forum

The place for Developers to share and learn.

  • 3,600 Topics
  • 9,620 Replies

3600 Topics

K
Kyle.B1Customer
asked in Developers Forum

Microsoft Word Package - Bug Report

For this package in the bot store: https://botstore.automationanywhere.com/bot/a2019-microsoft-word-package/p> For each "Replace" action I use, it adds a carriage return to the end of the word document. Ive tried to disable all replace actions, and the carriage returns did not show. Then, I added 1 replace action, and a single return appeared at the bottom of the output word doc... when i added a 2nd replace action... 2 returns appeared at the bottom of the output word doc. Is there any way to repair this or mitigate the issue?

2
T
1 year ago
A
Abhi25Partner
asked in Developers Forum

Fetch data between two dates using excel as database

How can I fetch data between two date ranges using select query?For eg I want the records that lie in the month of Oct 2022-Dec 2022. I am using below select query : select * from [Sheet1$$] where [Date] BETWEEN #10/1/2022# AND #12/31/2022#  the query is giving me records of every year for the months of Oct-Dec instead I want the records for just 3 months (Oct,Nov,Dec) of the year 2022.P.S. - I am using excel as database

3
Raul Jaimes
1 year ago
D
DebiB102172Customer
asked in Developers Forum

How can I edit or delete a WLM template?

While creating the WLM queue, I defined the template structure inaccurately and would like to revise the template, or delete it in order to completely redo the template

6
Padmakumar
1 year ago
S
SK007Partner
asked in Developers Forum

AA.11.3.5 email issue

The send email command is failing with the below error. Username '' in email setting option and From Email 'xxxx@xxx.com' within Send Email command should be same.Please ensure both emails are same and try again.

4
rbkadiyam
Automate the Universe SME
1 year ago
M
mohank06New Member
asked in Developers Forum

Dictionary Variable?

How to read an excel file using dictionary variable in automation anywhere? 

6
K
1 year ago
R
Ragavendhra
asked in Developers Forum

Hello Team, I am facing issue with Email Automation using Email Server as option to connect to Email Account but unfortunately i am getting error as "Invalid Credentials", I have verified my credentials. It's correct but still i am facing issue.

Hello Team, I am facing issue with Email Automation using Email Server as option to connect to Email Account but unfortunately i am getting error as "Invalid Credentials", I have verified my credentials. It's correct but still i am facing issue.

18
S
1 year ago
B
ben.terdaCustomer
asked in Developers Forum

How to connect with one user to multiple mailbox

Hello,we would like to set up a connection for one user to shared mailboxes, is there any possibility like this?We use Connect to Email server, with SSL sonnection and IMAP Protocol (HOST, Port, and credentials are filled in as well). But we did not find any possibility to define the mail address itself.Does each mailbox has to have enable extra user?We would prefere if one user could use multiple mailbox as it is in set up of IMAP mailboxes.Thanks! 😊

2
S
1 year ago
V
Vinayak18New Member
asked in Developers Forum

Cannot delete device, as it is part of an active bot deployment

Cannot delete device, as it is part of an active bot deployment ,,I am stucked in this , please help

2
rbkadiyam
Automate the Universe SME
1 year ago
I
IjustWANTanswerNew Member
asked in Developers Forum

How to click on every row in a table.

A stock market exchange website has a list of all stocks, and I want to click on all of them to get information.How do I acheive that?I know how to capture one stock, by opening the site and clicking on one stock, but how do I repeat the same thing for all stocks?The table contating the stocks contatin some rows that aren’t stocks, some extra information that I don’t need to click on.Thanks in advance.

5
rbkadiyam
Automate the Universe SME
1 year ago
M
Mohamed TimorPartner
asked in Developers Forum

Date Convertion

Hello Everyone,I want to convert any given date format to d/m/yyyy.the input value may be Jan 1, 2023, 1 Jan 2023, 1-1-2023,,,, meaning the format is not fixed.So I want to convert the given date to fixed format ex d/m/yyyy so we can work with the date further. Any Idea how to do it?

5
Tamil Arasu10
Most Valuable Pathfinder
1 year ago
A
Abhi25Partner
asked in Developers Forum

SQL Query to filter by Year in Excel as database

Hi Guys, In an excel sheet I have column where there dates in the format as below :12/26/202211/12/20215/5/202110/10/2020……. etc.I want to use select query (excel as database) where I want to filter records using the year only. Basically, I want to build a query something like this : select * from [Sheet1$$] where ‘Date’ <> 2021. In the above query what I am trying to do is filter the records where year is 2021 and leave rest of the records. Need some help on how to achieve this. Thanks in advance :)

9
A
1 year ago
A
Abhi25Partner
asked in Developers Forum

Excel as Database connection lost Error

Hi Guys, While running the code in a production server (unattended mode), I am getting an error when it is trying to run a basic select query in an excel and getting an error as below : The connection for viewing your linked Microsoft Excel worksheet was lost. I am getting this error on the exact same line where the select query is written and I was not getting this kind of error before (not even once!) . Surprisingly when I log in to the VM & run the code again, it runs fine. Any suggestions or resolutions please ?

9
Padmakumar
1 year ago
D
divakarMember
asked in Developers Forum

excel

What is best approch for data mapping?Like Manually in Excel we use Vlookup , what about in Automation Anywhere?

2
Padmakumar
1 year ago
P
Pramod 1192
asked in Developers Forum

I am getting the error Error: Unable to find LINK. Search Criteria did not match, while recording an action.?

I am getting the error Error: Unable to find LINK. Search Criteria did not match, while recording an action.?

6
Padmakumar
1 year ago
J
JMarinoCustomer
asked in Developers Forum

Zulu Platform x64 Architecture has stopped working

I’ve got a very simple BOT I started testing with:Excel Advanced Opens Excel file Excel Advanced Gets multiple cells and saves to data tableEach time it fails on step 2 saying “Zulu Platform x64 Architecture has stopped working”. There are 32,000 rows in the excel sheet. I’ve also tried just grabbing 5000 rows but same error.I’ve done this before in other BOTs so I don’t know what the deal is here. Any help would be appreciated.

6
C
Most Valuable Pathfinder
1 year ago
C
cacorderoPartner
asked in Developers Forum

Configuracion email EWS server basic

Buenos Dias! Tengo configurado la conexion de envio de correo con EWS SERVER y Basic con usuario y password, me indicaron que para el 31 de diciembre dejara de funcionar , alguien me puede confirmar que asi sea o si me va a seguir funcionando a como lo tengo?  

5
Tamil Arasu10
Most Valuable Pathfinder
1 year ago
S
Automate the Universe SME
Semih 3318Automate the Universe SME
asked in Developers Forum

Check in issue, why doesn't the bot seem in the tasks which are checked in?

the task is checked in, it doesnt throw an error, but its not in the checked in list

10
C
Most Valuable Pathfinder
1 year ago
R
Rpatilaadharhousing
asked in Developers Forum

i am getting the error while running the Boat As "' If the problem persists, please contact your system administrator."

i am getting the error while running the Boat As "' If the problem persists, please contact your system administrator."

5
Padmakumar
1 year ago
M
masuoMember
asked in Developers Forum

BotAgentが記憶しているProxy設定をリセットする方法が知りたい

Bot Creatorユーザーが使うパソコンに、ネットワーク通信キャプチャツール「Fiddler」をインストールして以降、Fiddlerを立ち上げてないとローカルデバイスの接続ができなくなりました。Bot Creatorユーザーが使うパソコンを立ち上げた直後、BotAgentサービスは正常に開始中になります。Control Roomでデバイスのステータスは「接続中」です。ところが、Bot Creatorユーザーでログインしてもローカルデバイスが「接続中」になりません。ここでFiddlerを立ち上げると、ローカルデバイスが「接続中」になります。一旦ローカルデバイスが「接続中」になった後は、Bot Creatorユーザーをログアウトするまで、ローカルデバイスが「接続中」のまま使えます。BotAgentがローカルデバイスを接続するときにProxyを使うように記憶してしまっているように思われます。BotAgentが記憶しているProxy設定をリセットする方法があれば、この問題を解決と思うのですが、何か良い方法はないでしょうか？(Botエージェントのバージョン：21.210)

4
M
1 year ago
H
harperjgCustomer
asked in Developers Forum

Need for a If condition

Hello,I need add a conditional logic to my bot so that it continues if there is no data returned from a search within a web application.Specifically, here is what is occurring:Search is executed. If a record is returned, the record will be presented in a row format with a radio button to be selected, as shown below: If there records returned, the screen will look like this with no radio button to select: If condition #2 occurs, the bot will click the radio button and the processing for that specific row will continueIf condition #3 occurs, the bot needs to terminate that iteration of the loop and go on to the next search parameter in the loop.I had my if statement set to if  the data table if blank (as shown in #3) to continue to the next search parameter in the loop, and my if else has the actions necessary to continue processing with the returned record (as shown in #2). However, when the bot encounters no records returned (as shown in #3) the bot stops processing. I believe using i

3
H
1 year ago
rbkadiyam
Automate the Universe SME
rbkadiyamAutomate the Universe SME
posted in Developers Forum

Audit logs are not populating in A11.3 control room

Issue :: Audit logs are not populating in A11.3 control room Error: “Failed to save to index: org.elasticsearch.ElasticsearchStatusException: Elasticsearch exception [type=cluster_block_exception, reason=blocked by: [FORBIDDEN/12/index read-only / allow delete (api)]”.Resolution :Stop elastic service  Rename data folder to data_bkp (C:\ProgramData\AutomationAnywhere\elasticsearch) Restart the service if you have more than one node do above steps for all nodes 

3
Raul Jaimes
1 year ago
rbkadiyam
Automate the Universe SME
rbkadiyamAutomate the Universe SME
posted in Developers Forum

Bot schedules are missing to run in A360

Issue :: Bot schedules are missing to run in A360This is happening after DR exercise Resolution : check if you have Disaster Recovery environment on different time zone and AA services are up on these servers.  Stop all AA services in DR environment. PN: AA control room servers are supposed to be run on same time zone otherwise schedules will fail to run.

0
rbkadiyam
Automate the Universe SME
1 year ago
rbkadiyam
Automate the Universe SME
rbkadiyamAutomate the Universe SME
posted in Developers Forum

Bots are unable to run after control room upgrade to V23 in A360

Issue :: Bots are unable to run after control room upgrade to V23 in A360Bot agent V21.200 VDI’s are failing to connect control roomThis is due to botagent vs control room versions not compatible Resolution :: update bot agent v21.121 or higher… 

0
rbkadiyam
Automate the Universe SME
1 year ago
M
Michell.C1Partner
asked in Developers Forum

Use DevOps practices in AA v11

Is it possible to use devops practices in automation anywhere v11? What devops practices could I use to automate the continuous integration (CI) and continuous deployment (CD) of the different bots. Could I automate tests for the bots?

2
C
Most Valuable Pathfinder
1 year ago
G
Gift.KP624Customer
asked in Developers Forum

Bot runner cannot set text in some objects on recorder action.

Hi Everyone, I have problem that I schedule bot runner to run process and error occured.The error showed that bot cannot set text in some objects on recorder action.When I remote to VM(bot runner) and let process run, it shows that bot can set text in the object that had an error before.I don’t know how to solve this issue.Please let me know if you have any suggestions. Thank you.

9
Padmakumar
1 year ago
Terms & ConditionsCookie settings