Skip to Content

Note (27 Aug 2014) : Good to see that SAP is listening and coming up with so many new enhancements πŸ™‚ . One of the most common requirement of Message Mapping documentation has been taken care. You can use the feature to export message mappings into Excel sheet with PI >=7.31 SP12/7.4 SP07. For details, please check Exporting Mapping Details as Spreadsheet and What’s new in SAP Process Orchestration 7.31 SP12 / 7.4 SP07 .


Are you finding it difficult to document complex PI mappings? Do you think the effort involved in documenting mappings is more than the development efforts? If yes, there are some good tools available already like The easy PI message mapping documentation service and SAP PI : Mapping Documenter that generates documentation.  From now on, we have one more tool MappingMaster πŸ™‚

MappingMaster is an Excel based application that helps generating mapping documentation easily.

Here are some key features that make it special:

1. No need to download xim/tpz/metadata for mapping from IR/ESR.

2. Select mapping with top to down filter with swc, namespace and multiplicity.

3. Local and function library udf can be easily identified with different color.

4. Local udf list is also provided along with code.

Generated Mapping Documentation

You are just 4 steps away. Want to try, here you go!

1. Open MappingMaster and enable macro.

2. Press alt + F11 > Tools > References and select the required library > click OK > close the window.

image

3. Click MappingMaster button or press ctrl + alt + M > fill up the details > press Login button.

4. Select the swc, namespace and mapping > click Generate Documentation button.

I am sure it will be helpful to you and would save a lot of time while documention.

To report this post you need to login first.

26 Comments

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

  1. Former Member
    Hi Sunil,

    I am unable to select the libraries as instructed in step 2. *****************************************
    2. Press alt + F11 > Tools > References and select the required library > click OK > close the window.
    *****************************************

    References is disabled.

    Could you please guide me?

    Regards,
    Sami.

    (0) 
      1. Former Member
        Thanks Sunil πŸ™‚

        Now I am able to select the referenced libraries.
        In a single click it generated the documentation for the message mapping.

        Regards,
        Sami.

        (0) 
  2. Former Member
    Hi Sunil,

    Appreciate your efforts in creating this user friendly PI Documentor, But I am currently facing the problem “Authentication failed”.
    However with the same credentials I am able to login to the ESR & ID.

    Regards
    Varun

    (0) 
        1. Former Member
          Hi Sunil,

          Excellent work done for creating the version1.2 and this mapping sheet no doubt contains all the information in organized format with all the UDF details and Function Libraries. It is working fine now, however at the place of Local UDF the sheet is showing calculate4 or calculate3 whereever there are many UDFs are used in the mapping. For a single UDF it is showing the correct name of the UDF. Is there any limitation for the number of UDFs?

          Regards
          Varun

          (0) 
    1. Sunil Chandra Post author
      Thanks Varun. The tool is in beta stage and has been tested only with some specific PI versions. For now I request you to report it as a bug in Tracker > Bugs section alongwith PI version and wait for v1.2.

      Regards,
      Sunil Chandra

      (0) 
        1. Former Member

          Hi,

          We have the v1.3 relase of the MappingMaster but we get an “Authentication failed”-error, while connecting to a XI 3.0. Does anyone have a clue how to solve this?

          Thanks and regards,

          Miguel

          (0) 
  3. Former Member
    Hi Sunil,

    I believe that using the host name,user name and password in an external tool, will create risk on the client SAP system. Also, if you have seen santhosh’s or Daniel’s PI documentation tools, no user name/password is required.

    Regards
    Varun

    (0) 
    1. Sunil Chandra Post author
      MappingMaster is an open source tool that has been designed to read/display PI mapping in your local network/environment, so I don’t see any risk involved in using that. If you still find it risky, you have other choices πŸ™‚

      Regards,
      Sunil Chandra

      (0) 
  4. Former Member

    Hi Sunil,

    I have downloaded the zip file from the url… File name: Lets Excel – MappingMaster v1.2.

    But, I am not able to find the Mapping master. (Step 1: Open MappingMaster and enable macro)

    Please help!

    Thanks,

    Pratibha

    (0) 
    1. Sunil Chandra Post author

      Change the file name to “Lets Excel – MappingMaster v1.2.xlsm”. Seems that the extension was lost while downloading.

      Regards,

      Sunil Chandra

      (0) 
      1. Former Member

        Thanks Sunil.

        I was able to dwnld the file and have enabled the macros.

        When I try to click on the Mapping Master button it gives me an error pop-up without any error text.

        Regards,

        Pratibha

        (0) 
  5. Former Member

    Hi Sunil,

    I am able to select SWCV,namespace details and all, but documentation is not generating for me. it neither gives error nor documentation. can u pls help.

    (0) 
  6. Former Member

    Hi Sunil,

    do you still support the solution?

    I have problem with FixedValues table  – it is not fetched completely, key values are missing.

    Beside of that, it is really useful tool!

    Thanks

    (0) 
  7. Rashmi Joshi

    Hi Sunil,

    I have v1.3, I am able to give swcm namescape n mapping name but its not giving document. I am getting below error –

    Compile error –

    User Defined Type not defined

    Please suggest how can I rectify this error.

    Thanks & Regards,

    Rashmi Joshi

    (0) 
  8. Former Member

    Thanks Sunil.

    I was able to dwnld the file and have enabled the macros.

    When I try to click on the Mapping Master button it gives me an error pop-up without any error text.

    Regards,

    GEETHA

     

    (0) 
  9. Former Member

    Hello Sunil,

    I am not getting the excel file. The link “https://sourceforge.net/projects/mappingmaster/”Β is not opening properly. How can I get the file?

    Thanks

    Anirban Dutta

    (0) 
  10. Former Member

    Hello Sunil,

    I got the file Mapping master1.3 excel. When I click on “Generate Documentation”, it is giving Compilation error – User-defined type not defined.

    Can you please help me on this.

    Regards,

    Anirban

    (1) 
    1. Bert Lemoine

      Hi,

      When prompted for the host, did you start with http? If so try to leave it out, only put the host and port itself.

      Afterwards you can select SWCV, namespace, multiplicity and Message Mapping. But for me the generate documentation button doesn’t seem to do anything (running PI7.5)

       

      Regards,

      Bert

      (2) 
  11. Philippe Addor

    Hi Sunil,

    I’ve noticed that the NWDS mapping export doesn’t contain the values of constants (that must be a bug, at least in my version at the moment).

    Besides that, the format of your MappingMaster sheets is still better than the one of NWDS export. Therefore I took your version 1.3 and created version 1.4 out of it, including support for PI/PO 7.5 and improvements regarding fix values and others! Do you mind if I’d share it with the community?

    Thank you,

    Philippe

     

    (1) 
    1. Sunil Chandra Post author

      Hi Philippe,

      Good to know that you like the format and created a updated version. Although I have updated my local version to support running on Excel 2016, but could not get a chance to test on different PO versions.

      Community is all about learning and sharing!

      It is a fantastic idea to share it with the community, please go ahead.

      Cheers,

      Sunil Chandra

      (0) 

Leave a Reply