Maximo

Hi Stevie — yes, it’s possible to delete a personid from the LOCATIONUSERCUST table using MxLoader, but it requires a custom object structure and careful handling of delete operations. Here's how you can approach it:

1. Create a Custom Object Structure

• Go to Integration > Object Structures

• Create a new structure (e.g., MXLOCATIONUSERCUSTDEL)

• Set the Primary Object to LOCATIONUSERCUST

• Include only the fields you need: LOCATION, PERSONID, ORGID, SITEID

2. Enable Delete Action

• In the object structure, go to Add/Modify Actions

• Ensure Delete is enabled for the LOCATIONUSERCUST object

3. Create an Enterprise Service (Optional)

• If you want to use this via REST or MIF, create an Enterprise Service linked to the object structure

• Set the processing rule to allow delete

4. Prepare Your MxLoader Sheet

Use the following format in your Excel sheet:

• _action must be set to Delete

• Ensure all key fields are populated correctly

5. Run MxLoader

• Use the correct object structure name in the ObjectStructure field

• Set Operation to Sync

• Make sure your user has delete permissions for LOCATIONUSERCUST

Hi Mohamed Moussa

Thank you for your assistance. In 7.6.1.2, I don't see the option to Add/Modify Actions as suggested in #2 of your response. Can you tell me where I might find it?

Thanks

Stevie

you welcome Mr Steive