Skip to main content

Unanswered questions

4020 Topics
L
LhosPartner
asked in Automation Anywhere University
Bot is adding @ symbol to formulas when running, how to prevent/remove?

I am trying to add a formula an Excel workbook using AA, but the bot adds the @ symbol making it not work correctly.  Is there a way to use the Set Cell Formula to not include the @ symbol when the bot runs?  =FILTER(UNIQUE($sMasterDataTabName$!F:F), (UNIQUE($sMasterDataTabName$!F:F) <> 0)) Turns into=@FILTER(UNIQUE($sMasterDataTabName$!F:F), (UNIQUE($sMasterDataTabName$!F:F) <> 0))

80
L
2 hours ago
L
LhosPartner
asked in Community Edition
Creating separate Excel files based on unique values in a master excel document

I have a workbook that contains data for multiple thousands of employees in multiple countries.  I need to separate that data into individual workbooks that contain just the rows for the employees that correspond to each country (So a “USA” workbook for all USA employees, an “India” workbook for all India employees, etc.)  In the end, if I have employees in 20 countries, I need to have saved 20 separate workbooks.    I’ve opened my workbook, and logically I believe I need to (First) retrieve the value from the country column, (second) if no workbook exists for that country, create one, add the headers and row of data, and save it with the name of the country, (third) if the workbook does already exist, append the row to the existing workbook I am having a hard time finding the right actions to do this in my loop.   

265
Aaron.Gleason
9 hours ago
S
sam 4218Member
asked in Automation Anywhere University
Unable to identify/extract Thai charecters using Automation Anywhere Tasks

Hi Team,I have a Thai language pdf where i need to extract the data from PDF. But when i try to extract the data from that PDF i am getting boxes instead of Thai characters. I have tried multiple way to read the data from PDF like PDF extract text activity and converted pdf to image and extracted data from that PDF. In all the way the extracted data is showing as boxes.Please suggest possible ways to extract/identify thai characters using automation anywhere.Thanks in advance 

111
Aaron.Gleason
10 hours ago
K
kumaririya19Member
asked in Developers Forum
good morning to all the best immediately by email

Velo Credit Loan Customer Care Helpline Number +91(8235639628) Toll-Free +91(7479837408) Call All Related Enquiry.

21
K
11 hours ago
S
ShammaHMember
asked in Community Edition
How can I loop through two data tables at once and increment a counter for both tables in Automation Anywhere?

I’m working with two data tables in Automation Anywhere and I need to loop through both tables simultaneously while comparing values (specifically temperatures). The challenge I’m facing is incrementing a counter once for both tables as I go through each row.Here’s what I want to achieve:I have two tables: WeatherOld and WeatherCurrent. I need to loop through both tables at the same time, comparing values from corresponding rows in both tables (e.g., comparing temperatures from the same city). I want to increment a counter once for both tables after processing each set of corresponding rows.How can I structure my loops and ensure the counter increments correctly for both tables at once?Any suggestions or guidance would be much appreciated!Thanks in advance!

515
Aaron.Gleason
11 hours ago
S
Srujana OS100222Customer
asked in Developers Forum
Excel as BD provider error

what are the Drivers requires to connect excel as Database 

7954
S
1 day ago
D
Danial ZiaPartner
asked in Developers Forum
Bot Migration from Enterprise to A360

I downloaded a Pivot table creation bot from bot store. Now I have to migrate it from Enterprise to A360. What are the ways to do it?

60
D
1 day ago
M
Michell.C1Partner
asked in Developers Forum
Can I use multi selection dropdown in a form?

I’ve been trying to use a multiselection dropdown in a form but it doesn’t show in the windows, or I only can use it in the copilot mode?I make this form and I’m esecuting It from a task (with interactive form:Display):  but I only can view this: 

2054
D
1 day ago
C
Chou6Member
asked in Developers Forum
Microsoft word save as dialog box instead of automatically downloading.

Upon clicking on a button, I need to get a Microsoft word save dialog box instead of automatically downloading the file. So that I can choose the location in my automation.

161
J
4 days ago
S
Song_Customer
asked in Developers Forum
How do I receive the browser javascript console.log result as an a360 variable value?

topic,I want receive the browser javascript console.log result as an a 360 variable value..can i get some guide? or a360 browser document? my code is herei = 0;while (i < 7) {    element = 'listitem' + i + 'innerListBoxdropdownlisteditorgrd2';    textContent = document.getElementById(element).textContent;    console.log(textContent);    i++;}I would appreciate really. it if solution 

1022
J
4 days ago
R
rveramendiCustomer
asked in Developers Forum
Email package FIFO EN LECTURA DE EMAILS

Los correos electrónicos se recuperan según la secuencia de las carpetas que aparecen en el campo Bandeja de entrada. Dentro de cada carpeta, los correos electrónicos se recuperan según la fecha y hora de recepción en el orden LIFO (último en entrar, primero en salir).  Necesito leer como FIFO, existe alguna alternativa?

182
R
4 days ago
E
emmanuelkatto24Member
asked in Developers Forum
Emmanuel Katto Dubai : Issue with Installing/Uninstalling Bot Agent - Network Resource Unavailable

Hi team,I'm Emmanuel Katto from Dubai,  United Arab Emirates (UAE) having trouble installing and uninstalling the Bot Agent on my system. Every time I attempt to install or uninstall, I receive a "network resource unavailable" error. I also tried to remove the bot agent via the Control Panel, but the error persists.Could someone assist me in resolving this? I’ve attached the error message for reference.Thanks in advance!RegardsEmmanuel Katto

91
J
4 days ago
Sishira
SishiraCustomer
asked in Developers Forum
Development Guideline and framework

Hi Team,I am new to AA. Need the community help to understand what best practice experts here recommend: 1- What is official recommended BOT Development framework which I should use while developing any BOT2- Any checklist you recommend to include for develop, review automation code 

392
Sishira
4 days ago
K
kiranrtuMember
asked in Community Edition
how to create VLOOKUP and pivot table using community edition v21.23

Hi Team,I need to create automate VLOOKUP and pivot table of dynamic data using A360 community edition v21.23 ...is there any command that can help me in the AA workbench. regards,kiran

12994
D
4 days ago
J
jesusostosPartner
asked in Automation Anywhere University
I DON'T HAVE THE DEVICE POOLS UNDER THE MANAGE MENU.

Good morning Automation Anywhere People, how are you?I trying to run the exercise:Maximizing Throughputof the 3rd. week, and this exercise take me to prepare the exercise:Creating and Managing Device Pools.but I don’t the authority to creates the Users and the Device Pools.Do I need to prepare this course or is it only for read and take the information of this course?Thanks a lot…Jesus Ostos. 

153
J
5 days ago
S
schehadeCustomer
asked in Developers Forum
Document Automation training validation feedback does not prevent fields not present on page from being extracted as incorrect values.

When I am validating data extracted from documents, I’m noticing that when a field is not present on one document, it is sometimes being extracted as as another incorrect value on the page. In the learning instance setup, the field is marked as optional and the confidence is set at 80%. I submit validation feedback by removing the mapping to the value, but each time I process a new document, it extracts the same incorrect data point. I have the same issue with tables that are being extracted for some documents for which the tables are not needed. Even after removing the mappings, the tables are extracted again when processing additional documents.  Is there a solution for this issue or a best practice for solving this problem? 

222
S
5 days ago
F
Francisco Javier.MPartner
asked in Developers Forum
Unable to update credential in CV using API and Encryption Key

Hi,  I’m trying to update a credential using the CV APIsI’m following this workflow1 - Authentication - {url}/v2/authentication - Done2 - List credentials - {url}/v2/credentialvault/credentials/list - Done3 - List credential attributes - {url}/v2/credentialvault/credentials/{id}/attributevalues - Done4 - Get Public Key - {url}/v2/credentialvault/keys/transport/public - Done at this point, I have the necessary to call the endpoint that update the attribute value5 - Update Attribute Value - /v2/credentialvault/credentials/{id}/attributevalues/{attributeValueId}?encryptionKey={publickey} When i request the put call the endpoint i receive the next message:{"code":"cv.validation.secure.keys.transport.invalid","details":null,"message":"The encryption key is incorrect"} the public key that i use in the Query Parameter is the string contained in the publicKey node of the step 4.Can anyone face the same issue?Any ideas to solve the problem? 

665
G
5 days ago
N
nikhilthakareMember
asked in Community Edition
Excel issue

I am getting below error while tried to open excel on both basic and advance package, last week was working fine.  

60
N
5 days ago
B
BirdThongchaiCustomer
asked in Community Edition
REST API Get method return 404 not found.

Hello everyone,I’m new learning AA, I’m now try to use action ‘Get method’ from under REST Web service in the order to get information of exchange rate from Bank Of Thailand web service.But It always return with 404 not found.I’ve tested same URL on simple test browser and return 401 unauthenticated. (on AA should be return the same).Could you suggest what I wrong?Thank you in advance.

396
B
5 days ago
D
dhruvssawant20Member
asked in Developers Forum
Not able to connect postgresql db

I am trying to connect postgresql db using userdefine connection and am passing port number like this <servername>,<port> and all other parameters however getting below error : This may be due to the following reason: Exception occurred in command execution. 'Could not Connect to Database. The connection attempt failed.'  Same work when i connect outside AA ..  Any help please 

213
Tamil Arasu10
Most Valuable Pathfinder
6 days ago
E
emmanuelkatto24Member
asked in Developers Forum
How can I extract and paste just a table from an email into Excel?

Hi everyone,I am Emmanuel Katto from Duabi, United Arab Emirates (UAE) need to copy only a table from an email body (without including any other content) and paste it directly into Excel as a table. Does anyone know the best way to do this? Any suggestions or tips on how to achieve this efficiently would be really helpful! RegardsEmmanuel Katto

121
Tamil Arasu10
Most Valuable Pathfinder
6 days ago
J
jan.marienCustomer
asked in Developer
Limitations of workload management package/ working with queues in A360

In my quest to integrate queues (workload management package) without API's I encounter some problems/questions.1) is it possible to loop through each queueitem with status 'New'? I only see the option Onhold, data error, failed. This parameter is not optional, so i can not leave it blank.2) is it possible to use the action 'Workload: update work item' outside of the "loop for each queueitem" but inside a task bot that uses a workload template? When yes, how can i get the workItemID of the currently picked up workItem? Is there a default attribute i can address to collect this data from the workitem itself?3) when non of the above is possible: is there a way to process queueitems without needing to re-do overhead steps again and again and a again for each picked up workitem without the usage of the WLM API's? It is a waste of time to login to UI applications, get accesstokens, get credentials, check environments each time again. By doing this a lot of valuable time is lost!4) Is it pos

200
J
6 days ago
A
Ajith 9655Partner
asked in Developers Forum
Unable to pass variable in rest web service post method.

Results not getting updated while pass the values using variable in Api post method. { "values":{ "Work Log Type":"Customer Communication","Detailed Description":"$detaildescrption$","Work Log Submitter":"MFDM","Incident Number":"$vIncidentId$"}}

203
Tamil Arasu10
Most Valuable Pathfinder
6 days ago
T
tripkkMember
asked in Developer
iq bot pre- processor : orient image

If we are getting the input from user as in image format but the orientation is not correct sometimes how bot can identify this image needs to be oriented correctly by bot

131
J
6 days ago
H
Harika 1170Member
asked in Community Edition
Can Bot identify Page Orientation?

How Can A360 bot identify page orientation?I have scanned PDFs and in those the page Orientation is in landscape , can bot identify whether the page is tilted or change in orientation through bot ?Is there any other solution for this ?or through Any Scripting?  

663
J
6 days ago
Terms & ConditionsCookie settings