topic RE: Oracle Application(Java) Menu closed before send click in Product Forum

Oracle Application(Java) Menu closed before send click

SergeiEvdokimov — Tue, 01 Dec 2020 09:01:00 GMT

Hello everybody!

When working with the application, I want to select the File-Export sub-menu. To do this, I click on the File menu item, then I want to click on the Export sub-item. But the menu closes immediately after the Navigation is executed by clicking the File. At the same time, everything is fine in the user interface, after clicking on the File menu, the application is waiting.

Perhaps someone has come across a similar one?

------------------------------
Sergei Evdokimov
------------------------------

RE: Oracle Application(Java) Menu closed before send click

Vamshi_KrishnaD — Tue, 01 Dec 2020 15:24:00 GMT

Hi

What is the spying mode are you using

------------------------------
VamshiKrihsna Dasa
System Architect
Fujitsu India Consulting Pvt. Ltd.
------------------------------

RE: Oracle Application(Java) Menu closed before send click

michaeloneil — Tue, 01 Dec 2020 17:51:00 GMT

Hi Sergei

What kind of click action are you using? Is it click centre or global mouse click or press? Also if this is an oracle database application is there any reason you cant extract the info using Oledb connection instead of automating the front end application? This is usually much simpler and streamlines your process.

------------------------------
Michael ONeil
Technical Lead developer
Everis Consultancy
Europe/London
------------------------------

RE: Oracle Application(Java) Menu closed before send click

SergeiEvdokimov — Wed, 02 Dec 2020 06:08:00 GMT

Hi

I using Java mode for spying

------------------------------
Sergei Evdokimov
------------------------------

RE: Oracle Application(Java) Menu closed before send click

SergeiEvdokimov — Wed, 02 Dec 2020 06:18:00 GMT

Hi Michael

Using global mouse click. Only this click action and double click are available. Press - not working.

Yes, we can query data from the database table. But this is time for coordination with administrative services, a request to the development department and creation of a view ... And this is still a successful solution lasting several weeks)) But we seem to be talking at the RPA forum 🙂 and Blue Prism should be able to precisely rob the process in the user level.

------------------------------
Sergei Evdokimov
------------------------------

RE: Oracle Application(Java) Menu closed before send click

michaeloneil — Wed, 02 Dec 2020 09:00:00 GMT

Hi Sergei

Blueprism RPA is capable of querying the database using the standard Data-Oledb VBO and shouldnt require creation of the view or access to sql developer just the sql query and a valid username and password. However if it is not possible in your current project then front end extraction is fine, can you tell me if the item you're selecting is from a drop down list? Can you possibly provide some screen shots of the problem you're having so I can understand the problem a little better?

------------------------------
Michael ONeil
Technical Lead developer
Everis Consultancy
Europe/London
------------------------------

RE: Oracle Application(Java) Menu closed before send click

SergeiEvdokimov — Wed, 02 Dec 2020 09:52:00 GMT

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
------------------------------

RE: Oracle Application(Java) Menu closed before send click

michaeloneil — Wed, 02 Dec 2020 11:17:00 GMT

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. 🙂

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
------------------------------

RE: Oracle Application(Java) Menu closed before send click

AndreyKudinov — Wed, 02 Dec 2020 16:07:00 GMT

You can also use menu shortcuts - Alt-F, Alt-E (underlined letters), instead of pressing downdowndown

------------------------------
Andrey Kudinov
Project Manager
MobileTelesystems PJSC
Europe/Moscow
------------------------------

RE: Oracle Application(Java) Menu closed before send click

michaeloneil — Wed, 02 Dec 2020 16:20:00 GMT

I think things like Alt-F open the file menu but I'm not sure if you would be able to use these to select an item from the menu list. The down button would be to select an item from the menu list once its open. So in Sergei's example it would be ALT-F to open file menu, {DOWN}, {ENTER} would select "New" from the menu list.

------------------------------
Michael ONeil
Technical Lead developer
Everis Consultancy
Europe/London
------------------------------

RE: Oracle Application(Java) Menu closed before send click

NileshJadhavBP — Wed, 02 Dec 2020 16:57:00 GMT

Hi,

use send keys to achieve output.

below link will help you for send-keys.

https://portal.blueprism.com/system/files/2018-02/Guide%20to%20Send%20Keys%20and%20Send%20Key%20Events.pdf

Thanks

------------------------------
Nilesh Jadhav
Senior RPA Specialist
ADP
India
------------------------------

RE: Oracle Application(Java) Menu closed before send click

AndreyKudinov — Wed, 02 Dec 2020 18:12:00 GMT

It's simply ALT, F, E on keyboard, no holding. Although I dont like sendkeys, because that needs focus.

So I tested normal way...
Spied: "File"(Role:"menu"; Name:"File ALT F", nothing else needed, but can keep Ordinal enabled too) and "Export"(Role:"menu item"; Name:"Export mnemonic E") separately in java mode, then just did one Navigate with two steps - File and Export, both Global mouse click center and delay 1 between them and it works fine for me.

------------------------------
Andrey Kudinov
Project Manager
MobileTelesystems PJSC
Europe/Moscow
------------------------------

RE: Oracle Application(Java) Menu closed before send click

SergeiEvdokimov — Thu, 03 Dec 2020 07:12:00 GMT

Good morning gentlemen! 🙂

Found a third solution.
The menu item has an attribute "Allowed Actions" = "Click".
So I used the "Do" action and passed the text - "Click". Without opening the File menu first. For this, I identified the item using the "Open Application Navigator".
It worked too.

PS I will test your advice a little later, thanks to Andrey and Michael for these advice.

PSS But in general, a tool for recording user actions in Blue Prism would be very helpful.

------------------------------
Sergei Evdokimov
------------------------------

RE: Oracle Application(Java) Menu closed before send click

SergeiEvdokimov — Thu, 03 Dec 2020 07:13:00 GMT

Hi

Thank you for this document!

------------------------------
Sergei Evdokimov
------------------------------

RE: Oracle Application(Java) Menu closed before send click

michaeloneil — Thu, 03 Dec 2020 09:05:00 GMT

Great news Sergei and good solution to your problem. I'll need to keep that in mind for the next time I'm working on a Java application.

------------------------------
Michael ONeil
Technical Lead developer
Everis Consultancy
Europe/London
------------------------------

RE: Oracle Application(Java) Menu closed before send click

NileshJadhavBP — Thu, 03 Dec 2020 10:27:00 GMT

Fantastic & thank you so much for sharing your solution here.

Now onward everyone has another way to achieve the goal in java automation.

Thanks
Nilesh

------------------------------
Nilesh Jadhav
Senior RPA Specialist
ADP
India
------------------------------