Developers Forum

I am running this script after manual input this script in automation anywhere python open package and after that using execute script package but no output file is getting generated but this code is working fine in pycharm from docx import Documentfrom docx.oxml.ns import qnfrom docx.oxml import OxmlElementimport osdef add_bullet(paragraph):    p = paragraph._p    pPr = p.get_or_add_pPr()    numPr = OxmlElement('w:numPr')    ilvl = OxmlElement('w:ilvl')    ilvl.set(qn('w:val'), '0')    numId = OxmlElement('w:numId')    numId.set(qn('w:val'), '1')    numPr.append(ilvl)    numPr.append(numId)    pPr.append(numPr)def save_markdown_to_word(md_text, file_path):    doc = Document()    lines = md_text.split('\n')    for line in lines:        line = line.strip()        if not line:            continue        if line.startswith('### '):

Anyone encountered this issue?Please suggest, If I am missing anything.Appreciate any help! 🙏Agenda:I am trying to pass comma-separated values to a dropdown in a form.Issue:When I pass the hardcoded values , the dropdown works correctly and displays multiple options.Example: Dropdown shows separate options. But when I pass the same values using a variable, the dropdown interprets it as a single consolidated string.Example:

Hi. I am trying to copy an Excel formula into several cells as a test. In the final exercise, there will be more than 400,000 rows. When I apply the keystroke with the following condition “[CTRL DOWN]d[CTRL UP],” nothing happens. However, if I perform the action with the Control + d keyboard shortcut, it replicates the formula downwards in all the selected rows. But when I perform the action via the keyboard, it takes me 1 minute to do it. Can you give me any idea why Control + d does not work for me? note: I cannot do this with a loop because it takes 2 hours for 194k records.  

While using Record option I am again and again getting this error. Bot Launcher for user session Admin crashed. Last recorded command recorder at line number 1. Please help me resolve the error

Hi,I’m using domxpath: //table[@id='_pl5zpc']//tr[$Counter.Number:toString$]//input[@type='checkbox' and contains(@class, 'w-chk-native')] to select the checkboxes. How can I verify that the checkbox is unchecked? Below is the screenshot of the object properties. 

Hello Team,I have two unattended runners (botrunner and botrunner3), and I need to complete 400 tasks every day. I have divided these tasks equally between the two runners, giving each 200 tasks. I want to create a device pool to manage the workload efficiently.However, I'm facing an issue with the device pool. Whenever I try to run tasks using the device pool, it always selects the device associated with botrunner (machine 1). If I'm logged in using the botrunner account, the task status shows as "picked at run time," but it does not choose botrunner3 for execution.can anyone suggest what is the exact issue?

Hi Team,I am new to AA. Need the community help to understand what best practice experts here recommend: 1- What is official recommended BOT Development framework which I should use while developing any BOT2- Any checklist you recommend to include for develop, review automation code 

Is there any way to retrieve a specific value from a data table like the following: StringVar = TableVar[0,1] ie, get value at row 1 column 1  in TableVar and insert it into StringVar. Or do i have to loop through the table one row at a time to get the value i want? 

Hello all, I have a feeling this is a long shot but thought i would ask none the less. We have a bot that reads in the contents of an email  which contains a list of information in the format <LABEL>: <VALUE>.Unfortunately, sometimes there are hidden special characters after a value. If I were to manually highlight the value in the email i can tell there are special characters usually by the fact there is more than one space after the value. The bot reads in the value along with its special characters which then causes problems later on in the code. I don’t suppose there is any way to check for and weed out special characters in an email?

Im getting Bot Error while executing python script but is successful while running it on other IDE:Here’s the code: import pandas as pdinput_data = pd.read_excel('inputdata.xlsx')master_data = pd.read_excel('masterdata.xlsx')filtered_data = input_data[input_data['Start time'].isin(master_data['Start time'])&(input_data['Status'].isnull() | input_data['Status'].eq(''))]output_file = 'filtereddata_{}.xlsx'.format('_'.join(master_data.columns))filtered_data.to_excel(output_file, index=False)

 I have developed the following code. Its throwing bot error. but if i execute it manual it is working fine. When integrating into A360 not working. A360_Pythonimport reimport datetimedef Pull_LatestDate_RowLocation(input_1):    with open(input_1,'r') as file:        Read_lines = file.readlines()    result = "\n".join(line.rstrip()if isinstance(line,str) else line for line in Read_lines)    table_data = str(result)    # initialize latest date vari

Hello everyone,i have registerd for Automation Anywhere community edition and want to access  Automation Co-Pilot but getting an licence issue attaching snip for information.  

I was trying to call the API task through Forms and the AI Skill Execute action is not working and showing the error :api task failure: task execution error - failed with status: (failed) with message:({"code":"access.is.denied","details":null,"message":"access is denied"}) at command: (genaipromptcommand) at line: (2) 

Hi ,  We recently had a server restart. Post that we are not able to access anything in the document automation. It gives the error as “Bad gateway 502”. I suspect some of the services to be down which is giving this error. Which are the services I should check and enable. Or is this something else. Task bot error AARI URL  Control Room 

Unable to click the element in the application page which is in the form of table format, we have to use the scroll bar to reach the element (to click the modified date column).we have to click the modified date column 3 times to get the correct date format. 

Hello,we are trying to configure an OAuth connection between Automation Anywhere Control Room (on-prem) and SharePoint Online in our tenant, but we are stuck with the following error:Unable to retrieve OAuth tokens. Code: cv.oauth.cannot.retrieve.tokensHere is what we have already set up:Azure AD App registration Created a new App Registration called Automation Anywhere. Redirect URI set to our AA Control Room DEV environment callback URL. Generated a client secret (Value stored securely, not the ID). Added Microsoft Graph API permission: Sites.Selected (Application). Global admin granted consent for this permission. SharePoint Online We have a dedicated site. Site Collection Admin granted the ap

Hi all,I want to download multiple emails with a different timestamps. How can I do that in v11/A360? Like i have emails from Jan - AUG but i need only jan-feb emails. So how can i download these emails.

Hi Community,here is my guide how you can do it 👇👀Step 1️⃣:Use the "Log to File: Log text to file" action and set the "File path" to a file with a .js extension. (C:\Users\marc.mueller\Desktop\AA_Slider.js)Put your JavaScript code in the "Enter text to log" textbox with your variables. (see screenshot) 👀⚠️Make sure to set the "When logging" property to "Overwrite existing log file" to have the current variable in your JavaScript code.⚠️Step 2️⃣:I the 🌐"Browser: Run JavaScript" action set the "JavaScript to run" as "Import existing file" and point to the same file we have specified in S

Hi all,I’m trying to get the row count from a table displayed in a SAP screen. Trying to use the “Get Row count” action in SAP package but not sure what I should input for the Field path.Same issue for “Export Table” action.Appreciate if someone can help.. Thanks in Advance. 

Hello, I used AA A360 and i want to use a variable in an email send with HTML design.This does not work in HTML design, but only in plain text. Is there a way to still use a variable in HTML design? 

 i need more tasks tfor begginers>>where to find 

Hi there,I recently upgraded a single-node Automation Anywhere on-prem setup from v35 build 29058 to v37 build 37379. The upgrade completed successfully without any errors. However, I began encountering the following issue: most bots—whether scheduled or run ad-hoc—are now failing. Below are the troubleshooting steps I have already performed without any luck:Verified that there are no special characters in the Control Room URL.  Confirmed that bot validation is disabled. Cleared the Elasticsearch logs. Successfully executed the OpenDistro admin setup. Stored certificates in the database and set the Elasticsearch password. Created / Activated the es_a360_monitoring user. Tested us

Hi, I’m trying to extract system generated PO’s using Document Automation. I have encountered one pdf where one table field is span into 2 pages.Item: Required field and Primary columnMaterial: Required fieldDescription: Required fieldPage 1 in DA:Example: Item     Material     Description 1           AHTD2      Item is shipped                               from Hyderabad                               Item no: 213422           AJUG5      Item is shipped                              from Mumbai                              Item No: 575603          AKIU4        Item is shippedPage 2 In DA:Item      Material     Description

Hi all, Is anyone else experiencing issues with the BLM API, specifically the /v2/blm/promoteBot endpoint.Since the v.37 update was deployed to our environment yesterday, all other endpoints are working but some of our promotion scripts are failing when executing a POST request on the promoteBot endpoint: 400: { "message": "Validation failed for 'api_key'. Reason: must match pattern [^<>]*."} This seems like a strange error to get, considering it was working yesterday and there were no changes at all. ThanksAdam