Blog
Find Roles with assignments in a Workflow
Roles in Maximo are used to represent a specific person or a group of people that can be used in workflows, communication templates and escalations. If you need to find which roles are used in a specific workflow you can use an SQL query like this. SELECT wfnode.title, wfnode.description, wfa.roleid, r.descriptionFROM wfnodeJOIN wfassignment wfa ON wfa.nodeid=wfnode.nodeid AND wfa.processrev=wfnode.processrev AND wfa.assigncode IS NULLJOIN maxrole r ON r.maxrole=wfa.roleidWHERE wfnode.processname='[PNAME]' AND wfnode.processrev=[PREV] AND wfnode.nodetype='WFTASK'ORDER BY wfnode.title; Just replace the [PNAME] and [PVER] tags with the correct process name and revision.
May 24, 2013
Link Parent-Child records in Maximo
In a previous post I have described how to correctly manage a child table in an application using the Application Designer. However, there are better ways of achieving the same goals so I will analyze all the available options to correctly link records in a parent-child relationship. If you are a creating custom objects and applications in TPAE you may need at some point to create a child table like the Subassemblies in the Assets application.
May 19, 2013
Java Logging and Tracing in Maximo
This entry is part of the Maximo Java Development series. A good logging (tracing) is always a lifesaver when you have problems in a production environment. I will never stop telling to my fellow programmers how much is important to fill code with meaningful log calls. Maximo has a good and flexible logging subsystem. This IBM TechNote describes in detail how logging works in Maximo. Let’s now see hot to use Maximo logging in your custom Java code.
May 13, 2013
TPAE Java coding standard
This entry is part of the Maximo Java Development series. What is a coding standard and why it is important? A coding standard is a set of guidelines, rules and regulations on how to write code which will help developers quickly read and understand source code conforming to the style as well as helping to avoid introducing faults and misunderstanding. Coding standards are important because they provide greater consistency and uniformity in writing code between programmers. This ultimately leads to the code that is easier to understand and maintain which reduces the overall cost of the project.
May 8, 2013
Sync data between Maximo and Excel
This article is outdated! Checkout MxLoader tool. This is the last step toward a complete integration between Maximo and Excel. In the previous article we have learned how to use Integration Object Service and HTTP calls from Excel to populate a spreadsheet with data retrieved from a Maximo server. In this new article I will show how to synchronize (create and update) data between a Maximo and Excel. First of all you have to complete all the configuration steps described in the previous article.
May 6, 2013
Child table in Application Designer
This article is obsolete. Please refer to this one. If you are a creating custom objects and applications in TPAE you may need at some point to create a child table like the Subassemblies in the Assets application. Let’s pretend we have a parent table called TB1 and a child table called TB2. TB1: Parent table TB1ID: Identifier of records in TB1 … TB2: Child table TB2ID: Identifier of records in TB2
May 2, 2013
Add a language pack to Maximo
Adding a language pack to Maximo after having installed it can be done by running the installer again. After few dialogs and some checks you will be prompted with a list of languages that can be added to the base language. Alternatively you can follow the manual procedure described hereafter. First of all you have to install the language pack using the Process Solution Installer. On the administrative workstation, launch the Process Solution Installer (PSI): Click Start > Programs > IBM Tivoli base services > Process Solution Installer. On the Choose PSI Package panel pick the desired language pack in [SMPDIR]\pmp directory. For example, to install italian language pack I have selected D:\IBM\SMP\pmp\PAE_Lang_Pkg_7.5.0.2_It.zip file. Provide the required middleware credentials and start the installation. Now you can add the language for use with the product using the TDToolkit. Open a command line and move to [SMPDIR]\maximo\tools\maximo directory. Launch the following command specifying the correct locale you want to install.
May 1, 2013
Maximo and Excel Integration
This article is outdated! Checkout MxLoader tool. After having written the two articles on importing and exporting data in Maximo, this morning I woke up with an insane idea. Is it Excel capable of parsing an XML structures and issue an HTTP calls to Maximo Integration Framework? Did you already got my idea? I switched on my tablet and did few searches. Yeeesss! I have all the pieces of the puzzle! The idea is to integrate Maximo and Excel using HTTP calls to a MIF Object Service. This allows to avoid passing through the generation and conversion of CSV files to exchange data between Maximo and Excel.
April 29, 2013
Importing data from a CSV file into Maximo
This entry is part of the Maximo Integration Framework series. In this tutorial I will show how to configure the Maximo Integration Framework (MIF) in order to import data in Maximo from a Comma Separated Values (CSV) text file. The best thing is to start with an export. Please follow this article before proceeding. To be able to export data using the MIF we must configure the following chain: Object Structure Enterprise Service External System Object Service
April 8, 2013
Flat CSV file export with Maximo Integration Framework
This entry is part of the Maximo Integration Framework series. In this tutorial I will show how to configure the Maximo Integration Framework in order to export data from Maximo into a Comma Separated Values (CSV) text file. To achieve such goal we must configure the following chain: Object Structure Publish Service External System For more details about how the MIF works look at the Maximo Integration Framework overview. If this is the first time you are using the Maximo Integration Framework, you should check that your MIF is properly set up before going ahead.
April 6, 2013