Rashmi Joshi

October 28, 2015 2 minute read

Simplest way to get Message Mapping in Excel Sheet

Hi All,

As we know getting Message Mapping Documented is a tedious job many times. There are ways to get XIM files from the Message Mapping using Hidden Buttons like ctrl + shft + 0 in lower versions of PI and then convert it into spreadsheets. But these buttons are disabled from the PI versions like 7.11 or sometimes may face issues like authorizations etc.

In this article we will see the two simple ways to download message mapping from SAP PI to excel sheet.

This method is useful for the versions higher than SAP PI 7.11.

Method 1 —

1. Goto URL –> http://PIHOSTNAME:PORT/rep/support/SimpleQuery

2. Select your desired SWCV —

3. Once you select your SWCV, now scroll down the page and select Message Mapping under Define the Object type(s). Click on “refresh dependant values”.

4. Now under Define the Query Conditions(s). Select condition –> NAME –> LIKE –> Provide your Map Name else you can also use wildcard entries too like “*”

and click on Start Query Button –

5. One object will be generated. Download the RAW file R in XML format

6. Now open this R.XML file in edit mode and get the value from the below tag and copy that in notepad with .zip format

<p1:content>

<tr:XiTrafo xmlns:tr=”urn:sap-com:xi:mapping:xitrafo”>

<tr:MetaData>

<tr:blob type=”zip” zipped=”true”>

7. After zipping file it gets encoded. Its time to decode this file now. Use any Base46 online free tools for this.

8. Once the file is encoded, extract a file by name “Value” from it. Again save it as .zip

9. Open Value file in winzip, you will get metadata file. You will see all the fields in this file

10. Get the jnlp tool to convert this metadata file into xsl file format

Testing –>

MM –

Excel Sheet –

Method 2 –

This method is really very simple and less time consuming too. One should have NWDS in the landscape to utilise this functionality.

1. Open NWDS

2. Connect to ESR objects (Windows –> Perspective –> ESR)

3. Right click on the required Message Mapping Program and Select option Export to Spreadsheet –

Testing –

Excel –

Thanks & Regards,

Rashmi Joshi

29 Comments

You must be Logged on to comment or reply to a post.

Former Member

October 28, 2015 at 12:32 pm

Helpful piece of information.

Thanks for sharing.

Good Work Rashmi !!! All the best !!!! Keep posting !!!

Harinath N

October 28, 2015 at 1:53 pm

Great work Rash..keep going like this.

Very helpful document Rash.

Thanks for sharing 😀

Former Member

October 28, 2015 at 1:56 pm

Hi Rashmi,

Thanks for sharing this document. It is helpful.

Regards,

Keerti

Sudheer gupta Potnuru

October 29, 2015 at 1:51 am

Hi Rashmi,

Thanks again for the document . It is very helpful.

Best Regards,

Sudheer gupta.

Shrihas Ekbote

October 29, 2015 at 5:26 am

Helpful info....keep posting... 🙂

Praveen Tirumareddy

October 29, 2015 at 9:06 am

Hi Rashmi,

It's really a very helpful document.

thanks and regards,

Praveen T

Yee Loon Khoo

November 4, 2015 at 3:03 am

HI Rashimi,

Could you explain more the step 10? what jnlp tool? how to convert xml to xls? Any additional development conversion involved?

"10. Get the jnlp tool to convert this metadata file into xsl file format"

Many thanks.

Regards,

Yee Loon

Rashmi Joshi

Blog Post Author

November 4, 2015 at 9:16 am

Hi Yee,

We need additional converter here.

BR,

Rashmi

Former Member

November 10, 2015 at 3:41 pm

was helpful. Thanks

Steve

Former Member

November 12, 2015 at 6:16 am

Hi Joshi,

Its good document. Could you please explain from 6 - 10 step in first method... I am getting confusion..

Regards,

Srikanth Mavuri.

Rashmi Joshi

Blog Post Author

November 12, 2015 at 8:48 am

Hi Shrikanth,

Try to search the value in tags -

<p1:content>

<tr:XiTrafo xmlns:tr="urn:sap-com:xi:mapping:xitrafo">

<tr:MetaData>

<tr:blob type="zip" zipped="true">

Get this value and then paste it in notepad as an .zip file then you need to use Base64. You can google Base64 encoder and use any free online tool for the same.

Please let me know if this is clear to you.

Regards,

Rashmi Joshi

Former Member

November 12, 2015 at 8:56 am

Hi Rashmi,

Actually i have done upto above step...

Like searching the value in tags:

<p1:content>

<tr:XiTrafo xmlns:tr="urn:sap-com:xi:mapping:xitrafo">

<tr:MetaData>

<tr:blob type="zip" zipped="true">

After getting this value i have pasted in Notepad and saved as a Sample.zip format... I have used online base64 tool to encode this.... but After this only i am getting confusion...

Could you please tell me the procedure....

Regards,

Srikanth Mavuri.

Rashmi Joshi

Blog Post Author

November 12, 2015 at 9:06 am

HI Shrikanth,

Can you share few letters what you are getting in <tr:blob type="zip" zipped="true"> ??

Regards,

Rashmi

Former Member

November 12, 2015 at 9:13 am

Hi Joshi,

Please find the details below.

<p1:content><tr:XiTrafo xmlns:tr="urn:sap-com:xi:mapping:xitrafo">

<tr:MetaData>

<tr:blob type="zip" zipped="true">

!zip!UEsDBBQACAAIAPQwbEcAAAAAAAAAAAAAAAAFAAAAdmFsdWUBQAq/9VBLAwQUAAgACABFY4VDAAAAAAAAAAAAAAAACAAAAG1ldGFkYXRh3VlZb+pKEn6fX5FBui+DJl6x8Z0kV17BYANeWa5GkXcb7yvLrx+bhCQnKyfnSqMZHkzTXa76quqr6ra5+WMfR1eN...................

</tr:blob>

</tr:MetaData>

I have copied this content.... is this correct ?

Regards,

Srikanth.

Rashmi Joshi

Blog Post Author

November 12, 2015 at 9:27 am

Hi Shrikanth,

Copy values from UEsDBBQACAAIAPQwbEcAAAAAAAAAAAAAAAA and perform the next steps. Let me know what you get.

BR,

Rashmi

Former Member

November 12, 2015 at 9:54 am

Hi Rashmi,

Actually i am not getting these three steps.

7. After zipping file it gets encoded. Its time to decode this file now. Use any Base46 online free tools for this.

8. Once the file is encoded, extract a file by name "Value" from it. Again save it as .zip

9. Open Value file in winzip, you will get metadata file. You will see all the fields in this file

My Doubts:

Actually i am copying these values in notepad.... UEsDBBQACAAIAPQwbEcAAAAAAAAAAAAAAAA .... Regarding save... in which format you want me to save...give me example like sample.zip or any other name...

After saving you are telling use any decoder tool...in those tools either i want pass that saved zip file or those values(UEsDBBQACAAIAPQwbEcAAAAAAAAAAAAAAAA )...why becase in some tools they asking me either paste the data or upload the file. So Thats y i am getting confusion....

Can u explain 8 & 9 steps....

Sorry to asking you again & again...

Regards,

Srikanth.

raju s

December 2, 2015 at 6:04 am

Hi rashmi,

Very useful document, please provide the tasks like f2f, file2idoc..

Former Member

February 2, 2016 at 6:18 pm

Great work rashmi, Have you tried PI Documentor tool figaf ?

Rashmi Joshi

Blog Post Author

February 8, 2016 at 8:37 am

Yes Varun.. But somehow I couldnt got luck with that 🙂

suchita tomar

May 3, 2016 at 11:45 am

Hi Rasmi ,

I have certain doubts

1) you want us to copy whatever there after

<tr:MetaData>

<tr:blob type="zip" zipped="true">!zip!

and copy till end of

</tr:blob>

</tr:MetaData>

???? is it right ? also tell me in which format should i save the notepad file once i copy this.

2) let me know which decoding tool should i use, as there are many and tell me i should paste above notepad file data or it should be the ZIP file data ? which has to be decoded.

Regards

S Tomar

Rashmi Joshi

Blog Post Author

May 4, 2016 at 4:02 pm

Hi S Tomar,

1. Save file in .zip format

2. I used below link to decode my file -

Free Online Base64 Encoder / Base64 Decoder Tool - Freeencoder.com

You need to paste your encoded file values and then download the file after decoding into .zip format.

BR,

Rashmi

Former Member

September 23, 2016 at 12:30 pm

Hi Rashmi Joshi,

please help with the last step. How i have to metadata file, which when i open shows some java classes.

How do i convert it in XLS now?

Thanks in advance.

Regards,

Prabhat.

Sampathi Geetha

January 19, 2018 at 6:39 am

Hi Rashimi,

Could you explain more the step 10? what jnlp tool? how to convert xml to xls? Any additional development conversion involved?

"10.Get the jnlp tool to convert this metadata file into xsl file format”

Regards,

Geetha

sai chaithanya

May 1, 2018 at 6:59 am

Hi Rashmi,

Thanks for sharing the Idea...It was very helpful..!!

Can you please let me the jnlp tool you have used to convert metadata to xls?

Best Regards:

Sai

Cristian Jiménez

October 3, 2018 at 2:03 pm

Thank you very much for the post.

I only need the last step, I can not find programs to do the conversion from jnlp to xls.

Can you recommend a program to do this?

Thank you.

Govinda Sairam

February 24, 2020 at 10:56 am

Hi Rashmi,

I was stuck at last point, Could you please help me on this. We're in a project that we need to give client for all our message mappings in a excel sheet. It's little urgent and helpful to me.

Please make a Video on this so that the same way we will try to understand the process.

Mariusz Mazurczak

June 2, 2020 at 11:30 am

Hi All,

Did anyone succeed with the last step (conversion of metadata ) ?
If yes, could you share the way?

Regards,

Mariusz

Michael van den Dool

March 31, 2021 at 11:11 am

Dear Rashmi,

Loved your post but like the others, I'd really like to get more info on step 10: Get the jnlp tool to convert this metadata file into xsl file format?

Can you / anyone please shine a light on this??

Kind regards,

Mike

Sowmya Venkatesh

April 29, 2022 at 7:53 pm

Hello Rashmi,

The information is useful, but honest feedback few things are not mentioned properly which is leading to confusion and would like to get more information on step 10: Get the jnlp tool to convert this metadata file into xsl file format?

is anyone succeeded on step 10.

Let me know your inputs.

Regards,
Sowmya

Simplest way to get Message Mapping in Excel Sheet

Assigned Tags