MxLoader

 View Only

  • 1.  MxL 8.1/8.2 - Preview XML/JSON does not add the header/footer with SYNC and ACTION= or SET

    Posted 11-18-2021 11:00
    Hi, I am trying to create XML MIF files using Preview XML , in 6.2 it works as needed,
    in later versions option is removed or in 8.1/8.2 does not provide header/footer  tags    <SYNC ...     or      action="AddChange">  or the "set" tag
    Anybody else encounter this?   Or, am I missing a setting that will enable the creation of the <SYNC ? 
    copying data back to earlier version is a bit inconvenient, if there is an adjustment I can make that  would be appreciated.
    ( big fan of MxLoader it is a big help in my work ) 
    thank you
    Don

    Example:    object structure is  XXX_CONVWO object is  WORKORDER

    version 6.2 - file generated includes everything to just submit MIF
    <SyncXXX_CONVWO xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://www.ibm.com/maximo" baseLanguage="EN" transLanguage="EN" >
    <XXX_CONVWOSet action="AddChange">
    <WORKORDER action="AddChange">
    <WONUM>XXXX00001</WONUM>
    ...
    </XXX_CONVWOSet>
    </SyncXXX_CONVWO>

    version 8.2   -  File generated does not include header or action or SET
    <WORKORDER>
    <WONUM>XXXX00001</WONUM>

    ------------------------------
    Don Filipchuk
    BPD Zenith Canada
    ------------------------------


  • 2.  RE: MxL 8.1/8.2 - Preview XML/JSON does not add the header/footer with SYNC and ACTION= or SET

    Posted 12-16-2021 14:23
    Hi,
    you are right, I have removed header/footer tags. I was thinking it is better to just have the data preview.
    Can you let me know why you are needing this feature?

    ------------------------------
    Regards
    Bruno Portaluri (MaximoDev)
    ------------------------------

    Original Message


  • 3.  RE: MxL 8.1/8.2 - Preview XML/JSON does not add the header/footer with SYNC and ACTION= or SET

    Posted 01-04-2022 10:50
    Edited by Don Filipchuk 01-04-2022 11:08
    Hi Bruno, thank you for the reply.  Sorry for the lateness of my response here.

    The reason I found the creation of the headers / footers very helpful is that myself and other team members are sometimes on large data conversion projects. Many times we are dealing with very large data sets.  In these projects the ability to save runnable MIF files as XML that may be submitted into Maximo is very valuable because a step is often needed to remove / "cleanse" non-ASCII or special characters in the text / XML file (data from various source systems often contains non-printable / non-ASCII characters in long descriptions).  Running large files (>100,000 rows) directly in MxLoader is not always practical, usually for performance reasons or technical issues like possible dropped connections. 

    As a result it was helpful for these large files to have runnable MIF XML files to submit as the data is promoted through test environments then through to production.  So I really appreciated this feature that "save to XML" included the header/footer for completeness, I found it very valuable.  Thank you!

    ------------------------------
    Don Filipchuk
    BPD Zenith Canada
    ------------------------------

    Original Message


Related Content