Skip to main content

Forums

Activate your network - connect, collaborate & be inspired.

5026 Topics
P
PushpiMember
asked in Developers Forum
Framework

Hi, Can someone tell me what is framework  and how we will create it in AA360?

611
Tamil Arasu10
Most Valuable Pathfinder
11 months ago
K
Ken 3236Customer
asked in Developers Forum
"Write from data table" is always TEXT in Excel

Hello,When I write from data table into excel worksheet the numbers are stored as text.  I need them to be numbers so I can put in formulas and have the calculations work properly.  I have tried several things.Changed format of all cells to ‘number’ (didn’t work). Made sure I was using .xlsx and not .csv file. Changed column type on data table to ‘numbers’ and then did write from data table (didn’t work). Turned off the error checking in Excel Options (didn’t work).What am I doing wrong??  How do I fix?

3344
J
11 months ago
T
TSantosMember
asked in Developers Forum
XML navigation

Hello everyone!I have a question about XML navigation, hope you can help!That’s basically the XML I have: For every XML doc I have the infNFe and from 1 to 999 “det” nodes and inside each det nItem node, I have the other nodes.The question here is how I can navigate from det node to det node if their name is the same and what differences them is the “nItem” attribute.For the first “det” node I can already reach the inside nodes with:NFe/infNFe/det/prod/NCMBut I don’t know how I can navigate throught them and get the NCM node from every “det” node. I hope I could make myself clear on my question.Thank you! 

240
T
11 months ago
J
Justin 8206Member
asked in Community Edition
Bot Stucked in Queued

Hi, Would just like to ask for help. My bot is stucked in queued in community edition. Is there a way to remove it? I already tried resetting the device through API and deleting the code, it is still stucked as queued.  

5836
A
11 months ago
A
AutoBot88Member
asked in Community Edition
BOT stuck in "In Progress" activity, with status "Waiting for user connect..."

I running the bot, but stuck in “In Progress” activity with status waiting. try restarting the service = doesn’t work logout login = doesn’t workhow can i solve it?

2802
A
11 months ago
N
Nikil_D_Gr8Member
asked in Community Edition
Automation anywhere doesnt launch even though i cleared browser data

 

1986
N
11 months ago
R
Rohan Tiwari 6713Customer
asked in Developers Forum
Alternative for database update command

Hi,I want to update an excel using update command where I set some values using where condition. Is there any alternative to this? Can I use an excel command for doing this? I don’t want to use database. I cannot see any command for this in automation anywhere

864
J
11 months ago
J
JMarinoCustomer
asked in Developers Forum
Detecting an SAP Session

Does anyone know how to detect if an SAP Session has been initiated or not? Like in an IF statement. I don’t mean SAP itself, just if the SAP Connect action has resulted in an active session for use in AA.I’ve placed the SAP Disconnect action in the catch of my error trapping to disconnect if there are errors. But I only want it to execute if there’s an active session. I’m thinking of moving the Disconnect action to a Finally section of error handling, but I think I may still experience issues if there’s not an active session.

1463
J
11 months ago
LoganPrice
Most Valuable Pathfinder
LoganPriceMost Valuable Pathfinder
posted in Developers Forum
"CSV/TXT: Read" Does not capture last column(s) if they are blank, EVEN IF they have headers

Has anyone else noticed that the "CSV/TXT: Read" action ignores the last column in a CSV if that column is null, despite the column having a header? For example, if you open the following CSV and read it:key val1 val2 val3 val4 1001   “StringData” “StringData”   1002 “StringData”   “StringData”    Your data table will only have 4 columns, “key”, “val1”, “val2”, and “val3”; “val4” will be omitted. This seems like an oversight to me and I think it should be fixed in future releases. I think we should at least have the option to toggle “headers” on and off to tell the “read” action how to interpret our files. EDIT:The “read” action appears to read the final column, but you can’t reference it. For example, I have a CSV with 14 columns, and the last is blank. When read into a DataTable, the table column count is 14, but when I reference index “13” (which is the 14th index position), I get an error that the index is out of bounds. Very odd to me.

1462
LoganPrice
Most Valuable Pathfinder
11 months ago
A
Arthas03Member
asked in Developers Forum
AA SQL dropping tables 

How does some one drop a list of tables and verify first ifd the y exit or not if they dont the BOT runs as it should but if they exist drop them  

1136
A
11 months ago
M
manognya.prasadPartner
asked in Community Edition
Invalid expression

wondering why am I getting invalid expression even if my regex expression matches with Tax (30%) - $46    

1263
Abhay Naik
11 months ago
K
Kerry 5181Member
asked in Automation Anywhere University
login to https://university.automationanywhere.com/ just loops

Used to be able to access this area but not anymore, it just loops and loops indefinitely.  Cleared cache, recycled chrome, tried Edge also with same results, rebooted laptop, have a stable wifi connection, etc, etc - what am I missing? https://university.automationanywhere.com/ Trying to get back to the Citizen Developer path

533
Padmakumar
11 months ago
M
manognya.prasadPartner
asked in Community Edition
Filepath creation

 I am unable to create a file path and getting the following error.  

1083
M
11 months ago
K
Kumar RanjanMember
asked in Community Edition
In progress Tab

Unable to remove bot from inprogress tab since many hours.  

954
R
11 months ago
H
HenrysmothMember
asked in Developers Forum
Bot Execution Failure in VM Post-Password Reset in Automation Anywhere Control Room

Hi,  It appears that after resetting the password for a bot operating within a Virtual Machine (VM), I updated the corresponding credentials in the Automation Anywhere (AA) Control Room. However, while the bot runs manually correctly(I believe so) in the Control Room, it fails to execute within the VM. Additionally, there is an absence of log generation in this context. Could you provide guidance on resolving this issue? thanks

532
R
11 months ago
M
manognya.prasadPartner
asked in Developers Forum
reading pdf data

I am getting an above error while try to extract data to excel from pdf, Just wondering if I am missing any action here

681
Abhay Naik
11 months ago
S
s 9425Member
asked in Developers Forum
Excel Datetime function - Assign function not working correcting

I want to loop through this format of a string and only execute a function if system date is more than this column, how can i compare the string to a system date. I have tried using datetime assign but the format is not getting accepted. The format I enter in custom format is MMM dd, yyyy HH:mm but its not getting converted to string for me to compare and execute next function. Please helpTimestamp Jan 5, 2024 09:03 Jan 5, 2024 08:22 Jan 5, 2024 08:20 Jan 5, 2024 08:18 Jan 5, 2024 08:09 Jan 5, 2024 07:46 Jan 5, 2024 07:46 Jan 5, 2024 09:39

711
Padmakumar
11 months ago
S
s 9425Member
asked in Developers Forum
Excel Datetime function

I want to loop through this format of a string and only execute a fucntion if system date is more than this column, how can i compare the string to a system date. I have tried using datetime assign but the format is not getting accepted. The format I enter in custom format is MMM dd, yyyy HH:mm but its not getting converted to string for me to compare and execute next function. Please helpTimestamp Jan 5, 2024 09:03 Jan 5, 2024 08:22 Jan 5, 2024 08:20 Jan 5, 2024 08:18 Jan 5, 2024 08:09 Jan 5, 2024 07:46 Jan 5, 2024 07:46 Jan 5, 2024 09:39

1046
S
11 months ago
Y
Yousuf MullaMember
asked in Developers Forum
Bot Agent error

An unusual error is occurring when I am trying to run my bot. I checked all log files, searched for error but no solution. I have installed A360 on my D drive.I have re-installed both bot agent and A360 but error is still there. I have also downloaded SSL certificate of control room and imported it in .cert file as directed in below link.error image is attached.I have checked for dependencies error, but no error found.there is plenty of storage.I have no proxy installedwhat is the fix?  

2213
Padmakumar
11 months ago
L
LesleyCustomer
posted in Developers Forum
DOMXPATH ISSUE

I want to capture the green highlighted domxpath in a list from an application however this needs to be dynamic, so every time the bot can click on the element.If you see they is a pattern in the domxpath list however when it captures the blue highlighted domxpath and move to the next element which is the green highlighted domxpath it has a seven and not a six .When I do an html inspect in chrome it shows they is a hidden element between div[5] and div[7].How do I dynamically capture the element?//form[@name='form']/div[5]/div[2]/div[1]/div[2]/div[1]/div[1]/div[1]/p[1]/label[1]//form[@name='form']/div[5]/div[2]/div[1]/div[2]/div[2]/div[1]/div[1]/p[1]/label[1]//form[@name='form']/div[5]/div[2]/div[1]/div[2]/div[3]/div[1]/div[1]/p[1]/label[1]//form[@name='form']/div[5]/div[2]/div[1]/div[2]/div[4]/div[1]/div[1]/p[1]/label[1]//form[@name='form']/div[5]/div[2]/div[1]/div[2]/div[5]/div[1]/div[1]/p[1]/label[1]//form[@name='form']/div[5]/div[2]/div[1]/div[2]/div[7]/div[1]/div[1]/p[1]/label[1]/

1032
S
11 months ago
P
PushpiMember
asked in Developers Forum
Excel

In the loop excel basic  set cell commnad is not working where as excel advance is working. Can someon tell me why is that happening.

723
Padmakumar
11 months ago
M
MaviaCustomer
asked in Developers Forum
How to setup WSSE Authorization Header for a SOAP Service

Hi,I’m developing in Automation Anywhere360 and using SOAP Web Service action. but the SOAP service that I need to connect requires a WSSE Authorization Header that needs to contain the User, Password and Timestamp. Can someone provide me with an example of how to setup that in the SOAP Web Service Action? 

420
M
1 year ago
jayqb
Automate the Universe SME
jayqbAutomate the Universe SME
asked in Developers Forum
AARI - Process, Task bot and Form

Hey, I’m working on a process for our accounting team and I’ve managed to build out a process that when they hit run in AARI it will show a form to upload a csv file which will be used in the task bot process to format the data in the excel and once completed I was wondering if I there is a way to show a different form with hyperlink to download the file within one process? perhaps if there would be a way to output variables from task bot to form that might work? I’m aware that I can drop the file “somewhere” using task bot or send them back in attached email, but it would be cool to have it all in one process run.  Thanks,J

1400
jayqb
Automate the Universe SME
1 year ago
H
HemanthavasanthMember
asked in Automation Anywhere University
Document Automation Assessment retake

Hi team,In the Document essentials we have an assessment. Is there anyway that we can retake the course and assessment from first after failing in 2 attempts of exam Any assistance would be grateful

2643
H
1 year ago
T
Tharushi GalappaththiPartner
asked in Developers Forum
What are the Reply URL & Sign In URL in Automation Anywhere for generate Client ID, Secrect & Tenant ID in SharePoint

We need to access SharePoint location through Automation Anywhere and for that have to configurea.       Client IDb.       Client Secretc.       Tenant ID  To config these in SharePoint IT has requested ·      1.Reply URL ·      2.Sign in URLPlease help us to find what are those URLs to connect AA + SharePoint

2718
T
1 year ago
Terms & ConditionsCookie settings