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

by | Jun 12, 2017

How to Load Multiple Objects Using One MxLoader Sheet

How to use MxLoader (or any MIF based Maximo Tool) to load data into more than one Object

Firstly, when loading any data into Maximo using the tools provided, it all relates to an Integration Object Structure. Whether the tool used is MxLoader, Import/Export in the Application or via an External System, the bit that tells Maximo where to put the data is the IntObject (as it is known for short).
There are many existing IntObjects that you can start with as a base point. Often this is the best place to start. There are numerous out-of-the-box options (best to use one of these if available) but they can be created from New or Duplicated.

Details of an IntObject (Integration Object Structure)

  1. Go to System Config > Migration > Object Structures
  2. On the list screen, filter by Consumed By: INTEGRATION

Note: Maximo standard IntObjects start with MX. They don’t cover everything but usually provide a good starting point.

  1. Find the appropriate IntObject – in this case I have selected MXJOBPLAN
  2. The first row is the Parent Object. This is the main object on which we will want to load records and its details have to appear on every line of our load sheet.
  3. The second row is the Sub Object. Subsequent rows can be added where more than one sub object is needed. This is the basic structure that we need.

Note: There are a few other things to be aware of in an IntObject:

  • Support Flat Structure has to be checked if you want to load through External Systems or Import / Export using a CSV File (Comma Separated Values). This is NOT needed for MxLoader. Where there are Alias Conflicts then you can use the Select Actions > Add/Modify Alias to assign a different name (usually we change the detail line and add a prefix. In our example it would be prefixed with “TASK_”
  • Exclude / Include Fields – under Select Actions, individual fields can be hidden or not. Any Persistent fields (held on the Database) are included as standard, Non-Persistent are excluded as standard.

Using MxLoader with Multi Object IntObjects

There are some examples in MxLoader that already use multiple objects. For our example above we can use:

  1. Open an MxLoader workbook (or download from IBM).
  2. On the MxLoader tab – click on New MxSheet icon.
  3. Select Planning – Job Plans (custom) – the new sheet is created with these headings:
  4. The first set of columns relate to the Job Plan record (header) and should be populated accordingly. These need to be replicated on every row, so if a Job Plan has 3 Tasks then there are 3 identical value in each of these columns.
  5. The second set of columns, those prefixed with “JOBTASK.” are for individual Task records and need to be populated as accordingly.
  6. If you have more than two objects then the corresponding columns also need the sub object name prefixed on the column.

Note: A good trick is to see what the data looks like based on an existing record. To do this, the value in cell C1 has to be set to Query. The value in D1 is then the appropriate SQL Where Clause – i.e. JPNUM = ‘XYZ123’.

  1. Run the Query Statement first to see what existing data looks like.
  2. To load the data you have a number of Options:
Option Description
Sync – AddChange Most commonly used – if records exist they will be updated, if they don’t exist they will be added
Sync – Add Add Records Only – existing records will error
Sync – Change Change records Only – new records will error
Sync For the individual object – removes all existing records and then add the record in as new (similar to Replace)
NB – this is great for loading Authorization records on Security Groups – but beware!
Delete Delete any existing records

A few other things with MxLoader

The Config sheet has some options in it that are useful.
Maximum objects – if you want to return more than 50 rows using Query option, you’ll need to set this higher.
Batch Size – if you have a large number of records to load then setting this will load the rows in batches. If you are doing test loads and want to easily find any problem rows then set it to 1. Each row is processed and MxLoader will stop when it finds a problem. You can then fix it and restart – you can continue at the same point if  Stop on error and Continue sync are set to True.

If your organization needs loading multiple objects, please contact us.

Simon Barnes

Simon Barnes

Simon has been working with Maximo for over ten years in a variety of industries (Oil and Gas, Utilities, Facilities Management etc.). He has a passion for sharing his experience and passing on his Business, Functional and Technical Know-How. Simon has worked with BPD Zenith in both Canada and the UK on a wide variety of projects. He takes a no-nonsense, direct approach and loves to solve problems. He has also worked for end users in senior management positions, giving him an insight into the challenges of making Maximo work for the business and its operations.


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...

The Hidden Value of CMMS Master Data

The Hidden Value of CMMS Master Data

Having made a significant investment in your CMMS, advances in Data analytics are prompting rethinks about the Master Data that underpins your ability to launch programs such as Asset performance management, Monitor Asset health and enhance Predictive Maintenance. A...

Meet the Team – Sourabh Jain

Meet the Team – Sourabh Jain

1. What is your position at BPD Zenith? My name is Sourabh and I’m currently a Senior Maximo Consultant at BPD Zenith, Sydney. 2. What led you to choose this career path? What alternative career path would you have chosen and why? When I was studying programming for...

Maximo 7.6 to 8.x transition

Maximo 7.6 to 8.x transition

It's challenging to keep up with technology and we understand from a customer perspective it’s much harder to keep up with consistent upgrades and technological changes. But it’s good to see Maximo journey from client server platform (MX4) to Web Application(MX6) and...

What is Asset Performance Management?

What is Asset Performance Management?

What is Asset Performance Management? Introduction As a definition, Asset Performance Management (APM) encompasses the capabilities of data capture, integration, visualization, and analytics tied together for the explicit purpose of improving the reliability and...

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.