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 ...
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 ...
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 ...
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 ...
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 ...
I have already shown in detail how to export data to an XML file but this screencast will show you how to import data using XML flat files. It will also show you how to get the XML file structure for the object you wish to import.
What you will learn:
Export data to XML file
Export data that is formatted correctly (readable)
1. Can MIF look at a file location to automatically load the files.
2. If it can, does this file need any additional tags like headers with authentication, external System info.
1) Yes, you can create a MIF global directory where you can put XML files or flat files and setup a cron task to pick up those files and process them. 2) No, but if you are using XML files, they do need to be formatted correctly.
Hi,
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”. Could you help plealse?
Thanks,
Radhika.
In Message Tracking
the “Publish” operations are “PROCESSED”,
the “Sync” operations remain “RECEIVED”.
And the current maximo base services package version is: 7.1.1.5.
For some reason the export is successful, importing the xml is on hold, with no errors.
Please advise?
Thanks,
Radhika.
Hi,
i imported one flat file to maximo 7 and i got this message
BMXAA5622E – Inbound transaction has been processed successfully to queue
and i cannot find the data in maximo and
in data base..i have already turned on the ‘JMSQSEQCONSUMER’ crontask, with the SEQQIN instance active under
crontask instances..Anything else i have to do
Hi,
Has anyone ever got the Inbound operations processed in 7.1.1.5 ?
for me the Sync, Create operations remain “Received”
While the Publish operations are “Processed” and successful.
Thanks,
Radhika.
But as I understand it, I need this “message driven beans” for processing in the continuous inbound queue.
This one is not enabled in my enterprise service.
So I enabled the continuous inbound queue. Unfortunately it didn’t help…
In the sysout.log I found this message at the moment of importig items:
DEBUG: Control uploadfile could not be found in order to process event loadData ::
Hmm… I’m not sure. So, you modified the ejb-jar.xml file and rebuilt and redeployed the maximo.ear file right? If so, I’m not sure what’s happening. I’d have to look at it to see exactly what’s happening…
Hello Chon!
Basic question I guess… Is there any way to import data from either XML, text delimited flat files, or interface tables with a “custom” source structure?
For example, let say we have a third-party system with “Users”, and we can export those users from that third-party system into specific XML or text-delimited flat file with a specific structure (not the typical Maximo structure)… Is there a way to import that file into Maximo using the MIF, and telling it what tag, field or whatever in the source file should correspond to what field of the maximo object structure ?
All the examples I have seen so far over the web were using the maximo typical structure for xml files, flat files, interface tables… but in a typical real-life case, the source file coming from a third-party system will have a different structure….
Does maximo/MIF have something for this ? Or do we have to build some sort of custom program to transfer the third-party source file into a MIF-recognized file/object structure before importing it with MIF ??
I am afraid that you have to create a file that Maximo can read. Otherwise you would just have to write software as a medium between the two applications. That is how I do it.
Great post, very helpful.
few question though,
1. Can MIF look at a file location to automatically load the files.
2. If it can, does this file need any additional tags like headers with authentication, external System info.
Thanks,
Sridhar
1) Yes, you can create a MIF global directory where you can put XML files or flat files and setup a cron task to pick up those files and process them. 2) No, but if you are using XML files, they do need to be formatted correctly.
Have you ever encountered an issue when you click the export data button. My fields in the data export menu are not bound to database for some reason
I have not. Maybe it’s something you can fix in Application Designer…
I imported the xml from another environment which worked. Great tutorial by the way
Hi,
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”. Could you help plealse?
Thanks,
Radhika.
If it’s not being processed, double check that you have enabled the framework, check out this post…
Hi,
In Message Tracking
the “Publish” operations are “PROCESSED”,
the “Sync” operations remain “RECEIVED”.
And the current maximo base services package version is: 7.1.1.5.
For some reason the export is successful, importing the xml is on hold, with no errors.
Please advise?
Thanks,
Radhika.
hi.
Try to look at the jms queues in your application server, probably is the queue is full.
Hi,
i imported one flat file to maximo 7 and i got this message
BMXAA5622E – Inbound transaction has been processed successfully to queue
and i cannot find the data in maximo and
in data base..i have already turned on the ‘JMSQSEQCONSUMER’ crontask, with the SEQQIN instance active under
crontask instances..Anything else i have to do
Thanks a Lot
Sneha
Please check admin mode from database configuration..if it is on then off it….
Hi,
Has anyone ever got the Inbound operations processed in 7.1.1.5 ?
for me the Sync, Create operations remain “Received”
While the Publish operations are “Processed” and successful.
Thanks,
Radhika.
Hi,
Before i were able to see the crotask JMSQSEQCONSUMER at log file in websphere..But this JMSQSEQCONSUMER is not coming in the log
Hi guys,
I do have the same problem. I’m able to export items as XML or Flat-File, thats OK.
But the import comes only into received status!!!
I tried also the import with IFACE-Table but nothing reached ever my item table.
I need HELP!!!
Thomas
Did you uncomment the necessary lines in the ejb-jar.xml file? If not, have a look here
Good Morning Chon!
Yes they are enabled:
-
-
JMSContQueueProcessor-1
psdi.iface.jms.JMSContQueueProcessor
Container
javax.jms.Queue
-
MESSAGEPROCESSOR
java.lang.String
psdi.iface.jms.QueueToMaximoProcessor
- <!–
MEA MDB for error queue
JMSContQueueProcessor-2
psdi.iface.jms.JMSContQueueProcessor
Container
javax.jms.Queue
MESSAGEPROCESSOR
java.lang.String
psdi.iface.jms.QueueToMaximoProcessor
MDBDELAY
java.lang.Long
30000
–>
But as I understand it, I need this “message driven beans” for processing in the continuous inbound queue.
This one is not enabled in my enterprise service.
Thomas
Yes, you need to enable that.
So I enabled the continuous inbound queue. Unfortunately it didn’t help…
In the sysout.log I found this message at the moment of importig items:
DEBUG: Control uploadfile could not be found in order to process event loadData ::
What “uploadfile” ?
Thomas
Hmm… I’m not sure. So, you modified the ejb-jar.xml file and rebuilt and redeployed the maximo.ear file right? If so, I’m not sure what’s happening. I’d have to look at it to see exactly what’s happening…
Excellent post, very helpful.
I am processing a bif flatfile and Maximo it is processing ok.
During Maximo processing (is very long) I like to know which records and how many records are procesed. How I can get this information?
Best regards,
JP
Hello Chon!
Basic question I guess… Is there any way to import data from either XML, text delimited flat files, or interface tables with a “custom” source structure?
For example, let say we have a third-party system with “Users”, and we can export those users from that third-party system into specific XML or text-delimited flat file with a specific structure (not the typical Maximo structure)… Is there a way to import that file into Maximo using the MIF, and telling it what tag, field or whatever in the source file should correspond to what field of the maximo object structure ?
All the examples I have seen so far over the web were using the maximo typical structure for xml files, flat files, interface tables… but in a typical real-life case, the source file coming from a third-party system will have a different structure….
Does maximo/MIF have something for this ? Or do we have to build some sort of custom program to transfer the third-party source file into a MIF-recognized file/object structure before importing it with MIF ??
Thank you very much!!
Nicolas
I am afraid that you have to create a file that Maximo can read. Otherwise you would just have to write software as a medium between the two applications. That is how I do it.