Bulk Loading Telephone Number Details

<< Click to Display Table of Contents >>

Navigation:  IMS version 22.6 & 22.9 > IMS Basics - User Guide 22.6 & 22.9 > Telephone Number Management (TNM) >

Bulk Loading Telephone Number Details

As we can imagine, adding new, modifying existing, or deleting data in TNM is not a desirable activity if there are dozens or hundreds of TNM records that need to be addressed. For that reason, in IMS there is a Bulk Loader tool that facilitates loading bulk data at speed. By using column names representing database fields, and SQL instructions like ADD, UPDATE, and DELETE, we can maximize data processing in far less time.

 

The following is a list of the main database fields that are needed in the process of bulk loading the Telephone Numbers of a given Range:

 

 

Rownum

Action

Entity

Id

TelephoneNumberRangeId

TelephoneNr

TelephoneNumberStatusId

PortedToId

ProjectStatusId

NiceNumber

CustomerId

OrderId

OrderId

ExpireDate