Welcome to Maximo Times

All Things Maximo

My name is Chon, feel free to ask me any question regarding Maximo. I will try to answer them as best as I can.

Member Login

Lost your password?

Not a member yet? Sign Up!

Maximo Tips & Tricks

Featured Solutions
Babson College - Utilizes EZDash

Babson College - Utilizes EZDash

Babson College, one of the leading business colleges in the world, has chosen InterPro Solutions’ EZDash module for a real-time and easy visualization of their maintenance productivity and energy consumption data.  This customizable dashboard runs 24 hours a day on a 46” wide screen monitor in the main office, so ...

View Solution...

EZMaxMobile - Maximo Mobile Integration

EZMaxMobile - Maximo Mobile Integration

Real Time Maximo Mobile Connectivity InterPro Solutions’ has developed a mobile integration framework that provides real time connectivity to Maximo via WiFi or 3G connectivity. Devices such as BlackBerry, iPhone, Android, MC 50/70s, etc. are now capable of logging into and communicating with Maximo on a real time basis. No longer ...

View Solution...

WebAssign - Workorder Assignment & Scheduling

WebAssign - Workorder Assignment & Scheduling

This web-based add-on to IBM Maximo application provides supervisors and managers with the ability to assign work orders to specific staff as well as track the status of those work orders. Work orders can be assigned on an individual basis or by groups - it as easy as a "point ...

View Solution...

EZDash - Custom Maximo Dashboard

EZDash - Custom Maximo Dashboard

A web based dashboard that seamlessly interacts with your Maximo maintenance management system. EZDash provides real time interactive graphs and charts for use by staff to monitor and manage work processes, inventory, labor hours, PM schedules, etc. EZDash is easily configured to display a wide range of key performance metrics ...

View Solution...

WebMaint - Customer Service Request Module

WebMaint - Customer Service Request Module

This web-based add-on to IBM’s Maximo application system provides customers with a simple way to enter service requests and view their previously entered service tickets.  Customers can enter requests without having to be a registered Maximo user, therefore eliminating the need for a user to register or be registered in ...

View Solution...




Screencast: Import data with XML flat files

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

...

Tags: , , Integration Framework, MIF,


18 Responses to “Screencast: Import data with XML flat files”


  1. prattipati says:

    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

    • Chon says:

      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.

  2. ec3 says:

    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

  3. ec3 says:

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

  4. rad says:

    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.

    • Chon says:

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

      • rad says:

        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. Sneha says:

    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. rad says:

    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.

  7. Sneha says:

    Hi,

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

  8. Thomas says:

    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

    • Chon says:

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

      • Thomas says:

        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

        • Chon says:

          Yes, you need to enable that.

          • Thomas says:

            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

  9. Chon says:

    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…


Leave a Reply

  • What We Can Do for You



    • Syclo Mobile Handheld Solutions
    • Integrations
    • Configurations
    • Support Services
    • Report Development
    • MAXIMO Upgrades
    • Custom Add-On Solutions
    • Engineering Support Services
    • Consulting
  • Clients