Thursday 10 April 2014

Import Maximo Classifications using MXCLASSIFICATION Object Structure


Purpose: This technote will explain the procedure to import Classifications using MXCLASSIFICATION Object Structure.

Issue: Many times, I has problem loading classifications along with its hierarchy in Classifications application using MXCLASSIFICATION object structure. Hence, I tried other alternative ways successfully by creating additional fields + Processing rules and importing the classification along with its hierarchy. With this procedure you will not require any additional fields and make use of the standard MXCLASSIFICATION Object Structure.

Applicable To: All versions of Maximo.

Solution
    1. In MXCLASSIFICATION Object Structure, remove the default Inbound     processing class.
    2. In ‘Restrict Attributes’ menu option, In the Source Object List, select   CLASSSTRUCTURE.
    3. Uncheck Restrict checkbox and check Override checkbox for below fields:
a.  Classstructureid
b.  Parent
    4. Select Action > Exclude / Include Fields
    5. In the Source Object List, select CLASSSTRUCTURE
    6. In the Persistant Fields sub-tab, look for HASCHILDREN and UNCHECK the       EXCLUDE checkBox. This will include the field in the schema.
    
    Please note MXCLASSIFICATION Object Structure should support flat file as I am using flat file to import data.

As, I am unable to attach templates with this blog; hence for template, export few classification records from the publish channel using MXCLASSIFICATION object structure and use the same template for importing classifications.

You can use the same template for loading Classstructure, Classusewith & Classspec. In the templates, the value in classstructureid should be the same as classificationid as below. 


1 comment:

  1. Thank you man, this helped me a lot, really.
    I'm an intern at IBM and not even the manager knew how to solve the problem.

    ReplyDelete