Skip to main content

Developers Forum

The place for Developers to share and learn.

  • 3,914 Topics
  • 10,354 Replies
3914 Topics
A
anandcPartner
asked in Developers Forum
Can we pass datatable as input to a C# DLL as a parameter ?

Hi Team, I wanted to pass DataTable as input parameter to C# DLL. I am unable to find Datatable parameter in the parameter type. Is it possible to pass Datatable as an input? Is there a workaround to pass a datatable as parameter? DLL Parameter 

5
D
5 months ago
P
priyankapriyaMember
asked in Developers Forum
csv date automatic conversion

when iam saving 2023-09-08 in csv format.It is automatically saving to different date formatHow to stop automatic conversion.

2
jayqb
Automate the Universe SME
5 months ago
U
User005262Customer
asked in Developers Forum
New features of V30 and recording by Beta

Regarding the new Beta recording feature in V30, it says it can be downloaded from the activity history, but there is no such thing on the screen. Is there a setting I need to do?

4
U
5 months ago
S
Sai Deepan.RPartner
asked in Developers Forum
Unable to delete excel file

As part of automation I create 6 excel files in the working folder. I delete the files from the working folder before every run. This works 90% of time but 10% of time the bot fails at the delete step.There are no files in the folder in the folder. I rerun the bot and I get the same error until I restart the machine. I have created a test bot to show the steps.Error : File:com.automationanywhere.botcommand.exception.BotCommandException: Unable to delete the file(s) 'C:\Automation Anywhere\Management Reporting and Planning\Working Folder\~$EmpManagerMapping_022024.xlsx' because access is denied. - 16 

4
Tamil Arasu10
Most Valuable Pathfinder
5 months ago
Z
ZaithelCustomer
asked in Developers Forum
Document Automation getting the column names

Hello,  I’m using the Document Automation to extract values from different invoices, but for some reason, there are a couple of invoices types where instead of extracting the value of the table row, the bot extracts the column name ex:Invoice number → “Reference”Date → 12/05/2023Amount → 3456.34So, instead of the invoice number being 123456 or so, I’m getting “Reference” which is the column name.Does anyone knows what else can I do? 

0
Z
5 months ago
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
5 months 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
5 months 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
5 months 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
5 months 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
rima.sengupta
5 months 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
5 months 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
5 months 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
5 months 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
5 months 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
5 months 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
5 months ago
mandarB
mandarBPartner
asked in Developers Forum
Docsumo Package in Automation Anywhere

Hi ,Have you guys tried using docsumo package in AA

0
mandarB
5 months 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
5 months 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
5 months 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
5 months 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
5 months 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
5 months ago
Ganesh Bhat
Most Valuable Pathfinder
Ganesh BhatMost Valuable Pathfinder
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
Most Valuable Pathfinder
5 months 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
5 months 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
5 months ago
Terms & ConditionsCookie settings