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.

← Older Comments
  • forozco

    Hi Chon, great post (as always)
    Is there some functionality that allows the insert of the assetnum attribute (or any object ID) to be generated automatically?
    Can I put &AUTOKEY& in the assetnum field for example?
    Thanks in advance

  • yarslan

    Hi All;

    I want to know how to import an excel file with MIF.

    Please write an article about this.I need help.

    Thanks.

    • http://interprosoft.com Chon

      Would a tutorial on importing from CSV be useful?

      • yarslan

        Of course, because an excel file can ve converted to csv file.

        • http://interprosoft.com Chon

          I will try to create a post sometime soon. Thanks!

  • wesonga

    Hey Chon,
    great article on MIF.Im trying to import several records(about 15000)into a a service records table.My question was in the insert statement
    INSERT INTO MXIN_INTER_TRANS (TRANSID,EXTSYSNAME,IFACENAME)
    VALUES (1,’EXTIMPORT’,'MXASSETInterface’);
    the transid is 1.what if i wanted to use unique transid for each of my records how would the insert statement read?

    • http://interprosoft.com Chon

      Replace 1 with whatever number you have associated with the record you want to insert

      • wesonga

        so for my 15000 records i have to run the script 15000 times replacing the 1 with all my different unique transid numbers?

        • http://interprosoft.com Chon

          Yes if that is how you want to do it. Please create a post in our forum if you would like to continue this support.

  • Pingback: Import PM’s and PM sequences with Maximo Integration Framework (MIF)

  • Pingback: The unofficial guide to the Maximo Integration Framework (MIF)

  • http://pulse.yahoo.com/_3ZCLHTOX4VZD6DTQTVQ7OHW63M Alex

    Do you have anything for loading classifications WITH the hierarchy classification hierarchy included.

    • http://maximotimes.com Chon Neth

      Coming soon…

  • Pingback: Import asset classification hierarchies and classification attributes with MIF

  • MB

    Is it possible to connect MIF to SQL server 2005? I want to query some table in a SQL server database and create new records in Maximo.. is it possible to do this? I have a Maximo 7.1.1.6 environment and Oracle 10g..
    Thanks…

  • Keifmayers

    Chon, great article and thanks (totally new to maximo just got dropped in my lap as it were).  In any case I am using maximo 7.5 and I can’t seem to find this part

    To do that, click on Select Action -> Create Interface Tables.  Select the interface and click on Create.

    Any thought where it might be in 7.5?

    Thanks

    • http://maximotimes.com Chon Neth

      It’s there, you might not have permissions to it.  Check your security settings

      • Keifmayers

        Perfect thank you !

  • Ame Eersel

    Hi Chon,

    I’m getting  BMXAA5861E – Mandatory keys are missing – unable to create xml from flat structure white trying to import Asset in Maximo 7.5. How can i find which fields are missing,

    Many thanks,

    Ame

    • http://interprosoft.com Chon Neth

      Usually it’s SITEID and ORGID

← Older Comments

Follow Maximo Times

Subscribe to RSS Contact Us Follow Us Linked In Facebook