IBM Support

How to import data into Manage using csv file

How To


Summary

Use Enterprise Service from External Systems application to import a csv file

Steps

1) Go to MXASSET Object Structure in Object Structures application

Select "Configure Object Structure Security"

Enable “Use Object Structure For Authorization”

Click OK
 

image-20230607205002-1

2) Go to Security Groups application, and select applications tab

Go to the Object Structures tab

Grant access to MXASSET object structure

Save the record

3) Go to External Systems application

Select Enterprise Services tab

Filter for MXASSETINTERFACE Enterprise Service

Click Action > Data Import

Import a csv file. 

Example:

EXTSYS1,MXASSETInterface,,EN
ASSETNUM,AS_SITEID
TEST2,BEDFORD

Click "Import preview" to check error

BMXAA5621I - The data import preview mode is successful.

Import again without checking “import Preview”. 

A system message shows that the transaction is successful if the import file does not have any error.

image-20230607205206-2

Go to Assets application.  Asset "TEST2" is imported

image-20230607205231-3

Related Information

Document Location

Worldwide

[{"Type":"MASTER","Line of Business":{"code":"LOB59","label":"Sustainability Software"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSRHPA","label":"IBM Maximo Application Suite"},"ARM Category":[{"code":"a8m50000000CbH7AAK","label":"Integration-\u003EMaximo Enterprise Adapters-\u003EFramework"}],"ARM Case Number":"TS011484498","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Versions"}]

Document Information

Modified date:
07 June 2023

UID

ibm17001825