Skip to main content

Developers Forum

The place for Developers to share and learn.

  • 4,386 Topics
  • 12,087 Replies
4386 Topics
A
ailiescuCadet | Tier 2
asked in Developers Forum
Set cell formula

Hello! I'm trying to add a formula in excel. This is the formula=TRANSPOSE(Table1) which I enter in "set cell formula" When I run the bot it adds this @ character to the formula in excel, and the formula doesn't work properly. Table 1 is defined in excel.  =@TRANSPOSE(@Table1) Thanks!

970
A
Automation Anywhere Team
W
wang.h2_0Navigator | Tier 3
asked in Developers Forum
AA2019 How to click link text in a html table cell

hi teami have tried to use recorder to catch the table, there are some actions in list,i choose "click on cell by text" and "click on cell by index". but when bot running,the link in the cell was not clicked any more...do you have any solutions for help?

2960
A
Automation Anywhere Team
H
hythGround Control | Tier 1
asked in Developers Forum
im trying to connect control room apis from postman

im trying to connect control room apis from postman

620
A
Automation Anywhere Team
V
Vara.PGround Control | Tier 1
asked in Developers Forum
In AA V11 someone checked out one bot and currently he/she not available in org. due to that i am unable to perform edit actions in that how can i overcome with that without losting any info ??

In AA V11 someone checked out one bot and currently he/she not available in org. due to that i am unable to perform edit actions in that how can i overcome with that without losting any info ??

170
A
Automation Anywhere Team
GOAA
Navigator | Tier 3
GOAANavigator | Tier 3
asked in Developers Forum
IQBOT -> Is TESSERACT reliable compared to other OCRs?

I would like to know how reliable TESSERACT is compared to other OCRsI'm doing a configuration of an instance, and with the tesseract I had one of the best PDF readings, with and without images. While AZURE was not as accurate with the other documents. Can anyone share their experience on this. Thank you!

450
Tamil Arasu10
Most Valuable Pathfinder
N
NamanPathak11Ground Control | Tier 1
asked in Developers Forum
I am trying to download a table from a web page using object cloning - get table- save as csv. some feilds of the table are not downloaded in the csv file

Attached screenshot. uncopied texts have been highlighted in yellow. Particularly, the editable section in the table is not reflected in the downloaded csv file. Checked for hidden characters and also tried to open in notepad.

210
A
Automation Anywhere Team
A
apasvGround Control | Tier 1
asked in Developers Forum
Fix issue in Automation Anywhere application

We face an issue in our VDI Machines from Friday 8/4 as we cannot open the Automation Anywhere application to run our processes.The error message appears in the attach file.Access Bridge status: Automation Anywhere.exe - Application errorThe instruction at 0x000000006ADBEEA6 referenced memory at 0x00000000083F1004.The memory could not be read.

700
A
Automation Anywhere Team
V
Ved Kumar SinghCadet | Tier 2
asked in Developers Forum
while fetching the email id from outlook message getting name of person instead of email id

i am trying to get the email id from my out look message , but in key " emialTo" store name of person which is store in outlooks contact detail . can any one advise how to get only email instead of name .

1140
A
Automation Anywhere Team
R
Rajkumar S. JagdaleCadet | Tier 2
asked in Developers Forum
Related to Modular BOT

I want to set cell values in excel file using 3 conditions Every conditions has more than 2000 lines of code. Can i Use Modular bot concept and make 3 Bots seperate 3 task bots to set cells in same excel file. Three conditions are setting cells in same excel file. accoring to my knowledge following are some options  1) Use one task bot to do 3 conditions and set cells in same excel file.2) Use 3 Task Bots to set cells in same excel file I have dought in second option because for every condition, I might be open excel file and it will be not proper way. What you think? Which Option is better or is there another way to do above task I want set cells in same file for each conditions..  Thank You.Rajkumar

340
A
Automation Anywhere Team
F
FABIO.RGround Control | Tier 1
asked in Developers Forum
Are there any restrictions for running bots at windows 7?

I used to run bots on a Laptop with Windows 7, but recently I just can't run it properly anymore. My bot open the browser but can't capture any field or type any text. It just keeps stuck at the same line of execution. The same happens on Chrome, Firefox or Edge. I've tried on 2 machines with windows 10 and it works normally. How can I proceed?

250
Tamil Arasu10
Most Valuable Pathfinder
F
Fred A.Navigator | Tier 3
asked in Developers Forum
How can I format Excel Cells using AA (either wth formula or command) with No keystrokes or manual intervention?

How can I format Excel Cells using AA (either wth formula or command) with No keystrokes or manual intervention?

610
A
Automation Anywhere Team
D
Dede 7849Cadet | Tier 2
asked in Developers Forum
Hi I am trying to set up a bot with the recorder but somehow the recorder doesn't recognize the button instead it recognizes a window. Could you tell me what I have to do/change that it recognizes the button?

Hi I am trying to set up a bot with the recorder but somehow the recorder doesn't recognize the button instead it recognizes a window. Could you tell me what I have to do/change that it recognizes the button?

350
D
S
Shahid 8791Cadet | Tier 2
asked in Developers Forum
I am using google sheet. unable to connect g-suit.

430
A
Automation Anywhere Team
S
Sohaib 3951Cadet | Tier 2
asked in Developers Forum
where the users credentials of Control Room being saved in the data base?

where the users credentials of Control Room being saved in the data base?

220
Tamil Arasu10
Most Valuable Pathfinder
A
adshgGround Control | Tier 1
asked in Developers Forum
I am now trying to automate the Salesforce application. All the domxpath are comes IFRAME. What are the alternative methods to automate salesforce. I am trying to download weekly report from salesforce.

I am now trying to automate the Salesforce application. All the domxpath are comes IFRAME. What are the alternative methods to automate salesforce. I am trying to download weekly report from salesforce.

1190
K
M
Mohammad AnwarCadet | Tier 2
asked in Developers Forum
It is taking too long for the BOT to download to the destination device for the first time the bot executes. What can a bot developer do to reduce this first run delay ?

It is taking too long for the BOT to download to the destination device for the first time the bot executes. What can a bot developer do to reduce this first run delay ?

1020
M
J
JessicaH108326Navigator | Tier 3
asked in Developers Forum
How do you use triggers and deploy from a DEV and PRD environment? Do you create two triggers in the bot, one for DEV and one for PRD? Then only update the DEV control room with the DEV trigger and same for PRD?

How do you use triggers and deploy from a DEV and PRD environment? Do you create two triggers in the bot, one for DEV and one for PRD? Then only update the DEV control room with the DEV trigger and same for PRD?

320
A
Automation Anywhere Team
M
MJDeContoCadet | Tier 2
asked in Developers Forum
Relative XML Path

In the XML example below, what is the XML path in AA to get to a value like the price of the book 'Everyday Italian' without looping through the nodes. I think in VBA something like this works://book[title/text()='Everyday Italian']/price but that gives me an error in AA '//DefaultNSPrefix:book[title/DefaultNSPrefix:text()='Everyday Italian']/DefaultNSPrefix:price' has an invalid token. Example XML: <?xml version="1.0" encoding="UTF-8"?> <bookstore> <book category="cooking">  <title lang="en">Everyday Italian</title>  <author>Giada De Laurentiis</author>  <year>2005</year>  <price>30.00</price></book> <book category="children">  <title lang="en">Harry Potter</title>  <author>J K. Rowling</author>  <year>2005</year>  <price>29.99</price></book> <book category=&quo

660
A
Automation Anywhere Team
S
Most Valuable Pathfinder
SaiMadhurMost Valuable Pathfinder
asked in Developers Forum
Hello, We recently provisioned A360 control control rooms, Does could A360 Control room comes with version control by default? or Do we need to manually configure Git integration? Thanks in advance!

Hello, We recently provisioned A360 control control rooms, Does could A360 Control room comes with version control by default? or Do we need to manually configure Git integration? Thanks in advance!

380
A
Automation Anywhere Team
L
Lucy 3556Ground Control | Tier 1
asked in Developers Forum
All of our bots are current using IE browser and MS is no longer support IE starting June 15. We are having issue to get initial set up for Chrome. We need your help with initial set up so that we can able to record in Chrome.

All of our bots are current using IE browser and MS is no longer support IE starting June 15. We are having issue to get initial set up for Chrome. We need your help with initial set up so that we can able to record in Chrome.

170
Tamil Arasu10
Most Valuable Pathfinder
T
Tejaswini LokeshGround Control | Tier 1
asked in Developers Forum
Hi Team, I am using the OutlookV2.mbot which is downloaded from Bot Store. But I am facing intermittent issue frequently while using the "SelectProfile" logic. Please find below the Error Description. Can you please help me in this issue?

 Error Description : [ERROR]:System.Runtime.InteropServices.COMException (0x800401E3): Operation unavailable (Exception from HRESULT: 0x800401E3 (MK_E_UNAVAILABLE))  at System.Runtime.InteropServices.Marshal.GetActiveObject(Guid& rclsid, IntPtr reserved, Object& ppunk)  at System.Runtime.InteropServices.Marshal.GetActiveObject(String progID)  at OutlookWrapper.OutlookWrapper.SelectProfile(String ProfileName, String ProfilePassword)

560
A
Automation Anywhere Team
S
santhosh 6476Cadet | Tier 2
asked in Developers Forum
When iam adding the username in credentials iam getting below error

When iam adding the username in credentials iam getting below error

280
A
Automation Anywhere Team
S
S017778Navigator | Tier 3
asked in Developers Forum
Where is the AA settings.xml file in Automation 360 to update tags? Facing html tags issue in body of email for the migrated code.

In v11.3.2 AA settings.xml html tags issue in email body were resolved when below part is added. <sendmail>    <resolvehtmltags>true</resolvehtmltags>  </sendmail> Is this the same approach to follow in A360 or is there any alternate way? Please suggest. Thanks.

1030
A
Automation Anywhere Team
S
santhosh 6476Cadet | Tier 2
asked in Developers Forum
I am trying to add the username in credentials but . It is not accepting the username and it is showing some error . Because of this reason I am unable to run my BOT

I am trying to add the username in credentials but . It is not accepting the username and it is showing some error . Because of this reason I am unable to run my BOT

693
Zaibi
J
JuhaNavigator | Tier 3
asked in Developers Forum
AA360 cannot calculate negative numbers at all. only positive digits work. examble: I have variable num 0 if I use Number:Decrement by 1 I get error message if I use number Assing num -1 i get error message

AA360 cannot calculate negative numbers at all. only positive digits work. examble: I have variable num 0 if I use Number:Decrement by 1 I get error message if I use number Assing num -1 i get error message

1050
Tamil Arasu10
Most Valuable Pathfinder
Terms & ConditionsCookie settings