Thanks for your reply .
If I understand you correctly, then you propose a way to access the database data using the OLEDB.
This will still require approvals, because we will need to get the rights to read the data, that is, we will need to create a separate user in the database with read rights for this.
The view is just created in order to restrict access to information in the database. But I described the way to get access to the view in the previous post.
Yes, here is a screenshot of the Java application menu I'm talking about.
------------------------------
Sergei Evdokimov
------------------------------
If I understand you correctly, then you propose a way to access the database data using the OLEDB.
This will still require approvals, because we will need to get the rights to read the data, that is, we will need to create a separate user in the database with read rights for this.
The view is just created in order to restrict access to information in the database. But I described the way to get access to the view in the previous post.
Yes, here is a screenshot of the Java application menu I'm talking about.
------------------------------
Sergei Evdokimov
------------------------------
thanks Sergei, yes the database functions are included in blue prism and usually are very simple and straight forward to implement. Although it doesnt sound like its an option in your current project keep it in mind for future projects it will greatly reduce development time.
For the issue you are having with the file menu there are a couple of possible solutions, one would be to re-spy using a different method or you could try spying the entire list menu and try using a navigate to select item using name and position.
If neither of these are suitable then the next option would be to use global send key events to select the menu item. This is is done by using the click to open the file menu then using the root application in a navigate stage and selecting global send key events. For this action you need to include the keystroke actions, for this menu list you want to press DOWN until you reach the item then press ENTER. So you may need to press DOWN 6 times to get to export then press ENTER. Add these in this format "{DOWN}" "{ENTER}". For the down action you can either add these as individual steps (recommended) or include them in one single step e.g. "{DOWN}" "{DOWN}" "{DOWN}" "{DOWN}" "{DOWN}" "{DOWN}"
I've included a couple of screen shot as an example to follow. Hopefully this is helpful, let me know how you get on with this and if it works for you. 🙂
------------------------------
Michael ONeil
Technical Lead developer
Everis Consultancy
Europe/London
------------------------------
For the issue you are having with the file menu there are a couple of possible solutions, one would be to re-spy using a different method or you could try spying the entire list menu and try using a navigate to select item using name and position.
If neither of these are suitable then the next option would be to use global send key events to select the menu item. This is is done by using the click to open the file menu then using the root application in a navigate stage and selecting global send key events. For this action you need to include the keystroke actions, for this menu list you want to press DOWN until you reach the item then press ENTER. So you may need to press DOWN 6 times to get to export then press ENTER. Add these in this format "{DOWN}" "{ENTER}". For the down action you can either add these as individual steps (recommended) or include them in one single step e.g. "{DOWN}" "{DOWN}" "{DOWN}" "{DOWN}" "{DOWN}" "{DOWN}"
I've included a couple of screen shot as an example to follow. Hopefully this is helpful, let me know how you get on with this and if it works for you. 🙂
------------------------------
Michael ONeil
Technical Lead developer
Everis Consultancy
Europe/London
------------------------------
