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
------------------------------
Original Message:
Sent: 03-08-2023 08:40
From: Alex Walter
Subject: Adding Asset Status and setting the memo
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:
- Navigate to the Integration > Object Structures application
- Locate the MXASSET Object Structure
- From the More Actions menu choose the Exclude/Include fields option
- Highlight the ASSET Object
- Click on the Non-Persistent Fields tab
- 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
Original Message:
Sent: 03-07-2023 09:08
From: Matt TRM
Subject: Adding Asset Status and setting the memo
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
------------------------------