IBM Maximo consultant, geek, agile evangelist
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 […]
Few times I have found a small but annoying issue on Maximo when attaching Office 2007 files. Do you know those Excel, Word, PowerPoint files with xlsx, docx, pptx extensions? Yes, those! If you are using Microsoft Internet Explorer it may happen that these files can be uploaded successfully into your DOCLINKS folder but when you try […]