Skip to main content

Developers Forum

The place for Developers to share and learn.

  • 4,312 Topics
  • 11,767 Replies
4312 Topics
LoganPrice
Most Valuable Pathfinder
LoganPriceMost Valuable Pathfinder
asked in Developers Forum
Connection String for CSV as Database in A360

Would you please kindly explain in detail how to use the "Database: Connect" action to access a .csv file on the runner's desktop? I have read through this prior APeople question, but the actual connection string syntax is not explained. Questions I have include:Do I have to install additional software on the runner in order to access a .csv like a database? I would like to avoid adding more software onto the runner.Are there a variety of connection string formats I could use?Is one preferable over the other?What does each part of the connection string mean? How can I apply this to my specific case (I have a desktop path to a .csv - I need to connect to it) I already have extensive knowledge of SQL and am very comfortable performing SELECT statements on data, but I am a complete novice at actually establishing the connection. We are using Windows 10 and, as far as I know, we just have the basic standard drivers installed. Thanks!

35974
C
Most Valuable Pathfinder
V
vineeth NagishettyCadet | Tier 2
asked in Developers Forum
How to ensure the input variable can accept Json format as well

Have created a bot where initially my input variables are strings. Now i want to pass Json content to it, what sort of changes have to be made in order to accept the Json content.  

2681
C
Most Valuable Pathfinder
P
Pallavi DesaiNavigator | Tier 3
asked in Developers Forum
Need help with SharePoint web page login

Hi,I want to create a Bot in which following steps needs to be done:Open a SharePoint site web page on chrome browser.  Sign in with Admin microsoft sharePoint account Open different links on the page from the menu Perform some click actions on the same page log out from the chrome browser pageWe are using v11 version yet. Need help with this bot specially how to login/sign in part

450
P
S
Semih 3318Pathfinder Advocate | Tier 6
asked in Developers Forum
Domain name isnt get loaded on the login screen of controlroom. What to do?

the dropdown list is empty. i found this but this is for A11 https://docs.automationanywhere.com/bundle/enterprise-v11.3/page/enterprise/topics/control-room/install/domains-drop-down-list-empty.html writing Domain\username worked for A11, but it was still waiting for a360I need solution for a360

3865
M
D
Dave.J2Cadet | Tier 2
asked in Developers Forum
New object cloning error "Unable to perform SetText Action" on an old BOT

I have a BOT in production that has been running successfully each night for many weeks. Last night I began to see the error "Unable to perform the SetText Action" on an Object Cloning line of code. What could cause this sudden change in behavior? We have at least one other production BOT that suddenly saw this error pop-up.

934
M
S
S SuryaTejaNavigator | Tier 3
asked in Developers Forum
how to get last 48 hours date from excel sheet using excel as database using sql?

Date column format (14-02-2023  12:57:00)Sql query with syntax?

500
S
C
Cesar.R1Cadet | Tier 2
asked in Developers Forum
SAP error freezing bot

Hello guys!I have a problem in a production environment: one of the automations uses SAP, however when there is some instability in it (connection, SAP crash and others), the bot is stuck infinitely. Is there any solution for this?Unfortunately it is disturbing the execution queue.

4756
R
I
ibtasaamCadet | Tier 2
asked in Developers Forum
Join datatable when i don't have a column name, but only column index

I am trying to perform a join using 2 Data Tables. DataTable1 is retrieved from a webpage where the column names are not being retrieved so I only have the column indexes. I don’t know how to perform a join when the join action is asking for the column name only and there is no option to provide a column index instead.  

1774
Raul Jaimes
C
cacorderoNavigator | Tier 3
asked in Developers Forum
Descargar informacion en archivo json

Buenos Días Necesito descargar información de una pagina web para que este en un archivo formato json, alguien sabe como podria hacer?

8032
Raul Jaimes
A
Allan Marques DiasGround Control | Tier 1
asked in Developers Forum
How to setup my MONTH FORMAT in AA11 ?

Hello AA Community, I would like to know how can I include 0 in the months that I have just one number, for example:If I use the system variable $Month$ it will bring the information below:Jan = 1Feb = 2Mar = 3I need the month number format like below:Jan = 01Feb = 02Mar = 03 Could you help me ? 

1161
Raul Jaimes
H
Harika 1170Cadet | Tier 2
asked in Developers Forum
How to come out of loop After finding header in dynamic row position

 I have a header in a dynamic row, after finding the header I have to read and write data from specific columns to output an excel file. I am able to transfer data. But not able to stop iteration through all rows after finding the header.         

420
H
J
Jun.TGround Control | Tier 1
asked in Developers Forum
切断されたBotRunnerがあっても利用可能なBotRunnerでタスクを実行する方法 How to perform tasks with BotRunner available even if there is a disconnected BotRunner

The new feature "Automatically select the number of Bot Runners users" announced in the v.27 release is a great solution.However, there is one troubled case.When a Bot is registered in multiple Botrunners and tries to execute a task in an available BotRunner,If even one of the registered BotRunners is disconnected, the bot itself will not be executed.Ideally, even if there is a Bot Runner that is disconnected, I'd like them to execute bot by rest available BotRunner.Is this feasible?v.27のリリースで発表された新機能「Automatically select the number of Bot Runners users」は素晴らしいソリューションだと思います。ただし、試したところ、困ったケースがあります。Botを複数のBotrunnerに登録して、利用可能なBot runnerでタスクを実行しようとした際に、登録したBotRunnerの内に１つでも接続が切れているものがあると、Bot自体が実行されない、という動きになります。理想は接続が切れているBot Runnerがあっても接続されているBotRunnerで実行されてほしいです。実現可能でしょうか？

1130
J
A
AzeglioCadet | Tier 2
asked in Developers Forum
Supported Python libraries for Task bots

I could not find a list of all supported python libraries when using python scripts with Task bots (not in IQ Bot!). Is there such a list? Or a different way to find out? :) I am using Cloud version of Automation Anywhere 360.

671
C
Most Valuable Pathfinder
I
IbalboGround Control | Tier 1
asked in Developers Forum
Gravador não funciona no site Power Apps

I'm trying to map the fields on the Power Apps website, but when using the normal recorder, it loses the reference when running, I tried using the AISense recorder but it's not working, does anyone know any other way to map this screen ? 

180
I
L
LSS 5396Cadet | Tier 2
asked in Developers Forum
Email Server Error: Running without stopping or showing error

Hi,The email server is not sending mail or showing any error while running. It keeps on running, even for over an hour. The configuration used is as follows:Email server : smtp.office365.comPort no: 587/25 (both having same situation)As per Biocon policy, the SSL/TSL must be enabled. When it is not enabled, the bot shows a Connection error message. PFA the screenshots and run log from CR. Kindly provide a solution for this.Old case: 01934975  [ ref:_00D90gDTd._5002tKfSce:ref ]Regards,Lekshmi

5639
Andoni_1
T
Tayyab 1511Cadet | Tier 2
asked in Developers Forum
MYSQL Syntax Error

Hi all, I am receiving the below error during bot running in v11, The database query is running accurately manually but showing an error during the process, don't know about this.“ you have an error in your SQL syntax check the manual that corresponds to your MySQL server version for the right syntax to use near " "1” 

631
Raul Jaimes
S
Semih 3318Pathfinder Advocate | Tier 6
asked in Developers Forum
A360 wait for window or recorder:capture seems always loading. What to do?

This is Automation 360 build 16685, I am migrating a task from A11 to A360 build 16685.I try to use recorder:capture and wait for window actions, but it doesn’t load windows, it seems always loading.says “notifying device”...Can you help?

1763
S
T
tin8420Cadet | Tier 2
asked in Developers Forum
Can't use recorder in the Edge with IE mode

I am using A360 V26 and when I tried to use recorder to capture HTML element in edge IE mode, it always capture the whole screen instead of element I want, but when I switch back to original IE page, it works fine again. I know that only version after V24 will be able to use recorder in edge IE mode but I already updated my A360 to the latest version so it seems like there’s some kind of bugs that don’t allow user to record them in edge IE mode. Thanks for all of your support in advance.  

2255
T
F
FinDGCadet | Tier 2
asked in Developers Forum
How to display excel data(say only values from 1 column Employee IDs) on AARI form

If I have an excel sheet with column Employee ID, this column has got 1000s of values. I wish to display these values on AARI form so that user can select 1 of them and then on selection that value is sent downstream to the bots built(say just show message box on value selected and sent back). Key here is , how do we show those 1000s of Employee IDs from excel or say even reading from WLM queue on AARI form.

420
F
L
lathabCadet | Tier 2
asked in Developers Forum
how to check empty with a string

how to compare empty with a string   

15592
rbkadiyam
Premier Pathfinder | Tier 7
rbkadiyam
Premier Pathfinder | Tier 7
rbkadiyamPremier Pathfinder | Tier 7
asked in Developers Forum
IQ bot learning instance download failing

I have uploaded  IQ learning instance from Dev to AT environment after migrating from 11.3 to 360. import and deployed in UAT. Now I am trying to take backup and download.Backup was successful, I am able to see the file in output folder but when i try to download i am getting  404 Error ( Error while downloading file) Request URL: https://URL/IQBot/api/backups/1bda1385-a40b-4171-82f7-b6105d3a98a8/download Request Method: GET Status Code: 404 Not Found I can see file in output folder with 1bda1385-a40b-4171-82f7-b6105d3a98a8-ATPRODMIGRATION_20230215_183015.iqba Let me know if any one having same issue with A360… 

360
rbkadiyam
Premier Pathfinder | Tier 7
G
GusGusCadet | Tier 2
asked in Developers Forum
I want to create workbook in google sheet but it's not working

Hi everyoneI found an error about create workbook in google sheet “An unexpected error occurred. null Please contact system administrator.”  So how can i solve this error 

815
rbkadiyam
Premier Pathfinder | Tier 7
rbkadiyam
Premier Pathfinder | Tier 7
rbkadiyamPremier Pathfinder | Tier 7
posted in Developers Forum
A360 - Control room is down due to DB issue

Issue :: A360 - Control room is down due to DB issue Error ::connect timed out. Verify the connection properties. Make sure that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port. Make sure that TCP connections to the port are not blocked by a firewall. This issue related to DB, password may change, DB serer may rebooted during maintenance window or networking issue to reach DB. Resolution:Restart A360 Services :  Restart the Control room services in the following sequence -Automation Anywhere Control Room Elastic Search service Automation Anywhere Control Room Caching Automation Anywhere Control Room Service Automation Anywhere Control Room Bot Compiler Service Automation Anywhere Control Room Storage Service Automation Anywhere Control Room IQBot Service Automation Anywhere Control Room Robotic Interface Service Automation Anywhere Control Room Discovery Bot Service Automation Anywhere Control Room Discovery Bot ML Service Automation Anywhe

4162
rbkadiyam
Premier Pathfinder | Tier 7
K
KLawCadet | Tier 2
asked in Developers Forum
Bot Insights Isn't Grabbing Data

Bot Insights/Analyze is failing to grab data. I have a bot that runs a bunch of smaller bots and when the smaller bots are run individually the data will populate in the dashboard. However, when run with the larger bot, the data isn’t populated and is completely lost. Is there a reason for this?I would appreciate any help that anyone can give

470
K
K
Kavindu PereraCadet | Tier 2
asked in Developers Forum
How to Loop through a string variable??

Hi, I’m a student who’s trying do assignment in Automation anywhere there’s some table data i have extracted from a pdf as a string variable.100 Clear front covers $0.49 $49.00 100 Black rear covers $0.99 $99.00 100 Color copies (pages 1-2) $2.99 $299.00 1000 Black and white copies $0.25 $250.00  I want to manipulate this string and get data separately I'm thinking if I can loop this string and get one by one rows to manipulate and get Like 100, Clear front covers, $0.49, $49.00. Thank you :)

4403
K
Terms & ConditionsCookie settings