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

Import data with Maximo Integration Framework (MIF)

March 25, 2009 by 100 Comments
This entry is part 1 of 14 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

I am a Senior Consultant/Software Engineer and co-lead developer of EZMaxMobile at InterPro Solutions, LLC

← Older Comments
Newer Comments →
  • rad

    I have uncommented the MEA MDB comments in the ejb-jar.xml.

    Now I get the error:
    SRVE0255E: A WebGroup/Virtual Host to handle /maximo has not been defined.
    Are there any other settings I should change to get the continuous queue working?
    Thanks,
    Radhika.

  • rad

    Hi,
    Could you tell me if I need a cron task setup for continuous queue?
    What are the parameters?
    Thanks,
    Radhika.

  • David

    This line to insert into IFACEASSET should be

    NULL,’MAIN’,'AUSTIN’,1,1,0,’OPERATING’,NULL,NULL,NULL,

    Instead of

    NULL,’MAIN’,'AUSTIN’,’1′,’1′,’0′,’OPERATING’,NULL,NULL,NULL,

    These are type mismatches

  • gawish_fci

    Hi,
    I have to made integration using interface table but their is somthing missing
    - i hav to make integration for company master table with MS ACCESS
    - I have created adatbase .mdb
    - i have added an ODBC DSN for MS ACCESS for the database i have created
    - the create the object structure that support flat file
    - the create the end point with the following configuration
    handler IFACTABLE
    Driver sun.jdbc.odbc.jdbcodbcdriver
    URL jdbc:odbc:
    - then create publish channel
    - then the external system and create the interface table from it
    - the activate the cron task and put to it the required parameters
    *** every thing is running well that when i add record in company master it transferred to the interface table thet i have created, but i want data that have been transferred to the interface table to be transferred to the MS ACCESS database that i have created that doesn’t happen till now ***
    if any one can support me i apprciate his effort
    thanks and best regards

  • Janhavi

    how we can import data through xml file. please provide sample xml file if possible

    • Janhavi

      i saw screencast for xml file import
      thank you

  • jamojo

    Hi,

    I followed the procedure for the loading asset. I was not able to insert records in Asset table. Can you please interpret this log?

    24 Feb 2010 21:03:10:615 [DEBUG] schemauseinclude==true
    24 Feb 2010 21:03:10:615 [DEBUG] schemauseinclude==true
    24 Feb 2010 21:03:10:616 [DEBUG] 1 openTagsList size 0
    24 Feb 2010 21:03:10:616 [DEBUG] 1 openTagsList size 0
    24 Feb 2010 21:03:10:616 [DEBUG] ASSET closing open tags for parent count===0
    24 Feb 2010 21:03:10:616 [DEBUG] ASSET closing open tags for parent count===0
    24 Feb 2010 21:03:10:616 [DEBUG] ASSETMETER level doesnt exist 1
    24 Feb 2010 21:03:10:616 [DEBUG] ASSETMETER level doesnt exist 1
    24 Feb 2010 21:03:10:616 [DEBUG] ASSETUSERCUST level doesnt exist 1
    24 Feb 2010 21:03:10:616 [DEBUG] ASSETUSERCUST level doesnt exist 1
    24 Feb 2010 21:03:10:617 [DEBUG] ASSETSPEC level doesnt exist 1
    24 Feb 2010 21:03:10:617 [DEBUG] ASSETSPEC level doesnt exist 1

    Thanks

    • http://interprosoft.com Chon

      It is saying the the object structure is missing an ASSETSPEC object

  • jamojo

    Is this means that I am missing values to the required columns of ASSETMETER,ASSETUSERCUST and ASSETSPEC?

    Is Maximo 7 produces too MXINTSQINFILE000000.DAT in the jmsstore, so I can delete this file to clear the queue again?

    Thanks very much

    • http://interprosoft.com Chon

      Yes and yes.

      • jamojo

        Thanks for the reply.

        I tried to search the MXINTSQINFILE000000.DAT file in /opt/IBM/WebSphere/AppServer in Linux. Where I can find this file? Or it has a different filename. In Maximo6/BEA for example, I can see the DAT file in C:\bea\jmsstore

  • faiz

    how can i import our lockout/tagout information in planning module and what is the exact procedure to get the information in these two subfield 1.Outbound Definition Class and 2.Inbound Processing Class in object strucure.
    help me out to collect that info.
    10q in adv

    • http://interprosoft.com Chon

      You can create your own object structure to do that and just leave the outbound and inbound processing class fields empty.

  • mikejh

    I followed your instructions and loaded the assets I had in my queue, but the status remained ‘NOT READY’ and not ‘OPERATING’ as I indicated like you said in the MXASSET_IFACE. Any ideas?
    Thanks,

    • http://interprosoft.com Chon

      If the assets are already imported into the database, you can try this

      • mikejh

        The Maximo 7 MIF does not allow for the status of Assets with the MXASSET object when the ASSETMETER object is included in the object. Thus if you need to associate a Meter to the Asset, you must create the asset with the Meter, then utilize a separate object and update the status. Another means of doing this would be to create an Escalation associated to the creation process that changes the status of the asset to the desired status.

        • http://interprosoft.com Chon

          What I did was unrestrict the STATUS attribute on the ASSET object.

  • bpscotty

    I ran the INSERT INTO MXIN_INTER_TRANS (TRANSID,EXTSYSNAME,IFACENAME)
    VALUES (1,’EXTIMPORT’,'MXASSETInterface’) query but get the following error in ImpotantMessage column in MX_INTER_TRANS table

    BMXAA5861E – Mandatory keys are missing – unable to create xml from flat structure.
    psdi.util.MXApplicationException: BMXAA5861E – Mandatory keys are missing – unable to create xml from flat structure.
    at psdi.iface.intertables.FlatToXMLConverter.prepareObjectXML(FlatToXMLConverter.java:288)

    I am using TAMIT/CCMDB/TSRM 7.2 with mbs 7.1.1.5 HF.

    do i need to exlude/include fields in the Object structure?

    • http://interprosoft.com Chon

      You can if you want, but I am assuming that you may need to include some mandatory fields such as SiteID and OrgID.

      • bpscotty

        I am trying to do your tutorial to get used to the MIF and importing asset data as I will soon need to import a large Asset register (which is a multisheet MS Excel spreadsheet)into the assets application of TAMIT.
        I am keen to know what fields are needed as a minimum to go into the interface table which will then be cron’d into the actual Asset app.

        Is it correct to think that I should use an existing SITEID and OrgID in place of your example?

        TAMIT 7.2 Asset app has budgeted cost and replacement cost as well as Purchase price with a * next to them – does this mean any import must have a value for these fields?

        if i had a csv file that I want to do a one of bulk data load into the Asset app what is the best way of going about this?

        your help is greatly appreciated

      • bpscotty

        I have it working now! I put in correct values sor site, org plus the additional cost values and then had to redo most of tutorial as well as reloading the jms cron.

        now on to the next stage!!

        Thanks Chon

        Brian S

← Older Comments
Newer Comments →

Follow Maximo Times

Subscribe to RSS Contact Us Follow Us Linked In Facebook