May 16, 2014

MxLoader has been released !

I am proud to announce the release of MxLoader on developerWorks. This is a great tool I have developed to help me in my day-to-day job as a Maximo specialist.

MxLoader is a Microsoft Excel spreadsheet that allows to quickly and easily query and load data into IBM Maximo, IBM SmartCloud Control Desk (SCCD) and other TPAE based applications. It brings together the power of the Maximo Integration Framework and the flexibility of Excel allowing to quickly manipulate and import data into any Maximo database.

Look at this short video for a quick overview of the tool.




Refer to MxLoader community on developerWorks to download the latest version of the tool. Subscribing to the community you will be able to write on the support forum and be notified when a new version is available.

24 comments:

  1. Excellent asset, Bruno! It was quick to setup and relatively painless to setup new object structures within the template. The error log on the applicaton server side (integration logger set at DEBUG and writing to its own file) served to be the best method for troubleshooting why a 500 error would occur. I see great things coming out of this tool. It's important to note that calling an object structure like this is really dangerous if an end user were to use this tool improperly!

    ReplyDelete
    Replies
    1. Thank you for the feedback.
      The latest version displays validation errors directly into Excel when HTTP 500 error code is returned.

      Delete
    2. Hi, I like mxloader and is very sleek for loading data into maximo. Wondering do you have any solution for linking documents from document library? I can provide all necessary details for the links. Basically the data table doclinks will require update.

      Delete
  2. this is just an awesome tool, the best of loaders i have found with Maximo. We had built something on the similar lane with access. but this one is so flexible.

    In term of allowing the operational user to use it, i will would see if we can define specific template and lock it down so that the operational users are allowed to update only what they are supposed to do.

    ReplyDelete
  3. Hi Bruno, very useful tool !!, congrats...!, i only have a question, i´m trying to upload failurelist codes, already had the failurecodes but i got an error like the connection was wrong, but the query option bring back all the records...., is something else that i should have to consider?

    ReplyDelete
    Replies
    1. For support please use the developerWorks forum: https://www.ibm.com/developerworks/community/forums/html/forum?id=0811f8d9-ccf4-400c-989b-43b1e254f112

      Delete
  4. can we write update query using MxLoader

    ReplyDelete
    Replies
    1. Yes We can, Just change operation type to sync in cell C1

      Delete
  5. Hi Bruno,

    Can we connect to Maximo 5.2 using MXLoader?

    ReplyDelete
  6. Hi Bruno,

    I have a problem uploading more than 100 records in POLINE. I found out that less than 100 is just fine, but over 100 the tool threw an error like: "Subscript out of range". Please help!

    ReplyDelete
  7. Hi Bruno,

    I tried inserting in workorder table using MxLoader, It works fine for 10 records more than that it throws error

    2014-06-24 18:17:46 [INFO] HTTP status : 500
    2014-06-24 18:17:46 [INFO] HTTP statusText : Internal Server Error
    2014-06-24 18:17:46 [INFO] HTTP responseText: Error 500: nested exception is: psdi.util.MXSystemException: BMXAA4214E - An unknown error has occurred.

    I have more than 60 columns and i am using 3.7 ( latest)
    i though problem could be with my data, then i fetched data using query operation ( 500 rows) changed operation to Sync and again i got same error.

    thanks

    ReplyDelete
  8. Bruno,

    Is there a classifications template in the works for MxLoader? Getting consistent portable hierarchies to load has always been a challenge. Having this capability available through a tool like MxLoader would be quite valuable.

    Paolo

    ReplyDelete
  9. Hi Bruno,

    How will we load multiple tables ex; location , locationcust, LOCHIERARCHY, looks like it is not supporting multiple object loading?

    Thanks for your help.

    Thanks
    Reddi

    ReplyDelete
  10. Hi Bruno,

    For my current project, we need to edit the macros used in MXLoader. But these macros are password protected and non-editable.

    Please suggest me a way to edit the macros!

    Thank you!

    ReplyDelete
    Replies
    1. MxLoader is not open source. Sorry.

      Delete
    2. Hi Bruno, can I use this MxLoader for bulk inserting Users (Security)??
      Thanks

      Delete
    3. Sure. There is template ready and is also documented in the user guide.

      Delete
  11. Hi Bruno,

    For the project requirement, I want to rename 'Refresh Data Dictionary' command to something else.

    I tried to modify it by using 'Customize the Ribbon' window. But all the tabs, except MXLoader, are displayed there. Please suggest me a way out!

    Thanks in advance!

    ReplyDelete
  12. Hello Bruno,

    I am from Brazil.

    I am working in a project that uses the IBM Maximo tool to manage incidents and problems at the projects.

    I read that your solution can sync the incidents / problems item into Excel.

    It will be amazing!!!

    But when i try to connect at your solution, i am getting an error "Unauthorized". I have already try to change the Authentication value. Didn't works for me.

    Could you help me or give some suggest?

    ReplyDelete
  13. Is MX_LOADER is available for Apache open office?

    ReplyDelete
  14. Hi Bruno

    MxLoader is very helpful in data loading.But I have couple of question for you ....
    1.Other than predefined template which is already there in MxLoader, Can we add some new or customized template in to MxLoader sheet if yes then how can I add new template.

    2.If I edit any field in Predefined template do they come automatically in MxLoader or will it show any change in Mxloader.

    ReplyDelete
    Replies
    1. 1 - yes you can define your own loading sheets modifying a template or by simply creating new worksheets. The structure of the sheet must be the same and must match an object structure defined on Maximo.
      2. You can modify the templates as long as the field names match exactly the object structure on the server.

      Please take a look at the user guide:
      https://www.ibm.com/developerworks/community/groups/service/html/communityview?communityUuid=220c5757-ac28-4f25-bd08-457c5a3364c3#fullpageWidgetId=W9cbbfec147e6_4341_9578_7671e722619f&file=729a4f7d-96cb-4696-9289-54cbe6a86308

      Delete