MII Query Template - Browser Display Mode Issue

[SS15]

Hello,

I am using MII version 15. I am facing issue to launch the query content in Browser Display mode. Picture 1

I have tried with all the Content Type - text/html,xml, csv,json. However rather than expected behavior of getting query result into csv,xml in new browser tab. A notepad opens with the message. Picture 2.

The only mode I can view the query result is Internal Frame and Panel. This is causing little irritation since everytime I have to copy the html link,put into IE browser,change html into csv and get the data downloaded into csv in my local system folder.

Kindly let me know, if there is some settings to be done in my laptop or java version. Thank you.

[ankit12]

Generally, when you open MII query result to the chrome the result will download the file(depends on the format you have selected like JSON, XML, CSV) into the system and then you can open it accordingly.

Now in your case, it is automatically opening the file into notepad. So I am expecting that it is also downloading the file into the system. So try to look into the file properties. It is possible that you have made notepad as by default choice for opening all kind of file.

Regards,
Ankit Gupta

[SS15]

Hello Ankit,

No, it doesn't download a file into the system. It merely opens a notepad with the error message.

I haven't specifically selected any browser or preference like notepad.

To be on safe side, Can you share steps/location in laptop or workbench settings where can I confirm this?

Thank you.

[SS15]

My issue is still not resolved :(...I still have to manually copy the link and paste in IE browser to get the spreadsheet downloaded with query data.

[agentry_src]

Could you provide more details on the query itself? Might also want to provide the version of 15 that you are working in. And the java version. And more information about your environment. Are you using Chrome or some other browser by default? Make sure it is not MS Edge (which sucks!).

Also what is your purpose for running the test, i.e. is it to save the result set? There are simpler ways to do that if that is your purpose. Like wrap a Transaction around the query template and save the data in a local file or within MII itself.

Cheers, Mike

[SS15]

Hello Mike,

Woah!! I like that you are thinking this from technical perspective but this is mere issue with workbench or my laptop system or java kinda problem.

As you know there are multiple times we execute SQL query to view data or take a extraction into spreadsheet for debugging/verification purposes and sometimes it's better to view payload (such as BAPI response) in Browsers.

This is where I am facing issue due to this minor glitch of Query Template Display mode not functioning as expected.

Details - java-ver.jpgmii-wkbnch.jpg

Workbench version - 15.2 SP3 Patch 0

Laptop Java Version - 1.8.0_241

P.S - Where is the option to check the default browser settings in workbench? Please let me know. Thank you.

[agentry_src]

Hi IE,

I am pretty sure the default browser is set in the laptop settings. I usually recommend Chrome, but you should be able to use FF or IE as well. I have used the Browser option maybe three times in almost 15 years of working with MII. And call me old school, but I often dump the content displayed into plain old Notepad for review. If I need the BAPI response, this is generally how I operate. Of course, I have been working with BAPIs for just about my whole MII span and they are like an old friend. Very familiar. Old habits I guess. I have used Notepad ++ a few times, but not very often.

Cheers, Mike