File Name
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
File Name
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
File Name
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
File Name
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
File Name
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
File Name
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
File Name
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
File Name
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