Solved Blueprism-Select menu item in SAP

[bharathrhegde]

Hi ,

I am trying to select System tab and then select list and then SAve as local file option in SAP.
In "Navigate" stage I have selected the spied element and the Action lists as Select Menuitem

What should I give in the Menupath field.

View attachment 1538417229962.png

 

[Sukesh Kumaru]

Hello,

Next step is to write a path to save the file,
simply use write stage and do that.

Good Luck.

 

[bharathrhegde]

Hi Suresh.thank you.

The problem is not writing the filepath but I need to fist select system then select list then file then save option to save the file.

How do I do this.

In the screenshot you can see I have an option of action selection menu but how do I pass the parameters

 

[Sukesh Kumaru]

Hello,

What you are getting the attributes after spying "System" and "File" etc...
share me the sc.

 

[bharathrhegde]

Hi Sukesh,

Please find the screenshot below.Now I have spied the Menu tab.I want to select System,then List and then SAve option.
View attachment 1538487763488.png

Now I am using the Navigate stage where I get the option Select menu item.What parameter should I pass in Menupath.Please refer below screenshot.
View attachment 1538487928762.png

 

[Sukesh Kumaru]

Hello,

As in SAP some of the work can be done by sending keystrokes(make sure sap is highlighted),
for in this scenario,

NB:don't spy those what you showed in screenshot.

first send a keystroke "s" to open system and "t" to select list and finally "a" to select save.

Good Luck.

 

[bharathrhegde]

But it is not giving an option to send key strokes at all.It only gives select menu item

 

[bharathrhegde]

Hi Sukesh,

Found an easier way.

Pass tcode: %pc it will directly give the option for save spreadsheet.

thanks..

 

[Sasi]

Hi Bharathrhegde, How do you pass this code %pc to SAP application, Through navigate stage ?

 

[bharathrhegde]

By using write stage pass it to the tcode box.and then use navigate to click on execute button.

 

[srivani]

Hi,

Use keystore "<{ALT}y>{ALT}"

 

[Anna Bova]

Hi Sukesh,

Found an easier way.

Pass tcode: %pc it will directly give the option for save spreadsheet.

thanks..

Thank you vm!

 

[Sasi]

Thanks for the update.

 

[gayatri]

Hi All,
I am also having same requirement to export data to excel. I have to navigate through List->Export->Spreadsheet. How can we do this using blueprism.
Could you please help me on this.

 

[sunortap]

Hi, gayatri
1) create a code stage with input ObjectID as text:

Dim SapGuiAuto as object
Dim SAPApp as object
Dim SAPCon as object
Dim session as object

SapGuiAuto = Microsoft.VisualBasic.Interaction.GetObject("SAPGUI") 'Get the SAP GUI Scripting object
SAPApp = SapGuiAuto.GetScriptingEngine 'Get the currently running SAP GUI
SAPCon = SAPApp.Children(0) 'Get the first system that is currently connected
session = SAPCon.Children(0) 'Get the first session (window) on that connection

session.findById(ObjectID).Select

2) to get ID please use application navigator (in application modeller use list in button Identify and choose Open Application Navigator)
go for cup of tea - it will loads some time
scroll down to bottom
scroll up until you find SAP Menubar
below you can find all Menu and Menu Items (see picture attached)
copy ID starting from "wnd"
/app/con[0]/ses[0]/wnd[0]/mbar/menu[0]/menu[3]/menu[1]
use this id as input for code stage

Please remember that you can choose spreadsheet directly, you do not need click List, export, spreadsheet.

 

[gayatri]

Thanks a lot sir

 

[himavantht]

You can use below in menu path inside navigate
"{System}{List}"