You are here: Home / Maximo / Screencast: Import data with XML flat files

Screencast: Import data with XML flat files

June 1, 2009 By 32 Comments
This entry is part 3 of 13 in the series Import Data with MIF

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
This text is available for purchase but you need to login or register first. Please Login here.
Series NavigationScreencast: Import users and passwords with Maximo Integration FrameworkImport assets and asset specifications with MIF
Filed Under: Maximo, MIF, Premium, ScreenCasts Tagged With: , , , ,
About Chon Neth

I am a Senior Software Engineer at InterPro Solutions, LLC located in Wakefield, MA.

Newer Comments →
  • prattipati

    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

    • http://interprosoft.com Chon

      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.

  • ec3

    Have you ever encountered an issue when you click the export data button. My fields in the data export menu are not bound to database for some reason

    • http://interprosoft.com Chon

      I have not. Maybe it’s something you can fix in Application Designer…

  • ec3

    I imported the xml from another environment which worked. Great tutorial by the way

  • rad

    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.

    • http://interprosoft.com Chon

      If it’s not being processed, double check that you have enabled the framework, check out this post…

      • rad

        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.

        • Helio

          hi.

          Try to look at the jms queues in your application server, probably is the queue is full.

  • Sneha

    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

    • jayant

      Please check admin mode from database configuration..if it is on then off it….

  • rad

    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.

  • Sneha

    Hi,

    Before i were able to see the crotask JMSQSEQCONSUMER at log file in websphere..But this JMSQSEQCONSUMER is not coming in the log

  • Thomas

    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

    • http://interprosoft.com Chon

      Did you uncomment the necessary lines in the ejb-jar.xml file? If not, have a look here

      • Thomas

        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

        • http://interprosoft.com Chon

          Yes, you need to enable that.

          • Thomas

            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

          • http://interprosoft.com Chon

            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…

  • JP

    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

  • Nicolas81

    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

    • http://interprosoft.com Chon

      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.

Newer Comments →

Follow Maximo Times

Subscribe to RSS Contact Us Follow Us Linked In Facebook