Recent content by ewilson

  1. E

    CSV delimiter

    If you check the latest release of the MS Excel VBO, available on the Digital Exchange, you'll see that the VBO includes an action called Import CSV that includes an optional input parameter to specify the delimiter used in the CSV file. Cheers, Eric
  2. E

    Unable to Open Excel XLSM File (Call was rejected by callee)

    Hello dsmith616. It seems this issues can be caused by any number of issues including: - Your Excel instance isn't licensed or the license hasn't been activated on the machine. - Certain add-ins can cause issues. Have you tried disabling any add-ins on the machine in question? - Since you...
  3. E

    How to check whether a particular folder exists or not in outlook

    Please take a look at the latest version of the MS Outlook VBO on the Blue Prism Digital Exchange. It includes an action called Check Folder Exists. Cheers, Eric
  4. E

    adda number to text?

    Here's one example that you could implement with a Code stage: string val1 = "AB00000001"; string val2 = "AB00000002"; int sum = Convert.ToInt32(val1.Substring(val1.Length - 8)) + Convert.ToInt32(val2.Substring(val2.Length - 8)); string finalVal = "AB" + sum.ToString("D8"); This assumes the...
  5. E

    adding zero before number?

    @HickeHiskelig are you attempting to do this via a Calculation stage? If so, you'll have to create the number as Text in order to keep all the zeros you want. Cheers, Eric
  6. E

    Double Quotes In Command Line And Blueprism

    @prateek grover are you experiencing an issue with this? Are you using the Utility - Environment VBO to attempt this or a Code stage? Cheers, Eric
  7. E

    File Exists giving wrong output

    Hello @Babjee Vangipurapu, Are you using the latest version of the Utility - File Management VBO available on the Digital Exchange? From your message it sounds like sometimes you get the correct response and other times you get the wrong response. Is that a correct statement? How are you...
  8. E

    calling stored procedure from a BP action

    @Jatin Kalra, Are you experiencing the same issue? If so, what DB system are you working with? Cheers,
  9. E

    Unable to upload file to API using HTP Request

    @indrajeet.roy, Are you using the latest version of the Utility - HTTP VBO available on the Blue Prism Digital Exchange? It has an action that supports uploading files via a multi-part request. Cheers,
  10. E

    Problem running process from scheduler

    @anuraag_msg, After you've applied you schedule settings, do you see it show up in the actual calendar (aka top-level Schedule and Timetables) displays? Cheers, Eric
  11. E

    Unexpected error Error during Web API HTTP Request Web Exception Status: ConnectFailure

    @vikas1612 are you traversing an HTTP proxy/firewall that requires authentication? If so, the Web API service feature of Blue Prism does not support proxy authentication. You would need to use the Utility - HTTP VBO instead.
  12. E

    How to configure a collection to WebAPI request with JSON template?

    Assuming you have multiple rows in your Collection, you do not want to use the Template body option. Instead, you would want to use the Custom Code body option and write C# or VB code to build the JSON body, populating it with each record. Cheers, Eric
  13. E

    Visual Studio IDE - best practices

    I typically create a .NET Framework Console Application in order to build/test code that will ultimately go into a Code Stage. Just make sure you choose an appropriate.NET Framework version. I tend to go v4.7.2 and I’m working with BP v6.10.4. I assume you may need to pull in a Nuget or two...
  14. E

    Get the data from collection without loop

    I’d say your only option would be drop into a Code stage where you could work with the Collection in its normal state which is a .Net DataTable. However, you’d still need to perform a loop to process every row. You could use Linq if you’re trying to query the data. ‍♂️ Eric
  15. E

    Running multiple instances of the same Java executable/jar

    @Robertics78 , When you talk about Excel are you referring to how the MS Excel VBO can support multiple instances of Excel? If so, you'll want to take a look at the Create Instance action of the VBO and the GetHandle function in the Global Code. What you'll see is that the action creates a GUID...