IBM Maximo consultant, geek, agile evangelist
In the old days there was no blog on the internet and there was no IBM community to discuss Maximo technical and functional topics. All these LinkedIn communities and webinars were not available to learn and share. Few heroes were trying to learn from each other on a closed and moderated Yahoo forum. Yahoo decided […]
One of the new features of MxLoader 7.2 (NextGen) is the capability to upload and download files from Maximo. Any text field can be exported to a file by simply prepending the attribute name with FILETXT: prefix. In this example, all the long descriptions of assets will be exported to text files under the Assets […]
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 […]
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 […]
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 […]
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 […]
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 […]
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 […]
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 […]
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, […]