THE BPD Blog

From blogs to case studies to news, we love sharing our tips and tricks for asset management, cloud, IoT and smarter operations.

by | Oct 14, 2021

Maximo Data Imports: A simplified guide

All your Maximo data import needs simplified

Being able to manage data loads and data extracts is a powerful ability. It can substantially improve processes and reduce delays. Maximo offers not one, but multiple ways of handling data. Equipped with user-friendly error prompts, there is no room for mistakes any more. For this reason, I have come up with the following guide on Maximo Data Imports:

 

Prerequisites to loading your data

 

1. Integration Object structure:

Prior to loading data, you need to have your Integration object structures ready. An object structure consists of one or more related business objects that define the content of an integration message. There are several standard Maximo Integration object structures available and ready to use (their names start with MX). They are an excellent place to start and you can tweak it to add any objects and attributes that you need.

An image demonstrating step 1, integration object structure in data imports

 

Additional settings within Object structure:

  • Support Flat Structure: This checkbox has to be checked if you want to load through External Systems or Import / Export using a CSV File (Comma Separated Values). Please note: You do not need this for MxLoader.
  • Alias Conflicts: If this check box is checked that means there are two or more objects in an object structure with the same name. To resolve this, you would need to assign a different name using the Select Actions > Add/Modify Alias. Please note: You would need to use these modified names in your loading sheet.
  • Exclude / Include Fields: You have the power to choose which fields need to be included as a part of your data load or data extract. Under Select Actions, individual fields can be hidden or not. There are mandatory fields that cannot be excluded. Please note: As standard, any Persistent fields are included and Non-Persistent are excluded.
  • Application Import/ Export: For this you need to enable the Object Structure for Import and Export in Maximo Applications. Select Add/Modify application Import and Export options from the Left.  You will need to specify the format, application as well as the maximum count of data you will be handling through this object structure. Please note: You will need to grant security privileges for the Import/Export functionality to see this option in the application.

 

2. Enterprise Service:

You need to set this up if you are importing data from an External system.

Please note: You do not need to set this up if you are using the MXLoader or Application Import/ Export option.

An image demonstrating step 2, enterprise service in data imports

 

3. Publish channels:

You need to set this up if you are exporting data from an External system.

Please note: You do not need to set this up if you are using the MXLoader or Application Import/ Export option.

An image demonstrating step 3, publish channels in data imports

  • MXLoader: Excel has been a very useful tool for managing data. You can use Excel to import data into Maximo. MxLoader is a Microsoft Excel spreadsheet that allows one to quickly and easily query and load data into IBM Maximo.  All you need to have is your Integration object structures ready.  There are several standard Maximo Integration object structures (their names start with MX). You can download an MXLoader sheet here. We have a detailed article on how to use MXLoader for your Maximo data needs.
  • Application Import/ Export: You can import data into Maximo using the Application Import icon. If you are unsure of the format of columns of the data you need to import, you can perform an export with a few records in List Tab. You can then modify this file to import in later. If you plan on importing a large number of records, this may not be the best option for you.  It would be best for you to use let the Flatfileconsumer cron task handle your data import.
  • Enterprise Service: You can load data into Maximo after you have configured an Enterprise Service against the External system.  You will need to pay attention to including the header in your data file when using External System. A detailed documentation of configuring Enterprise Service can be found here.
  • Flatfileconsumer Cron Task: Loading large csv files has never been easier with the Flatfileconsumer Cron Task. Instead of importing the files manually, you can use this Cron Task to handle the data import without any user intervention. The Source Directory needs to be configured along with other parameters.

Please note: This directory configured against Source Directory must exist on the application server.

 

An image summarizing the final process in data imports

 

Finally, I hope that this has clarified the Maximo Data Import process for you.

If you would like more information, please get in touch with BPD Zenith at https://www.bpdzenith.com/contact/

Deepa Thomas

Deepa Thomas

Deepa is a Maximo Technical Consultant at BPD Zenith. Before shifting her focus onto Maximo, Deepa worked with IBM Mainframe systems in India. She is now an integral part of the ANZ Support team and enjoys solving day to day issues faced by clients. When not exploring and tinkering with Maximo she loves doodling, painting and exploring art.

0 Comments

Submit a Comment

Your email address will not be published. Required fields are marked *

Architecture Governance

Architecture Governance

What is architecture governance? Governance is a system of rules, practices, and processes by which a company is controlled and directed. It is less about deliberate control and strict adherence to rules, and more about the effective usage of resources to achieve an...

Custom servlet in Maximo

Custom servlet in Maximo

What is a servlet? Servlets are Java classes which service HTTP requests and implement the ‘javax. servlet. HttpServlet’, an abstract class that implements the servlet interface and is specially designed to handle HTTP requests. A  servlet accepts the request,...

9 Recommendations For A Successful SAP & IBM Maximo EAM Interface

9 Recommendations For A Successful SAP & IBM Maximo EAM Interface

Integration is often a key component for getting the most out of your critical IT applications. Modern Enterprise Asset Management systems such as IBM Maximo are designed for integration which can expand their capabilities and allow the flexibility that the industry...

Reinvent the Wheel with BPD Zenith’s Maximo Accelerators

Reinvent the Wheel with BPD Zenith’s Maximo Accelerators

I was recently involved in preparing a business case for a Maximo implementation, and as a part of process I spent considerable time analyzing and evaluating the best approach. In essence, I was trying to find the optimum balance between minimizing the length of the...

Sign up to our free newsletter to explore emerging technologies, industry events and Maximo best practice.

Come with BPD Zenith to the future of Asset Management

Partner Ecosystem

BPD Zenith partners with a diverse array of the world’s top Technology, Business and Solution Integration leaders.