The place for Developers to share and learn.
- 2,322 Topics
- 6,237 Replies
Announcing NEW Generative AI Community Group - Join Today!
Whether you're a beginner or an expert, our new Generative AI group is the perfect place to stay up to date, connect, share knowledge, ask questions, and engage in meaningful community led discussions on all things AI. ✅ Join Today - Generative AI Group
Find the first empty cell and copy the value
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.
Excel Formulas are not reflecting with bot execution.
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.
Onedrive URL issue
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.Can someone help me with the same?Thanks,Ruhee
Do you have any standard for naming variables, and logging in RPA tasks?
What could be the best way for naming and logging?Is logging the errors in txt file and sending email enough, or should take a screenshot or anything else?Some people say it’s best way to have a report for the task details like powerBi, instead of looking at error mails.What do you think?also how do you name variables, string-integer-list-datetime-boolean etc
Capture command not working in unattended mode with Technology type MS_active_accessibility
Hi! I am facing a issue that all other capture actions are working in unattended mode only Capture action clicks whose Technology type is MS_active_accessibility are not working in unattended mode while its working in attended mode.
Excel sheet cells are not getting updated
I have Excel with multiple sheets. A few cells in the first sheet will get updated once the data are appended to cells in other sheets because the first sheet has formulas that pull data from different sheets. It works as expected when manually updating the data, but if the bot does the same, the first sheet is not getting updated. I need help to understand what is the issue here.Can someone help me with this if anyone knows or encountered this issue?
Setting array formula using excel advance package
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)
File Trigger works most of the time, not sure if something is timing out, or if its a vm setting.
I have a vm botrunner with a onedrive synced folder, if a file is dropped in this folder, the bot should be triggered to run. I remote into vm and boot up control room to make sure trigger event is active. I can successfully get the bot to trigger even if vm is unlocked, locked, connected, or disconnected. All appeared to be working, so I disconnect from vm for the day(not sign out). The next day, first thing in the morning, I dropped another file on the folder to see if it would trigger, it did not trigger. I'm new to this, did it not trigger because of a session timeout? Am I missing something else? Please help, thanks
Bot not picking the files in the order they saved
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 ?
Excel Advance "Get Mutiple Cells" command unable to fetch values
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.
check if application is running
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
Already have an account? Login
Login to the Pathfinder Community
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.