Maximo Open Forum

 View Only
  • 1.  MxLoader

    Posted 03-24-2022 05:09
    Hi,

    Did anyone know how to update Work Log in Work Order by using MxLoader? I did tried many times, seems like did not added into work log or doesn't make any changes. Maybe I miss something in MxLoader?



    Hopefully got someone know how to do it by using MxLoader.
    #EverythingMaximo
    #Integrations
    #WorkManagement

    ------------------------------
    Nor Herman Afandi
    ------------------------------


  • 2.  RE: MxLoader

    Posted 03-24-2022 14:36
    Hi,
    You need to use an object structure that has WORKORDER at the top and WORKLOG as a child - which MXWO does not have out of the box (it is just WORKORDER).

    If you duplicate the MXWO object structure, save it with a suitable name, add WORKLOG to the new object structure (I have used WORKLOGAPPT as the relationship), then use this new object structure in your MxLoader sheet you should achieve what you want.  If you want worklog long description, you will need to add that non-persistent field into the structure.

    Note in MxLoader your column header names are not correct for referencing a child object. They should be like this:

    WONUM
    SITEID
    WORKLOG.CLIENTVIEWABLE
    WORKLOG.CREATEDBY
    WORKLOG.CREATEDATE
    WORKLOG.DESCRIPTION
    WORKLOG.LOGTYPE
    WORKLOG.DESCRIPTION_LONGDESCRIPTION

    ------------------------------
    Cameron
    ------------------------------



  • 3.  RE: MxLoader

    Posted 03-25-2022 04:57
    Hi,

    Thank you for your explanation and suggestion. It's works! 

    Really appreciate it.

    ------------------------------
    Nor Herman Afandi
    ------------------------------



  • 4.  RE: MxLoader

    Posted 11-03-2023 06:39

    Dear,

    Can you explain how to do this ?

    If you want worklog long description, you will need to add that non-persistent field into the structure.

    Regards,

    Jan



    ------------------------------
    JAN VERELST
    DHL Aviation NV
    ------------------------------