Search results

  1. S

    Global Send Key using Chr

    Refer this article on Stackoverflow https://stackoverflow.com/questions/59251313/sendkeys-sendwait-writes-5-instead-of or Try Send Keys Event instead of Send Keys to see if that makes a difference.
  2. S

    Global Send Key using Chr

    Use "{%}"
  3. S

    Global send keys CTRL+SHIFT+F8

    Global Send Keys : "^+{F8}"
  4. S

    How are retry queue exception case with BP code

    In the Mark As Exception Action, the input field Retry lets you Retry the same queue item (by creating a clone) the number of times defined in System Tab. Refer to Foundation Training on Mark As Exception. The other way is to use Get Exception Items Action, to fetch all Exception Item IDs, and...
  5. S

    Pressing tab multiple times

    Use this : "{TAB "&[number of times data item]&"}"
  6. S

    Solved Issues while reading .txt file with UTF-8-BOM encoding

    Alright. Are you reading the CSV through Excel VBO "Get Worksheet as Collection" OR Utility File Mgmt - Get CSV as Collection ? I can probably pinpoint the issue with Excel VBO method, and help resolve that. If possible, could you share the csv file with sensitive data removed ? On the other...
  7. S

    Solved Issues while reading .txt file with UTF-8-BOM encoding

    Before looking for a way to read the file differently, could you try to read the file and replace the occurrence of all hidden characters using a calculation stage with Replace([text],[hidden character],""). Is this something that will serve the purpose?
  8. S

    Solved Global Send Key Events

    The issue was arising due to the fact that ALT key was not being released. < is used to press n hold a key > is used to release the key <{ALT}h>{ALT}m2 : This means hold ALT and press h, then release ALT, and then press m2 <{ALT}h>m2 : This means hold ALT and press h, then release m, and then...
  9. S

    copying SAP treeview hierarchy to collection

    Check the Get Clipboard action in object studio. Usually it fetches the clipboard data via GetClipboard() function and not a code stage. Another way to fetch Clipboard is via a code stage. Create a new action in the same object (Clipboard_Output is the output data item): Clipboard_Output =...
  10. S

    Solved Global Send Key Events

    Try this: "<{ALT}h>{ALT}m2"
  11. S

    copying SAP treeview hierarchy to collection

    There is no native way in BP to store the clipboard in collection. However, you can Get Clipboard via Utility - Environment VBO, after you are done sending ctrl+c. Then via Utility - Strings Split Text action, split the results using a delimiter (space, tab, etc), to get a collection as an output.
  12. S

    VM as Runtime Resource

    I think, you will need to install Login Agent and login to the VM/windows via that, if you are not sure whether you are signed in to the VM/windows. Blueprism guide on Login Agent + Installer can be found in the portal. Also refer their Remote Access for Control and Monitor guide in case you...
  13. S

    Collection Query

    You are welcome. However, I still feel it should be [Row Index]-1 for line 8. The reason being that indexing starts from 0th position for datatable, which is a collection in .Net. If you need to delete 3rd row from the image, the index should be 2 If it's working for you with +1 instead of -1...
  14. S

    Collection Query

    For action Delete Row at Index : Input : Collection_In(Collection), Row_Index (Number) Output : Collection_Out(Collection) CODE: Collection_In.Rows.Remove(Collection_In.Rows(Row_Index)) Collection_Out = Collection_In.Copy For action Get Row Index from Value : Input : Collection_In(Collection)...
  15. S

    Collection Query

    Result: 1. Use Collection contains value with Regex : "(.*&.*)". Output will be a flag + Groups collection (Idea is to check if & exists in Name Field) 2. Fetch the Row index from the value in [Groups.Group] and store in [Row Index] 3. Read collection field at [Row Index]-1 to fetch Date...
  16. S

    OLEDB Like Query

    SELECT * from [SheetName$] WHERE [ColumnName] LIKE '%abc%'
  17. S

    Loop on two collections with various row count ISSUE

    From what I understood, you want to compare 2 dynamic collections at run-time. If that is all you require, there is no need to store row count using count ++. Something like below should solve your issue, or are you looking for something else?
  18. S

    How to add bullets in email body for new line?

    I am assuming, & might be the problem since it is also used for concatenation in Blue Prism. Make sure &#8226 is being sent as text ("&#8226") If you are still not able to figure out, please post a screenshot of the new calculation stage
  19. S

    How to add bullets in email body for new line?

    Add &#8226 before the string where you want to insert Bullet Point. Example : "Hi Name, <br><br> &#8226 Point 1 <br><br> &#8226 Point 2 <br><br> End of Message <br><br> Thanks"
  20. S

    provider is not registered on the local machine. OLEDB

    Follow this and try to install 32 bit Access Engine : https://social.msdn.microsoft.com/Forums/en-US/1d5c04c7-157f-4955-a14b-41d912d50a64/how-to-fix-error-quotthe-microsoftaceoledb120-provider-is-not-registered-on-the-local?forum=vstsdb
Top