MxLoader

 View Only
  • 1.  Updating work orders that are in closed (CLS) status using MXLoader

    Posted 06-30-2025 17:44

    Hi All,

    Has anyone found a solution for updating failure hierarchy on work orders that are in CLOSED (CLS) status using MXLoader? The object structure MXWO allows us to null or update the failure code and problem for WORKORDER table as well as FAILUREREPORT table in WCC, DEP, and SKP statuses.  We can update the cause and remedy using MHWO on the FAILUREREPORT TABLE on the non-closed workorders. We are not able to use MXWO or MHWO on the failure hierarchy on any of the Closed workorder. We also tried creating a custom object structure  MXFAILUREREPORT, directly to the object FAILUREREPORT but without success.

    The error we received was:

    1) when using MXWO when nulling the failurecode and problem code

    2) When using MXFAILUREREPORT to update the problem, cause and remedy 

    BMXAA4534E - The failure report code is not valid.

     

    In the front end, we can use the "Edit History Work Order" option under Select Action to temporarily change the work order to a working status, then update the problem, cause, and remedy. However, we have thousands of work orders that need to be updated via MXLoader, and doing this manually is not feasible.

    Any ideas or guidance would be greatly appreciated, as our hands are currently tied.

    Thank you,

    Ethan 



    ------------------------------
    Ethan Ho
    fort worth water
    ------------------------------


  • 2.  RE: Updating work orders that are in closed (CLS) status using MXLoader

    Posted 07-21-2025 15:14

    Just following up to see if anyone has found a solution or any workaround for updating the failure hierarchy on work orders in CLOSED (CLS) status using MXLoader.

    If anyone has made progress on this or discovered an alternative method, please share. We're dealing with a large volume of records, so any input would be extremely helpful.



    ------------------------------
    Ethan Ho
    fort worth water
    ------------------------------



  • 3.  RE: Updating work orders that are in closed (CLS) status using MXLoader

    Posted 07-22-2025 12:31

    Ethan,

    I have not looked into this too much but typically when updating a Work Order in a status of CLOSED means that the HISTORYFLAG=1 and there is likely logic in the MBO that prevents you from updating these records even when using MXLOADER. If you have access to the database, you will likely need to run a SQL UPDATE statement on the Work Orders and likely change the STATUS  as well (ie. INPRG) , then you can use your MXLOADER sheet to update the records then re-run the SQL UPDATE to flip the HISTORYFLAG and STATUS values back. (Keep in mind good practice would be to take a DB backup first or at a minimum a backup of the table that you are temporarily modifying the Work Order. 

    Mike



    ------------------------------
    Michael Marsonet
    MRM-EAM Consulting Inc.
    ------------------------------