MxLoader

 View Only
  • 1.  Adding Asset Status and setting the memo

    Posted 03-07-2023 09:16

    Hello, While I am able to easily add an asset status record with MXL, I can't seem to set the memo without setting the PLUSCASSETSTATUS.MEMO after I've created the status.  I am setting the memo keying off of PLUSCASSETSTATUS.PLUSCASSETSTATUSID.  It's a bit tedious.  I thought I could include ASSET.NP_STATUSMEMO, but that doesn't seem to work.  Anyone been able to do this another way or somehow using that non-persistent NP_STATUSMEMO attribute?  Thank you.



    ------------------------------
    Matt TRM
    TRM
    ------------------------------


  • 2.  RE: Adding Asset Status and setting the memo

    Posted 03-08-2023 08:40

    Matt,

    Depending on the Object Structure you're using within MxLoader with assets, you might just need to include the NP_STATUSMEMO field. For example, if you:

    1. Navigate to the Integration > Object Structures application
    2. Locate the MXASSET Object Structure
    3. From the More Actions menu choose the Exclude/Include fields option
    4. Highlight the ASSET Object
    5. Click on the Non-Persistent Fields tab
    6. Locate the NP_STATUSMEMO field and ensure that the Include flag is checked.

    Most of the non-persistent fields in Object Structures are excluded by default, so you might just need to explicitly include it. Additionally, if you plan to modify an out-of-the-box Object Structure you should consider cloning the Object Structure and making modifications to the cloned record.

    Hope this helps,



    ------------------------------
    Alex Walter
    A3J Group, LLC
    ------------------------------



  • 3.  RE: Adding Asset Status and setting the memo

    Posted 03-08-2023 09:00

    Hi Alex, thank you.  I had actually tried that and expected it to work, but it didn't.  I included the attribute in the mxasset object structure (non-persistent attribute in the asset source object).  I even restarted as knowing that isn't necessary.  I was wondering if perhaps there was another attribute that required inclusion along with the np_statusmemo to allow it to update.  I do have a method to get it to update without specifying the np_statusmemo, but it is a bit tedious and requires to AddChange sheets.



    ------------------------------
    Matt Moore, TRM
    ------------------------------



  • 4.  RE: Adding Asset Status and setting the memo

    Posted 03-08-2023 10:46

    This unfortunately probably needs to be an enhancement request. We don't expose a method on the Asset MBO which would enable you to capture the memo because for the longest time we didn't record asset status history except for calibration assets. What we do is on the non-persistent AsChangeStatusSet (which is only used by the UI) in the changeMboStatus we fetch the last status history record and copy the memo down at that point. That's inefficient and only works for the UI so I think making the status history similar to the rest of the Maximo statusable objects makes sense.

    With the new Maximo Mobile asset application we're adding the ability to make status changes in 8.10 but don't support a memo (I assume because of this). So even our core experiences would benefit from this enhancement.

    If you really wanted to do this before the enhancement, I think you may be able to do something similar where you add an automation script on the object structure changeStatus event where you call the out of the box changeStatus logic like we'd normally do in the MaxAssetProcess class. Then you could get the child set of PLUSCASSETSTATUS and find the entry being added and take the memo field to copy down to that record. It's a hack but should technically work. Documentation on the OSIN object structure changeStatus event can be found here: https://ibm-maximo-dev.github.io/maximo-autoscript-documentation/integration/osevents



    ------------------------------
    Steven Shull
    IBM
    ------------------------------



  • 5.  RE: Adding Asset Status and setting the memo

    Posted 03-08-2023 10:53

    Thanks Steven.  I have an MXL workaround, but had considered hooking in with a script.  Appreciate the reply and have a good day.



    ------------------------------
    Matt Moore, TRM
    ------------------------------