How to set NULL values with MxLoader

A frequent question from people using MxLoader is how to clear the value of a field.

For example, if asset 11230 has the serial number field set to a certain value and we want to blank it out, the following MxLoader sheet will not do the job.

This is because MxLoader skips all the blank cells and does not pass the blank value to Maximo.

To achieve what we want, we can enter ~NULL~ to actually clear the value of the SERIALNUM field.

This is actually not specific to MxLoader but is a Maximo Integration Framework feature.

How to set NULL values with MxLoader

5 thoughts on “How to set NULL values with MxLoader

  1. How to remove a value with date type? This method doesn’t seem to work if trying to nullify a date-time field. MxLoader will throw “Type mismatch” error.

Leave a Reply

Your email address will not be published. Required fields are marked *

Scroll to top