Hi! How can I get values from row starting from a particular cell from Excel file? Example, I need to extract all values from 2nd row, starting from B2 cell?
P.s. it's better to extract non-empty cells.
Thanks in advance.
Hi All - Just a very curious question. Is it possible to export an automation build in BluePrism and convert that to WorkFusion. Something like exporting a .bprelease file and importing that into Workfusion tool? Is that even possible? Is there a possible workaround or does the whole automation...
Hello,
I have 2 use cases which has to do with Eastern Time. These are as follows:
1) Converting time to Eastern Time so that based on time, I can assign a job or mark as defer until pre-decided time.
2) Getting completed data times from work queue (Get completed items) object based on last...
Hi all,
Given a process and it's given summary comment, I am trying to create an object in BP that automates the "saving" and setting of the given process' summary comment.
For example, if I was to update the summary of a comment for a process, I would go into the process, click the save...
Hi all,
I'm trying to create a BP object that checks for a particular process to see if it has any compilation errors. If it does, then it gets all the existing errors and screenscrapes them onto some variable for future reading - possibly onto a word doc.
1. Currently, I'm using Application...
Hello,
i'm currently encountering an issue with my project.
I have to download multiple excel files from an Intranet. Then, open them one by one and call a specific macro (The same macro exists in all the files).
While running the macro, i noticed that there's a runtime error with the macro...
Hello,
I'm quiet new to Blue Prism and would like to extract text between specific values.
The values to be extracted are marked bold in the example below.
For instance:
Absence vacation for:
Employee ID: 12345
Employee Name: Max Smith
Your absence will start at Dec 21, 2020 and ends at Dec...
Hi,
I have a package on the database which requires a stub such as
declare
ln_ret number;
begin
ln_ret := pkg_rpa.DOC_UPLOAD (
'Y', 'SL004963', 'BOT Test');
dbms_output.put_line('ln_ret=' || t.t (ln_ret));
end;
This will insert a record into a table using these values
I...
Hi All,
I am facing an issue while reading text in surface automation when the RDP is not taken as when disconnected through RDP, it does not read some text value using Read text with OCR and when RDP is taken it reads it correctly.
Could anyone help me out with this?
Thanks in Advance!!!
Hi ,
We are getting issue in get worksheet as collection in which the blueprism gets hanged.
The logs showing
"Requested Clipboard operation did not succeed"
This issue is occurring in multiple robots and suddenly occuring in robots. Can suggest
Hi All,
We are evaluating a customer request of migration activities for SAP ECC system to S/4 HANA using any of the RPA tools.
It helps if someone can help with proper development strategy and points to be considered.
Thanks,
Mahesh
Hi Team,
This is a high level lay out for one of my project, which runs 24/7.
Theses are few details.
1- Object 1 , mostly works on HTML mode.
2-Object 2, 95% works in SAP mode.
5%- in UI mode.
Problem:-
Bot runs good however, it takes time to identify the 5% of UI mod elements. The time...
Hi, I have a scenario where I have to get the date and time from the previous scheduled run. For ex: if the last run till May 10 - 6PM then the next run should starts from May 10 - 6:01 PM. How to strore this data in BP for each run so that I can get the start time for the next run? I am...
Hi,
I am using Selenium web driver to automate logging into a website, but after logging in it s not waiting for the website to load and hence running into error in the next step.
Used the below code , but the whole page isnt loaded after the stage executes...
I have a Blueprism process which will generate a word file with a table of information. Each item will generate a new file. I want my process to combine each file into a combined file. Currently my process will copy the data from the individual file, but overwrites all of the data in the...
I am opening a new Excel workbook through one excel workbook(AFO) which is already open. Now after opening the new workbook I am getting issues with attaching. But if I manually close the previous workbook(the not required one), then everything seems to work perfectly.
Is there a way to close...
Hello, I have a process to select from drop down list in web browser (IE). Upon running it manually it is working fine. But when I schedule it scheduler I hit error it could not find the drop down list. I have apply the wait button. Anyone able to assist me to solve this.
Hi,
I have managed to delete all emails within a date range from Inbox with a loop, but we would need to also delete all emails under Deleted folder and also in Sent folder. Basically clear out all old emails from Outlook based on a date range for example from two weeks to yesterday.
Does...
Hi I am trying to save a pdf opened by an application directly on internet explorer tab. I have attached the correct window but I cant figure out a way to save the pdf to my local storage. I can't spy when the pdf is open (i can only spy with win32 mode if i kill the AdobeReader process on the...
Has anyone here tried to Automate an Excel with Analysis for BI Office Launcher? I tried to use the Open Workbook Action under MS Excel VBO but the Analysis Tab is missing. Please let us know if there is any other way to open the file. Thank you!
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.