Export data to XML files with MIF

This entry is part 5 of 13 in the series Import Data with MIF

Exporting data with the Integration Framework is a lot easier than importing data.  When importing data, we use “Enterprise Services”, but for exporting data we need to use “Publish Channels”.  Of course they are both based on Object Structures.  Out of the box, Maximo provides plenty of Publish Channels and Enterprise Services to satisfy most of our needs.  So for this tutorial, I will show you how to export ITEMS to an XML file.

What you will learn:

  • Setup integration framework global directory
  • Export data to XML file
  • Export data that is formatted correctly (readable)
This text is available for purchase but you need to login or register first. Please Login here.
Series NavigationImport assets and asset specifications with MIFHow to import failure codes with the Maximo Integration Framework (MIF)
About Chon Neth

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

  • kit

    Hi, I would like to export a workflow from Maximo7.1. I would like to use MXWinterface to export the workflow, but this interface is not available. Can you share with me how to do this?
    Thank you.

    • http://interprosoft.com Chon

      You can do this like you would with any other objects that don’t exist. You would create your own Object Structure definition for Workflow, then create an interface for the OS.

  • Garrett Hyder

    For me to get the ITEM xml files to write out to the MIF-Global Directory I had to:
    - Goto > System Configuration > Platform Configuration > Cron Task Setup
    - Select the JMSQSEQCONSUMER Cron Task
    - Set the SEQQOUT Cron Task Instance to Active
    - Save

    Once I’d implemented these steps I was able to export XML files.

  • ec3

    For some particular reason, I only see an axis2 folder and a schema folder in the directory I created. I also set up the crontask suggested by Garrett. When I checked the message tracking application and it says that the file has been published successfully but I don’t know were it went.LOL. Any idea Chon?

    • http://interprosoft.com Chon

      Not really sure. Double check your global directory and the end point.

  • afable

    I did by what you say, but occurs BMXAA1581E – JNDI don’t set up name {0} object like this
    why?

  • jrkshankar

    How can Import /Export the data using “JMS Handler” as endpoint .Can you give the steps for creating data through JMS Handler in (MIF) Maximo 7 interface
    Advanced Thanks
    Shankar K

  • jrkshankar

    Hi,
    Can you give the steps for creating data through JMS Handler?

    Shankar K

    • http://interprosoft.com Chon

      You have to create a new endpoint and set the handler to JMS. Then you would have to configure the parameters for the external system. I haven’t used the JMS handler but it should be just like the other handlers such as XML and FLAT files.

  • jrkshankar

    Thanks. One more question how can configure the conditional properties in application designer for hidden/change the label name etc.
    Advance thanks
    Shankar K

  • gpai

    After entering the mif-globaldir for mxe.int.globaldir, make sure you complete the following actions:

    1. save
    2. select check box for mxe.int.globaldir property
    3. Select Actiontion –> Live Refresh

  • dimetri

    Hi,

    Can anyone please let me know how to export data to an excel sheet ? Any suggestions would be appreciated. Thanks in Advance

    Dimetri

  • dimetri

    Chon…could you please help me out in finding a solution to export data to an excel sheet ? Thanks in advance

    • http://interprosoft.com Chon

      @dimetri, You can’t directly export to an excel file (.xls or .xlsx), but you can export to a flat file. This flat file is really a .csv file. You can then import this .csv file into excel. You can follow this tutorial but just change the endpoints to MXFLATFILE. Hope this helps…