Search results

  1. V

    MS Outlook Email VBO - unable to get emails

    You can't...Only using mapiex VBO you can manage different Outlook profiles. Unfortunately mapiex don't run on BP vers. 6.3 and later .
  2. V

    Blue Prism SQL Tables

    Thanks, it works
  3. V

    Blue Prism SQL Tables

    I need to extract from SQL Database, when a scheduled process has ended (date and time). Does anyone know the name of the SQL table from which I can extract this information?
    • Val
    • Thread
    • date and time ended processes sql tables
    • Replies: 3
    • Forum: Blue Prism
  4. V

    Group data of a collection

    It works now as expected
  5. V

    Group data of a collection

    You are right. But I've reached the same result with this modified query: SELECT Main.Email, Main.Name, Main.CompletionDate, LEFT(Main.Task,Len(Main.Task)-1) As Activity FROM ( SELECT DISTINCT ST2.Email, ST2.Name, ST2.CompletionDate, (...
  6. V

    Group data of a collection

    Done! But I still have some errors: USE RPAUF; SELECT task.[Nome], task., ST2.[Activity], task.[CompletionDate] FROM [RPAUF].[dbo].[task] LEFT Join (SELECT Main.Email, LEFT(Main.Task,Len(Main.Task)-1) As Activity FROM ( SELECT DISTINCT ST2.Email, (...
  7. V

    Group data of a collection

    A small update. I found a way to solve it but I still need help. The solution can be found using a SQL query that I don't know in deep. Unfortunately I wrote two separate queries and I need to join both in only one, because the 2nd include all the records and the last row must to be excluded...
  8. V

    Group data of a collection

    Hi, I've created a process that take data from a database and create a collection like that in fig1. This data must by taken from Outlook for send emails to those recipients and remind them that the activities must be completed within a certain date. The process works fine, but Outlook send one...
    • Val
    • Thread
    • collection manipulation concatenate rows group columns in a collection grouping columns grouping sql queries outlook sql queries
    • Replies: 9
    • Forum: Blue Prism
  9. V

    From txt to Excel with some adjustment

    I have a problem. Starting from a txt file I have to create an excel file ordered on three columns. The problem is that I have to search for words in a string and, depending on the word, copy the following lines to a different column. Attached: 1. the txt file 2. the excel blank file 3. the...
  10. V

    Appian and RPA Blueprism

    Hi, I'll try to explain it. Appian is a platform of Business Process Management. Means that with Appian you can realize Business Processes managed by humans. Appian has a strong partnership with Blue Prism, where as you know, you can develop unattended processes. So, for example, you can realize...
Top