Maximo Tips & Tricks
Screencast: Import data with XML flat files
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)
- Import data with XML flat file
...
For more, Please login or register for FREE!
Tags: Maximo, Maximo 71, Integration Framework, MIF, Import XML






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
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…