MxLoader

Loading classifications into Maximo is a difficult process -- due to the various related tables that are involved.

Is there a way to do the following with MxLoader to help simplify the process?

• Load a single classification row, and include a single flattened USEWITH field (comma-delimited).

• An example of a value in the USEWITH column would be:
  'SR, WOACTIVITY, WORKORDER'

• MxLoader would need to be capable of parsing and un-pivoting the USEWITH field into multiple USEWITH rows (vertical rows).

If parsing comma-delimited values is too difficult, then the following might be an alternative:

• The user could put the USEWITH values in separate columns (not rows).

• Example:

• CLASSSTRUCTUREID    USEWITH 1    USEWITH 2    USEWITH 3
  ----------------    ---------    ---------    ---------
              1234    SR           WOACTIVITY   WORKORDER

• Maximo would un-pivot the columns into rows when loading the data.
  
  

Loading classifications into Maximo is a difficult process -- due to the various related tables that are involved.

Is there a way to do the following with MxLoader to help simplify the process?

• Load a single classification row, and include a single flattened USEWITH field (comma-delimited).

• An example of a value in the USEWITH column would be:
  'SR, WOACTIVITY, WORKORDER'

• MxLoader would need to be capable of parsing and un-pivoting the USEWITH field into multiple USEWITH rows (vertical rows).

If parsing comma-delimited values is too difficult, then the following might be an alternative:

• The user could put the USEWITH values in separate columns (not rows).

• Example:

• CLASSSTRUCTUREID    USEWITH 1    USEWITH 2    USEWITH 3
  ----------------    ---------    ---------    ---------
              1234    SR           WOACTIVITY   WORKORDER

• Maximo would un-pivot the columns into rows when loading the data.
  
  

Loading classifications into Maximo is a difficult process -- due to the various related tables that are involved.

Is there a way to do the following with MxLoader to help simplify the process?

• Load a single classification row, and include a single flattened USEWITH field (comma-delimited).

• An example of a value in the USEWITH column would be:
  'SR, WOACTIVITY, WORKORDER'

• MxLoader would need to be capable of parsing and un-pivoting the USEWITH field into multiple USEWITH rows (vertical rows).

If parsing comma-delimited values is too difficult, then the following might be an alternative:

• The user could put the USEWITH values in separate columns (not rows).

• Example:

• CLASSSTRUCTUREID    USEWITH 1    USEWITH 2    USEWITH 3
  ----------------    ---------    ---------    ---------
              1234    SR           WOACTIVITY   WORKORDER

• Maximo would un-pivot the columns into rows when loading the data.
  
  

Loading classifications into Maximo is a difficult process -- due to the various related tables that are involved.

Is there a way to do the following with MxLoader to help simplify the process?

• Load a single classification row, and include a single flattened USEWITH field (comma-delimited).

• An example of a value in the USEWITH column would be:
  'SR, WOACTIVITY, WORKORDER'

• MxLoader would need to be capable of parsing and un-pivoting the USEWITH field into multiple USEWITH rows (vertical rows).

If parsing comma-delimited values is too difficult, then the following might be an alternative:

• The user could put the USEWITH values in separate columns (not rows).

• Example:

• CLASSSTRUCTUREID    USEWITH 1    USEWITH 2    USEWITH 3
  ----------------    ---------    ---------    ---------
              1234    SR           WOACTIVITY   WORKORDER

• Maximo would un-pivot the columns into rows when loading the data.
  
  

Loading classifications into Maximo is a difficult process -- due to the various related tables that are involved.

Is there a way to do the following with MxLoader to help simplify the process?

• Load a single classification row, and include a single flattened USEWITH field (comma-delimited).

• An example of a value in the USEWITH column would be:
  'SR, WOACTIVITY, WORKORDER'

• MxLoader would need to be capable of parsing and un-pivoting the USEWITH field into multiple USEWITH rows (vertical rows).

If parsing comma-delimited values is too difficult, then the following might be an alternative:

• The user could put the USEWITH values in separate columns (not rows).

• Example:

• CLASSSTRUCTUREID    USEWITH 1    USEWITH 2    USEWITH 3
  ----------------    ---------    ---------    ---------
              1234    SR           WOACTIVITY   WORKORDER

• Maximo would un-pivot the columns into rows when loading the data.