There are two approaches when dealing with Maximo automation scripts input and output variables. Using launch point variables – This method is described in the product’s knowledge center and allows to get/set values from/to the database specifying how to bind the script variables to specific database fields. Using getter/setter methods – This approach uses Maximo […]
How to resend failed emails
Some Maximo implementations massively rely on email communications to notify users about important events like new tickets or assigned tasks. Sometimes outbound emails are also used to implement integration or notify external parties about relevant events. In such environments, it is important to avoid that a planner or unplanned email server downtime results in a […]
Automatically calculate Job Plan duration from Tasks
A small customization I have been recently asked for is to automatically calculate Job Plan duration from Tasks. This can be easily achieved with an automation script on the JOBTASK object. Open the Automation Scripts application and create the following Script with Object Launch Point Launch Point: MXDJPDURATION – Automatically calculates Job Plan Duration from […]
MxLoader NextGen Beta available now!
I’m proud to announce the availability of the beta version of MxLoader based on the new IBM Maximo NextGen APIs. This is a major step to ensure a future-proof tool with better security, performance and reliability. I had to completely rewrite the Excel VBA code to support the new APIs and improve overall performances. The […]
The importance of ‘sameas’ in Database Configuration
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 […]