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
Helpful piece of information.
Thanks for sharing.
Good Work Rashmi !!! All the best !!!! Keep posting !!!
Great work Rash..keep going like this.
Very helpful document Rash.
Thanks for sharing 😀
Hi Rashmi,
Thanks for sharing this document. It is helpful.
Regards,
Keerti
Hi Rashmi,
Thanks again for the document . It is very helpful.
Best Regards,
Sudheer gupta.
Helpful info....keep posting... 🙂
Hi Rashmi,
It's really a very helpful document.
thanks and regards,
Praveen T
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
Hi Yee,
We need additional converter here.
BR,
Rashmi
was helpful. Thanks
Steve
Hi Joshi,
Its good document. Could you please explain from 6 - 10 step in first method... I am getting confusion..
Regards,
Srikanth Mavuri.
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
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.
HI Shrikanth,
Can you share few letters what you are getting in <tr:blob type="zip" zipped="true"> ??
Regards,
Rashmi
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.
Hi Shrikanth,
Copy values from UEsDBBQACAAIAPQwbEcAAAAAAAAAAAAAAAA and perform the next steps. Let me know what you get.
BR,
Rashmi
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.
Hi rashmi,
Very useful document, please provide the tasks like f2f, file2idoc..
Great work rashmi, Have you tried PI Documentor tool figaf ?
Yes Varun.. But somehow I couldnt got luck with that 🙂
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
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
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.
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
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
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.
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.
Hi All,
Did anyone succeed with the last step (conversion of metadata ) ?
If yes, could you share the way?
Regards,
Mariusz
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
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