Exercise 1 - Add Customer Data

<< Click to Display Table of Contents >>

Navigation:  IMS version 21.9 > IMS Basics - User Guide  > Bulk Loader >

Exercise 1 - Add Customer Data

 

Open the Bulkloader form.

 

 

▪

Select the Customer template from the Entities dropdown field

▪

Click on the Generate excel template icon

 

 

04GenerateTemplate

▪

Open up the excel file once generated which will be located in the lower left corner of the Bulkloader form

▪

Fill on the following information in the spreadsheet

 


 


Rownum

1 – 5


Action

ADD [in all five rows]


Entity

CUSTOMER [in all five rows]


Id

[leave blank]


Name

CUST1.X – CUST5.X [in all five rows]


Full Name

CUSTOMER 1.X – CUSTOMER 5.X (5 rows)

 

 

Copy rows 2 through 7 - exclude row 1

 

02SpreadsheetCust

 

▪

Paste the copied data into the bulk loader screen of IMS and click on the execute button in the lower right of the screen.

 

 

03LoadTheData

 

 

 

▪

Once loaded you should receive a Success confirmation

 

If any issues are encountered during loading, then a Failed message will show giving a clue to the problem i.e., object already exists, or invalid action (missing ADD in the Action column), etc.

 

 

06Output