Screencast: Import data with XML flat files

Written by Chon Neth, Editor-in-Chief

Import Data with MIF

I have already shown in detail how to export data to an XML file but this screencast will show you how to import data using XML flat files.  It will also show you how to get the XML file structure for the object you wish to import.

What you will learn:

  • Export data to XML file
  • Export data that is formatted correctly (readable)
  • Import data with XML flat file

Series Navigation
This entry is part [part not set] of 15 in the series Import Data with MIF

Did You Know...

As Maximo Experts, we have developed several add-on products for Maximo that mobilize the work force, simplifies assignments, provides ad-hoc reporting capabilities and facilitates the seamless integration of Service Requests into Maximo.

Check out our products by clicking on the following links: EZMaxMobile, EZMaxPlanner and EZMaxRequest.

Find Out More

34 thoughts on “Screencast: Import data with XML flat files”

  1. Great post, very helpful.

    few question though,

    1. Can MIF look at a file location to automatically load the files.
    2. If it can, does this file need any additional tags like headers with authentication, external System info.

    Thanks,
    Sridhar

    1. 1) Yes, you can create a MIF global directory where you can put XML files or flat files and setup a cron task to pick up those files and process them. 2) No, but if you are using XML files, they do need to be formatted correctly.

  4. Hi,
    I am trying to import from an xml file into Person records. There seems to be no problem with the xml format. The “Data Import” says that “Inbound transaction has been processed successfully to queue”.
    But the record doesn’t appear in the person records. However, the current status in Message Tracking is “Received”. It is never going into “Processed”. Could you help plealse?
    Thanks,
    Radhika.

      1. Hi,

        In Message Tracking
        the “Publish” operations are “PROCESSED”,
        the “Sync” operations remain “RECEIVED”.
        And the current maximo base services package version is: 7.1.1.5.
        For some reason the export is successful, importing the xml is on hold, with no errors.
        Please advise?
        Thanks,
        Radhika.

  5. Hi,
    i imported one flat file to maximo 7 and i got this message
    BMXAA5622E – Inbound transaction has been processed successfully to queue
    and i cannot find the data in maximo and
    in data base..i have already turned on the ‘JMSQSEQCONSUMER’ crontask, with the SEQQIN instance active under
    crontask instances..Anything else i have to do

    Thanks a Lot
    Sneha

  6. Hi,
    Has anyone ever got the Inbound operations processed in 7.1.1.5 ?
    for me the Sync, Create operations remain “Received”
    While the Publish operations are “Processed” and successful.
    Thanks,
    Radhika.

  8. Hi guys,
    I do have the same problem. I’m able to export items as XML or Flat-File, thats OK.
    But the import comes only into received status!!!

    I tried also the import with IFACE-Table but nothing reached ever my item table.

    I need HELP!!!
    Thomas

      1. Good Morning Chon!
        Yes they are enabled:
        –
        –
        JMSContQueueProcessor-1
        psdi.iface.jms.JMSContQueueProcessor
        Container
        javax.jms.Queue
        –
        MESSAGEPROCESSOR
        java.lang.String
        psdi.iface.jms.QueueToMaximoProcessor

        – <!–
        MEA MDB for error queue

        JMSContQueueProcessor-2
        psdi.iface.jms.JMSContQueueProcessor
        Container
        javax.jms.Queue

        MESSAGEPROCESSOR
        java.lang.String
        psdi.iface.jms.QueueToMaximoProcessor

        MDBDELAY
        java.lang.Long
        30000

        –>

        But as I understand it, I need this “message driven beans” for processing in the continuous inbound queue.
        This one is not enabled in my enterprise service.

        Thomas

          1. So I enabled the continuous inbound queue. Unfortunately it didn’t help…

            In the sysout.log I found this message at the moment of importig items:
            DEBUG: Control uploadfile could not be found in order to process event loadData ::

            What “uploadfile” ?
            Thomas

          2. Hmm… I’m not sure. So, you modified the ejb-jar.xml file and rebuilt and redeployed the maximo.ear file right? If so, I’m not sure what’s happening. I’d have to look at it to see exactly what’s happening…

  9. Excellent post, very helpful.

    I am processing a bif flatfile and Maximo it is processing ok.

    During Maximo processing (is very long) I like to know which records and how many records are procesed. How I can get this information?

    Best regards,
    JP

  10. Hello Chon!
    Basic question I guess… Is there any way to import data from either XML, text delimited flat files, or interface tables with a “custom” source structure?
    For example, let say we have a third-party system with “Users”, and we can export those users from that third-party system into specific XML or text-delimited flat file with a specific structure (not the typical Maximo structure)… Is there a way to import that file into Maximo using the MIF, and telling it what tag, field or whatever in the source file should correspond to what field of the maximo object structure ?
    All the examples I have seen so far over the web were using the maximo typical structure for xml files, flat files, interface tables… but in a typical real-life case, the source file coming from a third-party system will have a different structure….
    Does maximo/MIF have something for this ? Or do we have to build some sort of custom program to transfer the third-party source file into a MIF-recognized file/object structure before importing it with MIF ??

    Thank you very much!!
    Nicolas

    1. I am afraid that you have to create a file that Maximo can read. Otherwise you would just have to write software as a medium between the two applications. That is how I do it.

  11. Hi chon,
    i am trying to import data using flat file (csv). While importing Following message come ” BMXAA5622E – Inbound transaction has been processed successfully to queue.” but data is not present in Item master also in message reprosesing , No message is there.

    Need Solution

  12. Chon, Have you tried to import/export work order? I am trying to generate a import template, the easier way is to export a flat file first, but I met problem, error message is ‘BMXAA1613 – This Publish Channel has processing rulse that may only be applicable for event-based processing’. no flatfile was exported. how can I do?

  14. Pingback: Export and import data with Excel | Maximo Times
  15. Pingback: The unofficial guide to the Maximo Integration Framework (MIF) | Maximo Times
  16. Pingback: Maximo 7.1 Integration Framework Configuration Basics

  17. Hello Chon

    I am trying to import attach documents via MIF (Flat file) using an Enterprise service . This is for adding attachments for Locations.
    I have the Object structure with Parent as Locations and child as DOCLINKS. I have the upload file with data.
    Can this be done? I am running in to an issue.
    Thanks
    RG

  18. Pingback: Screencasts Now in HD! - InterPro Solutions

Leave a Reply