You are here: Home / Maximo / Import data with Maximo Integration Framework (MIF)

Import data with Maximo Integration Framework (MIF)

March 25, 2009 By 99 Comments
This entry is part 1 of 13 in the series Import Data with MIF

Import Data with MIF

The new Maximo Integration Framework, formerly known as Maximo Enterprise Adapter (MEA), makes it easy to import data.  I will show you how you can import data into Maximo from an interface table.

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 Framework
Filed Under: Maximo, MIF, Premium, Tips & Tricks Tagged With: , , ,
About Chon Neth

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

Newer Comments →
  • praveen

    Hi,
    Can you please explain me
    “HOW to interface the MAXIMO 7 with a webservice application using the maximo integration frame work?”

    • http://interprosoft.com Chon

      @Praveen
      Writing a webservice is out of the scope of this blog, but I would image you could do something that would insert records into an interface table that would then import data into Maximo.

    • http://interprosoft.com Chon

      @Praveen
      I think I misunderstood, if you were talking about Maximo’s Web Service Library Integration, then that tutorial may come at another date…

  • Dan

    On your external system, do you set anf of the End Point properties for the MXIFACETABLE? I.e. DRIVER, ISREMOTE, PASSWORD, URL, USERNAME.

    I have everything setup exactly as you described and the rows are just sitting in my IFACEASSET and MXIN_INTER_TRANS tables.

    • http://interprosoft.com Chon

      No, I just left mine with the default values. The only end point that has a value is ISREMOTE which is set to 0. The rows in the MXIFACETABLE should NOT be deleted once the transaction has been completed. If the MXIN_INTER_TRANS transaction is still queued up, then it means that the CRON TASK is not picking it up. The transaction should be deleted once the CRON TASK finds it. Check to see if the CRON TASK is active and running. Also check if your JMS queues and buses are setup correctly and working. If you are running Maximo 7.1.1.4, check out this post. Make sure all of the “MEA MDB” sections are uncommented.

  • weaser42

    Any tips on data import for Jobplans? We can import the base jobplan record just fine but have been unable to import Jobtasks. We have tried working with seperate interface objects for Jobplan and Jobtask, each only containing info of one table, and also creating one object which has Jobplan as parent and Jobtask as a child. Either way we have not been able to add records via Integration Framework. This was no problem using the GDL with Maximo 5.2, loading Jobplans in one load followed by Jobtasks.

    • http://interprosoft.com Chon

      To import job plans and tasks, you must create a new object structure and a new enterprise service.

  • mcesa

    Hello,
    Can I write custom class to fill IFACE table? I have on line query view in SQL Server data base and I must data of this view somehow insert into IFACE table …

    • http://interprosoft.com Chon

      Why do you need a custom class? Just import that data into the table however you wish. You can enter data with DTS (Data Transformation Services) or SQL Server Integration Services

  • mcesa

    Thank you for your answer. I have all Maximo connected to Microsoft SQL Server DB. I want with MIF get data from table view in MS SQL server DB (this view is not part of Maximo System) and insert data in IFACE table and from this table with MIF in COMPANIES Maximo table (object). I want to do this automatically without my intervention to insert or get data (somehow with crontask).
    What is the procedure of this steps in MIF? Thank you in advance.

  • Janhavi

    can anybody please tell me how to integrate third party tool(BO crystal)in maximo7.1.
    i want to run crystal reports from maximo.

  • Bernard

    Hi and thans for the tutorial it was very helpful.
    However i get a bit worried working on the back end of the database so i am wondering whether there is not a way of doing so at the front end.

    Cheers

    • http://interprosoft.com Chon

      @Bernard, you shouldn’t have to worry too much about working on the back end of the database as long as you aren’t inserting, deleting or updating any of the MAXIMO tables. If you are only modifying the interface tables, then you are OK. Those interface tables can be deleted and recreated from the front end. So don’t touch any of the MAXIMO defined tables and you should be good to go.

  • Joe

    Can you import JOBPLANS and JOBTASK with a CSV FlatFile in MX7 or do you have to use the XML EndPoint because of the parent child relationship?

  • mcesa2

    Hello,
    Is there any way to import data in Maximo Integration Framework with Java Bean (EJB)? If yes, how? What classes must use?

    • http://interprosoft.com Chon

      I’m pretty sure you can but I have never done it so I am not really sure what classes to use.

  • mcesa2

    Thank you very much for your answer.

Newer Comments →

Follow Maximo Times

Subscribe to RSS Contact Us Follow Us Linked In Facebook