Search results

  1. C

    Connect BluePrism to Database

    Thanks a lot. Can I send you a message with the csv I'm trying to read? I'm having problems in reading the values of the rows in the correct columns. Many Thanks, Camilla.
  2. C

    Connect BluePrism to Database

    Thanks @sahil_raina_91. I get the error. I need t read the file at this path Can you please help me? Thanks Camilla
  3. C

    Connect BluePrism to Database

    Thank you so much @sahil_raina_91 . The file is a csv and not an Excel. I'm getting this error when using this action: 'Get Worksheet as Collection' Process: 'Test' Subsheet: 'Get Collection From Csv' ERROR: Internal : Could not execute code stage because exception thrown by code stage: Illegal...
  4. C

    Connect BluePrism to Database

    Thank you so much @sahil_raina_91. I've tried the SQL server data - Set Connection and it works. Now I ask you another question: I need to Read an Excel File , Read the Collection of rows associated to it and insert the rows (without duplicates) in a Datatable inside the Database. How can I do...
  5. C

    Connect BluePrism to Database

    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.
  6. C

    Import csv file in Database

    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.
  7. C

    Send Ctrl+ H in Excel Sheet

    Thank you so much @Sachin_Kharmale . I'll try and let you know as soon as possible. Cami
  8. C

    Send Ctrl+ H in Excel Sheet

    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.
  9. C

    Extract Start and End execution time

    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 :)
  10. C

    Get last day of a month

    Thank you so much for your precious help @Jiri.Hurda . Camilla.
  11. C

    Get last day of a month

    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.
  12. C

    Assign values to rows of a new column of a collection

    Thank you so much. Can you please provide me screenshots of the activities? Thank you, Camilla
  13. C

    Set cell value error

    Thank you so much @DTforrpa. I'll try and let you know as soon as possible. Cami
  14. C

    Set cell value error

    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...
  15. C

    Vloo

    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.
  16. C

    Assign values to rows of a new column of a collection

    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...
  17. C

    Query Select result collection null

    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...
  18. C

    Find word with regex

    Thank you so so much @sivagelli. Your help is always precious :)
  19. C

    Find word with regex

    Thank you so much @sheel. Can you please share the regex expression that can be used to extract the word COMUNE only if preceeded and succeeded by ".;,", not by numbers or letters? Thank you so much, Cami
  20. C

    Find word with regex

    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...
Top