Search results

  1. H

    How to merge column values in different collections?

    1. You need to find distinct names first 2. Call one by one and filter collection 3. Manipulate the filtered collection row by row and merge "Notes" with "," and assign to the "Name" 4. Next Name in the loop and same process
  2. H

    Application Recognition

    Try modifying windows selectors to find best unique match by using wildcard, it may work (so we can use activate window efficiently)
  3. H

    How to attach Excel (opened by SAP)?

    Hey Hurda, you can use attach active workbook and save as the report. Thanks, HT
  4. H

    Solved Blueprism-Select menu item in SAP

    You can use below in menu path inside navigate "{System}{List}"
  5. H

    Excel VBO - Move Worksheet Error

    Hi, Please help me out in moving the worksheet from one workbook to another. I'm getting the Bad index exception(PFA). Please help!
  6. H

    Start Process acts different

    Hi Sachin, But, how to validate if script run is completed. for example: my script will take 6-7 mins to execute. But I tried running through blueprism - prompt opens and closes in a second (same when you the code stage in blueprism). It just passes the code stage with in a sec and...
  7. H

    Power point Automation with Blueprism(Workingfine in Object studio but not working in process studio)

    Try running with the application active state. Also you can use global send key events to navigate to the slide selector page Use {ALT}<H{ALT}> & {ALT}<I{ALT}>
  8. H

    SAP Success Factors - Workbook Automation

    Hi there, Has anyone in the group got a chance to work on SAP Success Factors automation. If yes, please respond me. Thanks, Himavanth
  9. H

    Data Extraction From Excel Using OLEDB

    Hi gil.silva, I sorted out this issue couple of days ago using Get worksheet as collection offset(same approach you suggested) Yeah, I'm aware even using OLEDB, BP collection concatenates _1,_2 wherever it finds duplicate column names in a sheet. Thanks for you help Man! Have a good day ahead.
  10. H

    Data Extraction From Excel Using OLEDB

    Hi All, I need help on extracting data from Excel file. I cannot use MS Excel VBO - because Sheet has more than 10 duplicate column names(but data inside them is different). So if I try to extract using Excel VBO I get an error stating column name already exists in the data table. So I tried...
  11. H

    Transpose Collection

    Hello, As we all know Transpose collection in Utility Collection Manipulation VBO - Changes the horizontal cells to Vertical I was wondering is there any way to transpose collection from vertical cells to horizontal. Thanks in Advance! Himavanth
  12. H

    Blue Prism - MS Access DB Connectivity and Run Macros with Key-In Parameters

    Hello All, We have a requirement to Run Macros from MS Access DB through Blue Prism. I just want to request you guys to share info on these below questions if anyone worked in a similar case earlier or if they have knowledge on this one. 1. How to connect MS Access DB to BP? Do we need to...
  13. H

    workqueues_BP

    Madhuri- Could you please elaborate little bit.
  14. H

    Exception thrown by code stage : Access Denined

    Shiva - This issue happend because an other instance is already open in the background, so BP doesn't have to read or modify on the sheet. It is caused because of improper closing of excel instance. So if you kill the process in task manager it will be unlocked for operations. Best practice-...
  15. H

    mask important data

    Chakravarthy - If stage logging is disabled for one stage it applies to all the actions in it. So create a separate calc stage for the one which you do not want to log the records and disable logging for that. Let me know if you need any help!
  16. H

    SAP mode mouse click issue

    Hi Shweta, Let me know which stage you are using to perform action to that spyed element? In SAP, I too faced double clicking nodes. The best alternative for it is - In SAP GUI application there are many buttons present there on the toolbar and in page. For Example: If you want to open...
Top