Developers Forum

The place for Developers to share and learn.

  • 3,592 Topics
  • 9,589 Replies

3592 Topics

A
albertkila410Member
asked in Developers Forum

Build a bot to create a excel file with records

I want to build a bot that will create a excel file with records. How can I do that? What is the package I will use?

2
A
12 days ago
I
ishii_hiroyukiCustomer
asked in Developers Forum

Issue with AI Sense - "An internal error occurred in the recorder. Please stop recording and try again.

Hello,I've been encountering a persistent issue while using AI Sense in Automation Anywhere. Whenever I attempt to record an action, the following error message appears: "An internal error occurred in the recorder. Please stop recording and try again."I've already tried restarting my computer, but the issue persists. Could anyone provide insights or solutions to resolve this problem? Any advice or troubleshooting tips would be greatly appreciated.Thank you in advance for your help.

2
I
12 days ago
S
sleemandCustomer
asked in Developers Forum

IQ Bot OCR mistaking English/Latin characters for Cyrillic

I’ve run into an odd issue that was causing problems with our IQ bot document extraction.An invoice has a string which shows something like “PO 123456 - foo bar baz WO 987654” which gets extracted as a full string into the PO number field. I have some logic on this field to extract the numeric portion of the PO, but I discovered the OCR was storing the characters “PO” as unicode 1056 and 1054 which are the Cyrillic PO characters. When my python logic runs, it does not match due to this.import repo_match = re.compile(r'PO (\d{6,8})')match = re.search(po_match, field_value)if match: field_value = match[1]else: field_value = 'NO MATCH'I’ve worked around this using some replacements specifically related to this issue.field_value = field_value.replace(chr(1056),"P")field_value = field_value.replace(chr(1054),"O")I’m wondering if there is anything that can be done on the front end with IQ bot.My learning instance is configured as English, so I’m unsure why this even occurred in the fir

0
S
13 days ago
J
JustinH105691Customer
asked in Developers Forum

Unable to View Historical in Control Room

Hello! When trying to view details in Historical in Control Room, the details do not load.  Instead, after a while, a message “could not extract ResultSet” is displayed (see below).  Any idea what is causing this issue and how to resolve it? Thank you! Justin Hogan

1
J
13 days ago
Fouad G. Sabry
Fouad G. SabryCustomer
asked in Developers Forum

Forcefully closed the bot execution due to user stopping it.

Hello, The bot suddenly stops with the following message, and it happened many times across many machines.“Forcefully closed the bot execution due to user stopping it.”And of course, the user did not stop the bot.Did anyone experinece the same issue and what is the solution? Kind Regards,Fouad Sabry

1
R
14 days ago
J
JGABARRAMember
posted in Developers Forum

Python Execute Bot Error

I’m doing the Learning Trail: https://upskill.automationanywhere.com/learn/video/getting-started-with-the-python-packageOn the Python section.I’m supposed to input a text on the prompt.Then use Python script to reverse the input.But the output is just saying output error.I don’t think it’s an installation issue.Also my scripts are working outside of AA 

1
U
15 days ago
S
Siva ShankerK105734Partner
asked in Developers Forum

Unable to process documents in Document Automation.

Hi Team, I am unable to process documents in Document Automation. After uploading document it is showing as ‘Queued’ when checking in View Status and it is displaying as “The task is in queue and will be soon processed”. Please find attachment and let me know how to train in such case.

0
S
17 days ago
D
dhavalmodiMember
asked in Developers Forum

Subquery returned more than 1 value database query error

Hi.. I am getting below query error during database execution. Error - Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression automation anywhere a360 error. Query - UPDATE [Sheet1$$] SET [Status] = '$intCRMIncidentRequest$' WHERE UCase(Trim([Description])) LIKE '%$intReferenceNumber$%' AND UCase(Trim([Cr_Dr]))='CR' AND [Transaction_Amount] = $intAmount$.

0
D
18 days ago
K
Automate the Universe SME
khondokerAutomate the Universe SME
asked in Developers Forum

AARI Forms Table Values

Is there a way to add pattern based validation(for example using regex) to particular columns in AARI forms.I want to ensure that certain columns have data in a particular format before user is able to click submit button on the AARI form

2
K
Automate the Universe SME
18 days ago
G
GuruLokesh92Partner
asked in Developers Forum

How to paste images in Excel

Hi Team, I need to paste images from local path to Excel in separate sheets and send that Excel to client.I tried to use "Add picture from file to excel" bot from bot store but images getting disabled when image deleted or moved to another location.So please suggest me how to insert images which should not disappear. Thanks,Lokesh 

1
R
18 days ago
K
KeetzMember
asked in Developers Forum

Dependency file are not downloading completely

I have a bot, and while running downloading dependencies around 1.7 GB, but the dependencies are not sable to download completely, the CR is getting disconnected in between. And after relogin while running the bot, I’m getting the below error. But there is no activity in inprogress. I have tried several tries still the dependencies are not able to load properly Any solutions?-- How to get rid of this below error?-- Is still the downloading dependency activity is running in background, because of that only I’m unable to trigger another run?  

0
K
18 days ago
C
celestinoImpreCustomer
asked in Developers Forum

bot blocked

There is a way to get an alert when a bot crashes but the error handled in the bot itself does not arrive. Thank you

4
mandarB
18 days ago
mandarB
mandarBPartner
asked in Developers Forum

Docsumo Package in Automation Anywhere

Hi ,Have you guys tried using docsumo package in AA

0
mandarB
18 days ago
A
AA360SnailCustomer
asked in Developers Forum

Couldn't find "" Sheet in Macro Excel Using Excel Advanced

I’m using Excel Advanced to open a macro file on version 21.112 or above. Recently, I’ve ben running into an issue where the macro file does open but the bot crashed saying it cannot find a sheet. “Unable to find sheet '' in file …” is the message I receive when attempting to run.The first time this issue appeared was on 12-20-2023, and ever since, the bot has continued to crash when being run manually or scheduled. I’ve attempted to select a specific sheet in the same Open Excel Advanced action, but it provide the same error, just with the selected sheet within the apostrophes of the message above. I’ve also tried unhiding all sheets, graphs, and everything in-between, but same issue.Does anyone have a similar issue or have a work around solution? I need the file to be a local excel session so I can manipulate the data within. 

3
W
19 days ago
H
hemanth.vasanthPartner
asked in Developers Forum

Extract Historical data through control API using start and end date

Hi Team,Required to extract Historical data through control API using start and end date only like bot insight APIthanks in advance

1
H
19 days ago
G
gregbowersMember
asked in Developers Forum

Integrating CPQ with Legacy Systems

Hello I'm exploring the integration of Salesforce CPQ with legacy systems using RPA (Robotic Process Automation) and seeking insights into the challenges and strategies involved in this process. Specifically, I'm interested in understanding how to overcome potential data silos and ensure seamless integration between modern CPQ solutions and older, legacy systems.Some key points for discussion include:Challenges: What are the main hurdles faced when integrating CPQ with legacy systems using RPA? Examples may include compatibility issues, data format discrepancies, and process complexities. Strategies: What strategies or best practices can be employed to address these challenges effectively? Are there specific RPA techniques or tools that prove particularly useful in this context? Data Silo Mitigation: How can organizations mitigate the risk of data silos arising from the integration of CPQ with legacy systems? What steps can be taken to ensure data consistency and accessibility across a

0
G
20 days ago
S
smanojkMember
asked in Developers Forum

Need for user presence while running bot inside the server and scheduling options.

Hi,I tried to run the bot inside the server using citizen license. while running the bot, i have minimize the server and bot has been stopped running. is it necessary to keep the screen without disturbing while running even inside the server ?Do we have scheduling options to schedule the bot  or something like listener option to trigger the bot once file is placed into the folder.  

0
S
20 days ago
P
prasadnPartner
posted in Developers Forum

'LIMIT' SQL query not working in A360

Limit sql query not working in A360 .Please help 

0
P
20 days ago
Ganesh Bhat
Ganesh BhatPartner
posted in Developers Forum

Seamlessly Switch Between Runner/Creator Devices in Automation Anywhere Control Room Without Uninstalling Bot Agents 😊

Switch Bot Agent to a Different Control Room Are you tired of constantly switching between devices for your Control Room login, only to be greeted by the frustrating error message, "This device is already registered with another Control Room"? It's a common hiccup we encounter when juggling Control Room logins on the same device. But fear not, for there is a solution at hand! Understanding the Issue:Before we delve into the fix, let's dissect why this error occurs in the first place. The Control Room associates each device with a unique registration, allowing only one Control Room per device at any given time. So, how do we resolve this issue and effectively delete the device registration? Deleting or Renaming registration.properties File: Here's the answer: Navigate to the Registration properties File Path: C:\Windows\System32\config\systemprofile\AppData\Local\AutomationAnywhere. Once there, locate and either delete or rename the "registration.properties" file. With this step complet

0
Ganesh Bhat
20 days ago
S
Automate the Universe SME
Semih 3318Automate the Universe SME
asked in Developers Forum

Why can't I send png file visible in email body?

I did this many times, and it worked.Now i created a task.In attachment I added “C:\Users\botcreator1\Desktop\invoiceKumulatifKontrol.png”and in email body, <img src="cid:invoiceKumulatifKontrol.png">but it sends it in attachment. What should I do?

1
S
Automate the Universe SME
20 days ago
D
Deepak BasarPartner
asked in Developers Forum

unable to read latest files from the folders

hi i am using file folder trigger to run the bot .when new file is added in folder bot has trigger and read newly added xml file .but somtimes two or more files are added in the folder at same time  (suppose 5 files added at same time the bot is triggered 5 times but it reads only same file each time .I need read those 5 files one by one). i just want to read newly added latest files not exesting files how i overcome this problem . (Note: latest file is comes at first index always)

1
S
Automate the Universe SME
20 days ago
S
Siva ShankerK105734Partner
asked in Developers Forum

Sample PDF files for Document Automation

Hi Team, please post some sample documents for Document Automation Practice purpose. Or please let me know where I can find them.

1
J
20 days ago
S
Sergio SouzaPartner
asked in Developers Forum

Handle sessions in a custom package

Hello,We are creating a special package that will have actions to connect and disconnect from the database and some actions that will manipulate data in a table. For the actions that will manipulate the data I need to pass the handle of the connection created in the connect action. how do I do this?The explanation "Handle sessions in a custom package" in the documentation gives some light but does not have some clear points. Does anyone have working example code?I need it to be a customized package because we will manipulate data that cannot be visible in the automation. Thank you for any helpSergio Souza

0
S
20 days ago
T
tayyabimtiaz1Partner
asked in Developers Forum

Error message: Unable to perform auto-login for user abc

Hi all, I am trying to run/schedule some Bots but the bot failed with below error. I have also updated the control room device setting with all possible options but failed.Always create a new sessionReuse an existing sessionReuse an existing session, if available after changing these 3 options still get the same error “Error message: Unable to perform auto-login for user”. 

0
T
20 days ago
A
AnalystCallenCustomer
asked in Developers Forum

What is the best way to compare versions between what is in Public compared to Production Control Room?

We currently do not have a Sandbox environment. Most of the time, our Public Control Room matches the Production Control Room. There have been times where we have noticed the two CRs have bots with different versions unexpectedly (e.g., we did not push something to Production so it sat in Public). What is the best way to compare tasks/module versions in Production versus what is in Public?

3
K
20 days ago
Terms & ConditionsCookie settings