September 7, 2014

Remove legacy (Actuate) reports from Maximo

If you are upgrading from Maximo 5 or 6, to Maximo 7.1 or 7.5, you may want to remove legacy (Actuate) Maximo 5 or 6 reports.
The following SQL script deletes those obsolete report entries from the database.

delete from reportlookup
where reportlookup.reportnum in
(select reportnum from report
where runtype in ('ESPREADSHEET', 'QUERY', 'REPORT'))
or reportlookup.reportnum is null
or reportlookup.reportname is null;

delete from reportlabel
where reportname like '%.rox'
or reportname like '%.dox'
or reportname like '%.vts'
or reportname like '%.vtf';

delete from report
where reportname like '%.rox'
or reportname like '%.dox'
or reportname like '%.vts'
or reportname like '%.vtf';

Reference: Maximo Wiki - Deleting reports

September 4, 2014

MxLoader 4.1 has been released !

Hi all,
I have just released MxLoader version 4.1 on developerWorks.

These are the new features:
  • Rewritten XML/TABLE conversion algorithm to support unlimited levels of nested objects
  • Many MxSheet templates added with object's primary key fields underlined in header row
  • Object count limit now works also for sync action
  • For sync operation it is possible to specify the action (Add, Delete, Update, Change, Replace, AddChange)
  • New button to quickly create custom MxLoader Object Structures
  • MxLoader.xlsm file size reduced from 4 MB to 0.5 MB
  • Comments support in MxSheet templates
  • Removed text formatting for text fields because it was messing Excel formula automatic calculation
  • Performance optimization in attribute lookup algorithm (GetAttrType)

Feel free to download it and it everyday.
For questions and support please use this forum.

June 20, 2014

Invoke an Action when a button is pressed

In this article I explain how to attach/associate an action to a push button in an application.

  1. Create the Action you have to call if not already done (Go To - System Configuration - Platform Configuration - Actions).
  2. Open your application with the Application Designer and create a Signature Option with the same name of the Action you want to call (Actions - Add/Modify Signature Options - New Row).
  3. Expand the 'Advanced Signature Options' section and set 'This is an action that must be invoked by user in the UI'.
  4. Create a Push Button on the application with the following settings
    1. Event: enter the action name
    2. Signature Option: READ 
  5.  Grant the Signature Option to appropriate users in Security Groups.

June 10, 2014

Attachments (DOCLINKS) Configuration

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.

  • [IHSDIR] - C:\Program Files\IBM\HTTPServer
  • [DOCLINKSDIR] - C:\doclinks

  • [IHSDIR] -  /home/IBMHTTPD
  • [DOCLINKSDIR] - /home/doclinks

Attachment repository

First of all you have to create the create the [DOCLINKSDIR] directory to store your attachments. For example: C:\doclinks for Windows or /home/doclinks for UNIX.

This directory must be accessible from both the application servers and from the web servers. If you have a simple environment running on a single system you are done. Otherwise you have to share this directory and mount it on all the involved servers.
A procedure to automatically mount shared DOCLINKS folder on Windows is described in this article.

IBM HTTP Server configuration

The second step is to publish the [DOCLINKSDIR] directory through the HTTP Server. This will allow to retrieve the attachments stored in it from the users web browser.
  1. Locate the configuration directory of the IBM HTTP Server . For example C:\Program Files\IBM\HTTPServer\conf for Windows and /home/IBMHTTPD/conf for UNIX
  2. Backup httpd.conf file
  3. Open the httpd.conf file with a text editor
  4. Find 'DocumentRoot' and change like below
    DocumentRoot "[DOCLINKSDIR]"
  5. Find '# This should be changed to whatever you set DocumentRoot to.' and change like below
    <Directory "[DOCLINKSDIR]">
  6. Save and close httpd.conf file
  7. Restart the HTTP Server
  8. Verify that the HTTP Server is configured correctly
    1. Create a test file text.txt into [DOCLINKSDIR] directory
    2. Open a web browser and type in address: http://[MXHOSTNAME]/test.txt where [MXHOSTNAME] is the hostname of your server
    3. You should be able see your test.txt document in this window. If you cannot open the test file, you must go back and check the configuration steps.

Maximo configuration

The last step is to configure where Maximo will store the attachments and how it will retrieve them.
  1. Login to Maximo with administrative rights
  2. Go To - System Configuration - Platform Configuration - System Properties
  3. Set the following properties according to your configuration
    mxe.doclink.doctypes.defpath = [DOCLINKSDIR]
    mxe.doclink.path01 = [DOCLINKSDIR] = http://[MXHOSTNAME]

    Note: These paths in Windows and Unix are case sensistive.
  4. Reload the properties with a ‘Live Refresh’ or restart application server
The mxe.doclink.doctypes.defpath defines where Maximo is storing the attachments locally. The mxe.doclink.path01 allows to translate local paths to the correct HTTP links.

Go To any application which has attachments and select Action > Attachment Library/Folders > Manage folders. Set or check the following:
  • Attachments: [DOCLINKSDIR]\attachments
  • Diagrams: [DOCLINKSDIR]\diagrams
  • Images: [DOCLINKSDIR]\images
Note these Default file paths are case-sensitive and must match the case of directory structure and that of the file.

Finally test that everything is working fine.


Setting up Attached Documents for Maximo 7.1