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:


Pre-requisites 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

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.


Submit a Comment

Your email address will not be published.

Automotive Manufacturing – Are we working smart?

Automotive Manufacturing – Are we working smart?

If you work as a Chief Operational Officer, a Maintenance Engineer, a Facilities Manager or Safety Officer, or are in charge of renewals/disposals in the Auto Industry, then chances are at some point you will have come across a lack of accurate data, bottlenecks and...

Resourcing for Success

Resourcing for Success

Project resourcing is frequently one of the hot topics in our meetings. I frequently receive questions such as: Can we start the project now? Can we commit this resource to deliver from start to finish? Can we upskill one of our techs? Can we provide an additional...

Maximo Mobile Review

Maximo Mobile Review

The Maximo Mobile app recently released by IBM is something to get excited about!  IBM's Maximo mobility journey has been a little checkered in the past – previous solutions (Everyplace and Anywhere) didn't quite meet all the needs and requirements of many...

Developing Custom Mobile App using Maximo REST API

Developing Custom Mobile App using Maximo REST API

The mobile app for Maximo operations is a gateway to IoT and Advanced Analytics by capturing precise data at the point of performance and data not being captured when using the desktop version of Maximo. As assets become smarter and existing businesses need more...

Asset Management for Net-Zero Futures

Asset Management for Net-Zero Futures

Sustainability is not a new concept and BPD Zenith have always strived to be socially responsible, however, it is a critical imperative for today’s business operations – and for the planet. There has been a shift from using digital to improve the bottom line, to...

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

Discover the Maximo Application Suite

Discover BPD's award winning Maximo and IoT Services

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.