Maximo Tips & Tricks
Featured Solutions
EZMaxMobile - Maximo Mobile Integration
Screen shots (click to enlarge & click image to close): [nggallery id=4] Real Time Maximo Mobile Connectivity InterPro Solutions’ has developed a mobile integration framework that provides real time connectivity to Maximo via WiFi or 3G connectivity. Devices such as iPhone, iPad, iTouch, Android, BlackBerry, etc. are now capable of logging into and ...
EZDash - Custom Maximo Dashboard
A web based dashboard that seamlessly interacts with your Maximo maintenance management system. EZDash provides real time interactive graphs and charts for use by staff to monitor and manage work processes, inventory, labor hours, PM schedules, etc. EZDash is easily configured to display a wide range of key performance metrics ...
EZEnergyDash - Custom Maximo Energy Dashboard
A web based dashboard that seamlessly interacts with your Maximo maintenance management system. EZEnergyDash provides real time interactive graphs and charts for use by staff to monitor and manage and view energy consumption. EZEnergyDash is easily configured to display a wide range of key performance metrics relevant to what’s important ...
WebMaint - Customer Service Request Module
This web-based add-on to IBM’s Maximo application system provides customers with a simple way to enter service requests and view their previously entered service tickets. Customers can enter requests without having to be a registered Maximo user, therefore eliminating the need for a user to register or be registered in ...
WebAssign - Workorder Assignment & Scheduling
This web-based add-on to IBM Maximo application provides supervisors and managers with the ability to assign work orders to specific staff as well as track the status of those work orders. Work orders can be assigned on an individual basis or by groups - it as easy as a "point ...Import data with Maximo Integration Framework (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.
...
For more, Please login or register for FREE!
Tags: Maximo 7, Integration Framework, MIF
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.
Hi,
Could you tell me if I need a cron task setup for continuous queue?
What are the parameters?
Thanks,
Radhika.
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
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
how we can import data through xml file. please provide sample xml file if possible
i saw screencast for xml file import
thank you
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
It is saying the the object structure is missing an ASSETSPEC object
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
Yes and yes.
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
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
You can create your own object structure to do that and just leave the outbound and inbound processing class fields empty.
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,
If the assets are already imported into the database, you can try this
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.
What I did was unrestrict the STATUS attribute on the ASSET object.
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?
You can if you want, but I am assuming that you may need to include some mandatory fields such as SiteID and OrgID.
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
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