Search results

  1. M

    How can an Excel handle be shared?

    Our company has developed hundreds of automations, many of which interact with Excel. This required developing our own Excel VBOs for actions not included in the built-in Blue Prism Excel VBO. A major problem is that actions cannot be called from any business object other than the one that...
  2. M

    How can an Excel handle be shared?

    Our company has developed hundreds of automations, many of which interact with Excel. This required developing our own Excel VBOs for actions not included in the built-in Blue Prism Excel VBO. A major problem is that actions cannot be called from any business object other than the one that...
  3. M

    Maximum text data element size

    We are loading text into a Blue Prism text data element and I cannot find any documentation on the maximum size of a text data element. Does such a limit exist? I understand that BP itself could encounter a memory error if GB of data were loaded into anything but I just want to know if Blue...
  4. M

    Blue Prism-Excel-How detect and handle prompt when saving file

    Hi, We have an issue with Blue Prism (BP) saving Excel files to a directory that encrypts the file and locks the directory to other writes while the encrypted save completes. If two BP processes attempt to save files in the same directory at the same time, one process will receive a Microsoft...
  5. M

    Copy a worksheet bewtween two workbooks in different Excel instances

    Hi, I have a process that will execute many SAP transactions, some returning large amounts of data, and create an Excel workbook (Output.xlsx) with separate worksheets containing the data from each SAP transaction. As each SAP transaction is run, we have SAP export the data to Excel. For...
  6. M

    Attachments to digitally signed Outlook 365 emails

    My company recently migrated to Office 365 and encountered a problem in which none of the attachments to digitally signed Outlook 365 emails except the smime p7s are visible to the RPA bot. The issue affects Chrome version 78.0.3904.108 and IE version 11.864.17763.0, which are the only browsers...
  7. M

    How determine process name

    Hi, I'm writing a reusable business object action to acquire an environment lock and, if unsuccessful, to determine if the process currently holding that lock is making progress by creating work queue items in the most recent passage of a specified time span. If no progress is being made, an...
  8. M

    How copy collection to clipboard

    Hi, My process interacts with SAP and Excel. One of the tasks is to copy a column of values (no more than 100 items) from an Excel worksheet and paste it into separate rows of a table on an SAP screen. I use the MS Excel VBO Select and Copy actions to place the values in the clipboard and the...
  9. M

    How obtain row count from nested collection

    I have a single row collection (call it Coll-A) that has a nested collection as a field (call the field Coll-B). I need to get a rowcount from the Coll-B collection in the only row of Coll-A. The Collection internal business object Count Rows action requires a collection name parameter so I use...
  10. M

    Is a wait stage with multiple actions sequential?

    Hi, I'm using Blue Prism with an application that has separate Development, QA, and Production environments. The different environments are of the same version and appear visually identical but sometimes produce different identifiers when spied in Application Manager. We handle this by spying...
  11. M

    Are environment locks released when process ends?

    Hi, If a Blue Prism process ends while holding the token for an environment lock, is that token released? I wrote a Cleanup page for my process to ensure that open applications are closed, temporary files are deleted, and any held environment tokens are released. Cleanup is called before ending...
  12. M

    How search business object for all occurrences of a global send key?

    Is there a method that allows me to search a business object for all occurrences of a global send key?
  13. M

    Solved How delete unreferenced items from Application Explorer

    Hi, During development, many items were spied that are not referenced in the final code. These show up as Advice items on the Business Object Validation window. If I open a Navigation stage, these items appear in the Application Explorer but the popup menu that appears when one of them is...
  14. M

    Deploying new version of a Blue Prism release package

    From our QA environment,I created a release package that was used to deploy a Blue Prism app to production. The package contained numerous environment variables and credentials that had to be set as part of the production deployment. Since the initial deployment, numerous fixes and enhancements...
  15. M

    Solved Problem accessing Outlook 2016 folder with MapiEx

    I have a Blue Prism process using MapiEx to read emails in a subfolder of the primary email inbox. It works correctly when running from my computer in a development environment. When moved to the quality test environment, MapiEx.Get Mail returns an error that it could not open the subfolder. I...
  16. M

    Solved How sort collection by multiple fields

    Is there a way to sort a collection by multiple columns? For example, if I have a collection with first name and last name fields and I want it sorted by last name and then first name to ensure that Allen Jones appears before Tom Jones, how can I do that?
  17. M

    Solved How can I share an Excel instance and open workbook between processes

    I'm new to Blue Prism and I'm writing a callable, shared Blue Prism process to start an Excel instance, open or create a workbook/worksheet, and allow the calling process to interact with that workbook. This will allow me to validate the directory and file names and perform all the actions and...
Top