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
Newer Comments →
  • mmd

    Hello Chon,

    Found solution to the problem(“Stop and Restart Websphere app Server” with the problem of: “BMXAA1331E – The user name supplied is not authorized to perform this operation.”

    We were trying to look at system log(Systemout.log)files located in three different locations for the Application server on a Windows 2003 System using

    WebSphere \ibm\WebSphere\AppServer\profiles\ctgAppSrv01\logs\MXServer

    \ibm\WebSphere\AppServer\profiles\ctgDmgr01\logs\dmgr

    \ibm\WebSphere\AppServer\profiles\ctgAppSrv01\logs\nodeagent

    To look at the log file from the most recent issue, we have to delete them by 1)stopping websphere app server, 2) delete the log files, 3)restart websphere, 4) reexecute the script for input to replicate error issue.

    Turns out by stopping and starting the Websphere application server to try to get a fresh log file solved the problem, probably the Site assignment of MXINTADM was not set Websphere application until the app server gets restarted?

    Thank you for you help.

    Right now it has seemed to fix that problem I am sure many more to come.

    By the way, do you know anything about the JMSQUE? does it take a long time if wrong data is inputted? cause when we try to do an input script and accidentally put wrong value for default site, the Message Reprocessing took about 40 min to 1 hour to send the error message even after the data was cleared from MXintranstables, the data was no where to be found and didn’t get any error message until 40min – 1 hour later. We found the error with the input script of wrong value for Site fixed it, and the corrected script execution only executed after the 40min – 1 hr delay after the Message Reprocessing error was cleared.
    Any Idea what is causing the lag?

    • http://interprosoft.com Chon

      Good to hear that you got it working. Yeah, when you set the default site of the MXINTADM user, you do need to restart the app server for it take affect in regards to the integration framework. As for the lag, just because you stopped and restarted the app server, the messages in the queue might still be there, that is why the processing took so long. If I have a message that might be hung in the queue, I usually delete the appropriate directory for you maximo application under: C:\Program Files\IBM\WebSphere\AppServer\profiles\ctgAppSrv01\filestores\com.ibm.ws.sib

  • sg

    I am trying to import data into SQL2005 table IFACEASSET via MS SSIS impirt excel and get the following error

    Error at Data Flow Task [Destination - ifaceasset [647]]: Column “as_description_ld” cannot convert between unicode and non-unicode string data types.

    Error at Data Flow Task [DTS.Pipeline]: “component “Destination – ifaceasset” (647)” failed validation and returned validation status “VS_ISBROKEN”.

    Error at Data Flow Task [DTS.Pipeline]: One or more component failed validation.

    Error at Data Flow Task: There were errors during task validation.

    It looks like it does not like the data type of CBLOB

    Do you have any ideas why this is happening

    Thanks in advance

    • http://interprosoft.com Chon

      This is a SQL server issue and it’s due to the fact that the long description field is an ntext field and if you try to import it from excel you will get this error. If you google it then you should be able to find a way around it.

  • sg

    Thank you for your help

  • Zee

    Chon, I am starting to import Max4 data into my Max7 environment. I have couple of questions:

    1- In order to import data, why are you using Interface Tables instead of just importing from csv or xml files. Is there a special reason? Can’t we just get output of a table data into xls, manipulate it and then save it as csv and then import that directly into Maximo.

    2- I tried to see you other post regarding Asset and Specs for asset. What did you base your xls file on? I mean what was the reason of putting two tables into ONE xls? whay not two separate xls files?

    • http://interprosoft.com Chon

      You don’t have to use iface tables, you could use csv or xml if you are more comfortable with that. XML is actually faster because the data in the iface tables is actually converted to xml before any kind of import, but I just prefer to use iface tables because it’s easier to manipulate data.

      The two tables are actually two different objects are held in one object structure. That is needed in order to import assets and specs. I had trouble importing specs after I imported the assets, so I decided to put them together to see if that worked and it did.

  • Zee

    Thank you so much. By the way just going over your posts it saved all of us huge amount of time. It is because your posts are really detailed.

    My new questions are:

    1- how do u import xls into interface table.
    2- I am starting with importing gls… then Locations followed by assets. Do you by any chance have a sample post/tutorial that shows the sample xls (the way you had for assets and specs) for locations as it does have alot of tables like lochierarchy which are not in object structure. So I am a little confused how those will be populated.

    Thanks again.

  • hicham

    hello, I am initial in Maximo 7.1, and I must import data from a Access data base, if you know how can i do that, please help me

    • http://interprosoft.com Chon

      Have a look at this google search….

  • Radhika

    About Object Structure above,
    it is said:
    Also verify that no conflicts exist because of duplicate by selecting ‘Add/Modify Alias’ from Select Action dropdown.
    However,
    there is no checkbox to select, the available “duplicate” check box is readonly. Could you kindly clarify this?
    Thanks,
    Radhika.

    • http://interprosoft.com Chon

      Yes, the check box is read only. This is just to notify you that the aliasname property is a duplicate. All you need to do is change the aliasname to another value and click OK. Then the duplicate check box will clear.

      • rad

        Thank you for the reply.
        I am trying to import from an xml file into Person records. There seems to be no problem with the xml format. The “Data Import” says that “Inbound transaction has been processed successfully to queue”.
        But the record doesn’t appear in the person records. However, the current status in Message Tracking is “Received”. It is never going into “Processed”.
        Also in the log it shows “Control upload file could not be found in order to process event loadData”. Could you please help?
        Thanks,
        Radhika.

        • http://interprosoft.com Chon

          If it’s not being processed, double check that you have enabled the framework, check out this post…

  • Sneha

    Can you please help me to load locations in maximo

    When i tried to upload location without system and parent,it was loaded,but how can i associate the location with system and paarents?…

    • http://interprosoft.com Chon

      You have to include the non-persistent fields: HASPARENT, PARENT, SYSTEMID

    • Andrej

      You have to have exactly one top-level location (no parent) in your system, all other locations must be descendants of this location either directly or indirectly. I strongly advise to first load locations in a dummy table, then to sort them by hierarchy, export like that and then try loading.

  • rad

    Hi,
    I trying to import person records throguh xml import. The sequential queue works and I am able to see the new records in the database.
    But, the people/person application does not open up in maximo. When I select a personid from the list, the application hangs, without opening the person app.
    How do I resolve this?
    thanks,
    Radhika.

    • http://interprosoft.com Chon

      Not sure, this seems like an application issue as opposed to an integration issue. Double check your indexes in the person table.

  • rad

    Hi,
    The sequential queue works for me.
    I am able to see the new records in the database. However, when I select the “continuous queue” option in the enterprise service. The messages remain in “RECEIVED” status. But those in sequential queue get processed successfully.
    One more thing, I did not uncomment the comments to Mea MDB in the ejb-jar.xml.

    The sequential queue is working without ejb-jar.xml updates (to Mea Mdb beans).
    Any suggestions as to how I can make the continuous queue work?

    Thanks,
    Radhika.

    • http://interprosoft.com Chon

      Try uncommenting the comments in the ejb-jar.xml.

    • rad

      Hi,
      The sequential queue works for me.
      I am able to see the new records in the database. However, when I select the “continuous queue” option in the enterprise service. The messages remain in “RECEIVED” status. But those in sequential queue get processed successfully.
      One more thing, I did not uncomment the comments to Mea MDB in the ejb-jar.xml.

      The sequential queue is working without ejb-jar.xml updates (to Mea Mdb beans).
      Any suggestions as to how I can make the continuous queue work?

      Also, in the ejb-jar.xml the <!– MEA MDB is commented out.
      Inspite of that, sequential import works.
      Does uncommenting the MEA MDB in the ejb-jar.xml (ibm-ejb-jar-bnd.xmi, weblogic-ejb-jar.xml) help? Are there any other changes I need to make to get continuous queue working?

      Thanks,
      Radhika.

← Older Comments
Newer Comments →

Follow Maximo Times

Subscribe to RSS Contact Us Follow Us Linked In Facebook