Skip to Content
Author's profile photo Rashmi Joshi

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 —

     URL1.PNG

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

     MM.PNG

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 –

     Start.PNG

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

     RAW.PNG

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 –

     MM_ESR.PNG

Excel Sheet –

     excell.PNG

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 –

     NWDS.png

Testing –

     MM_ESR.PNG

Excel –

     NWDS_EXCEL.PNG

Thanks & Regards,

Rashmi Joshi

Assigned Tags

      29 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      Helpful piece of information.

      Thanks for sharing.

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

      Author's profile photo Harinath N
      Harinath N

      Great work Rash..keep going like this.

      Very helpful document Rash.

      Thanks for sharing 😀

      Author's profile photo Former Member
      Former Member

      Hi Rashmi,

      Thanks for sharing this document. It is helpful.

      Regards,

      Keerti

      Author's profile photo Sudheer gupta Potnuru
      Sudheer gupta Potnuru

      Hi Rashmi,

      Thanks again for the document . It is very helpful.

      Best Regards,

      Sudheer gupta.

      Author's profile photo Shrihas Ekbote
      Shrihas Ekbote

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

      Author's profile photo Praveen Tirumareddy
      Praveen Tirumareddy

      Hi Rashmi,

      It's really a very helpful document.

      thanks and regards,

      Praveen T

      Author's profile photo Yee Loon Khoo
      Yee Loon Khoo

      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

      Author's profile photo Rashmi Joshi
      Rashmi Joshi
      Blog Post Author

      Hi Yee,

      We need additional converter here.

      BR,

      Rashmi

      Author's profile photo Former Member
      Former Member

      was helpful. Thanks

      Steve

      Author's profile photo Former Member
      Former Member

      Hi Joshi,

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

      Regards,

      Srikanth Mavuri.

      Author's profile photo Rashmi Joshi
      Rashmi Joshi
      Blog Post Author

      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

      Author's profile photo Former Member
      Former Member

      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.

      Author's profile photo Rashmi Joshi
      Rashmi Joshi
      Blog Post Author

      HI Shrikanth,

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

      Regards,

      Rashmi

      Author's profile photo Former Member
      Former Member

      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.

      Author's profile photo Rashmi Joshi
      Rashmi Joshi
      Blog Post Author

      Hi Shrikanth,

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


      BR,

      Rashmi

      Author's profile photo Former Member
      Former Member

      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.

      Author's profile photo raju s
      raju s

      Hi rashmi,

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

      Author's profile photo Former Member
      Former Member

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

      Author's profile photo Rashmi Joshi
      Rashmi Joshi
      Blog Post Author

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

      Author's profile photo suchita tomar
      suchita tomar

      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

      Author's profile photo Rashmi Joshi
      Rashmi Joshi
      Blog Post Author

      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

      Author's profile photo Former Member
      Former Member

      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.

      Author's profile photo Sampathi Geetha
      Sampathi Geetha

      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

      Author's profile photo sai chaithanya
      sai chaithanya

      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

      Author's profile photo Cristian Jiménez
      Cristian Jiménez
      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.

       

      Author's profile photo Govinda Sairam
      Govinda Sairam

      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.

      Author's profile photo Mariusz Mazurczak
      Mariusz Mazurczak

      Hi All,

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

       

      Regards,

      Mariusz

      Author's profile photo Michael van den Dool
      Michael van den Dool

      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

      Author's profile photo Sowmya Venkatesh
      Sowmya Venkatesh

      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