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