Search results

  1. G

    how to solve the difference between excel macro code and Excel VBO code in BP

    Hello, The best way to understand Excel VBO is to check the existent actions and apply the same functions/methods to the new ones. You can notice that Excel VBO has a huge Global Code in the Initialize page, which is huge to facilitate the creation of action. So, you have functions like...
  2. G

    How to download multi line attachment from a HTML Table

    Hello, I guess you're clicking in the table links to download the attachments, right? You can use a loop where you increment the table html reference to click in each row/link.
  3. G

    change a value of an element in XML with Blue Prism

    You can use Regex to find and replace the value or you can use the Utility - XML object provided by Blue Prism.
  4. G

    Finalizing the best approach

    1. Make that as a pre-requirement. The account should be manually configured in Production. 2. That logic should be stated in the process. Blue Prism Control Room is quite limited and it doesn't allow to easily build dynamic schedules. For your specific example, I would schedule the process to...
  5. G

    Renaming multiple file names in the data collection stored in Current values but not in the Initial Values.

    Hello tiger19, You can use a Loop stage, in the calculation stage you should have something like Left(CollectionName.Filename, Len(CollectionName.Filename)-13)
  6. G

    Warning status in control room

    So, it means the robot is getting stuck in some action, please through the process log, identify the stage where the warning is occurring and try to identify the issue. Feel free to post here a screenshot of the stage/error
  7. G

    Warning status in control room

    Warning status it doesn't necessarily mean that you need to restart the server. Sometimes, if the robot takes a long time in a specific stage (calculating something in Excel, for example), it will show a warning status in Control Room.
  8. G

    Matching format of number

    You have two approaches: Use Regular Expressions (RegEx) Use the functions for Text manipulation 1. Regex expression: 1\d{3} | P\s{4-5} | \d{5-6} 2. Functions to manipulate text (Len([number]) = 4 AND StartsWith([number], "1") ) OR (Len([number]) = 5 OR Len([number]) = 5 AND...
  9. G

    Help merging 4 .csv files into one

    Hello, There are a couple of options to perform that: IF the CSV are quite small (less than 10k rows): Use Excel VBO: get worksheet as collection Use Utility - Collection Manipulation: Append Rows to Collection Repeat for all the 4 CSV files Write Collection to file (Excel VBO) IF the CSV are...
  10. G

    Excel VBA - Copy Paste As Values

    Dim sw, dw As Object Dim ss, ds As Object Dim excel, sheet, source, destination, cells, cell As Object Try sw = GetWorkbook(Handle, Source_Workbook) dw = GetWorkbook(Handle, Destination_Workbook) ss = GetWorksheet(Handle, Source_Workbook, Source_Worksheet) ds = GetWorksheet(Handle...
  11. G

    Find value from collection in Email Body

    Can you describe the problem? Your approach seems correct, you just need to insert a Loop with the calculation stage inside and a decision stage to know if the output is True/False
  12. G

    Saving Excel as PDF

    Hello, Duplicate one action from the Excel VBO, for instance, the Rename worksheet. Keep the initialize of variables and ws and add: ws.ExportAsFixedFormat(0, Destination) Destination should be your input variable with the path + filename.pdf
  13. G

    Copy Collection

    Hello kiss4344, Keep in mind that when you use Copy Rows, the 'start row' is the index, which starts in 0. "Start Row must not point beyond the end of the collection. " It looks you're trying to copy from an index out of the collection range (e.g collection with 10 rows, index from 0 to 9)
  14. G

    Blue Prism

    Hello, How are you attaching the collection in the e-mail? There are 2 main ways to report/send table data in an e-mail: Write Collection in an excel file and attach it Loop the collection and concatenate the data in a Calculation stage, then write it as Body, for better result use HTML format...
  15. G

    Queue Management, Schedule and Environement variable: how to keep clean when going big.

    Hello DFugere, Congrats on your team achievements. There's a couple of best practices/tips which can be followed to have a clean/organized environment: Naming convention: using naming convention can make a huge impact to properly maintain big environments, this approach should be used in the...
  16. G

    Unable to trigger a process through scheduler

    Hello Janya, Go to the tab Recent Activity and see if there were some 'terminated' schedules, where you can check what happened. Make sure the target machine is active and in the Log out state.
  17. G

    How to spy JavaScript page in IE

    Hello manoj_ck, You should be able to use UIA mode to spy the visible elements on the page. There's also the option to use javascript invoke actions, but it requires a deeper understanding of .js
  18. G

    Use of Environment Variables

    Hello rgillam2, Yes, you can use a calculation stage Replace within the process where the 'Server Path' will be replaced by other data item or Env. variable. That can be very useful to set 'global paths' for instance: \{user name}\Desktop \{user name}\Documents Then, with a replace function...
  19. G

    Need help to Identify chrome process is running or not in Blue Prism

    Hello, You can use the action 'Process exists' with input "chrome.exe", from Utility - General, to verify if Chrome is opened.
  20. G

    Path for citrix application

    Hello, When working with Citrix application you will need to use surface and/or keystrokes (global send keys) to interact with the systems. To run an application you can open the CMD in the target machine or a folder and then send with global keys the path to the target application.
Top