Importing Item Assembly Structure through Application Import in Item Application

Step 1: Create an Object Structure

Parent : ITEM

Child : ITEMSTRUCT

Relationship : CHILDRENITEMSTRUCT

Step 2: Make sure to change the Alias of ITEMSTRUCT.ITEMID to C_ITEMID and check the support flat file Structure check box.

Step 3: Create a csv file with the following fields.

Step 4: Import that csv through application import in Item application. The Item has been successfully imported.

Step 5: What !!!!!!! The item has been imported but the item structure has not been imported.

Step 6: Query the ITEMSTRUCT table to see the ITEMID field. The fields are totally wrong. Maximo has added the values by itself. This can be handled by updating the ITEMID field in DB. So the smart way is to alter the Object structure.

Step 7:  Go to the Object structure and click Inbound Setting Restrictions.

Step 8: Click on the Override Check box and uncheck Restricted check box. So what happens is, Maximo will look at the Override check box and allow the value that is present in flat file. 

Step 9: Import the flat file again. Voilà! The item structure has been imported.

Step 10: Also confirmed this by querying the DB