Bulk loader version 2

<< Click to Display Table of Contents >>

Navigation:  Bulkloaders >

Bulk loader version 2

New features:

Extra fields can be used in the normal entity (just add the label text of the Extrafieldgroup in the header of the bulk loader properties)

Dynamic entities are supported.

 

 

New ways to find the record that needs to be updated.

 

There are multiple ways a bulk loader can find the entity in the database to update or delete:

 

Use the ID field        

oThe record ID                                                        (Example ID:1234)

owhen the entity has a unique property (f.i. Name)                        (Example GBLON0001)

oto find the entity based on 1 of the properties of the entity        (Example Name:GBLON0001)

oto find the entity based on multiple properties of the entity        (Example Node.Name:GBLON0001,Shelf.Name:SHELF-01, Name:1/1/1)

Don’t use the ID field

obut the unique property of the entity

obut the multi-unique property of the entity

 

Example 1:

clip0602

 

Example 2:

clip0603

 

 

Example 3:

clip0604

 

 

Example 4:

clip0605

 

All above examples are to find/update an existing object in IMS or to delete an existing object in IMS, to create objects this ID field cannot be used of course as the object not yet exists and thus has no ID.

 

The options when not using the ID field are the regular Bulk loader options as described in the previous chapter(s).

 

To enable the Bulk loader version 2 a setting has to be implemented in the user settings via the following bulk loader command:

 

Rownum        Action        Entity                UserId        SettingName        Setting

1                Add        UserSetting        CLIENT                        BULKLOADER_VERSION 2