You are here: Home / Maximo / Import assets and asset specifications with MIF

Import assets and asset specifications with MIF

April 26, 2009 By 25 Comments
This entry is part 4 of 13 in the series Import Data with MIF

Import Data with MIF

I have already given a simple tutorial on how to import assets with MIF using interface tables.  Now, if you want to import asset specifications as well, this is a detailed tutorial on how to do that with interface tables.  You can also download a sample excel document that I used to import into the interface table, prior to the MIF importing into Maximo, which you can use as base structure for your own data import.

Prior to loading data, I will assume that you have already setup the MIF, entered locations, and created some classifications for your assets.  To setup MIF that is ready to import assets you can read this post.

This text is available for purchase but you need to login or register first. Please Login here.
Series NavigationScreencast: Import data with XML flat filesExport data to XML files with MIF
Filed Under: Maximo, MIF, Premium Tagged With: , , ,
About Chon Neth

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

Newer Comments →
  • Will

    Very helpful post. I would be interested in seeing the sample Excel document that you used. Where do I download that?

  • praveen

    Hi,Guys
    I need a help..i have Data in XLS file and iam using maximo 7.1 so i am able to use MEA …but there is no option for importing the XLS files …
    I had also tried to save the xls file to txt format and imported but it is saying that fileheader is not correct …so some one sort out me from this

    WIth Regards & thanks
    Praveen.p
    Maximo

    • http://interprosoft.com Chon

      @Praveen, You should use the interface tables to import data. Map your excel document to the interface table structure, then import the data from excel. Then use MIF to insert records from the interface table into Maximo

  • nivgeo

    what does this error imply to:
    11 Aug 2009 09:12:46:843 [ERROR] Processing failed for MXINVISSUEInterface. The
    object structure is 1. The primary object is null. The key is null.null
    11 Aug 2009 09:12:46:875 [ERROR] BMXAA4214E – An unknown error has occurred.
    Please contact your system administrator for assistance.
    null
    psdi.util.MXSystemException: BMXAA4214E – An unknown error has occurred.
    Please contact your system administrator for assistance.

    trying to load MATUSETRANS record via MIF and i get this error. i never faced in while importinf ASSET, LOCATIONS, ITEM, INVENTORY,INVBALANCES, COMPANIES etc.

    • http://interprosoft.com Chon

      It could be anything from missing values to setting a wrong relationship. I’d have to look at it to give you a better answer.

  • nivgeo

    hi chon,
    i got the thing working. the sendersysid was null. i loaded the inventory record through MIF so the ownersysid was the external sys name. so i had to pass the sendersysid as the external sys name when adding data into the iface table for INVISSUE,so that when MAXIMO checks the inventory it does not pass null MBO set.

  • knitsharp

    Hi
    ” I have tried to insert assets first, then tried to insert and associate asset specs at a later time and wasn’t successful. ” Can you please explain…We are in process of loading assets and assetspec.. Any help would be appreciated..

    • http://interprosoft.com Chon

      If I tried to associate asset specs with an already existing asset that was already classified, it would fail because the asset specs already existed. I think this was due to the fact that the MIF was trying to insert records that already existed when in actuality it should of just updated the values.

  • maximosysana

    Thanks Chon!!!
    We are in process of loading assets and assetspec (new data) we are using max6.2 weblogic8 n sql2005. any suggestions/advise we should consider or known pitfalls ?
    Thank you again in advance for your time.

    • http://interprosoft.com Chon

      I think the same rules apply with Maximo 6 as with 7. There are too many to list, so I guess it’s all just trial and error as with any other import process.

  • livestrong72

    Chon, incredibly helpful post. You saved me many hours of work and, no doubt, frustration. I appreciate this very much.

  • livestrong72

    Chon, one question. In your example Excel file you have a column labeled OBJECT that you mention in your post above. When I create the interface tables I do not see a column by that name. I’m using Maximo 7.1. I’m trying to take this lesson and apply it to FailureCode and FailureList. Can you suggest why that column might be missing?

    • http://interprosoft.com Chon

      That column is a non-persistent column. You have to manually add it to the object structure. You may or may not need that column. I’ve got it working without it.

  • chandu

    I need someone to help me in “How to Import data from excel sheet to MAXIMO”. can any one tell me step by step procedure. ASAP…!!!

    • http://interprosoft.com Chon

      You can’t directly import from excel. You can either use interface tables that import data from excel or you can use CSV files to import directly into Maximo. The CSV needs to follow a certain format to work properly.

  • chandu

    @CHON: Can you please tell me the detail procedure to import excel sheet data into MAXIMO 7.1

    it will be really grateful, i am still learning MAXIMO 7.1

Newer Comments →

Follow Maximo Times

Subscribe to RSS Contact Us Follow Us Linked In Facebook