Blog
MxLoader registration Q&A
MxLoader 8.4 no longer requires registration. You can download the latest version or the updater tool from this page.
September 4, 2021
DBC XML Format Reference
The DBC XML Format Technical Reference document disappeared from IBM website. You can download the document from this link. Thanks to Biplab Das Choudhury and Cezar Tipa.
August 17, 2021
MxLoader Webinar Q&A
In this post I’m collecting the answer to the questions that we have received during the webinar of 18th of June 2021 about the release of MxLoader 8.1. Data Validation Validation process is important before upload. because many clients were asked us physical validation report before process data in Maximo. Do we have any such report using MXLoader? Unfortunately MxLoader cannot perform validation before processing the data.
July 2, 2021
Setting multiple fields as readonly with script
Sometimes you may need to allow some users to update only few fields. This may be hard to achieve using conditional UI and conditional expressions. In the following snippet I’m setting all fields as readonly except DESCRIPTION and STATUS if the current user is in MANSUP security group. Attach the script to the Initialize event of the object you want to control. from psdi.mbo import MboConstants from psdi.server import MXServer # check if the current user is in MANSUP security group currentuser = mbo.getUserInfo().getUserName() groupuserSet= MXServer.getMXServer().getMboSet('GROUPUSER', mbo.getUserInfo()) groupuserSet.setWhere("groupname in ('MANSUP') and userid='" + currentuser + "'") if not groupuserSet.isEmpty(): mbo.setFieldFlag(["DESCRIPTION", "STATUS"], False, MboConstants.READONLY, True) The powerful trick here is to use the method Mbo.setFieldFlag(names, inclusive, flag, state)
April 27, 2021
Strict validation of attachment types
Few days ago, Vincenzo Luzzi, a fellow Maximo senior consultant working with me in Omninecs, forwarded this secret tip to me. I haven’t tested it but think I could be useful for the community. You know you can control what types of attachments can be uploaded to Maximo using the system property mxe.doclink.doctypes.allowedFileExtensions. However Maximo just checks the file extension and is not performing any additional check to ensure other types of files are uploaded to its repository. Starting from Maximo 7.6.0.6 you can implement a more strict file type scanning when you upload an attached document.
April 26, 2021
Highlight table rows conditionally
You may not know but there is an easy trick to conditionally set the color of Maximo table rows based on a condition. In this tutorial I will show you how to highlight high priority work orders in Work Order Tracking application. Identify the field First of all you need to identify the field on which the rule will be based on. In our example, the rule will be based on WORKORDER.WOPRIORITY field.
April 25, 2021
Custom REST service with Automation Script
The REST APIs have a tight integration with the automation scripts. Automation scripts can be used to develop custom APIs. The following example call describes how automation scripts interact with REST APIs. You can also use automation scripts for implementing custom queries and custom actions. JavaScript language is always the preferred choice for integration scripts since it provides native functions to manage JSON objects. To find the total number of work that is in progress and service requests in a given site, you need to create an API since there is no out-of-the-box API for this task. Create the following Automation Script:
April 18, 2021
Querying data with MxLoader using REST service
MxLoader 7.1 and above supports the new Maximo JSON APIs that are available from Maximo 7.6.0.2. The REST APIs are based on the OSLC protocol so there are some changes you have to consider. The most important difference between OS and REST service is the format of the where clause that can be set in cell D1 of MxLoader sheets. While OS server accepts SQL syntax, the REST service follows the OSLC specifications. In this post I will describe the most important concept to write OSLC where clauses.
April 18, 2021
JavaDocs for Maximo 7.6
For whatever reason IBM recently decided to remove the online version of Maximo JavaDocs from their website. At the moment they are only available as zip files for Maximo 7.6 and Maximo 7.6.1.2. I think this is not really useful because it is really hard to search what you are looking for so I have just published the JavaDocs on my website so they can easily be searched with Google. Maximo 7.6 JavaDocs
March 28, 2021
Send Communication Template from script
This is a quite old topic that has been already addressed in many Maximo communities and blogs around. However, I have found none of them seems to handle it correctly. There are mainly several techniques of sending an email from an automation script. I will explain the limitations of the current solutions and propose a best practice. If you just want to se the final solution jump here. Using Java APIs - worst solution You know you can use any Java API in your Maximo automation scrips so the first solution is to use the javax.mail package to send email.
March 28, 2021