Search results

  1. M

    Blueprism To Create Validation Drop Down List In Excel

    I have a Code stage running the following: GetInstance(handle).Activecell.Validation.Add (Type:=xlValidateList, AlertStyle:=xlValidAlertStop,Formula1:=("Yes,No")) This is producing the following error: Page: Input Validation List Stage: Input Validation List Type: Error Action: Validate...
  2. M

    How to get files in all sub directories?

    Hi, I have a root folder with multiple sub folders and those sub folders could have more sub folders and so on and so forth. I want to run an action and pass it the base folder and get all files that are contained in there (Even in sub folders). The Get files action only gets the files at the...
  3. M

    Blueprism To Run Database Package

    Hi, I have a package on the database which requires a stub such as declare ln_ret number; begin ln_ret := pkg_rpa.DOC_UPLOAD ( 'Y', 'SL004963', 'BOT Test'); dbms_output.put_line('ln_ret=' || t.t (ln_ret)); end; This will insert a record into a table using these values I...
  4. M

    Double Quotes In Command Line And Blueprism

    I am trying to use Nitro PDF reader via the command line from Blueprism. Information here: https://kb.gonitro.com/knowledgebase/#/search/command/000004309 "Combine PDF Files Nitro Pro: NitroPDF.exe /m E.g.: C:\Program Files\Nitro\Pro\12>NitroPDF.exe /m C:\Users\amanenti\Desktop\test.pdf...
  5. M

    Combine Multiple Word Documents

    I have a Blueprism process which will generate a word file with a table of information. Each item will generate a new file. I want my process to combine each file into a combined file. Currently my process will copy the data from the individual file, but overwrites all of the data in the...
  6. M

    Kill Process Not Working

    Hi, I am using the Kill Process in Utility Environment to kill iexplore. However, it doesn't seem to be doing anything? The process just moves on but doesn't close the application? I am using iexplore as the input value
  7. M

    Identifying Elements On Webpage

    I am launching https://www.ibancalculator.com/iban_validieren.html from Blueprism (Internet Explorer). The application modeler doesn't seem to be able to identify elements. Do I need to enable any settings to do this?
  8. M

    Blueprism Code Producing 403 Forbidden Error

    I am trying to use Blueprism to download pdf files from Sharepoint. I am using the below code. Url and Path are both variables which get passed through. This is producing a 403 forbidden error. I believe that Blueprism is required to pass credentials to Sharepoint before it will be allowed to...
  9. M

    SQL Query Ran Through Blueprism Not Returning Results

    I have a Blueprism object which opens an Oracle database connection and runs a SQL script. This object has been working correctly for the past 12 months. I am developing a new process and the object isn't bringing back any results. If I run the SQL select against the database it returns results...
  10. M

    Run SQL Pivot Query

    Hi All, I have a process which will run a SQL query and put the output into a collection. I need to run a SQL pivot query. The job just runs and outputs blank results. Is there anyway to have Blueprism put the pivot table into some sort of variable or else right it to a file?
  11. M

    Microsoft Word Remove All Links

    Hi, I have an object which should highlight all text in a Word document and then press CTRL SHIFT F9 to remove all links. All the text highlights but the links remain afterwards? This works when I do it manually. I am global mouse clicking the page and then global sending "^+{F9}"
  12. M

    Identifying An Upload Browse File Prompt

    I have a process which has been running fine for about 8 months. The bot uses Newsweaver (Internet Explorer) and at one point it clicks upload files, and a file browser window opens. The bot then selects a file etc. However, this same logic is not running on another resource. I am unable to...
  13. M

    Blueprism - Read Actual Value Issue

    I am reading a set of column headings from Excel. I am then using the read value to make a decision. My issue is that one of the values in the Excel is "Town", when Blueprism reads the value it reads it as "Town " . I have checked the excel and the value is "Town". Why would this happen?
  14. M

    Queue Filter Version 6.5

    Hi All, We have recently upgraded to Blueprism 6.5 but don't seem to be able to filter our queues? Image attached Regards
  15. M

    How to reference a field from a multi tiered collection

    I am using the Natural Language Google API in Blueprism. This API outputs a collection which contains sub collections. I want to reference a sub column from this collection. However, If I simply use the collection name.sub collection.sub collection.field I get an error. Am I doing something wrong?
  16. M

    Blueprism View Logs Issue

    Hi, When I view logs of an item/process the whole view is very difficult to read. This only occurred yesterday and I have never had the issue before. Could someone advise on a solution?
  17. M

    System out of Memory Excel VBO

    Hi, I am attempting to get a collection from an excel worksheet using the excel VBO. Normally this works fine. However, my file has approx. 200k lines. I am getting a system out of memory error message. Is there anyway to load this volume of data into a collection?
  18. M

    Set Session Variable From Another Process

    I have a process which will keep on running until a session variable is changed from False to True. Is it possible for another process to set this variable? So the original process will run for an hour then the other process starts, passes in the variable and the original one stops?
  19. M

    Process Does Not Exist Error Message

    I am using #AutomateC to kick processes off on resources. However, I am getting an error message saying the process does not exist eg Error: process 'Claim_Sub_Process' does not exist However, the process does exist.
  20. M

    Run SQL Server Query With Windows Authentication

    I want to have a process run a SQL server query against the Blueprism database. The only way I can manually connect is by using Windows Authentication. I have tried using the SQL Server VBO but the run query is returning a login failed for user message. Is there a way to run the query by using...
Top