Search results

  1. A

    Retrieve large number of rows in collection through SQL

    Hi All, I am trying to fetch a large number of rows into Blueprism collection through SQL. The issue is, it is able to retrieve the rows(somewhere around 50,000) but it starts giving error right after. My motive is to filter it and then write this collection into an Excel file. Please let me...
  2. A

    Close one of thee two open excel workbook

    I am opening a new Excel workbook through one excel workbook(AFO) which is already open. Now after opening the new workbook I am getting issues with attaching. But if I manually close the previous workbook(the not required one), then everything seems to work perfectly. Is there a way to close...
  3. A

    Need a code to remove empty columns (similiar to removing empty rows)

    Hi All, I am searching for VBA code to delete all empty columns from a collection which works similar to removing empty rows action.
  4. A

    How to identify row in collection and store fields in data items

    Hi @Skydizer , For this scenario, you can use a Multi calc stage, a decision, between the loop and new data item stages to store your desired row. Use the code like "Collection Name.Column Name = "Your desired value" in the decision stage, the true part should be linked with multi calc stage...
  5. A

    Controlroom live alert

    Hi @arghya_bh , My suggestion on this would be to create a mail sending process and call it before the end of the desired process you want to track. You can track if the flow was successful or if there was exception and send the mail accordingly. However, there is no way to get a mail via...
  6. A

    How to work with AutoFill items in Blueprism?

    Hi @2020shanoor , In that scenario, I'd suggest that you spy the logout button and perform proper logout operation instead of closing the browser directly. That way you'll always be redirected to the facebook login page. BR, Aman
  7. A

    How to work with AutoFill items in Blueprism?

    Hi @2020shanoor , For this scenario, the best practice is to always clear the textbox before entering the credentials. For this you can simply use send keys on the textbox. Use the click center on the username textbox and then pass send keys Ctrl+A and Delete. After that you can type in your...
  8. A

    Spying modes

    Hi @deepakbn9099 , The Active Accessibility or the AA mode works as if you are moving the mouse manually or performing the operation manually. It comes in handy mostly when the HTML page is coded with AJAX. For ex. in an AJAX drop down, you cant spy properly with any other mode, the AA mode in...
  9. A

    Validate the rows in collection

    Hi @sainath769 , I believe you are trying to check if the column/field "payments" and "bills" are present in your collection or not. If that is the case, then use a block, inside the block use a loop, then a calculate stage. Within the calculate, type your Collection Name.Column Name and try...
  10. A

    Google Sheet query

    Could you please share the source link or screenshot of the table that you are trying to read? And also the attributes of the element that you are selecting from application modeller.
  11. A

    How to attach Mainframe emulator window?

    Rahul that varies from emulator to emulator in the case of mainframe. The one I used also didn't had option for attach. You need to complete the flow in one go. Launch it, it'll already be attached. Then complete the operation. If you need to go to mainframe home, there are shortcuts. However...
  12. A

    Google Sheet query

    Please check if you are taking the element as table while spying in HTML mode. Other way to get that data into collection is using your way but then you'll have to do a lot of manipulation. So do try one more time with the HTML mode.
  13. A

    Google Sheet query

    Hi Shweta, If you copy data to clipboard, it'll never be sorted in a collection according to columns. Did you try to read the whole collection from google sheet data by spying it and using the read stage to fetch the data?
  14. A

    Read previous row based on value of next row

    Thanks Sivagelli. Your solution seems good but I figured out an alternate solution. Using choice stage and in the "otherwise", i am writing data to a single row collection. Now if the next row contains keyword Equity, it adds a row to my final collection and copies the data from single row to...
  15. A

    Read previous row based on value of next row

    The data is row wise. Its confidential so I can give you the rough idea. Below the data is in collection rows and I've changes the values. Row1 - Keyword1 Row2 - Country Name Row3 - Country Name Row4 - 999,999.99 NAT BK City Name T/D 2.330 FEB 27 19 99,999,999.99...
  16. A

    Read previous row based on value of next row

    Hi all, I am trying to extract data using string manipulation. Although there is a row that doesn't consist of any fix keyword but there is a fix keyword in the next row. How do I get this done using Utility-Collection Manipulation or is there any other alternate?
  17. A

    How to read a large file txt or excel?

    Hi @hernan I am attaching the screenshot of the action stage here. In case if it still doesn't works would mean that your text file has more characters as compared to my text file. Let me know if it helps.
  18. A

    Problem with combobox

    In that case, did you try to use the combo box using the send keys after focusing on the combo box? It actually works like if you are manually operating with the application. So sometimes this helps a lot. Or select the value in the combo box first and then fill the textboxes. I hope that helps.
  19. A

    How to Complete my process If an advertisement is popping up in between of my process?

    Hi @Varun Kumar If the pop up appears randomly, then try to spy it just once and use a decision stage before the other stage and if apply logic that if the popup appears then close it else continue with your application. If it appears multiple times then you can try using multiple decision...
  20. A

    Problem with combobox

    Hi @Daenerys The issue that you are stating seems an application specific issue. To verify this, did you notice that the search button disappears when you use the combo box manually. So check if is working fine or not while you are working manually.
Top