IBM Maximo consultant, geek, agile evangelist
If you are collecting a lot of photos with service requests or workorder you may start wasting a lot of disk space in the DOCLINCS folder. Here is a small script I have developed for one of our clients to resize JPEG files in the doclinks folder using ImageMagick open-source software. Download the application from […]
Attachments types can be defined setting the system property mxe.doclink.doctypes.allowedFileExtensions but Maximo just checks the file extension. Implement a more strict file type scanning when you upload an attached document.
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 […]
In this post I’m sharing an automation script to generate a BIRT report automatically and attach it a work order. I my scenario I have triggered it from the workflow but it can be also triggered from an escalation.
One of the fist lessons I have learned through all these years as Maximo consultant is that every time there is a default value for a field the user will not change it. A very common example of this is the Folder field of the Add Attachment dialog. The value of this field will always […]
I have just implemented the capability to upload attachments straight from MxLoader. This is in response to some requests on my blog and MxLoader support forum. Starting from Maximo 7.1.1.6 it is possible to import attachments to an object through MIF using Base64 encoding.MxLoader has the capability to read files from the filesystem, encode them […]
This post explains how to extract a set of attachments from the server. First of all you have to find the root folder where the attachments are stored. This can be found in mxe.doclink.doctypes.defpath system property (System Configuration – Platform Configuration – System Properties). Unfortunately, from the file names you cannot understand to which records […]
This procedure describes how to set up attached documents in Maximo 7.1 and above with IBM WebSphere Application Server. In this procedure I will use [IHSDIR] and [DOCLINKSDIR] tags to identify IBM HTTP Server and attachments home directory respectively. Replace those tags according to your environment. Here are the default values. Windows [IHSDIR] – C:\Program Files\IBM\HTTPServer […]
A typical configuration step when building a Maximo cluster on Windows systems is to mount a shared filesystem on all the physical systems that belongs to the cluster. This allows to store attachments in a single place in order to be able to access them from all the servers that builds up the cluster.It is […]
During a performance assessment of a production customer environment I have set the mxe.db.logSQLTimeLimit system property to 2000 to log all long-running SQL statements (see this TechNote for details). Looking at the system logs I have noticed many entries like this. select * from doclinks where (ownertable=’WORKORDER’ and ownerid=1065680) or (ownertable=’WORKORDER’ and ownerid in (select […]