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.
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...
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...
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...
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.
@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.
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.
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...
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. ♂️
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...