Search results

Hi Jon It seems that you have no the first row as header since collection column names are automatically populated using default BP nomenclature (eg. column1, column2, etc). I suppose you are using standard Excel VBO. Could you please double check the file path to ensure you are assessing the...

Hi Neem71 I don't know if you were able to solve your problem. If not, here you are a solution. Please consider I'm replacing the string "(IDM)" internally in the collection to allow the robot to find out the NEXT first parentheses which is the delimited character for extracting the store number

Amlan In the meantime, I've de-installed "Microsoft Access Database Engine 2010" 64-bit version and installed the 32-bit version, even if my machine is Windows 10 64 bit and Office 365 64 bit and the OLEDB connection works fine. Don't ask me why (for whatever reason, the MS Access database...

Thanks Amlan for your support. Definitely Rajadeva's video help me a lot. The bad news is that, after installing "Microsoft Access Database Engine 2010 Redistributable" software from https://www.microsoft.com/en-us/download/details.aspx?id=13255 and once populated the "Connection String"...

Thanks Amlan for your prompt reply. Can you please be so kind to bring me some examples in how to manage such OLEDB VBO. I mean, the standard action sequence for reading from an excel spreadsheet, the usual connection parameters like .....Database name, Provider, etc. Thanks in advance for your...

Hi Amlan I'm facing the same problem. "Get Worksheet as Collection" action in standard MS EXcel VBO, copies the content of visible rows/columns into the Clipboard and later on, move the Clipboard to the Collection. I've also checking with "Show" action, but the VBO does the same, that is ...it...

I've made some investigations thru SQL Server Management Studio and I've found that Blue Prism stored wrongly the expiration dates for users when the year used is over 2030. For instance, even if you select within the calendar panel "January 1st, 2030" the system stored "January 1st, 1930" so...

I'm not able to get into Blue Prism tool since the app said that "admin" user id password has expired. After some tries it said that I've to contact with the System Administrator due to the account has expired. I was able to read the user table in the SQL/Server instance and I see that...

Thanks again for your reply VJ. It seems it was my fault as this is the first robot I'm creating using a web browser and I thought every URL had to had its own BP Object. During my previous "tries", I tried your pointed solution launching from an executable file (ie. iexplore.exe) with the...

Thanks a lot VJ fr your prompt support. Please correct me if I'm wrong in the steps done: 1.- Main BP process runs well launching the 1st BP Object which have the 1st URL. Once completed this part, I'm still leaving open the IE tab to leverage on existing user ID/password used already on this...

Hi there, I'm programming a BP process which requires to have data from two different URL's, both monitored with the same USER ID/Password control, so once I've completed the task with the 1st website, I would like to maintain it opened and launch the 2nd website URL. Based on the fact that...

Thanks a lot VJ, I've tried your post#2 solution and works fine. I will follow with post 7#. Thanks

Thanks a lot VJ for your time and support. Definitely I've to contact with my technical colleagues in order to check if in V6 this error does not appear. In the meantime, I will follow your suggestion to store images in separate .JPG files or something similar. Thanks again.

Hi there I'm trying to save a collection which contains text and image fields in an excel file using MS Excel VBO ("Write Collection" action) but unfortunately I'm receiving the following internal error ... "ERROR: Internal : Could not execute code stage because exception thrown by code stage...

If sometimes works and sometimes do not, I do realise you have to find the "pattern" to ensure you read data only when it's needed. Perhaps you might wish to use a text variable in a READ stage for capturing any representative HTML attribute (in the example below "path"). So try any of the...

For instance, in my case I'm calculating the row using the following formula... while ID Index variable is modified in a loop, depending if I've found the row to be used ...

Hi VJR, thanks again for your time and prompt reply. You definitely gave me the clue. I get now the solution. I've spying "datatables" web site but using HTML spy mode, where I found that in both cases ... pages 1, 2, 3, etc and page 6 (the last one with "Next" link disabled ... attribute...

Thanks VJR for your quick response. I've made the update as you proposed, but unfortunately it doesn't work, showing me the following message "READ: 'Reader1' Process: 'Ver Next Page' Subsheet: 'Ver Next' ERROR: Internal : Failed to perform step 1 in Read Stage 'Reader1' on page 'Ver Next' - No...

Team I'm trying to find how to evaluate if a field in a web browser is "enabled" or "disabled" for clicking on it and do an action. As you probably know, when you have more pages to check a table, you usually has a sort of "Next Page" link at bottom which is always enabled if you are in the 1st...

Thanks a lot AnisJolly for your guide. It was crisp and clear. It works perfectly, moving from one row to the next one thru a loop. Great solution!!!