IBM Maximo consultant, geek, agile evangelist
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 […]
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 […]
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 […]
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 […]
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 […]
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 […]
In this little post I will share few database queries to list the customizations made to your Maximo environment. It also applies to other TPAE based products. Security restrictions SELECT * FROM securityrestrictORDER BY objectname, attributename; Custom objects and attributes SELECT * FROM maxobjectWHERE userdefined=1ORDER by objectname;SELECT * FROM maxattributeWHERE userdefined=1ORDER by objectname, attributename; Custom […]
Maximo and other IBM service management products based on TPAE (like SmartCloud Control Desk) can be seen as sitting at the apex of a pyramid that consists of network, hardware, and software services. As you can see, network performance are the foundation of the pyramid.The simplest way of measuring network performances and speed is the […]
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 […]
This entry is part of the Conditional Expressions HowTo. If you need to make a field or an object readonly if it has an active and running workflow you are in right place!All you need is a conditional expression that can be used in conditional UI or data restriction.The following conditional expression evaluate to true […]