Skip to main content

Forums

Activate your network - connect, collaborate & be inspired.

5021 Topics
E
erickbenitezMember
asked in Developers Forum
Problem with the action DataBase Connect

Hello community, please I need your help and expertise.Currently I want import data from my sql server to csv file, but I am receiving this error:     “Cannot find any Connect command using session name 'Default'”  I was checking some way to verify if the “Default” session is configurate but I cannot find anything in the control room.¿Can you help me somebody please?  🙏🏼

71920
E
1 year ago
A
Anthony YeoNew Member
asked in Community Edition
How to I whatsapp a picture to my client?

How to I whatsapp a picture to my client?

2645
C
Most Valuable Pathfinder
1 year ago
S
swethaparthasarathyNew Member
asked in Developers Forum
Writing exception message in CSV file

Hi, I am trying to write the exception message into a CSV file using Log To File command. While doing that, the exception message is getting inserted into two cells, rather than in a single cell itself.  So can someone please let me know on how to get the exception message in single cell?

984
Raul Jaimes
1 year ago
F
Fuentes 5225New Member
asked in Developers Forum
can you use automation anywhere without internet?

I have a requirement to perform an automation on a computer without an internet connection. What kind of license do I need to do this job?

832
Raul Jaimes
1 year ago
L
Laura Sanchez
asked in Developers Forum
Office 365 Excel - Using data table variable

Hello,  In Excel advanced I could do the following instructions: Excel advanced: Get worksheet as data tableExcel advanced: Write from data table However, it seems I can't do them anymore with Office 365 Excel Could anyone give me a hand with this??

454
C
Most Valuable Pathfinder
1 year ago
H
Harika 1170Member
asked in Community Edition
read column names in excel

how to read column names in excel, where the position/index of column name changes for each file

5391
Padmakumar
1 year ago
P
pablo 2030Partner
asked in Community Edition
there was a problem with my credentials

Hi everybdy,I’m trying to do login in a web page. I can’t access to my credentials:login with credentials​​​​problem with credentialsHow can I fix this error?? Why I get error in line #0 if there isn´t line #0 in my code??A lot of thanks :) 

22827
P
1 year ago
B
BrobertCustomer
asked in Developers Forum
Using the loop function to process cell values in a column of a CSV file

Hi All,I working on creating a bot to process a cell value in a single column in an CSV document, F2, and once that processing is complete the bot would go to the next cell below, F3, in that column until there is an empty cell.I started with an example CSV doc with values in cells F2 and F3, and after the opening the file in line 4, I set used the Get multiple cells function to get multiple cells and store those two values in the table titled TABLEofHSIPNos.  With the loop function it looks like I set it up to loop through the each row of the TABLEofHSIPNos and record the values in HSIPNoFromTable. However from here, I don’t understand how to use the above steps to, for example, create a message bot that would process each of value in the column from cell F2 to F[# of cells that contain a value] (which could be up to 100).  I would appreciate any advice on how to use the loop to process each individual cell values from F2 - F[N] in an CSV. Thank you for reading, and thank you in advan

3610
B
1 year ago
A
ajith 2492
asked in Developers Forum
How can I import task bot from private to public

Hi,I want to import a task bot from private folder to public folder to schedule my bot.

6062
rbkadiyam
Automate the Universe SME
1 year ago
G
GabrieleC102784Customer
asked in Developers Forum
Run SQL and export with pipe delimiter

Dear All,I’ve to run a query returning millions of record (no datatable usage possible) and export the result to a pipe separated CSV.Do you know any solution/workaround to force a different CSV delimiter when exporting to excel?

1624
G
1 year ago
S
srinathbCustomer
asked in Developers Forum
UNKOWN: User:(user id) is already running a bot on device: (device name)

Hello, We are repeatedly getting error pop up when we try to run the task on A360. The error pop up says UNKOWN: User:(user id) is already running a bot on device: (device name).  We also see, the task is listed in pending execution state under CR->In Progress screen even though the task is successfully completed.  The only workaround we are aware is to restart bot agent service and we are doing almost every-time before running a task. We see similar issues reported by other users here but none has found a solution yet.https://apeople.automationanywhere.com/s/question/0D52t00001b0rvkCAA/why-am-i-getting-this-error-while-trying-to-run-a-bot-unknown-user-username-is-already-running-a-bot-on-device-if-the-problem-persists-please-contact-your-system-administrator?language=en_US__;!!KLCbKzk!jzFApkASE3W4sOY5Rlfbx5iyY1u_iiY8SJjsbO7cEYNO3E-RbmHFCiV8vlcbcAwqHLLh74ulmXIgYPxt2LGNwQeihmSEX6Dq7kQ$"alt="https://urldefense.com/v3/__https://apeople.automationanywhere.com/s/question/0D52t00001b0rvkC

14924
A
1 year ago
D
Dave_1New Member
asked in Developers Forum
Split Single page PDF into 2 individual PDFs via Text delimiter

Can anyone help me with below problem statementCode for Splitting Single page PDF into 2 individual PDFs via Text delimiterPlease don't share stack overflow links already been there, open for Python or any other programming solution which will work.

542
D
1 year ago
R
Rashmi.B2Partner
asked in Developers Forum
How to use 'Open Program/File' action to launch a URL in the same chrome tab?

I am using the 'Open Program/File' action to launch a website. One webpage is already open in the chrome, and I want to launch a new one in the same tab. I have entered the path of chrome.exe in the Location field and the URL in the Parameters field. What parameter should I add to launch the URL in the the same chrome tab? 

7715
C
Most Valuable Pathfinder
1 year ago
V
vineeth NagishettyPartner
asked in Developers Forum
Asynchronous HTTP response

Can the AA360 control room API's are capable of returning an asynchronous HTTP response?

582
C
Most Valuable Pathfinder
1 year ago
C
CHAKRI 3011Member
asked in Developers Forum
Automate or Display Weekdays like Sunday Monday

Is it possible to display weekdays validation using A360 BOT., I mean in a calendar take one date for example take date 21-01-2023 - Saturday, using this date how can we validate 21-01-2023 is Saturday or Not? Please suggest logic.

4797
C
1 year ago
B
botLCustomer
asked in Developers Forum
Bot not retrieving data from one column in database query

I am developing a bot which reads from a SQL database. All works well with the exception of one column in the table. The bot does not retrieve any text from that column - when storing that column's contents to a data table, that row is blank. All other columns' contents are read/exported fine.  The data type of the column is VARCHAR(MAX) and its contents are the body of an email. My query works fine in MySQL but nothing is returned from the query when used within Automation Anywhere. I have tried removing the carriage return (CHAR(13)), the line feed (CHAR(10)), and tab (CHAR(9)) in the SELECT statement, thinking that could be the cause of the problem but the data table row for this column is still blank. I have tried exporting the data to CSV using every encoding option and Automation Anywhere still retrieves nothing, although the queries work fine in MySQL. What could be the reason for this? Example of the SLEECT statement as used in the 'Export to data table' and &#3

1422
C
1 year ago
S
Shusha321Member
asked in Community Edition
An unexpected problem occured during taskbot deployment

Hi, Good day! Does someone here has an idea on how to fix this error “ An unexpected problem occurred” ? I can’t successfully run a taskbot in botcreator because of this prompt error. I don’t know where it started and how to fix this. So I’m here asking for your help and guidance. Thanks in Advance.

8634
Raul Jaimes
1 year ago
V
virangahCustomer
asked in Developers Forum
High Availability of AA 360

We have one control room and we need to scale up the same to high availability architecture.Control room high availability  How we can make high availability for un attendant BOT runners.Thanks 

352
Raul Jaimes
1 year ago
L
lathabCustomer
asked in Developers Forum
Enter using simulate keystroke

How to add ENTER using simulate keystroke action in A360, as I don’t see enter in virtual keyboard. 

6192
rbkadiyam
Automate the Universe SME
1 year ago
V
Most Valuable Pathfinder
Vern DicksonMost Valuable Pathfinder
asked in Developers Forum
SQL Values In CSV File in A360 don't match Values in V11

We are migrating a SQL query over a DB2 file from V11 to A360 that outputs to a CSV file. The values from V11 look like this:The same results from the A360 query look like this:Any suggestions on what might be causing this or how to correct it?

401
Raul Jaimes
1 year ago
A
ajith 2492
asked in Developers Forum
Recorder has experienced an internal error. Please stop recording and try again

Hi,I was trying to define an image button using AISense recorder and it is showing this error every time when I do so.Please help me with this.  

2382
rbkadiyam
Automate the Universe SME
1 year ago
V
vineeth NagishettyPartner
asked in Developers Forum
API key for authentication as a query parameter

Does the AA360 control room API's allow adding an API key for authentication as a query parameter?

742
rbkadiyam
Automate the Universe SME
1 year ago
A
anandcPartner
asked in Developers Forum
Filter Datatable based on specific values

Is there a way to filter Datatable based on specific columns using inbuilt Datatable package or other packages? For example, Suppose we have a Datatable with columns “Name and ID”. I want to filter all the data with specific name and ID. Note - I do not want to use loops since the number of data is high and also cannot write the data to excel and use excel as database query, due to certain limitations in the client environment.

10913
Padmakumar
1 year ago
R
Rajeswari.N1Partner
asked in Developers Forum
States Property gives Null value

HI ALL,  I am creating a bot for Dynamics 365 where in a field is disabled and it will enable after few actions. So I need to confirm if the property of the field is enabled or not to perform next actions.For this , I am trying with Recorder - get property - ‘States’ which shows value as ‘Unavailable’ when that field is disabled and the value of States property is null as soon the field is enabled in UI screen.Now , running the bot when the field is disable and the States value is unavailable but then it is taking as null value though the value is assigned in the Property  Please could you help 

1142
Marc 1985
1 year ago
A
Asif 3500Member
asked in Community Edition
How to Download automation anywhere community edition desktop version?

I am new to automation anywhere, for learning purpose I want to install automation anywhere community desktop version, please suggest from where can I download the setup?Thanks

16952
A
1 year ago
Terms & ConditionsCookie settings