An often misused feature of Maximo Database Configuration is the ‘Same as Object’ and ‘Same as Attribute’ fields when defining custom database attributes. To understand how this works lets consider the ASSET.LOCATION attribute. As you can see from the screenshot below, the LOCATION column of the ASSET table is defined ‘same as’ LOCATIONS.LOCATION’ field. The […]
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 […]
Attribute validation not triggered immediately
Have you ever experienced a delay when entering data on a field and validation is triggered after several seconds? The asyncronous data validation has been introduced in Maximo 7.5 to improve responsiveness of the user interface. However there are some situations where this is really annoying. For example, if you have developed your own scripts […]
Route Workflow error in cloned applications
Maximo Everyplace is the quick way-to-go to provide access to mobile devices for IBM Maximo. It is basically a slightly changed look and feel of the standard web interface with a dedicated start center that is automatically displayed when logging from a mobile web browser. Obviously it works only in online mode but is straightforward […]
Reset all meter readings
On a development/test environment today I had to reset all meter readings. Maximo is storing the last readings in a set of fields of the ASSETMETER table and the reading history in the METERREADING table. Here are the SQL statements I have used. delete from meterreading; update assetmeter set lastreading=0, lastreadingdate=null, sincelastrepair=0, sincelastoverhaul=0, sincelastinspect=0, sinceinstall=0, […]
Modify Asset’s condition code from Work Order
Condition codes are used in Maximo to define various physical states of a particular item. Once the condition code of an asset is set, it becomes readonly and can only be modified using the Move/Modify Asset menu option found in the Select Action menu of the Assets application (link). In some cases it makes sense […]
Loading Item Assembly Structures (IAS) with MxLoader
I have just releases version 6.2 of MxLoader that contains a brand new template for loading Loading Item Assembly Structures (IAS) into Maximo. An item assembly structure is a list of spare parts and subassemblies required to build an Asset or to define the requirements of a location. Starting from this IBM technote I have […]
Ensure Asset’s serial number uniqueness
Sometimes you need to ensure the uniqueness of a certain database column in the Maximo database. A common example of this scenario is to ensure that asset’s serial numbers are not duplicated. This can prevent the creation of duplicate assets. In this post I describe two techniques to achieve this using a unique database index […]
Send Work Order Calendar invitations
In this article I will show how to send calendar invitations to workers with work order details and reminders for the activities. The calendar event can have a link to Maximo in order to report progress or close the work order using the standard Everyplace or Work Centers interface.
Improved Automation Scripts application
Maximo automation scripts are a very useful tool to implement custom business logic for your customer. After time you may have many scripts to maintain and it may become hard to understand all the logic you have implemented on a specific object. I easy and useful trick I always use is to modify the Automation […]