Topic
  • 2 replies
  • Latest Post - ‏2013-05-09T11:58:11Z by Chris_in_NY
Chris_in_NY
Chris_in_NY
54 Posts

Pinned topic mif import of item master from flat file xml error

‏2013-05-08T22:48:20Z |

We are using the MIF to import item master data from a flat file. I think the xml being generated is not correctly formated and is causing an error.

Below is the xml being generated. Note the conditioncode tag in red does not have a matching starting tag, which I think is causing the error.

Anyone run into this and resolve it ?

 

Also we are a new implementation, and our consultants are having us use the MIF. This is painfull to use. Have others used straight sql to load their data and did you encounter issues ?

 

Thanks so much.

 

 

 

 

I am trying to import item master recs with the mif using a 
flat file.
 
I think the xml being generated by the mif is not in good format and is
causing the error.
 
Here is the xml being generated for one record:
Note the part in red. It only has the end tag, not the start tag.
I tried editing the xml and putting a <CONDITIONCODE> tag right
before it, but I got an unknown system error when it tried to reprocess it.
 
Ideas ?
 
 
<?xml version="1.0" encoding="UTF-8"?>
<ERROR>
  <ERRORMESSAGE>The following error occurred while processing ITEM. The object structure number is 1.BMXAA4195E - The Condition Code field requires a value.</ERRORMESSAGE>
  <ER>
    <SyncBU_MXITEM xmlns="http://www.ibm.com/ maximo" xmlns:xsi="http://www.w3.org/ 2001/XMLSchema-instance" creationDateTime="2013-05- 08T18:38:52-04:00" transLanguage="EN" baseLanguage="EN" messageID=" 1368052733668418268">
      <BU_MXITEMSet>
        <ITEM action="">
          <CONDITIONENABLED>0</ CONDITIONENABLED>
          <DESCRIPTION>ANCHOR, VINYL WHITE 4-6 X 1%, 100/BAG, #50981</DESCRIPTION>
          <ISSUEUNIT>EA</ISSUEUNIT>
          <ITEMNUM>02002001</ITEMNUM>
          <ITEMSETID>ITEMSET1</ ITEMSETID>
          <ITEMTYPE>ITEM</ITEMTYPE>
          <ITEM_DESCRIPTION>ANCHOR, VINYL WHITE 4-6 X 1%, 100/BAG, #50981</ITEM_DESCRIPTION>
          <LOTTYPE>NOLOT</LOTTYPE>
          <ORDERUNIT>EA</ORDERUNIT>
          <STATUS>ACTIVE</STATUS>
          <STATUSDATE>2013-05-08</ STATUSDATE>
          <ITEMCONDITION>
            <CONDITIONCODE />
            <DESCRIPTION>ANCHOR, VINYL WHITE 4-6 X 1%, 100/BAG, #50981</DESCRIPTION>
            <STOCKTYPE>STK</STOCKTYPE>
          </ITEMCONDITION>
        </ITEM>
      </BU_MXITEMSet>
    </SyncBU_MXITEM>
  </ER>
  <IR>
    <SyncBU_MXITEM xmlns="http://www.ibm.com/ maximo" xmlns:xsi="http://www.w3.org/ 2001/XMLSchema-instance" creationDateTime="2013-05- 08T18:38:52-04:00" transLanguage="EN" baseLanguage="EN" messageID=" 1368052733668418268">
      <BU_MXITEMSet>
        <ITEM action="">
          <CONDITIONENABLED>0</ CONDITIONENABLED>
          <DESCRIPTION>ANCHOR, VINYL WHITE 4-6 X 1%, 100/BAG, #50981</DESCRIPTION>
          <ISSUEUNIT>EA</ISSUEUNIT>
          <ITEMNUM>02002001</ITEMNUM>
          <ITEMSETID>ITEMSET1</ ITEMSETID>
          <ITEMTYPE>ITEM</ITEMTYPE>
          <ITEM_DESCRIPTION>ANCHOR, VINYL WHITE 4-6 X 1%, 100/BAG, #50981</ITEM_DESCRIPTION>
          <LOTTYPE>NOLOT</LOTTYPE>
          <ORDERUNIT>EA</ORDERUNIT>
          <STATUS>ACTIVE</STATUS>
          <STATUSDATE>2013-05-08</ STATUSDATE>
          <ITEMCONDITION>
            <CONDITIONCODE />
            <DESCRIPTION>ANCHOR, VINYL WHITE 4-6 X 1%, 100/BAG, #50981</DESCRIPTION>
            <STOCKTYPE>STK</STOCKTYPE>
            <ITEMNUM>02002001</ITEMNUM>
            <ITEMSETID>ITEMSET1</ ITEMSETID>
          </ITEMCONDITION>
        </ITEM>
      </BU_MXITEMSet>
    </SyncBU_MXITEM>
  </IR>
</ERROR>

 

  • robert_v
    robert_v
    1 Post

    Re: mif import of item master from flat file xml error

    ‏2013-05-09T10:29:25Z  

    Why do you have the same description for ITEM and also for ITEMCONDITION?

    Tag CODITIONCODE is correctly closed (xml implicit closure), but a value for this field is required if you specify an ITEMCONDITION record. If you don't want CONTIONCODE record, remove the data of ITEMCONDITION section.

    Regards.

  • Chris_in_NY
    Chris_in_NY
    54 Posts

    Re: mif import of item master from flat file xml error

    ‏2013-05-09T11:58:11Z  
    • robert_v
    • ‏2013-05-09T10:29:25Z

    Why do you have the same description for ITEM and also for ITEMCONDITION?

    Tag CODITIONCODE is correctly closed (xml implicit closure), but a value for this field is required if you specify an ITEMCONDITION record. If you don't want CONTIONCODE record, remove the data of ITEMCONDITION section.

    Regards.

    Thanks for the help. 

    We do not have conditiions, so I removed it all, and it worked.