My organization has a process for loading data from Excel into Maximo (as part of a new Maximo implementation project).

1. Users fill in custom excel templates.
2. Users email the templates to technical experts.
3. The technical experts copy the template data into MxLoader and then load from MxLoader into Maximo.
4. The data load inevitably fails (has a litany of errors).
5. The technical experts email an Excel list of the errors to users.
6. Users review and try again. Repeat.

It’s not an efficient process.

Question:
Does anyone have any techniques they could share that has proven to make data loading less painful?

For example, I came across a product called  MaXLS that lets users copy a range of cells from Excel and paste them directly into Maximo (via a grid in Maximo). That sounds appealing. More info here and here.

I'm interested to hear what has worked well for people. Thanks!
#Maximo
#AssetandFacilitiesManagement

Hi User1971,

We developed our own Data Management Tool starting already in 2010. Compared with MXLoader I'd say EAM Data Management is more focusing on Super Users and not on Admins to do the Upload. There is also no knowledge about Object Structures ect. required.

Free demos and trials available....
Cheers
Johann

------------------------------
Johann Rumpl
Maximo Senior Consultant
EAM Swiss GmbH
Gais
Switzerland
------------------------------

Hi,

I only see 2 options, one to make the excel file "more cleaver" or allow end user to use application import for that object structure.
The advantage with application import is that if there is one error it will block the loading for that file in total so even if row 1 to 4000 where ok nothing
will be loaded if there is an error in row 4001.
Disadvantage is that application import is often limited to for example 5000 rows so are there big amounts you need to split up the file in multiple files.

We use mxloader but run some checks on the content before we start loading that the data is correct

------------------------------
Agron Basha
------------------------------

It all depends on what data you are loading. I did work on this in the past. My approach was to export the data from MX in the form of a CSV file. Then use that as a template and then put my data. You need to clean some stuff based on your data. And then import it using integration. I was able to successfully load my data without major hiccups.

-Sanjay

------------------------------
SANJAY PATIL
------------------------------

You can use Application Import / Export in Integration Modules to solve this!

------------------------------
Viet Nguyen
Team Lead
Avenue JSC
84 8 5410 1820
------------------------------

Hi User1971,
The one solution that I've worked with that seems to meet mass upload is MAXLS Data Management.  https://maxls-dataload.com/

------------------------------
Dean Wright
------------------------------