Routines for dutl_gl.kb


CopyInventoryValuesToExternalMap

File Name

dutl_gl.kb

Syntax

PROCEDURE CopyValuesToExternalMap( REF externalMap: ExternalMapRec, VAL applicationName: STRING, VAL sql_cfg_name: STRING, VAL scan_time: STRING, VAL externalMapID: STRING, VAL externalID_2: STRING, VAL externalID_3: STRING, VAL externalID_4: STRING, VAL externalID_5: STRING, VAL externalID_6: STRING, VAL externalID_7: STRING, VAL externalID_8: STRING, VAL externalID_9: STRING, VAL externalID_10: STRING, VAL is_inventory_id: INTEGER, VAL people_id: INTEGER, VAL location_id: STRING )

Parameters

EXT_APP_NAME - TivAppName

SQL_CFG_NAME - dbsource is passed in from tiv_mig

Parameter Mapping For Tivoli

EXT_ID_1 - exteralMapID (Inventory)

EXT_ID_2 - hardwareSysID

EXT_ID_3 - tme_object_id

EXT_ID_4 - tme_object_label

EXT_ID_5 - migrationRelease

EXT_ID_6 - $unknown

EXT_ID_7 - $unknown

EXT_ID_8 - $unknown

EXT_ID_9 - $unknown

EXT_ID_10 - $unknown

IS_INVENTORY_ID - is_inventory.is_inventory_id (TAM table)

EXT_ID_1 - externalMapID (Location)

EXT_ID_2 - tiv table location.location_id

EXT_ID_3 - migrationRelease

EXT_ID_4 - $unknown

EXT_ID_5 - $unknown

EXT_ID_6 - $unknown

EXT_ID_7 - $unknown

EXT_ID_8 - $unknown

EXT_ID_9 - $unknown

EXT_ID_10 - $unknown

LOCATION_ID - location.location_id (TAM table)

EXT_ID_1 - externalMapID (People)

EXT_ID_2 - personID

EXT_ID_3 - migrationRelease

EXT_ID_4 - $unknown

EXT_ID_5 - $unknown

EXT_ID_6 - $unknown

EXT_ID_7 - $unknown

EXT_ID_8 - $unknown

EXT_ID_9 - $unknown

EXT_ID_10 - $unknown

PEOPLE_ID - people.people_id (TAM table)

Parameter Mapping For NetCensus

EXT_ID_1 - externalMapID (Inventory)

EXT_ID_2 - config_id

EXT_ID_3 - prod_id

EXT_ID_4 - mapping choice - MapChoice

EXT_ID_5 - demographics option - demog

EXT_ID_6 - component values option - comp

EXT_ID_7 - logon option -j logon

EXT_ID_8 - number of records to migrate - ChunkSize

EXT_ID_9 - $unknown

EXT_ID_10 - netCensusPath

IS_INVENTORY_ID - is_inventory.is_inventory_id (TAM table)

PARAMETER MAPPING FOR SMS

EXT_ID_1 = externalMapID ( 'Inventory' )

EXT_ID_2 = assetTag

EXT_ID_3 = alternateTag

EXT_ID_4 = smsID - comparing this will tell the mapping

EXT_ID_5 = MigrateInvent - inventory checkbox

EXT_ID_6 = MigrateUsers - users checkbox

EXT_ID_7 = MigrateConnect - connection checkbox

EXT_ID_8 = MigrateOrg - organization checkbox

EXT_ID_9 = SMSSite - site that was migrated

EXT_ID_10 = migrateOrganizationID - org ID for visible_org

Returns

String - the updated EXTERNAL_MAP record

Side Effects

None

Description

Populates the control columns of the EXTERNAL_MAP record. These are the values that are always populated regardless of the type of EXTERNAL_MAP record being created. The values specific to each type of map record should be mapped in the calling function.

Dialog Forms Called

None


CreateInvalidAssetMigReport

File Name

dutl_gl.kb

Syntax

CreateInvalidAssetMigReport ( REF rptdef: I_MC_ReportRec )

Parameters

I_MC_Repor tRec - determines the text for the log file

Returns

Nothing

Side Effects

Appends data to the migration log file

Description

This procedure is used to generate a report line to the log file that lists any invalid assets.

Dialog Forms Called

None


CreateInvalidOrgMigReport

File Name

dutl_gl.kb

Syntax

CreateInvalidOrgMigReport ( REF rptdef: I_MC_ReportRec, VAL insertHasBeenAttempted: BOOLEAN )

Parameters

I_MC_ReportRec - determines the text for the log file

insertHasBeenAttempted - determines if the organization did or did not previously exist

Returns

Nothing

Side Effects

Appends data to the migration log file

Description

This procedure is used to generate a report line to the log file that lists any invalid assets. It also determines if the organization was updated or inserted.

Dialog Forms Called

None


DisplayTransactionStatus

File Name

dutl_gl.kb

Syntax

DisplayTransactionStatus( VAL w: WINDOW, VAL text: STRING, REF location: INTEGER, VAL fileName: STRING )

Parameters

w - window handle for writing status text

text - text to be displayed

location - location on scroll window for displaying text

file - optional name of log file for recording transaction text

Returns

Nothing

Side Effects

None

Description

This procedure writes transaction status to a scroll window and optionally, to a desired log or text file.

Dialog Forms Called

None


FileOpen

File Name

dutl_gl.kb

Syntax

FileOpen( VAL w: WINDOW, REF thisPath: STRING, VAL extension: STRING, VAL winDialogTitle: STRING )

Parameters

w - window handle

thisPath - path and file name for the desired file

extension - default extension for the file

winDialogTitle - title to display on the file dialog box

Returns

Nothing

Side Effects

None

Description

This routine is used to select a file to open.

Dialog Forms Called

None


FileSaveAs

File Name

dutl_gl.kb

Syntax

FileSaveAs( VAL w: WINDOW, REF thisPath: STRING, VAL extension: STRING, VAL winDialogTitle: STRING )

Parameters

w - window handle

thisPath - path and file name for the desired file

extension - default extension for the file

winDialogTitle - title to display on the file dialog box

Returns

Nothing

Side Effects

None

Description

This routine is used to determine where the user wants to log the transaction results from the TAM utilities. This routine is also used to determine where to write a file in other situations, like the export CSV file. This routine is currently used by Import and Export and should also be used for SMS and NetCensus migration.

Dialog Forms Called

None


ProcessMigrationErrorMessage

File Name

dutl_gl.kb

Syntax

ProcessMigrationErrorMessage( VAL w: WINDOW, VAL title: STRING, VAL userMessage: STRING, VAL logFileMessage: STRING, VAL logFileName: STRING )

Parameters

w - parent window handle

title - error message title

userMessage - message to be displayed to user

logFileMessage - message to be written to log file

logFileName - name of log file to which to write messages

Returns

Nothing

Side Effects

None

Description

This procedure writes the migration error to the log file and also displays the migration error to the user.

Dialog Forms Called

None


WriteToLogFile

File Name

dutl_gl.kb

Syntax

WriteToLogFile( VAL logFileMessage: STRING, VAL logFileName: STRING )

Parameters

logFileMessage - message to be written to log file

logFileName - name of log file to which to write messages

Returns

Nothing

Side Effects

None

Description

This procedure writes a message to a specified log file.

Dialog Forms Called

None