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
No comments:
Post a Comment