Massive update of Asset attributes using MxLoader
Bruno Portaluri 120000GS1X Visits (18253)
MxLoader is a great tool and allows to perform massive updates in Maximo in few seconds. Updating attributes can be a little tricky so here is a little tutorial on how to do it.
When MxLoader is corretly working and connected to your Maximo server you can click on the 'New MxSheet' button and select the 'Assets - Asset Classification and Attributes' template.
Type an SQL where clause in cell D1 to select the list of assets you would like to update. In this example I am selecting a specific type of pumps querying by ITEMNUM.
If you want to change the attributes values you have to:
In this example I have set the SPEED of these pumps to 1300 instead of 1200.
If you now click on the Run button your updated attributes will be synched with Maximo.
Be careful when choosing the right action to set in cell C1. There are two main options.
This means that if you choose 'Sync' the attributes will be created, updated or deleted to exactly match the definition in MxLoader. This can lead to deletion of some attributes. The 'Sync-AddChange' is a safer option if you just want to update existing attribute values.
Refer to the MxLoader User Guide for more information.