Developers Forum

We would like to check if SAP GUI is running on the remote machine before we try any automation actions on it. We initially thought the IF application is running method might work but SAP has two instances running when we checked task manager the SAP logon 760 and SAP Easy Access. Has anyone been able to check if SAP Easy Access is running without doing a window exist test? Would like to stay away from window names in the initial test to see if the application itself is running or not.Assistance will be greatly appreciated.The application used A360 cloud 

Hello all,I need help or suggestion for my below issue. Please anyone knows the reason please reply to me back with your points.I am automating the Power BI application for downloading the Excel and copy past data into the other excel sheet (Contains Formals).I am copying the data into Data Table variable and pasting into the Output file. Based on business flow the formals should works and reflects the data with back-end Calculation and gives Sum value.Issue:The formals are not working and the sum value not able to append into the Output file. 

Hello. I’m trying to create a BOT but I’m experience some difficulties. I would like it to open a website (on Firefox) and another website (an Excel sharepoint). So far so good.I would like the BOT to run all the rows in the column A and stop on the first empty cell.Then, I would like to copy the value from cell B(#row) to the previous website textbox. And cell C(#row), and D(#row), and so on.Then, repat the process until it finds another empty cell. Could you help do that please? Thank you for your support.

Question for the community: When you get data from an excel sheet and put it into a data table (no schema) using the get multiple cells (all) Excel command, if one of the columns is a date type in excel, what type of column do you get in the data table?I’m getting mixed results when trying to read through the data table and place the data from a column into a date variable. I need to do some date formatting (US to European) and I need to detect when I’m receiving a European short date (d/m/yyyy) or a US date format (m/d/yyyy).

I'm using the capture activity to write a variable in a textbox, but right after it writes, the text is erased. Can anyone help me with this?

Hi all, hope you are well Are there any generative AI features or use cases for post-production stages? Such as tasks intelligent orchestration, tasks self-healing capabilities, optimal devices utilization, credential management etcI think most of the generative AI use cases are focused on assessment and delivery, and one of the main pillars of a successful RPA project is Production environment and support teams management. I would love to see how generative AI could fit these scenarios.  Thanks for your help!

Pdf file has digital data and if before it was fields forms. Is there a chance of missing data while extracting? Below is screenshot 

IMPORTANCE OF PROMPTSHave you ever used Generative AI and felt like you didn’t get the results you were looking for? Just like search engines, the results returned from Generative AI tools, such as ChatGPT, rely heavily on your prompts.When just starting to test Generative AI as a new tool in your intelligent automation tool belt, you can experiment with different phrasing to observe how results vary. However, when you are ready to implement AI into new or existing automations, you need to be sure the results returned from your prompts are what you need.Prompt engineering is quickly becoming an essential aspect of intelligent automation development resulting in increased accuracy, time-savings, improved efficiency, scalability, reduction in errors, ease of use, and more.TIPS FOR WRITING BETTER CHATGPT PROMPTSBased on our experience, here are some things we’ve learned to create effective pro

Hi,I have a python code , while executing the python i am getting the correct output.but at same time when i am calling the same python code through AA 360(V23), its stuck on execution steps. BoT is not retuning any error or output.

This is thread is your place to unlock event related resources, updates, and to ask questions.  What is the Automation + AI: LIVE event?  Put generative AI to work with the Automation Success Platform. Every company is in the midst of a productivity crisis - either driven by a labor shortage, cost constraints, or competitive pressures. At the same time, McKinsey predicts that in order to meet global GDP targets, businesses will need to see a 50% increase in productivity. The combination of generative AI and automation has the power to unlock this next wave of productivity and trigger our next industrial revolution, completely changing the way we work and empowering teams to create their own productivity tools that will help them expand their impact on the business.  Join this special digital event with experts across AI and automation and learn how you can put generative AI to work with the A

One thing I’ve found very useful in working with Generative AI models is to create/tweak/tune templatized prompts.What I mean by that is - have you ever had a conversation with one of these Gen AI models...and after 10-15 back and forth prompts/clarifications you actually got to the thing you ultimately wanted? With this concept of templatized prompts, the goal is to shortcut that process down to 1-2 prompts as opposed to 10-15.  A helpful approach that I’ve been using is by setting up a JSON array of clearly defined “rules” that the model needs to follow in addressing my responses… (there’s really nothing special about it being a JSON so much as thats how I started working on it)- but in this way, I can be sure that as a prep the model for my prompt, we already have a clear set of expectations on the role the model should be playing, the expectation for its responses, and how it can be invoked in different ways to provide extra output. This is probably best exp

Can I get a detailed explanation of how the URL must be given https://docs.automationanywhere.com/bundle/enterprise-v2019/page/enterprise-cloud/topics/aae-client/bot-creator/commands/one-drive-get-file-or-folder-information.htmlhttps://*sharepoint.com/personal/*****.com/For example my Onedrive hasHomeMy files & the folder that I want is inside for example Resource/ Help / New How do I get the folder linkI tried as https://*sharepoint.com/personal/*****.com/Documents/ NewBut it throws me error message.Ca

Hi, while extracting data from pdf some data is missing. ow to handle it? below is screenshot of the field drawing no: i’m missing 023 while extracting.  

Prior to performing a POC  I would like to know if other clients are using AWS Workspaces for Bot creation or Bot Execution. I couldn’t find any articles on best practices for use so thought I would ask the community?

I am getting a leading ‘@’ symbol whenever I am trying to put an array formula using Set Cell Formula command from excel advanced package. A360 automatically converting array formula to scalar formula. I tried to using Set Cell command but not working. I even tried various string operations to replace ‘@” sign but not successful. Is there any solution to set an array formula in excel using A360? Note: Array formula used is =UNIQUE(A:A,0,0)

Has anyone accessed or performed CRUD operations of Mongo DB thru A360 bots? 

Can bot identify pages with strikes or overwritten with hand writing on scanned pages ?and Page with landscape Orientation.

How Can A360 bot identify page orientation?I have scanned PDFs and in those the page Orientation is in landscape , can bot identify whether the page is tilted or change in orientation through bot ?Is there any other solution for this ?or through Any Scripting?

I am processing Scanned PDFs having multiple pages, first using PDF - Extract Image I have extracted images and they are saved into folder. Filenames are in the order  Invoice_1, Invoice_2, …..Invoice10, Invoice11 so on.Now using loop for each file in folder I am extracting text for that images and saving the extracted text into txt file with file name as InvoiceTxt_1, InvoiceTxt_2 and so on. But bot is not picking the Image files in the order  nvoice_1, Invoice_2, …..Invoice10, Invoice11 so on. Instead it is picking files in the order  Invoice_1, Invoice_10,   Invoice_11, …...Invoice_2 so on. Is there any solution for this ?

I am using Excel Advanced package and getting error on “Get Multiple Cells” command. Cell range is “All cells” and read option is “Read cell value”. The bot has been failing only for few files. The error message is “Unable to fetch values for range 'A1:BT48240'”. I am not sure what might be the reason.BOT Process - Step 1 - Open Excel (Using Excel Advanced)Step 2 - Get multiple cells (storing it in a data table)Step 3 - Close Excel.

Hi All, Need Database connection string for .xlsm format excel file

I have the following problem when I play the bot it shows me this message: Waiting for user: botrunner and/or device from pool(s): DADevicePoolIt also shows me that the device is disconnected. 

Hi everyone!I am facing issue in my intel evo laptop On Incident Table create a new UI Action button with the name “Provide Info”. This button should appear only when the Logged in User is the Requestor (Opened by) of the ticket being loaded on the screen and the “State” of the ticket is “On Hold”.If the logged in User is the Requestor (Opened by), then he will click “Provide Info” button to provide the details to the support team.   The following validations should be done before the ticket is submitted. The additional comments are mandatory when the “Provide Info” button is clicked.The State of the incident should be changed to “In Progress” function runClCode() {    g_form.setMandatory('comments', true);    alert(true);    g_form.setValue('state', '2');     gsftSubmit(

Hi everyone!I am facing issue in my intel evo laptop On Incident Table create a new UI Action button with the name “Provide Info”. This button should appear only when the Logged in User is the Requestor (Opened by) of the ticket being loaded on the screen and the “State” of the ticket is “On Hold”.If the logged in User is the Requestor (Opened by), then he will click “Provide Info” button to provide the details to the support team.   The following validations should be done before the ticket is submitted. The additional comments are mandatory when the “Provide Info” button is clicked.The State of the incident should be changed to “In Progress” function runClCode() {    g_form.setMandatory('comments', true);    alert(true);    g_form.setValue('state', '2');     gsftSubmit(

Hi everyone!I am facing issue in my intel evo laptop On Incident Table create a new UI Action button with the name “Provide Info”. This button should appear only when the Logged in User is the Requestor (Opened by) of the ticket being loaded on the screen and the “State” of the ticket is “On Hold”.If the logged in User is the Requestor (Opened by), then he will click “Provide Info” button to provide the details to the support team.   The following validations should be done before the ticket is submitted. The additional comments are mandatory when the “Provide Info” button is clicked.The State of the incident should be changed to “In Progress” function runClCode() {    g_form.setMandatory('comments', true);    alert(true);    g_form.setValue('state', '2');     gsftSubmit(