Search results

  1. S

    How to Convert IST time to UST time.

    Use below code to change current local time to a specific Timezone Input TimeZoneID as Text Output ConvertedTime as Time Dim now As DateTime = DateTime.Now ConvertedTime = TimeZoneInfo.ConvertTime(now, TimeZoneInfo.FindSystemTimeZoneById(TimeZoneID))...
  2. S

    Write custom delimiter text into MS excel

    Hi All, Below method shows writing text into excel ,this is another way to write excel in more efficient way from text file. Input Value : Collection(input collection), Delimiter(#,|,$....), Target(example C:\Temp\Test.txt) C# Code : Create CSV file with Custom delimiter =========...
  3. S

    'Launch' - Value does not fall within the expected range.

    This error is occurs when Resource PC is suddenly disconnected, during execution. Could anyone explain reason behind show as disconnect ? And resource PC get connected own without any touch. Please note this BOT machine VDI.
  4. S

    'Launch' - Value does not fall within the expected range.

    This error internal is display in Work queue , during processing of items and error comes from Navigate action while launching webpage.
  5. S

    'Launch' - Value does not fall within the expected range.

    Hi All, Getting error message intermittent during launching application in Blue Prism. Could anyone help fix for this one. ERROR: Internal : Failed To perform Step 1 In Navigate Stage 'Launch' on page 'Launch' - Value does not fall within the expected range.
  6. S

    Help needed with OLEDB csv connection string.

    Could you please guide what fix you applied for CSV.
  7. S

    Refreshing Pivot Table

    Create As object and call in process
  8. S

    Refreshing Pivot Table

    @maybeccie please refer attachment
  9. S

    Refreshing Pivot Table

    Can you please share error msg, otherwise above screenshot working
  10. S

    work with previous year dates

    I believe previous year date you select from calendar, and calendar having some up or down button to select future or past date. spy from BP and set your counter and click on up or down button of calendar for past or future date
  11. S

    Refreshing Pivot Table

    @sonali H Above code working we need to Pivot table name correctly
  12. S

    Refreshing Pivot Table

    @sonali H @sivagelli I am also getting same error after performing above steps, could you please help me. Internal : Could not execute code stage because exception thrown by code stage: Unable to get the PivotTables property of the Worksheet class
  13. S

    Solved how to Send Mail with collection table in message body??

    string textBody = "<table cellpadding='5' cellspacing='0' style='border: 1px solid #ccc;font-size: 9pt;font-family:Arial'><tr><th style='background-color: #B8DBFD;border: 1px solid #ccc'>Scenario No</th><th style='background-color: #B8DBFD;border: 1px solid #ccc'>Scenario Detail</th><th...
  14. S

    OLEDB with Excel

    DB_SEC_E_AUTH_FAILED error indicates it’s a database authentication issue, check the database file path and try the connection string like this: Conn = new OleDbConnection(string.Format(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source={0};Jet OLEDB:Database Password=1234", DbPath))
  15. S

    Please advise, how to check whether application session active or expired in Blue prism?

    Hi Silva , Thanks for response , currently I am doing same logic. In this case count value should be hardcode as environment variable . Which can be change in future in prod env, so I planning to opting JS or .Net to check session active or inactive
  16. S

    Can Blue Prism replace reporting tools like SSRS and Cognos?

    As per my opinion , you can connect blue prism with DB and write SQL and create HTML reports. To connect with DB and fetch SQL data use OLDEB VBO and also we can write custom code in BP in C# or VB .Finally I can say it depends on business to business requirement Thanks!
  17. S

    Please advise, how to check whether application session active or expired in Blue prism?

    Hi All, Designing bots for Web based application/Java application, after performing few transactions session of application expired and bot got stuck, please suggest how to check application session active or expired of application by BluePrism Thanks, Vicky
  18. S

    How to get Data table from body of email?

    Hi , please refer this may be this will help Thanks, Sheel
  19. S

    Google Maps API

    Hi Aleksandr, Pls try to store your API output as Image then use surface automation to extract information from image, hope this will work for you.