Search results

Hi, (@sahil_raina_91, @Pete_L ) I want to ask you kindly which are the steps necessary to connect BluePrism to a Table in SqlServerExpress and execute a query on it. What are the steps involved? CAn you please provide me an example of workflow that does this? Thank you so much, CAmilla.

Hello friends, @sivagelli, I need to import a csv file with many rows in a Table situated in BluePrism Database. how is it possible to do that? Thank you, Camilla.

Hello friends how to send Ctrl +h command in an Excel file open? I tried with Send Hotkey "^H" on Excel Application but doesn't work. Can you please help me? CAmilla.

Hello friends, can anyone tell me how is it possible to extract from BluePrism the Start and End Execution Time of a Process? Thank you so much, cami :)

Hello friends, How to get the last date of a month with out using any code stage? I would like to get that only by passing as parameters the year and month, not the day. Any ideas and suggestions appreciated. Thanks, Camilla.

Hello All, I am trying to pass the value in the cell using SET CELL Value function however it is throwing error ""HRESULT: 0x800A03EC"" The value is ""=+VLOOKUP(B3,'C:\*******\[ConsolidatedReport.xlsx]Sheet1'!$A$1:$N$1600,1,FALSE)". I have valdated it before running. However i have an...

Hi all, I would like to clarify is it possible to perform the Excel function "VLOOKUP" using Blue Prism? If so/not what is the approach to automate the VLOOKUP across 2 Excel data files? Many thanks in advance.

Hello friends, how is it possible to assign values to rows of an added new column to a collection? For example I have this situation: Data di reg. Conto contropartita Definizione conto contropartita Importo in divisa interna Mese 01/08/2019 3602B12000...

Hello friends, (@sivagelli,@VJR ) I need to execute a query of type "Select from *..." where the result is no rows selected because no rows match the criteria. How to implement an action that performs an Sql querY? How to perform the fact that the result of the query can be a null datatable...

Hello friends, I should find a certain word in a string. In particular I should find the word "COMUNE" inside a string, for example inside "BONIFICO DA COMUNE" How is it possible to implement the regex formula? I should find the word COMUNE only if preceeded and succeeded by ".;,", not by...

Hello friends, I need to compare two collections. I need to find if in the main collection are already present the rows of another collection. In positive case, I need to delete the row of the second colleciton from the main collection. How to do that? Thank you so much, Cami

Hello friends, how is it possible to trim a collection? Can you please share the code with me? Thank you so much, CAmi

Hello friends, how to find the difference between Today and a date like 03/11/2018? I would like to have an output in dd/MM/yyyy formt. Thank you, CAmi

Hello friends, how to get the collection I attach sorted in ascending order with data? I trasformed the date values in date format. Thank you, cami

Hello friends, how to convert a text from this format 3456.89 to 3.456,89? Thank you so much, Cami

Hello friends, how to get the last file saved in a folder? Thank you so much, Cami :)

Hello friends, how to insert a certain row from Collection 1 to the fist empy position of collection 2? Thank you so much, CAmi

Hello friends, how is it possible to read a variable text with OCR, from an application modelled with Application Modeller? Thank you so much, Cami

Hello friends, How is it possible to extract data from a table extracted from an application page modelled through Application Modeller? I cannot extract the application page as a table :( CAn you please help me? It's urgent. Thank you so much, Cami

Hello friends, I'm trying to click on an Image modelled through Region mode. I get the following error: "Cannot find region identified as an image." How can I solve the problem? Thank you so much, Cami