Question & Answer
Question
How to create and configure an Integration for Item Assembly Structure data load?
Cause
When Maximo / TPAE is being deployed, the user may need to import new Item Assembly Structure for an existing Item record.
This may also be part of an Online Interface, having an External System sending new Item Assembly Structures to Maximo / TPAE.
This may also be part of an Online Interface, having an External System sending new Item Assembly Structures to Maximo / TPAE.
Answer
1. New Object Structure
Go to > Integration > Object Structures > New
Name this Object Structure as you prefer
Add ITEM as the first Source MBO
Add ITEMSTRUCT as child of ITEM, using the CHILDRENITEMSTRUCT relationship
Select Action > Advanced Configuration
In the ITEMSTRUCT row, uncheck the "Exclude Parent Key Attributes?" option > OK
Click Save
Check the "Support Flat Structure" option, so Flatfiles or Interface tables can be used.
Click Save
Select Action > Add Modify Alias
Highlight the ITEMSTRUCT > You will see 3 duplicated attributes that need to be fixed
Add a prefix "IAS_" to ITEMID, ITEMNUM and ITEMSETID. You may set this (IAS_ITEMID, IAS_ITEMNUM and IAS_ITEMSETID).
Click OK
Click Save
2. New Enterprise Service
Go to > Integration > Enterprise Services > New
Name this Service as you prefer
Define the Object Structure created on step 1.
Click Save.
3. Configure the External System
You can create a new External System or use an existing one.
We are going to use EXTSYS1.
Go to > Integration > External System > EXTSYS1
Swap to Enterprise Services Tab
In the lower section, click the New Row button
Define the Enterprise Service defined in the Step 2.
Check the Enabled option
Verify which queue will be used. Continuous or Sequential ?
Click Save.
The MIF is ready to import new Item Assembly Structures.
Attached is a sample CSV file. ( Using MAXDEMO Database)
Go to > Integration > Object Structures > New
Name this Object Structure as you prefer
Add ITEM as the first Source MBO
Add ITEMSTRUCT as child of ITEM, using the CHILDRENITEMSTRUCT relationship
Select Action > Advanced Configuration
In the ITEMSTRUCT row, uncheck the "Exclude Parent Key Attributes?" option > OK
Click Save
Check the "Support Flat Structure" option, so Flatfiles or Interface tables can be used.
Click Save
Select Action > Add Modify Alias
Highlight the ITEMSTRUCT > You will see 3 duplicated attributes that need to be fixed
Add a prefix "IAS_" to ITEMID, ITEMNUM and ITEMSETID. You may set this (IAS_ITEMID, IAS_ITEMNUM and IAS_ITEMSETID).
Click OK
Click Save
2. New Enterprise Service
Go to > Integration > Enterprise Services > New
Name this Service as you prefer
Define the Object Structure created on step 1.
Click Save.
3. Configure the External System
You can create a new External System or use an existing one.
We are going to use EXTSYS1.
Go to > Integration > External System > EXTSYS1
Swap to Enterprise Services Tab
In the lower section, click the New Row button
Define the Enterprise Service defined in the Step 2.
Check the Enabled option
Verify which queue will be used. Continuous or Sequential ?
Click Save.
The MIF is ready to import new Item Assembly Structures.
Attached is a sample CSV file. ( Using MAXDEMO Database)
[{"Product":{"code":"SSLKT6","label":"IBM Maximo Asset Management"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"MEA: Generic","Platform":[{"code":"PF025","label":"Platform Independent"},{"code":"PF027","label":"Solaris"}],"Version":"7.1;7.1.1;7.5;7.6","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]
Was this topic helpful?
Document Information
More support for:
IBM Maximo Asset Management
Software version:
7.1, 7.1.1, 7.5, 7.6
Operating system(s):
Solaris
Document number:
510181
Modified date:
09 July 2020
UID
swg21673284
Manage My Notification Subscriptions