In the add to queue action where you place a collection into the work queue there could be a flag option to write only those that dont already exist in the queue. At the moment we need to check each row if it exists in the queue already and if so the...
It might be useful to have code snippet options available within code stages to allow for fast development of custom code stages. This would also benefit those will limited knowledge on coding and help them understand code stages where they might nee...
Hi all
I have an unusual error with outlook action Get emails, when its running it returns the error message "Value does not fall within expected range". This has only appeared recently and the is inconsistent with it running normally sometimes and s...
Hi allI have an unusual issue in SAP with one of my automations that I've never seen before and hoping someone on here might have the solution. I am running a transaction that uploads files to SAP and sometimes I get the below error message and when ...
Hi allI have a question on the oledb connection frmo blueprism to sql databases. MY understanding of this is that the oracle database access components should be installed on the machine and you shouldnt need to use a TNS-less connection string. I ha...
It looks like the element is spied as a hyperlink, try respying it as a button. If this is not possible then use a navigate stage, add 2 steps, the first is the element and select focus as the action. The second step will be the high level applicatio...
No problem Im glad it was helpful ------------------------------Michael ONeilTechnical Lead developerNTTDataEurope/London------------------------------
Hi
I created a couple of actions for this previously if its useful to you. You will need to create a new action Refresh Pivot Tables and add a code stage with the following code:
Dim wb As Objectwb = GetWorkbook(handle,workbookname)wb.Activate()
wb....
Ah from a pdf can be awkward, are you using ocr to identify and extract the information? have you tried using 'Get text' and regex to extract the information?
I think transferring the data to bp collection as a numerical wouldnt always be the case where the format is general in excel or there are a mix of formats in column. The easiest and simplest solution would always be to format the cells to get the de...
