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 […]
Why I hate automation script variables binding
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!
MxLoader NextGen Beta is now over and starting from MxLoader 7.1 all the NextGen features are now available in the official version. Refer to MxLoader main web page for download. MxLoader NextGen advantages are: Support for Maximo NextGen REST APIs Improved performance File download/upload capabilities Detailed results dialog Individual response codes for bulk updates There […]
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, […]