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.
Is that kind of thing possible in MxLoader?
IBM is currently looking into implementing the same sort of thing
via Application Import. But using MxLoader for this would be even better.
Thanks.
------------------------------
User 1972
------------------------------