TEMENOS – PBG – Country Model Bank

Data Migration Tool

User Guide

Information in this document is subject to change without notice.

No part of this document may be reproduced or transmitted in any form or by any means, for any purpose,
without the express written permission of TEMENOS HEADQUARTERS SA.

COPYRIGHT 2007 - 2008 TEMENOS HEADQUARTERS SA. All rights reserved.

 DM Tool – User Guide

Table of Contents

Table of Contents ...................................................................................................................... 1

Document History ...................................................................................................................... 4
Overview of this guide ............................................................................................................... 6
Assumptions .............................................................................................................................. 6
Document Support ................................................................................................................. 6
Abbreviations used in this Guide ........................................................................................... 6
T24 Modules Supported ............................................................................................................ 6
1. Introduction ......................................................................................................................... 7
2. Product Overview ............................................................................................................... 7
3. Workflow Diagram .............................................................................................................. 8
4. Template, Fields and Description ....................................................................................... 9
4.1. [Link] ................................................................................................. 9
4.2. [Link] .................................................................................... 10
4.3. [Link] ............................................................................................. 11
4.4. [Link] ......................................................................... 12
4.5. [Link] .................................................................................. 13
4.6. [Link] ...................................................................................... 16
4.7. [Link] ................................................................................. 17
4.8. [Link] .................................................................................................. 18
4.9. [Link] ........................................................................................... 19
4.10. [Link] .................................................................................................. 20
4.11. [Link] ...................................................................................... 22
4.12. [Link] ................................................................................................. 23
4.13. [Link] ....................................................................................................... 23
5. Process workflow: ............................................................................................................ 25
5.1. Menus .................................................................................................................... 26
5.1.1 Migration Pre-Requisite Check .......................................................................... 26
[Link] Check Migration Table Record Count ............................................................ 28
5.1.2 Client System to T24 Migration .......................................................................... 31
[Link] T24 Data Loading ........................................................................................... 31
[Link] Data Migration Load Preparation ................................................................... 32
[Link] Data Mapping Definition ................................................................................. 44
[Link] Automatic creation of Versions & DMD’s: ...................................................... 70
[Link] DM Service Control ........................................................................................ 75
[Link] Service Control ............................................................................................... 88
[Link] Application backup ......................................................................................... 90
[Link] [Link] ................................................................................................. 96

2 GPACK
 DM Tool – User Guide

[Link] [Link] (Multi-Threading) .......................................................... 98

[Link] STP – Straight Through Processing workflow.............................................. 103
5.1.3 T24 Recon Data Extract................................................................................... 109
[Link] [Link] .................................................................................... 110
[Link] T24 Data Extract for Reconciliation .............................................................. 114
5.1.4 T24 to T24 Migration ........................................................................................ 179
5.1.5 Data & Object Audit ......................................................................................... 179
[Link] DATA AUDIT BUILD .................................................................................... 179
[Link] OBJECT AUDIT BUILD ................................................................................ 218
a. DM Tool Additional Features .......................................................................................... 254
i. [Link] .................................................................................................. 254
ii. [Link] .............................................................................. 255
iii. [Link] ................................................................................ 257
iv. [Link] ............................................................................................ 260
v. [Link] ...................................................................... 262
vi. [Link] Load and [Link] updating .................. 265
vii. Data Compare ..................................................................................................... 272
viii. DM Scheduler ...................................................................................................... 281
ix. [Link] .................................................................................. 288
x. Handling BYTE Length in ORD ........................................................................... 291
xi. [Link] ...................................................................... 293
xii. [Link] .......................................................... 294
xiii. [Link] .................................................................................... 295
xiv. Mnemonic duplication: ......................................................................................... 296
xv. AA - Product Proofing and Publishing ................................................................. 298
xvi. [Link] ................................................................. 299
xvii. ENQUIRY [Link] ........................................................................ 301
xviii. UTF8 conversion .............................................................................................. 301
xix. [Link] ..................................................................................................... 304
[Link]: ....................................................................................................................... 308

3 GPACK
 DM Tool – User Guide

Document History

Author Version Date

Gpack 1.0 11th April 2013

Gpack 2.0 5th August 2013

Data Migration 3.0 13th September 2013

Gpack 4.0 17th February 2016

Gpack 5.0 27th July 2016

Jeya Sudha.K 5.1 13 Mar 2017

[Link] 6.0 15 Mar 2017

B Srinivas Rao 6.1 Updateddesc of the DMD

record

K Jeya Sudha 7.0 Reviewed

B Srinivasarao 7.1 Updated the Description of the

@ID field in the
[Link]
application

K Jeya Sudha 8.0 Reviewed

Ragachandrika 8.1 Updated Error log id format

Sarath Balaji 8.2 New Field in

[Link]

Sarath Balaji 8.3 New Field in

[Link]

Sarath B 8.4 New field introduced in

[Link] to
support straight through
processing.

Sarath B 8.5 OFS REPLACE functionality

covered.

Sarath B 8.6 New fields introduced in

[Link] to support
the value of Delimiters in the
data records.

4 GPACK
 DM Tool – User Guide

Comments:

5 GPACK
 DM Tool – User Guide

Overview of this guide

This document is intended to be used as a reference guide for using DM Tool. The purpose of this
guide is to help the user to understand the various Templates and the fields in the Templates and
the crucial setup of any PARAMETER Files in the DM Tool.

Assumptions

This reference guide is prepared in different releases. Hence the screen shots will be in any
release. Wherever the release is mentioned, there are all the actual release is applicable.

Document Support

Any queries in any part of this document can be addressed to gpack@[Link].

Abbreviations used in this Guide

▪ S – Single Value Field

▪ M – Multi Value Field
▪ AMS – Associated Multi Value Starts Here
▪ AM – Member of Associated Multi Value
▪ AMC – Associated Multi Value Closes Here
▪ OFS – Open Financial Services
▪ TSM – Temenos Service Manager
▪ TSA – Temenos Service Agent

T24 Modules Supported

▪ CUSTOMER
▪ ACCOUNT
▪ COLLATERAL
▪ CURRENCY
▪ [Link]
▪ [Link], etc

6 GPACK
 DM Tool – User Guide

1. Introduction
The T24 Data Migration tool was originally written using the [Link] option. Phantom
processing in T24 is gradually moving from [Link] to [Link]. The Data
Migration tool too has been modified to be run as a Service. The original functionalities of
• Multi-threaded transaction takeover
• Takeover performance reporting, have been preserved in the latest version.

2. Product Overview
The T24™ Data Migration tool will be used during the pre-Live in any site implementations. It
basically covers the following functionalities.

• Used the Standard OFS module to perform the Load. The Option is given to
use either OFS or standard jBase WRITE function to perform the Load.
• Validations done on the data, prior to update.
• Accepts data in any layout and format, that includes double byte characters
(Provided the jBase used for the implementation is 4.1 or higher)
• Required less manual intervention during mapping of the incoming file to
T24™ applications, which is a onetime setup.
• Supports load of Local Tables too that are site specific
• Perform all standard T24™ validations and also includes any special cases to
perform local validations for the data being loaded.
• Supports scaling, using the multi-threading capabilities of [Link].
However, this is dependent more on the hardware capabilities.
• Stop/Resume options in case the Server/T24™/Database connectivity is lost
in the middle of the load. In this case, the operation will be resumed from
where it was paused. Standard [Link] transaction management
capabilities are available.
• Exception Handling is done to report any erroneous data present in the Data
file. This report also includes detailed description of the error that is raised
during the load.
• Supports Sequential Load of Data in multithread. For example, In Drawings
Table, where data is to be loaded in sequence of the ID.
• Supports Read Replacement for Multi Company.

7 GPACK
 DM Tool – User Guide

3. Workflow Diagram

8 GPACK
 DM Tool – User Guide

4. Template, Fields and Description

4.1. [Link]

Counting the number of records for every application, before and after migration, is a vital part
of Data Migration .The information of the number of counts per application is available in a
Live file [Link]. This application keeps track of the changes in the load count.
The entire operation can be successfully complete using the Browser

No. Field Name Description

@ID ID must be SYSTEM.

1.1 [Link] The name of the client for which the migration is to be done

2.1 DESCRIPTION. The descriptions of your report set / interface.

The migration type that is going to be done (E.g. TM0, DR1,

3 [Link] LIVE)
This is an optional filed, where a valid &SAVEDLISTS& name
4 [Link] can be given.

5 MNEMONIC Specify the company Mnemonic

This is a multivalue set where we should provide the Application
6.1 APPLICATION Names for which the count is to be done
This is an associated multivalue set where the number of
7.1 [Link] records in LIVE file will be populated.
This is an associated multivalue set where the number of
8.1 [Link] records in NAU file will be populated.
This is an associated multivalue set where the number of
9.1 [Link] records in HIS file will be populated.

10 OVERRIDE Overrides that are generated, if any.

If set to “Yes” then records are not overwritten and the same is
reported as exception in log file. Record check is applicable only
for load type “WRITE” in DMD record. Valid values are “Yes” or
11 [Link] “No”. No and null are treated the same way.
If the FM delimiter ‘|’ defined in [Link] is
part of migration data then the same has to be replace by
special characters defined in this field. Example: Let say the
delimiter used is | pipe symbol and if beneficiary name contains |
pipe symbol “John | Smith” then it has to be replaced by “John
12 [Link] %$% Smith” for successful processing in Transact.

13 [Link] Same as above

14 [Link] Same as above

Table 1 – [Link]

9 GPACK
 DM Tool – User Guide

4.2. [Link]
The data provided by the Client will contain values that correspond to the Legacy
Data Format which cannot be loaded into T24 without any TRANSLATION. Hence a valid
TRANSLATION must be done so that the Data is converted into a T24 Data format and can
be loaded. The application [Link] is used for converting legacy data into
T24 format.

No. Field Name Description

The id should be the valid Directory inside the
[Link] directory. Creation of directory [[Link]] is
covered as part of Installation [Link] id allows 25
@ID characters long
1 APPLICATION The application for which the conversion carried out.
The source directory of the data file consisting of
2 [Link] Legacy ID is provided in this field
3 [Link] The Data file name consisting of Legacy ID is given.
The name of the output directory where the
converted file will be available after the conversion is
over. Any error log generated will be available as
mentioned above.
By default [Link] can be provided or modified as
per the user.
4 [Link]
The name of the converted data file with T24 Ids
5 [Link] must be given here.
The Field Marker that is used in the datafile to delimit
field values. By default ‘|’ is defaulted which can be
modified as per the user.
6 [Link]
The Value Marker that is used in the datafile to
delimit field values. By default ‘::’ is defaulted which
can be modified as per the user.
7 [Link]
The Sub Value Marker that is used in the datafile to
delimit field values. By default ‘!!’ is defaulted which
can be modified as per the user.
8 [Link]
Any Concat file name that will be used for the
conversion can be provided in this field. This is a
multivalue field.
9.1 [Link]
The positions in the datafile where the conversion
has to be done and replaced with T24 Ids. This is a
10.1.1 [Link] sub value field associated with Mapping Table field.

The positions in the data file where the conversion

11.1.1 [Link] values are defined .This is a sub value field

10 GPACK
 DM Tool – User Guide

associated field.

A subroutine can be attached to this field that will be

used for conversion logic. This is an associated sub
value set with Position Check field. This is a sub
12.1.1 [Link] value field associated field.
The number of agents that will be required to run the
conversion can be mentioned in this field. Default
13 [Link] value is 16
Table 2 – [Link]

4.3. [Link]
This table is used to create folders and for copying of data files to the respective folders
and creating the [Link] (DSC) that are necessary for the load of Data to
T24. Using the application [Link] we can create necessary folders and moves
the data files to their respective paths. We will also be able to create folders for placing
reconciliation extracts from T24.

No. Field Name Description

A 3 digit number followed by an asterisk (*), followed
by a valid user name that must be present in the
@ID USER table
1 DESCRIPTION Free text Description.
The task that will be done when the application is
verified. Either creation of DSCs or Only creation of
2 PROCESS Directories or Both can be specified here.
3 RESERVED.5 Future Use
The directory name where the data files are stored
and under this directory will other folders get created
which will be used as Path Name in
[Link]. The value [Link] is
defaulted, which can be changed to any other
4 [Link] directory as and when needed.
This is an optional filed, where a valid
5 [Link] &SAVEDLISTS& name can be given
This is an Associated Multivalue set which will hold
the DMD name for which the
[Link] will be created followed by
a dot (.) and a two digit sequence number. (The
format is mandatory). The folders that need to be
created for the data file will be based on the input to
6.1 [Link] this field.
This is an Associated Multivalue set .The data file
that will be used for the load will be selected
automatically based on the input in the previous field.
The data file must be present in the Directory that
7.1 [Link] has been specified in the field Directory Name. The

11 GPACK
 DM Tool – User Guide

format of the data file must be as follows.

<[Link]>.<2 digit
number>.<yyyymmddhhmm>.TXT
E.g.: [Link]

We need to specify if Reconciliation Folders are to be

12 RECONCILIATION created or not. By default, the value “No” is defaulted.
The Directory name must be specified here where
the reconciliation folders will be created. By default
13 [Link] [Link] is populated in this field.
This is a multivalue field that is used to provide the
Names of the folders that need to be created under
the Directory specified in the field Recon Dir.
14.1 [Link]
This is a multivalue field that contains DM Extractor
Id. The value entered must exist in the
15.1 [Link] [Link] table
16 [Link] File conversion will be done if this field is set to YES.
This field specifies whether the file load is from
17 [Link] Server or Local host
Conversion type is specified here. Values entered
18 [Link] here are NT or Unix
Table 3 – [Link]

4.4. [Link]

Verifying the correctness of the Data Mapping Table and the [Link] is a
vital part of Data Migration, without which the data load, could go wrong.
[Link] verifies, whether the Data Mapping Table and the
[Link] are in synchronisation.
This application also produces an output file in the specified DMV directory with the status of
the Verification.

No. Field Name Description

The id of this application is free format text, 12
characters long.

A meaningful ID, indicating the application name e.g.,

CUSTOMER should be provided.
CUSTOMER
[Link]
LIMIT
@ID
1 DESCRIPTION Free text Description.

12 GPACK
 DM Tool – User Guide

Name of the T24™ Table to which the Data is been

2 [Link] loaded.
3 [Link] DMD Name to be specified.

The Directory name where the DMV status result will

4 [Link] be stored.
This field gets updated on verification of the record
with PASS or FAIL status
If the fields in DMD and the one in save list are same
without any mismatch then it would be updated as
5 [Link] PASS.
This is the name of the file where the core fields are
given for comparison. This file is to be placed in
6 [Link] [Link].
This is the name of the file where the local fields if
any are given for comparison. This file is to be placed
7 [Link] in [Link].
This is an associated Multivalued field which gets
updated with the fields in the [Link] i.e the Core
8.1 [Link] fields upon verification.
The Delimiter used to identify each multi-value field in
the data. Value allowed only when [Link] is
9.1 [Link] set to DELIM. This is an associated Multivalued field
This is a Multivalue field which gets updated with the
fields in the [Link] i.e the local fields upon
10.1 [Link] verification
This field specifies the Data file name. The file has to
11 [Link] be placed in DMV directory.
This field becomes mandatory on providing value for
the field [Link] allowed is
12 [Link] FIRST,POSITION,RANDOM.
This field becomes Mandatory on specifying
POSITION in [Link] field
specifies the position from where verification has to
13 [Link] be done for the file.
This field becomes Mandatory on specifying
POSITION in [Link] field
specifies the position till where verification has to be
14 [Link] done for the file
The number of records in datafile will be updated
15 [Link] here.
If there is any error then the error message will be
16 [Link] populated on verifying the record.
Table 4 – [Link]

4.5. [Link]

13 GPACK
 DM Tool – User Guide

This application allows the user to define the format of the data in the incoming tape. The
following provides the list of fields, positions and the associated description.

No. Field Name Description

The id of this application is free format text, 12
characters long.

A meaningful ID, indicating the application name e.g.

first six characters of the application name,
CUSTOMER and the Load process, should be
provided.
[Link]
[Link]
[Link]
@ID
1 GB. DESCRIPTION Free text Description to describe the Load.
Name of the T24™ Table to which the Data is been
2 [Link] loaded.
Either ‘[Link]’ or ‘WRITE’ or
‘[Link]’ or ‘[Link]’ or
‘[Link]’ to specify if the load is via
OFS module or jBASE Write function or the
3 [Link] replacement of a few fields.
A value ‘VALIDATE’ or ‘PROCESS’ will just
validate/process the contents of the data if it fits into
T24™ table. Value is allowed in this field only when
4 [Link] [Link] is set to OFS.
The following FUNCTIONS are allowed to be
specified to be used by the OFS to process the
5 [Link] transaction. (I, R, A, D). “I” is taken as default.
The Type of T24™ files to be updated. Values could
be $NAU, LIVE or $HIS. Value is allowed only when
the [Link] is set to WRITE or
6 [Link] [Link].
The T24™ Application’s Version to be used when
loading through OFS. Value is allowed in this field
7 [Link] only when [Link] is set to OFS
To define the way in which the fields are read. Either
8 [Link] DELIM or POSITION or OFS
The Delimiter used to identify each fields in the data.
Value allowed only when [Link] is set to
9 [Link] DELIM
The Delimiter used to identify each multi-value field in
the data. Value allowed only when [Link] is
10 [Link] set to DELIM
The Delimiter used to identify each sub-value fields in
the data. Value allowed only when [Link] is
11 [Link] set to DELIM
12 [Link] When a particular character in the incoming data

14 GPACK
 DM Tool – User Guide

needs to be converted, the character to be converted

must be provided here.
Works in conjunction with [Link], this is the
character to which the [Link] character will be
13 [Link] converted.
Either ‘AUTO’ (which system takes care to generate
the ID) ‘DATA’ (hardcoded ID in the coming file itself)
14 [Link] ‘ROUTINE’ (A routine attached that forms the ID)
The Routine that forms the ID for each record loaded.
15 [Link] Value allowed only when [Link] is set to ROUTINE
The position in which the ID of each record can be
found. Value allowed only when [Link] is set to
16 [Link] DATA
The Length of the ID in each record in the data file.
Value allowed only when [Link] is set to DATA
Note – This field is used in reference with
[Link] to get the data for the ID from the raw
17 [Link] file
The field name in the T24™ table to which the data is
updated. 65 characters long (Associated multi-value
set till 22.1).
This field allows to accept the field names and field
positions of the application. For local reference field,
Use the local field name and not the position.
To define the fields from [Link]
18.1 [Link] use the respective field names only .
The starting position of the data that will be updated
in the T24™ field (Associated multi-value set till
24.1). Associated multi-value set till 22.1). Value
19.1 [Link] allowed only when [Link] is set to POSITION
The length of the data that will be updated in the
T24™ field (Associated multi-value set till 24.1).
Associated multi-value set till 22.1). Value allowed
only when [Link] is set to POSITION
Note – This field is used in reference with
[Link] to get the data for the field from the
20.1 [Link] raw file
Either ‘ROUTINE’ – indicated the data will be formed
from the routine for this field (or) ‘CONSTANT’ – a
21.1 [Link] static value that will be updated for the field
The Static value that will be updated for the field.
Value allowed only when [Link] is set to
22.1 [Link] CONSTANT
The Post update routine , used a s a user exit routine
that will be triggered for every record that is been
23 [Link] loaded
The OFS source record to be used when loading
data into T24. Two OFS Source records,
1. [Link]
2. [Link]
24 [Link] 3. [Link]

15 GPACK
 DM Tool – User Guide

4. [Link]
5. [Link]
With [Link] set to ‘YES’ for cases where
field validation processing must be triggered e.g.
[Link] are provided by default.
Table 5 – [Link]

4.6. [Link]
This application is used
To define the company for which the data is loaded
The location of the incoming data
Control the execution of the data load process
The following are the fields and associated description

No. Field Name Description

@ID Must be the same as [Link].
The company for which the data is loaded. It is also possible to
provide the load company in the Incoming data. However, once
the value is provided here, this value takes precedence over
1 [Link] incoming data.
The directory where the flat file resides. This must be a valid
directory name, e.g. [Link]. Actual path or relative path of
2 [Link] the directory must be provided.
The flat file name of the incoming data. Must be an existing file
3 [Link] name.
4 [Link] Specifies the name of the server, for multiple application servers
The user name which will be used for the load process. This
username will get updated in the [Link] record related
5 USER to the [Link].
No of threads that the [Link] must spawn for
6 NO. OF SESSIONS processing this request.
The field [Link] is to move the error details from DSC
7 [Link] to another template namely [Link]
The status of the process. This can be either
• START – Updated automatically by the system when
the [Link] record is ‘Verified.
• STOP – Manual stop request to stop the takeover
10 [Link] process.
11 [Link] Dsc type should be either DMD or DME
This field is used to run the [Link] service as
multi-threaded or single threaded. It is a mandatory field. The
values accept as SINGLE or MULTI. For sequential file upload
12 [Link] this type should be ‘SINGLE’.
13 [Link] This field is used to specify the load type, either file based or

16 GPACK
 DM Tool – User Guide

message based for straight through processing. Possible values

are blank or "FILE" or "ONLINE". If "blank" or "FILE": File based
processing. If "ONLINE": Message based processing.
Refer section [Link] for online processing.
Contains the processing messages of the Service. Auto
15.1.1 [Link] updated.
The errors that have been generated after the completion of the
16.1 [Link] process will be captured in this field. Auto updated.
The number of errors that have been recorded after the
completion of the process will be captured in this field. Auto
17.1 [Link] updated.
The type of errors consolidated from all the errors generated
after the completion of the process will be captured in this field.
18.1 [Link] Auto updated.
If the error is generated, this field will indicate the path where the
19 [Link] error long gets stored. Auto Updated.
If the error is generated, this field will indicate the file name of
20 [Link] the error long gets stored. Auto Updated.
The current date of the load process will be updated in this field.
21 DATE Auto updated.
The current start date/time of the load process will be updated in
22 STARTED this field. Auto updated.
The current end date/time of the load process will be updated in
23 STOPPED this field. Auto updated.
The current elapsed date/time of the load process will be
updated in this field. Auto updated.
24 ELAPSED
Table 6 – [Link]

4.7. [Link]
The services for validating, loading and authorizing of Data in T24 is required to be scheduled
and automated. Most of the tasks are manually performed which needs to be eliminated. The
multithread service will perform the tasks in an automated way to eliminate the manual task to
an extent.

No. Field Name Description

The ID for this application must be a user defined name for the
SCHEDULER.
@ID e.g.: [Link]

1.1 DESCRIPTION The description of the SCHEDULER.

To indicate whether the service needs to be run for

[Link] or [Link]. It accepts
2 [Link] values as DMD or DME
The [Link] table record which needs to be
3 [Link] completed successfully in order for the current service to be

17 GPACK
 DM Tool – User Guide

started.

To indicate whether the service needs to be started or stopped.

4 [Link] The two options available are START and STOP.
To store the [Link] table record which needs
5.1 [Link] to be started
To store the [Link] table record which needs
6.1
to be completed successfully in order for the service, associated
VERIFICATION to the multivalued set, to be started
To store the specified data file path for that services. This is an
7.1 [Link] associated multi-value field.
To specify the data file name for validate or load the data. This
8.1 [Link] is an associated multi-value field.
To specify the new data file path for that services. This is an
9.1 [Link] associated multi-value field.
To specify the maximum number of errors that will be tolerated
10.1 [Link] before marking the service as failed.
No input field to update the number of records in error from the
corresponding [Link] after the service is
11 [Link] complete
To specify if the service needs to be run or can be skipped. The
12.1 [Link] two options are YES and NO
No input field which will be updated with values 0, 1, 2 or 3
based on the current status of the service associated with the
13.1 [Link] field [Link]
No input field which will be updated with values 0, 1, 2 or 3
based on the current status of all the services in the
14 [Link] SCHEDULER
No input field which will be updated with some details for
15 [Link] information only
To specify TAFJ locking mechanism defined in [Link]
file.
If [Link] is set to DATABASE (Use database
locks of the underlying database) then input [Link] as
16 [Link] DATABASE or else it can be left blank.
Table 7 – [Link]

4.8. [Link]
This is the table where the parameters are provided.
The ID for this application must be in the format:

No. Field Name Description

Id for this application must be in the format:

@ID A 3 digit number followed by an asterisk (*), followed by a valid

18 GPACK
 DM Tool – User Guide

user name that must be present in the USER table.

If only the USER is provided, then the 3 digit number will be

defaulted automatically

1 DESCRIPTION The descriptions of report / interface

Specifies the task that will be done when the application is
verified. FULL is specified for the entire extract of AA Product
and Properties. The option ‘Only Product’ and ‘Properties’ is
reserved for Future Use.
2 [Link]

3 [Link] Has two option Yes or No.

4 [Link] Reserved for future use.

Table 8 – [Link]

4.9. [Link]
The Reconciliation extract will be taken from T24 after completion of load as per the process,
and the reconciliation extract from the Legacy will also be extracted and provided in the
[Link] Directory.
The table is used to compare both the Extracts and to provide the output of the comparison.

No. Field Name Description

@ID User defined Id.

1 DESCRIPTION The Description for the comparison

The [Link] table record which will be
used for mapping of the reconciliation Extracts
Two comparisons can be performed using
[Link].
1. [Link] – file to file compare.
2. [Link] - file to environment
2 [Link] compare.
This field position of the Primary key (ID) in the file that is
3 [Link] provided for comparison.
4 [Link] The field delimiter used in the extract files.
5 [Link] The multi value field delimiter used in the extract files.
6 [Link] The sub value field delimiter used in the extract files.
This field is to flag if both the source and target extract for file
7 HEADER compare has Headers or not.
This field is used for information only to store the Legacy Data
8 [Link] Extract.

9 [Link] The directory name where the extract is provided by the bank.

19 GPACK
 DM Tool – User Guide

10 [Link] The file name of the extract provided by the bank.

The Directory Name where the recon extract from T24 is
11 [Link] located.

12 [Link] The File Name of the recon extract from T24.

The Output file path where the reconciliation extract is available
13 [Link] after the comparison.
The Output file name of the reconciliation extract after the
14 [Link] comparison.
The number of agents that will be required to run the
15 [Link] comparison can be mentioned in this field.
16 [Link] The application name for the comparison.
This field specifies the position of the field and applicable only
17.1 [Link] for environment compare.
18.1 [Link] This field specifies the first field of source data file.
Table 9 – [Link]

4.10. [Link]
Extraction of Data from T24 is necessary when a Migration is to take place between older
releases of T24 to a newer release or for reconciliation extracts.
The application [Link] is used for extraction of data from T24.

No. Field Name Description

The id of this application is free format text, 12
characters long.

A meaningful ID, indicating the application name e.g.,

CUSTOMER should be provided.
CUSTOMER
[Link]
LIMIT
@ID
1 DESCRIPTION The descriptions of your report set / interface.
The name of the table for which the extraction is to
be done. The entry in this field must be present in the
[Link].
2 APPLICATION
Whether the extraction is Multi Company or not.
3 [Link]
Specifies the type of file which has to be
4 [Link] extracted($NAU or $HIS or $ARC)

20 GPACK
 DM Tool – User Guide

The value in this field can be either “VALIDATE” or

“PROCESS”. If VALIDATE is selected then the
records corresponding to ‘Application’ will be
validated for errors and if PROCESS then the normal
5 [Link] extraction is performed.
The description of the selection criteria. This is a
multivalue field.
6.1 [Link]
The Selection field from the application must be
7.1 [Link] specified here. This is an associated multivalue field.
The Selection criteria must be specified here. This is
an associated multivalue field.
8.1 [Link]
The Selection Value must be specified here. This is
9.1 [Link] an associated multivalue field.
The Selection Combination must be specified here.
This is an associated multivalue field.
10.1 [Link]
The save list name must be entered in this field.
11 [Link]
12 [Link] The output filename for the Extraction.
The output directory where the extracted file will
13 [Link] reside
The Field Marker that will be used in the extract to
14 [Link] separate the fields.
The Value Marker that will be used in the extract to
separate the Multi values.
15 [Link]
The Sub value Marker that will be used in the extract
to separate the Sub values.
16 [Link]
The Local Currency must be specified only if the
17 [Link] extract is done for [Link] application.
The takeover account category must be specified
based on which the internal account.
18 [Link]
The number from which the department code part in
19 [Link] [Link] id must be started is specified.
Whether the headers need to be provided for the
extract or not.
20 [Link]
The field description for the field to be extracted.
21.1 [Link]
The application name must be specified from which
22.1 [Link] the for concurrent extract of the value is done.

21 GPACK
 DM Tool – User Guide

The extract type for the field is specified here.

23.1 [Link]
The field name from the application which is to be
24.1.1 [Link] extracted.
The value in this field can be either “APPEND” or
“TRIM” or “REPLACE”. This field performs the
transformation in order to pick values from other
application.
25.1 [Link]
The value provided depends on the type mentioned
in the field “Trans Condition”. This field becomes
mandatory when “Trans Condition” is provided.
26.1 [Link]
A subroutine can be attached to this field that will be
27.1 [Link] used for different extraction logic.
The field name from the application mentioned in Fld
App must be specified.
28.1.1 [Link]
Whether the extract is done for [Link]
application or not.
29 DATACAPTURE
The credit transaction code must be specified. The
value is provided only if the extract is done for
[Link].
30 [Link]
The debit transaction code must be specified. The
value is provided only if the extract is done for
31 [Link] [Link].
Table 10 – [Link]

4.11. [Link]

No. Field Name Description

@ID Id to this should be valid DMD record id.
The name of the table for which the extraction is to be done. The
entry in this field must be present in the
[Link].
1 [Link]

The core field name of the application for which the extraction
2 [Link] has to be done
This field indicate what type of core validation check is used for
3 [Link] that particular field

22 GPACK
 DM Tool – User Guide

This represent maximum number of alpha or alphanumeric or

4 FMT numeric characters allowed for that particular fields
5 [Link] This field represent the field number of that particular field

The local field name of the application for which the extraction
6 [Link] has to be done
To indicate what type of core validation check is used for that
7 [Link] particular field
To indicate what type of core validation check is used for that
8 [Link] particular field
No input field which will be updated with values 0, 1, 2 or 3
based on the current status of the service associated with the
9 [Link] field [Link]
Table 11 – [Link]

4.12. [Link]

No. Field Name Description

Id to this should be valid user name that must be present in the
@ID USER table.

1 DESCRIPTION The description about the extract is provided.

This field is used specify the product line for which the extract is
to be taken. Only two options are valid either “Deposits” or
2 [Link] “Lending”.
3 [Link] To specify field level delimiter.

4 [Link] To specify the delimiter for multi value fields.

5 [Link] To specify the delimiter for sub value fields.

To specify the output directory in which the extract will be
6 [Link] placed.
The name in which the extracted file will be created in the
7 [Link] directory.
Table 12 – [Link]

4.13. [Link]

No. Field Name Description

@ID Id to this should be SYSTEM

1 [Link] This is an no inputtable field

2 [Link] This field is used to specify the source server name/id

23 GPACK
 DM Tool – User Guide

3 [Link] This field is used to specify the company ID of the environment

This field is used to specify the savelist ID. If the selected

application need to be compared. If not, the build will be crated for
4 [Link] all applications
This field will be automatically updated by the system after running
5 [Link] the service with info build date
This field will be automatically updated by the system after running
6 [Link] the service with status

7 [Link] This is an no inputtable field

This field will be automatically updated by the system after running

8 [Link] the service with info build date
This field will be automatically updated by the system after running
9 [Link] the service with status

10 [Link] This is an no inputtable field

11 [Link] This field is used to specify the target server name/id

This field will be automatically updated by the system after running
12 [Link] the service with date
This field will be automatically updated by the system after running
13 [Link] the service with status

14 [Link] This is an no inputtable field

If the reverse comparison needs to be done then this is set to Y

15 [Link] (i.e, From Target to Source as well)
This field will be automatically updated by the system after running
16 [Link] the service with date
This field will be automatically updated by the system after running
17 [Link] the service with status

18 [Link] This is an no inputtable field

This field is to specify the savedlist ID with BP (Directory) names to

19 [Link] create the build
This field will be automatically updated by the system after running
20 [Link] the service with info build date
This field will be automatically updated by the system after running
21 [Link] the service with status

22 [Link] This is an no inputtable field

This field is to specify the savedlist ID with BP (Directory) names to

23 [Link] create the build
This field will be automatically updated by the system after running
24 [Link] the service with info build date
This field will be automatically updated by the system after running
25 [Link] the service with status

26 [Link] This is an no inputtable field

This field will be automatically updated by the system after running
27 [Link] the service with date

24 GPACK
 DM Tool – User Guide

This field will be automatically updated by the system after running

28 [Link] the service with status
Table 14 – [Link]

5. Process workflow:
This Section covers the functionalities involved in the DMIG tool. Each of the tables and
their related functionalities are explained. Also, sample setups are given. Please Use the
Menu [Link] for operations using the DM TOOL.

It has three menus namely Migration Pre-Requisite Check, Client System to T24
Migration , T24 to T24 Migration to facilitate efficient working with DM tool.
A sample screenshot of the Screen is as shown.

25 GPACK
 DM Tool – User Guide

5.1. Menus

5.1.1 Migration Pre-Requisite Check

This menu contains applications for making the pre-requisite checks.
A sample screenshot of the Screen is as shown.

➢ System Dates

26 GPACK
 DM Tool – User Guide

Table
DATES
Purpose
The DATES application is checked for the current system Date before start of Data Migration.

➢ Check Holiday Setup

Table
HOLIDAY
Purpose
The HOLIDAY application is checked for the current holiday setup.

➢ Check Migration User

USER
Purpose
The USER application is checked for existence of Data Migration Users .

➢ Check the Licensed Product

Table
SPF
Purpose
The SPF application is checked for the license in field number 36 , [Link].

➢ Check Company Record Setup

Table
COMPANY
Purpose
The COMPANY application is checked for the current holiday setup.

➢ Check T24 Application Auto Id Setup

Table
[Link]
Purpose
The [Link] application is checked the Ids Setup of the applications in scope for
Migration.

➢ Check DM Tool Details

Enquiry
ENQUIRY [Link]

Purpose

27 GPACK
 DM Tool – User Guide

Display the details of the DM Tool that will be used for the validation and Load.

[Link] Check Migration Table Record Count

Table
[Link]
Purpose
The application is used to summarise the number of records Loaded. The information of
the
number of counts per application is available in a Live file [Link]. This
application
keeps track of the changes in the Load count.

Detailed Working Procedure

This is the table where the parameters are provided. It can be accessed from the
Command line of the Browser.
The ID for this application must be only SYSTEM.

After selecting the correct ID you will get a screen as below. Input The application name
and commit it.

28 GPACK
 DM Tool – User Guide

[Link] – verify

After doing the initial setup of parameters, [Link] is verified. On

Verification:

1. The count for each application is done and updated in the fields LIVE Count, NAU
Count, HIS Count.
2. The value is updated in a LIVE file [Link].
After committing the record we need to verify the record. We select the record name to be
verified and click the button as shown.

Click the marked button to verify the record.

After the transaction is processed we get the following screen.

29 GPACK
 DM Tool – User Guide

As mentioned, the LIVE file [Link] will be updated as shown below.

Multiple counts will also be captured in the LIVE file.

30 GPACK
 DM Tool – User Guide

The latest count of the application in the area will be the first multivalue set.

5.1.2 Client System to T24 Migration

[Link] T24 Data Loading

This menu contains applications that are used while migrating data from a Client’s system to T24.
It consists of T24 Data Loading and T24 Recon Data Extract.
A sample screenshot of the Screen is as shown.

31 GPACK
 DM Tool – User Guide

[Link] Data Migration Load Preparation

Table
[Link]
Purpose
Creation of folder, copying of data files to the respective folders and creating the
[Link] (DSC) is necessary for the load of Data to
[Link] by which we can create necessary folders and moves the data files
to their respective paths. We will also be able to create folders for Reconciliation.
The DSC is an integral part of data load. This application also creates specified DSCs
with appropriate field values through Open Financial Service (OFS).

[Link]

The following [Link] record [Link] must be available in the deployed area.

32 GPACK
 DM Tool – User Guide

[Link] – Parameters

This is the table where the parameters are provided. It can be accessed from the Command
line of the Browser.
The ID for this application must be in the format:
A 3 digit number followed by an asterisk (*), followed by a valid user name that must be present in
the USER table. (The format is mandatory).

After selecting the correct ID you will get a screen as below.

33 GPACK
 DM Tool – User Guide

Here you can enter the following items

• Description: The descriptions of your report set / interface.

• Process: The task that will be done when the application is verified. Either
creation of DSCs or Only creation of Directories or Both can be specified here.
• Directory Name: The directory name where the data files are stored and under
this directory will other folders get created which will be used as Path Name in
[Link]. The value [Link] is defaulted, which can be
changed to any other directory as and when needed.
• Select List: This is an optional filed, where a valid &SAVEDLISTS& name can be
given.
• Dmd Name: This is an Associated Multivalue set which will hold the DMD name
for which the [Link] will be created followed by a dot (.) and a
two digit sequence number. (The format is mandatory). The folders that need to
be created for the data file will be based on the input to this field.
• File Name: The data file that will be used for the Load will be selected
automatically based on the input in the previous field. The data file must be
present in the Directory that has been specified in the field Directory Name. The
format of the data file must be as follows.
• <[Link]>.<2 digit number>.<yyyymmddhhmm>.TXT

34 GPACK
 DM Tool – User Guide

• E.g.: [Link]
• Reconciliation: We need to specify if Reconciliation Folders are to be created or
not. By default, the value “No” is defaulted.
• Recon Dir: The Directory name must be specified here where the reconciliation
folders will be created. By default [Link] is populated in this field.
• Recon Spec Name: This is a multivalue field that is used to provide the Names of
the folders that need to be created under the Directory specified in the field
Recon Dir.
• DM Extractor Name: This is a multivalue field that contains DM Extractor Id. The
value entered must exist in the [Link] table.
• File Conv Reqd: File conversion will be done if this field is set to YES.
• File Load Type: This field specifies whether the file load is from Server or Local
host.
• Conversion Type: Conversion type is specified here. Values entered here are NT
or Unix.
• Local Ref: Currently non inputtable, can be used for further developments.
• Override: Provides the overrides.

[Link] – Verify
After doing the initial setup of parameters, [Link] is verified. On verification 4
processes are triggered. Creation of folders VERIFY01, VERIFY02, VERIFY03, LOAD01,
AUTH01, DMV under the specified folders. Copying of the data file to the above folders in their
respective paths.
Creation of DSC records via OFS.
Creation of Reconciliation folders.
If DMD with function ‘R’ or ‘D’ records are not available, DSC will not be created. This will be
captured as override. For other DMDs with function as ‘V’, ‘I’ or ‘A’, if record is not present, it
will be an error.

35 GPACK
 DM Tool – User Guide

After committing the record we need to verify the record. We type the record name to be
verified and click the button as shown.

36 GPACK
 DM Tool – User Guide

After the transaction is processed we get the following screen.

The folders are created for Validate, Input and Authorise and also the Reconciliation folders are
created as shown below and the data file is also copied to the respective path
TAFC:

37 GPACK
 DM Tool – User Guide

TAFJ:

The DSCs are also created for DMD.

Data Mapping Layout

Table
[Link]

38 GPACK
 DM Tool – User Guide

Purpose

The menu is used to do the initial setup for the verification of the Data Mapping Sheet and the
[Link]
Detailed Working Procedure

This is the table where the parameters are provided. It can be accessed from the Command
line of the Browser.
The ID for this application can be upto 65 characters

After selecting the correct ID you will get a screen as below.

39 GPACK
 DM Tool – User Guide

After committing the record we need to verify the record. We type the record name to be
verified and click the button as shown.

After the transaction is processed we get the following screen

40 GPACK
 DM Tool – User Guide

The result file will be created as below.

TAFC:

The compared DMV fields and the DMD fields are populated in the file as below

By providing the data file name only, the values in the data file will be validated and the
PASS/FAIL status will be updated based on the validation status of each record. The validation
status of each record will be stored in a separate file as a result.
The validation of the record values in the data file can be validated based on the
verification type provided by the user. The following are verification types,

41 GPACK
 DM Tool – User Guide

FIRST
POSITION
RANDOM

1. FIRST

If the datafile name is given and the verification type is “FIRST” then only the first string in
the datafile will be validated and the result for that particular record will be stored in a separate file
in the DMV folder. A sample record is provided below for reference.

On verifying the DMV, the PASS/FAIL status will be updated and the result will be stored
in the DMV folder. Only the file for data file will be created as the field verification is not provided in
this case.

42 GPACK
 DM Tool – User Guide

TAFC:
The result will be stored in the DMV folder as below

TAFJ:

Screen shot for the text and log files location

The status of the validated datafile will be populated in the file as below

43 GPACK
 DM Tool – User Guide

2. POSITION
If the datafile name is given and the verification type is “POSITION” then it’s mandatory to
provide values for the fields “[Link]” and “[Link]”. The number of strings
present between the two position values in the datafile will be validated and the result for those
records will be stored in a separate file in the DMV folder.
On verifying the DMV, the PASS/FAIL status will be updated and the result will be stored
in the DMV folder. Only the file for data file will be created as the field verification is not provided in
this case.
3. RANDOM

If the datafile name is given and the verification type is “RANDOM” then a string will be
picked randomly from datafile and will be validated. The result for that particular record will be
stored in a separate file in the DMV folder. A sample record is provided below for reference.

On verifying the DMV, the PASS/FAIL status will be updated and the result will be stored
in the DMV folder. Only the file for datafile will be created as the field verification is not provided in
this case.

[Link] Data Mapping Definition

Table

44 GPACK
 DM Tool – User Guide

[Link]

Purpose
This is the base mapping definition table, which maps the incoming data with T24™ fields.
The following items are defined here.
• T24™ Table to be Loaded
• Type of Load to be done (Example – OFS or flat jbase write)
• Type of Action to be performed (Example – Only Validate the data or actual
• update)
• Function to be used (Allowed function are Input, Authorise, Delete, Reverse)
• If not mentioned, Input function will be used by default.
• Way to identify the each field in a transaction/record (Example – by delimiter or
• position)
• Associated multi-valued sets to map the T24™ field with Data, by giving the
• position or delimiter to identify the data from the source file
• Any Post Update routine that will be called for every transaction/record being
• Loaded.

Detailed Working Procedure

This application is used for defining the mapping of T24™ fields with the data received in the
Data file from the Client’s system. This can be defined for different T24™ applications (Core
as well as locally developed applications).
The ID of a record in this file can be any 35 alphanumeric characters. This need not be the
name of the application and any name can be given to a record. It is also possible to define
more than one record for an application since this can be used for multiple loading sessions
for the same application.
The parameters defined in this file include:
1. OFS Write or Flat write – While doing data loading, it is possible that data has to be
loaded in the core tables or in the locally developed tables. In case of Core Tables the
data has to be loaded through the OFS route where for locally developed tables load
can be either through the OFS route or can be a flat write. This however depends
upon the structure and linkages of the locally developed table. In case the load has to
be done on a single table which does not update any other table then the load can be
done through a flat write rather than going through the OFS route.

2. This parameter is governed by the Field “ [Link]”. This is a mandatory field and
the possible values are [Link] or WRITE or [Link]. When value
[Link] is selected then the data loading will be done through the OFS route
whereas selecting a value of WRITE will enable direct write to the tables. The
[Link] option will update certain fields of an already Loaded record
through direct write of only those fields.

3. [Link] – To Ensure the correctness of the Data been Loaded, a value

‘VALIDATE’ can be set in this field, which does everything with the Load of the data,

45 GPACK
 DM Tool – User Guide

except that the data is not writt en to the disk. It checks all the validations/raise
exceptions/errors. A value ‘PROCESS’ will straight away does the physical write into
the database, after the validation

4. File Type – In case of a flat write, the data can be directly written to either of the $NAU,
$HIS or LIVE files. This parameter is determined by the value in field “ [Link]”.
The possible values in this field are NULL, $NAU and $HIS. In case NULL is selected
the write will be to LIVE file else the direct write will be done to the respe ctive files
($NAU or $HIS).

5. Defining Incoming Data – Generally the incoming data from the client received in the
Data file will comprise of several records in the form of text strings. For the purpose of
loading these records have to be segregated and this segregation can be done using
different methods. The possible methods for segregation include (i) use of delimiters
for identifying the records and fields within a record (ii) use of position of different
fields e.g. field 7 in a record can be of length 6 and will be starting at a position 25.
This way a field can be defined in a record. In this case it is not possible to define the
multi-value and sub-value fields since the position for mapping will get fixed and it will
not be possible to support the variable field lengths in case of multi -value and sub value fields.

This option is handled through the mandatory field “ [Link]” which has 2 options viz DELIM
or POSITION. The option DELIM is used for defining the delimiters to be used whereas POSITION
i s used for defining the position of the fields.
5. Delimiter Definitions: It is possible to parameterize different delimiters that can be
used for identifying the records, multi -values and sub-values. These definitions can be
provided in the fields [Link], [Link] and [Link] as each of these fields
represent one type of delimitation.

6. ID Generation:
In T24™ it is possible that for some of the application the ID has to be system
generated whereas for certain other applications the ID has be to be provided
manually.
Accordingly 3 options have been provided in this mandatory field “ [Link]” viz.
AUTO, DATA and ROUTINE.
When the option AUTO is selected the ID will be automatically generated by the
system.
For option DATA the record ID has to be part of the incoming data.
In case of some of the applications require routine for generating the Ids the n the
option ROUTINE can be used. In this case a single argument is passed and returned
back from the routine used for forming the record ID. The name of the ID routine
can be defined in the field [Link].

46 GPACK
 DM Tool – User Guide

The ID position has to be defined in case of data being segregated by fixed positions.
This field [Link] becomes a mandatory field if field [Link] has a value of
POSITION.

7. Escape Sequence:
There is a provision to allow the user to change certain character in the data from one
kind to another. For example if a “,” has to be changed to “:” then this can be done
using an associated multi -value field “[Link]” and “[Link]”. The value
defined in the field “[Link]” will be changed to the value in the field “[Link]”.

8. Mapping:
These are a set of associated multi -value fields from “[Link]” to
“[Link]” that are used for mapping either OFS or flat write. This set of fields
comprise of [Link], [Link], [Link],
[Link] and [Link].

9. Field “[Link]” is for defining the name of the field in given T24™
application (either core or local). It can take up to 65 characters. The field has to be defined in the
[Link] record of the application. Either the field name or the field
number can be input in this field.

It is possible to provide the company for which the record is loaded. To do this, the
field name must be set to [Link] and the company code must be
provided in the associated field position.
For [Link], an option to provide both the
[Link] record as well as the [Link] record is
available. The values must be separated using a message separator, defined using
‘[Link]’.

10. Field “[Link]” is used to define the position of the field in the record given
by the client. For example if there is local reference field in the customer record
defined as field number 40.2 ([Link]) and this has been provided at
25th position in the data given by the Client then the field “ [Link]” should
have the value [Link] ER and field “[Link]” should have the
value of 25. This is used in case option “DELIM” or “POSITION” is opted in field
[Link].

11. Field “[Link] is a mandatory field in case field “ [Link]” has value of
“POSITION” and for other cases this s is a no-input field.

12. Field [Link] has two options viz. CONSTANT and ROUTINE. When option

47 GPACK
 DM Tool – User Guide

“CONSTANT” is selected the value in the field “[Link]” will be mapped to the
Application field as constant value. In case option “ROUTINE” is selected the n the
Name of the routine should be defined in the field [Link]. The name of the
Routine should be preceded by ‘@’ and should be defined in the [Link] as type “S”.

13. Field [Link] is used in conjunction with the field [Link]. If

[Link] is provided as CONSTANT, then the value in this field is used for all
incoming records.

14. Field [Link] is used to perform the post update processing for a
record. In applications like LD which are single authoriser, this routine will be used to
perform the authorisation of an unauthorised record. any routine is attached to the field
[Link], it can be removed even after the record is authorised.

15. Field [Link] is used to define the [Link] record to be used when
Loading the data into T24 via OFS. Four [Link] records [Link],
[Link], [Link] and [Link] are available.
In cases where the field validation needs to be trigger for incoming OFS message then choose
[Link] for OFS processing. If update required in [Link] file then
choose [Link] for OFS processing.

Note: LOG details are controlled using the field [Link] in [Link].
Below are the possible options.
1. FULL – Both success and failure transactions captured in error log file.
2. EXCEPT – Only failure transactions captured in error log file.
3. NONE – No log file update.

48 GPACK
 DM Tool – User Guide

Sample DMD Record:

Updating of Multi/sub value field using [Link] as Load Type

Using the [Link] option as [Link], it is possible to replace particular field
value.
Sub value
Data file:

49 GPACK
 DM Tool – User Guide

DMD Record:

[Link] record before read replacement:

50 GPACK
 DM Tool – User Guide

[Link] record after read replacement:

51 GPACK
 DM Tool – User Guide

Loading of $ARC using the DMD record:

DMD Record:

52 GPACK
 DM Tool – User Guide

53 GPACK
 DM Tool – User Guide

54 GPACK
 DM Tool – User Guide

55 GPACK
 DM Tool – User Guide

56 GPACK
 DM Tool – User Guide

57 GPACK
 DM Tool – User Guide

58 GPACK
 DM Tool – User Guide

Before authorization of DMD:

After authorization of DMD:

59 GPACK
 DM Tool – User Guide

The below screenshot shows the $ARC file of the [Link] record

60 GPACK
 DM Tool – User Guide

61 GPACK
 DM Tool – User Guide

Sequential Upload through DMD ([Link])

Some Applications require entries in T24 sequentially. The following document explains the
process of uploading Data using [Link], which require Sequential Entry into T24.
Example: Application is LIMIT. This Application is used for demonstration of Sequential
upload in this document.
Test Case:
Prerequisites:
CUSTOMER application is required as prerequisite for LIMIT application.
10 records are created for CUSTOMER.
• 600000001

• 600000002 to 600000010

The first multi value for [Link] must be [Link] with

[Link] as 1. The second multi value for [Link] must be
[Link] with [Link] as 2.
This configuration and sequence must be maintained for Sequential Upload. For Non
Sequential Upload, these values can be ignored.
The screenshot for reference.

62 GPACK
 DM Tool – User Guide

Other Field values mapped as per the Data Mapping Sheet.

Data File

Data File Count: 30 records

63 GPACK
 DM Tool – User Guide

Groups: 10
Each group will contain 3 records where the first record will be the global limit
followed by the product and sub product limits for the particular customer.

Group 1

Group 2

The first block is the Group 1 and the Second block is Group 2. (N number of groups
can be included in the data file). The first field in the Data file must be the Group ID
followed by the second field which must be the Sequence number for the respective
Group.

Sequential Upload Process

Upload

Verify the [Link]>[Link]

Start the TSM

64 GPACK
 DM Tool – User Guide

The [Link] is will have 10 Record Keys for each of the 10

Groups in the Data File.

Group 1 of the data file:

Group 2 of the data file:

The other groups will be created similarly.

• The [Link] (ORD) lists all the records in the data file, as processed.

65 GPACK
 DM Tool – User Guide

Processed [Link]

Uploaded Records:
Global Limit: 600000001.0010000.01

66 GPACK
 DM Tool – User Guide

67 GPACK
 DM Tool – User Guide

Product Limit: 600000001.0001000.01

68 GPACK
 DM Tool – User Guide

Sub Product Limit: 600000001.0001010.01

69 GPACK
 DM Tool – User Guide

[Link] Automatic creation of Versions & DMD’s:

It is a program which is used to create the Versions and DMD’s

([Link]) for any input able applications in [Link] program is executed
in jshell prompt, during program execution, it will prompt for

• Application name

• Suffix of DMD name

Once the user provides the appropriate values, the program takes care of creating the
respective Version’s (If the record does not exist in the environment) for the corresponding
DMD and also DMD’s in the environment.

Prerequisites

Need to have these record has the perquisite for successful execution this routine
• VERSION > VERSION,RNT

70 GPACK
 DM Tool – User Guide

• VERSION > [Link],RNT

Process Flow:

Once the application name is keyed, all input able fields are extracted from the
[Link] and for that particular application and then DMD will be created.

[Link] is modified now. Previously it was working as a mainline routine.

Now, it has been converted to a service.

Please follow the below steps for running the service [Link]

71 GPACK
 DM Tool – User Guide

72 GPACK
 DM Tool – User Guide

Now the records are succefully created.

Creation of Versions and DMD’s for the given application

73 GPACK
 DM Tool – User Guide

Note: All Versions are single level authorization

Below is the sample screenshot of the automatically created DMD for the CUSTOMER
application

[Link]>[Link]

74 GPACK
 DM Tool – User Guide

[Link] DM Service Control

Table
[Link]

Purpose
This work-file application is used to control the actual Load process. The following details must
be provided when the [Link] is set up .
• Load Company – The Company for which the data is loaded. If this information is
not provided in the incoming tape, it must be provided here.

• Data file directory and file name – A valid directory name and file name.

• Number of Sessions – The number of sessions with which the [Link]

must be run.

• Run Status – To Request for a STOP of the [Link].

• User – The user name which will be used for the Load process. This username
will get updated in the [Link] record related to the
[Link]. Initially DMUSER was hardcoded as the USER.

• [Link] – Implies whether the status of service as START or STOP.

• [Link] – Implies whether the service is for DMD(Loading) or

DME(Extraction)

• Error Details, No Of Error and Type Of Error – The details of the errors that are
generated during validation/process will be updated in these fields. Date, Started,
Stopped and Elapsed – The Current system Date, the start time, end time and
the elapsed time of validation/process activity will be updated in these fields.

[Link]>[Link]

75 GPACK
 DM Tool – User Guide

Detailed Working Procedure

Setting up the Service Control for the first Time

The ID of the [Link] file must be the same as the

[Link] table. After setting up the above mentioned fields, the record must be
committed. This must be done in the INPUT mode.
Pick up the newly setup record in Verify Mode and commit.
When running for the first time, the system will check if the BATCH, [Link] and
[Link] are present and if no they will be created. This is checked in the file
[Link]. If they don’t exist, they are created by the system. The
following components are created.

Batch
A batch record with the id as [Link] -<<[Link] name>> is created.
This contains three jobs namely

[Link] – A single thread process which reads the incoming sequential

file and writes to [Link]

[Link] – is a multi-threaded job that reads [Link] and updates the job
list. Each record is then processed by [Link] and error log files generated using
the naming convention below.
<< [Link] Name>>#LOG.<<Session Number>>

[Link] – is a single threaded process which consolidated all the LOG

files generated for a particular xxxx into a single error output file. Naming convention of the log
file is given below.
<< [Link] Name >>’-‘<< [Link] >>-‘[Link]’

76 GPACK
 DM Tool – User Guide

BATCH>[Link]

[Link] record

The number of sessions in the [Link] record is updated as number of

agents in this record

[Link]>[Link]

77 GPACK
 DM Tool – User Guide

[Link] record

A [Link] record with the following contents is created.

[Link]> [Link]

As can be seen, the user in the [Link] record is updated from the
[Link].

On verification, the status of the [Link] record is marked as ‘START’. The

same is updated into [Link] record as well. The control log is updated with the starting
request details.

Then start the TSM

Data File:
TAFC

TAFJ:

Run the service.

78 GPACK
 DM Tool – User Guide

Output:

79 GPACK
 DM Tool – User Guide

Marking the service Stop

To mark the [Link] stop, the [Link] record must be opened in Input
mode and the [Link] must be set to STOP.

Immediately the [Link] is marked for STOP. The agents will stop after processing the
current records.

Modifying the number of agents at Run time

To modify the number of agents during run time ,pick up the [Link]
record in Verify mode. Update the number of sessions as required. This will be updated to the
[Link] application. Once the TSM reaches its review time, it will either
spawn more or less agents as required (in Phantom mode) or request for running more or less
agents (in Debug mode)
Right now this option is available only in Classic

Updating of Time Field in DSC:

The process of enhancing DSC, by capturing the Start and Stop fields in DSC, when the service is
started . The field [Link] is included in [Link] which can be updated either
as DME or DMD. If the id of the [Link] is from [Link]
application then the value DMD is given or else if the id is from [Link], then DME is
given in the field [Link].

80 GPACK
 DM Tool – User Guide

[Link] ID from [Link]

• If the id of the [Link] is from [Link]

application then the value DMD is given

[Link]>[Link]

• The [Link] must be verified

81 GPACK
 DM Tool – User Guide

• On verifying [Link] the respective service will get started

[Link] ID from [Link]

• If the id of the [Link] is from [Link]

application then the value DMD is given, if [Link] is from
[Link] then any id can be given.

82 GPACK
 DM Tool – User Guide

• The [Link] must be verified

83 GPACK
 DM Tool – User Guide

• On verifying [Link] the respective service will get started

• Start the extraction by executing the [Link] command in Jshell prompt.

• After the extraction is complete we will find that the time fields in DSC have been
updated.

84 GPACK
 DM Tool – User Guide

Updating of [Link] through DSC:

The process of enhancing DSC, by updating the field [Link] has been included
to move the error details from DSC to another template namely
[Link].

• Mark the values as ‘Y’ in [Link] field and commit the record.
[Link]>[Link]

• The [Link] must be verified

85 GPACK
 DM Tool – User Guide

• Accept Override.

• On verifying [Link] the error details will be moved to

[Link] and the error details in DSC will be removed.

86 GPACK
 DM Tool – User Guide

Updating of [Link] through DSC:

The process is to enhance DSC, by updating the [Link] for
each time when DSC is edited and VERIFIED.

The [Link] (DSC) is verified, and thereby numbers of agents have

been changed from 2 to 4.
[Link]>[Link]

The [Link] is updated correctly. The agents required are

updated as 4 once the corresponding DSC is verified after the number of agents has
been updated in the DSC record.

87 GPACK
 DM Tool – User Guide

[Link]>[Link]

[Link] Service Control

Table
[Link]

Purpose

The Menu is used to Start or Stop the [Link] record TSM or any other service that
needs to be started or stopped manually.

Service Status

88 GPACK
 DM Tool – User Guide

Enquiry
ENQUIRY [Link]

Purpose
This enquiry provides the information for all Data Migration services as well as the TSM status.
Once the [Link] has been marked as START, if the TSM is running in phantom mode
the tSA(agent) will be automatically started. If the same is running in debug mode, then the agents
will have to be manually initiated to start the actual process.

Detailed Working Procedure

The Enquiry [Link] is used to get the details of [Link] and to
monitor the status of the services from T24. The selection criteria are as shown below.

We need to refresh the enquiry regularly to know the status of the services. For this we need
to enable auto refresh as shown below.

Click on the more options link.

89 GPACK
 DM Tool – User Guide

Enter the desired time to get refresh the display

The result will be as below and the query will refresh every 5 seconds.

[Link] Application backup

90 GPACK
 DM Tool – User Guide

Table
[Link]

Purpose
Taking backup of the application is a necessary step in the process of migration. The following
Steps explain the usage of the application [Link] by which we can take the
Backup of any application.

The entire operation can be successfully complete using the Browser.

[Link] - parameters

This is the table where the parameters are provided. It can be accessed from the MENU line
of the Browser.

The @id of the application should be APP.<<valid [Link] entry>>

91 GPACK
 DM Tool – User Guide

Here you can enter the following items:

• Application: This field is defaulted with the Application for which the APPLICATION N
backup is to be taken.
• Backup Dir: The Backup Directory where the folders will be created for creating the
backup.
• Backup Folder: The folder name where the APPLICATION records will be moved is
defaulted here.
• No Of Agents: The number of agents that will be required to run the service to clear and
backup the APPLICATION.
• Local Ref: Currently non inputtable, can be used for further developments.
• Override: No overrides are generated with this application.

92 GPACK
 DM Tool – User Guide

[Link] – verify (T24 Application)

After doing the initial setup of parameters, [Link] is verified. On verification 3

tables are updated.

1. [Link] is updated/created with Id as

DOB-<ID of [Link]>

2. [Link] is updated/created with Id as

DOB-<ID of [Link]>

93 GPACK
 DM Tool – User Guide

3. BATCH is updated/created with Id as

DOB-<ID of [Link]>

After the transaction is processed we get the following screen.

94 GPACK
 DM Tool – User Guide

The Folder for taking the Application backup will be created under [Link].

After the transaction is processed, [Link] is automatically stopped and the

BATCH record is updated accordingly .

Running the Service

1. The [Link], [Link] will be started automatically on verifying the

application [Link].

2. Start the TSM , but inputting and authorizing the [Link] records TSM to “Start”
3. Initiate the TSM in the classic mode like below.

4. The records from the APPLICATION will be moved to the backup folder.

Records count before and After the [Link]

Before :

95 GPACK
 DM Tool – User Guide

After
Count the number of records in the backup folder to verify all the records are been
moved .

[Link] [Link]

Table
[Link]
Purpose
This application is used to extract the AA products with their respective Properties
and Property class.

Description: The descriptions of your report / interface.

Extract Type: Specifies the task that will be done when the application is
verified. FULL is specified for the entire extract of AA Product and Properties.
The option ‘Only Product’ and ‘Properties’ is reserved for Future Use.
Product: This field is reserved for Future Use.

96 GPACK
 DM Tool – User Guide

Input a record

Verify the record in [Link]

97 GPACK
 DM Tool – User Guide

After the extraction is completed the status will be as below.

The output will be stored in [Link] directory under the particular product line
name

[Link] [Link] (Multi-Threading)

• Table
[Link]
• Purpose
The scope of the table is to explain in detail regarding Multi-Threading
[Link].

98 GPACK
 DM Tool – User Guide

Detailed Working Procedure

The [Link] the field Pre Process is included. The field is mandatory
and value can be provided based on the vetting table as SINLGE or MULTI.

[Link] screenshot with field included:

[Link]>V.TESTPP1

Changes in [Link]

The following are the changes done in [Link]

99 GPACK
 DM Tool – User Guide

100 GPACK
 DM Tool – User Guide

CREATION OF BATCH FOR SINGLE

The below screenshot depicts the BATCH for SINLGLE Pre Process

101 GPACK
 DM Tool – User Guide

CREATION OF BATCH FOR MULTI

The below screenshot depicts the BATCH for MULTI Pre Process

102 GPACK
 DM Tool – User Guide

[Link] STP – Straight Through Processing workflow

A new field is introduced in [Link] to support message based processing

in addition to conventional file based process. Individual data lines should be pushed to JMS
queues using the message format described below.
Note: OFS source [Link] should be configure in [Link]
Kindly refer standard configuration document for JMS queue setup.

Message structure:
[Link], OPERATION, Pay Load (i.e. Data)

Delimiter: ',' - Comma

[Link] : [Link] record id
OPERATION : Possible values are ‘null’ or ‘1’
‘null' – Indicates straight through processing.
'1' - Indicates two-step process. The actual data is written to interim staging table
[Link] and then followed by [Link] for actual posting in T24.
Pay Load / Data – To be processed in T24.

Example:
[Link],,101106|MARKJ|Mark Josy|Cathy Perry|Nelson
Chambers|1001|1|1000|1||1|US|1

103 GPACK
 DM Tool – User Guide

OPERATION is null - indicating straight through process.

Where [Link] is a record from [Link] application

containing definition for customer record creation.

Pay load/Data – Customer data required for successful record creation.

104 GPACK
 DM Tool – User Guide

[Link]

105 GPACK
 DM Tool – User Guide

[Link] with [Link] set to Online.

Push the sample message to data migration JSM queues configured (to use [Link] ofs
source) for further processing in T24.

Customer record create in T24 for the sample message shared above.

106 GPACK
 DM Tool – User Guide

Log files generated on the file path specified in DSC record.

After running [Link] job, a consolidated log file will be generated.

Consolidated output file:

107 GPACK
 DM Tool – User Guide

For OPERATION = 1
[Link],1,101116|MARRR|Mark|Cathy Perry|Nelson
Chambers|1001|1|1000|1||1|US|1

After posting messages, please check the interim staging table [Link].
Query above file using DBTools > JQL LIST-ITEM [Link]

Run [Link] for further processing in T24.

108 GPACK
 DM Tool – User Guide

5.1.3 T24 Recon Data Extract

➢ Directory Creation for Reconciliation extract

Table
[Link]
Purpose
To create the necessary directories for reconciliation extracts.

➢ T24 Data Extract for Reconciliation

Table
[Link]
Purpose
The application [Link] is used for extraction of data from T24.

109 GPACK
 DM Tool – User Guide

➢ Service Control
Table
[Link]
Purpose
To start and stop the services during extraction process.
➢ Service Status
Table
[Link]
Purpose
To monitor the services status during extraction process.

Directory Creation for Reconciliation extract

Table
[Link]
Purpose
To create the necessary directories for reconciliation extracts.

[Link] [Link]

This is the table where the parameters are provided. It can be accessed from the
Command
line of the Browser.

The ID for this application must be in the format:

A 3 digit number followed by an asterisk (*), followed by a valid user name that must be
present in the USER table. (The format is mandatory).

110 GPACK
 DM Tool – User Guide

After selecting the correct ID you will get a screen as below.

Here you can enter the following items:

• Description: The descriptions of your report set / interface.

• Process: The task that will be done when the application is verified. Either creation of
DSCs or Only creation of Directories or Both can be specified here.

• Directory Name: The directory name where the data files are stored and under this
directory will other folders get created which will be used as Path Name in

111 GPACK
 DM Tool – User Guide

[Link]. The value [Link] is default ed, which can be changed to

any other directory as and when needed.

• Select List: This is an optional filed, where a valid &SAVEDLISTS& name can be
Given.

• Dmd Name: This is an Associated Multivalue set which will hold the DMD name for
Which the [Link] will be created followed by a dot (.) and a two
Digit sequence number. (The format is mandatory). The folders that need to be
Created for the data file will be based on the input to this field

• File Name: The data file that will be used for the Load will be selected automatically
based on the input in the previous field. The data file must be present in the Directory
that has been specified in the field Directory Name. The format of the data file must
be as follows.

<[Link]>.<2 digit number>.<yyyymmddhhmm>.TXT

E.g.: [Link]

• Reconciliation: We need to specify if Reconciliation Folders are to be created or not .

By default, the value “No” is defaulted.

• Recon Dir: The Directory name must be specified here where the reconciliation
folders will be created. By default [Link] is populated in this field.

• Recon Spec Name: This is a multivalue field that is used to provide the Names of the
folders that need to be created under the Directory specified in the field Recon Dir.

• Local Ref: Currently non inputtable, can be used for further developments .

• Override: Provides the overrides.

112 GPACK
 DM Tool – User Guide

[Link] – verify

After doing the initial setup of parameters, [Link] is verified. On verification

below process will be triggered:

• Creation of Reconciliation folders.

•
After committing the record we need to verify the record. We type the record name to be
verified and click the button as shown.

113 GPACK
 DM Tool – User Guide

After the transaction is processed we get the foll owing screen.

The folders are created Reconciliation are shown below .

[Link] T24 Data Extract for Reconciliation

Table
[Link]
Purpose
The application [Link] is used for extraction of data from T24.
[Link] – parameters

114 GPACK
 DM Tool – User Guide

This is the table where the parameters are provided. It ca n be accessed from the Command
line of the Browser.
There are no specifications for the ID of this application.

Here you can enter the following items:

• Description: The descriptions of your report set / interface.

• Application: The name of the table for which the extraction is to be done. The entry
in this field must be present in the [Link].
• Multi Company: Whether the extraction is Multi Company or not.
• Sel Desc: The description of the selection criteria. This is a multivalue field.
• Sel Fld: The Selection field from the application must be specified here. This is an
associated multivalue field.
• Sel Crit: The Selection criteria must be specified here . This is an associated
multivalue field.
• Sel Value: The Selection Value must be specified here. This is an associated
multivalue field.

• Sel Comb: The Selection Combination must be specified here. This is an associated
multivalue field.
Select List: The save list name must be enter ed in this field.
• Target File: The output filename for the Extraction.
• Output Dir: The output directory where the extracted file will reside.

115 GPACK
 DM Tool – User Guide

• FM Delim: The Field Marker that will be used in the extract to separate the fields.
• VM Delim: The Value Marker that will be used in the extract to separate the Multi
values.
• SM Delim: The Sub value Marker that will be used in the extract to separate the Sub
values.
• Fld Label: The field description for the field to be extracted .
• Fld Type: The extract type for the field is specified here.
• Fld Name: The field name from the application which is to be extracted.
• Fld Rtn: A subroutine can be attached to this field that will be used for different
extraction logic

[Link] – authorize

After doing the initial setup of parameters, [Link] is authorised. On authorisation 3

tables are updated:

1. [Link] is updated/created with Id as

[Link]-<ID of [Link]>

2. [Link] is updated/created with Id as

[Link]-<ID of [Link]>

3. BATCH is updated/created with Id as

[Link]-<ID of [Link]>

After the transactions are processed [Link], [Link] and the

BATCH record area created as below.

[Link]

116 GPACK
 DM Tool – User Guide

[Link]

BATCH

117 GPACK
 DM Tool – User Guide

Running the Service

After authorization, the service is started manually.

118 GPACK
 DM Tool – User Guide

Start the TSM.

Check the services, if started.

Start the services.

119 GPACK
 DM Tool – User Guide

The output file specified in the application is generated in the output directory.

• [Link]- Validation process

As in loading process, validation can be done for extraction.
Create a record in the [Link] with application name as COLLATERAL.
Input the necessary details in the respective fields and [Link] must be
VALIDATE.

120 GPACK
 DM Tool – User Guide

121 GPACK
 DM Tool – User Guide

After authorising the record, the service has to be started as per the below screen shot.

Once the service is complete, the OFS will be listed as shown below.

122 GPACK
 DM Tool – User Guide

• The headers can be included for the extracts

It is possible to include headers in the extract via DME.
[Link] when set to Yes – It can be made available in the extract.

123 GPACK
 DM Tool – User Guide

Extracted File with Headers:-

124 GPACK
 DM Tool – User Guide

• Multiple Applications can be extracted simultaneously

It is posible to extract mutilple application via [Link]

Extraction for Multiple Applications can be done as explained below:-

125 GPACK
 DM Tool – User Guide

126 GPACK
 DM Tool – User Guide

Extracted file with Multiple Applications.

• Extraction can be done for Multicompany/book.

Extraction can also be done for multibook or multicompany via DME as below

127 GPACK
 DM Tool – User Guide

MULTI COMPANY SET TO YES

128 GPACK
 DM Tool – User Guide

OUTPUT:

129 GPACK
 DM Tool – User Guide

• Sub/Multi value for Core/Local. Fields can be extracted

It is possible to extract Core and local fields via DME.

130 GPACK
 DM Tool – User Guide

131 GPACK
 DM Tool – User Guide

132 GPACK
 DM Tool – User Guide

• The specific conversions can be extracted using no routines

Any specific conversion that is required for extraction can also be done.

133 GPACK
 DM Tool – User Guide

Extracted Sample of Records:-

DME Record with Arithmetic Operation

134 GPACK
 DM Tool – User Guide

135 GPACK
 DM Tool – User Guide

Extracted Sample of Records: -

DME Record for Absolute value testing.

136 GPACK
 DM Tool – User Guide

137 GPACK
 DM Tool – User Guide

DME Record with the usage of Substitute:-

138 GPACK
 DM Tool – User Guide

139 GPACK
 DM Tool – User Guide

DME can be used to convert [Link] if needed .

140 GPACK
 DM Tool – User Guide

141 GPACK
 DM Tool – User Guide

It is also possible to extract data based on position..

142 GPACK
 DM Tool – User Guide

143 GPACK
 DM Tool – User Guide

• The trail balance for foreign currency can be extracted.

Trail balance for the GL in foreign currency can be extracted through DME.

144 GPACK
 DM Tool – User Guide

[Link] record:
On authorisation of the [Link] record a record in [Link] will be created.

The result will be stored in [Link] folder in the [Link] path:

Sample Output :

[Link] record:
On authorisation of the [Link] record a record in [Link] will be created.

145 GPACK
 DM Tool – User Guide

The result will be stored in [Link] folder in the [Link] path:

Sample Output :

146 GPACK
 DM Tool – User Guide

• Transformation via DME

Any transformation required that is appending values or trimming any value can be done
via DME as below.

Append:
Append is the condition which is used to add a value in the first position or in the last position
of the field value. Also a value can be added at a position mentioned within the field value.

The format is VALUE[POSITION]

E.g.:
VALUE[F] : To append to the first position of the field value
VALUE[L] : To append to the last position of the field value
VALUE[NUMBER] : To append to any position in the field value

The field values are provided as given in the below screen shot to extract from more than one
application using the append condition.

147 GPACK
 DM Tool – User Guide

Create a record in the [Link]

148 GPACK
 DM Tool – User Guide

Start the service [Link]

After running the service, target file has been created in the output directory

149 GPACK
 DM Tool – User Guide

Extracted file

Trim:

Trim is the condition which is used to remove a value from the position which is mentioned
within the field value.

The format is [position]

E.g.:
[number1, number2]
[13,19] : Trim from 13th position to 19th position
Or [number]
The field values are provided as given in the below screen shot to extract from more than one
application using the trim condition.

150 GPACK
 DM Tool – User Guide

151 GPACK
 DM Tool – User Guide

After running the service, target file has been created in the output directory

Extracted file

Replace:
Replace is the condition which is used to replace one value with another value in the position
mentioned in the field value.
The format is VALUE[POSITION]
E.g.:
VALUE [number1, number2]
Or VALUE[number]

152 GPACK
 DM Tool – User Guide

The field values are provided as given in the below screen shot to extract from more than one
application using the replace condition.

153 GPACK
 DM Tool – User Guide

After running the service, target file has been created in the output directory

Extracted file

154 GPACK
 DM Tool – User Guide

Specific Conversions
For specific conversions [Link] field should be set to MANIPULATE .

System Variables

Variables like !TODAY, !USER, ![Link] etc. can be used

[Link] Record

155 GPACK
 DM Tool – User Guide

EXTRACTED DATA:

156 GPACK
 DM Tool – User Guide

Arithmetic Operation

The following operations can be performed.

+, - , * , /

[Link] Record

157 GPACK
 DM Tool – User Guide

EXTRACTED DATA:

158 GPACK
 DM Tool – User Guide

Absolute value

Absolute value can be extracted. [Link] should be set to A

[Link].

[Link] Record

159 GPACK
 DM Tool – User Guide

EXTRACTED DATA:

160 GPACK
 DM Tool – User Guide

Substitute

[Link] Record

161 GPACK
 DM Tool – User Guide

EXTRACTED DATA:

162 GPACK
 DM Tool – User Guide

Convert

This will replace every occurrence of the character X with Y.

[Link] Record:

163 GPACK
 DM Tool – User Guide

EXTRACTED DATA:

164 GPACK
 DM Tool – User Guide

Extract

The values in the record is Extracted from position N1 to N2.

[Link] Record:

165 GPACK
 DM Tool – User Guide

EXTRACTED DATA:

166 GPACK
 DM Tool – User Guide

Extracting [Link] via [Link]

For the [Link] Application the field [Link] should be set to

“YES” and also [Link] field should be defined.
In order to create an internal Account we should define the three fields
[Link], [Link], [Link].
Where,
[Link] - The take over account category which is unused must
be specified
[Link] - The Department account officer id (DAO) which is a part
of [Link] id must be specified.

167 GPACK
 DM Tool – User Guide

168 GPACK
 DM Tool – User Guide

The value “[Link]” in the field [Link] will extract the values
for the fields Sign, Transaction Reference and Amount FCY/Amount LCY as
mentioned below.

After the process, three files will be extracted namely

o A file with the name mentioned in the field [Link]
o [Link]
o [Link]

The final extracted file with the balanced batches is stored in

“[Link]” and the same must be considered.

[Link] (future repayment) Extraction

Extract the data from LD and [Link] (future repayment) based

on the multi-value field the future repayment will be extracted

169 GPACK
 DM Tool – User Guide

Before extracting the data, the DME record the [Link] fields must
be in the below format. The @id only required for extracting the future repayment
data. Here the LD records with future repayment schedule will be extracted

[Link] Record:

The [Link] field must be value [Link] and [Link],

[Link] must be value ‘@ID’ and also DATACAPTURE must be selected ‘NO’

170 GPACK
 DM Tool – User Guide

After starting the services the DME records the LD contract with future repayment will
be extracted.

171 GPACK
 DM Tool – User Guide

Extracted file:

172 GPACK
 DM Tool – User Guide

[Link] ($ARC) Archival Extraction:

Extraction of archived files in T24 can be extracted by providing the value for the field
[Link] as “$ARC”.

Similarly the date can be extracted for both HISTORY and UNAUTHORISED records.
The value to be provided in the field [Link] for extraction of history and
unauthorised files are “$HIS” and “$NAU”.

[Link] Record:

The [Link] field must be provided with the value $ARC for extracting archived
records. If the field [Link] is left blank the live file will be extracted for the
particular application.

173 GPACK
 DM Tool – User Guide

After starting the services the DME records the LD contract with future repayment will
be extracted.

174 GPACK
 DM Tool – User Guide

Extracted file:

Service Control

175 GPACK
 DM Tool – User Guide

Table
[Link]

Purpose

The Menu is used to Start or Stop the [Link] record TSM or any other service that
needs to be started or stopped manually.

Service Status

Enquiry
ENQUIRY [Link]

Purpose
This enquiry provides the information for all Data Migration services as well as the TSM status.
Once the [Link] has been marked as START, if the TSM is running in phantom mode
the tSA(agent) will be automatically started. If the same is running in debug mode, then the agents
will have to be manually initiated to start the actual process.

Detailed Working Procedure

The Enquiry [Link] is used to get the details of [Link] and to
monitor the status of the services from T24. The selection criteria are as shown below.

176 GPACK
 DM Tool – User Guide

We need to refresh the enquiry regularly to know the status of the services. For this we need
to enable auto refresh as shown below.

Click on the more options link.

Enter the desired time to get refresh the display

177 GPACK
 DM Tool – User Guide

The result will be as below and the query will refresh every 5 seconds.

178 GPACK
 DM Tool – User Guide

5.1.4 T24 to T24 Migration

T24 to T24 migration has the same menus as in Client System to T24 Migration and the
procedure is also the same as seen above.

5.1.5 Data & Object Audit

[Link] DATA AUDIT BUILD

The prerequisite for DAB comparison is mentioned below:
Check whether the below Routines are present in the environment.
The routine creates the records with ID as system date and application name in source
environment. These records are input to create the source dump.
✓ [Link]
✓ [Link]
✓ [Link]
✓ [Link]
✓ [Link]
✓ [Link]
✓ [Link]

179 GPACK
 DM Tool – User Guide

✓ [Link]
✓ [Link]
✓ [Link]
The below routines creates the dump file from source environment.
✓ [Link]
✓ [Link]
✓ [Link]
✓ [Link]
The below routine creates the dump file from target environment.
✓ [Link]
✓ [Link]
✓ [Link]
✓ [Link]

The below routine creates the output dump file, which is comparison of source and target
dump in the target environment.

✓ [Link]
✓ [Link]
✓ [Link]
✓ [Link]

This routine creates the output dump file, which is comparison of source and target dump in
the target environment.
The Data Audit Build tool is developed for all the data tables.
In this document, we have shown for both AUDIT and NON AUDIT Field data tables. Similarly
the procedure can be used for all the data tables.

Steps to be done in Source environment

RECORD CREATION
The inputs required for DAB has to be provided in this record as shown in the below
screenshot.

180 GPACK
 DM Tool – User Guide

Browser View:

181 GPACK
 DM Tool – User Guide

Putty View:

[Link]- The savedlists ID with the selected application has to be provided in this
field. If not, the build will be created for all the applications

The table names has to be provided in the savedlists as shown in the below screenshot,

STEP1: Clear files

Before run each and every service the below mentioned has to be cleared
[Link] [Link]
[Link] [Link]
[Link] [Link]

182 GPACK
 DM Tool – User Guide

STEP2: Start the TSM

Start the TSM first and then start the service [Link] in Auto mode

STEP3: Start the [Link] service

START THE SERVICE “[Link]” to create the table info with the
application provided in savedlists (if savedlists provided) or with all the applications

183 GPACK
 DM Tool – User Guide

Browser View to start/stop the Service:

184 GPACK
 DM Tool – User Guide

Putty View to start/stop the Service:

STEP4: Start the TSM service

TAFJ:

185 GPACK
 DM Tool – User Guide

STEP5: Check the [Link]

The status can be checked as shown below

LIST [Link] WITH @ID EQ 'SYSTEM' [Link]

Check the [Link] application after completing [Link]

186 GPACK
 DM Tool – User Guide

STEP6: List the [Link]

To view the template give the command “[Link] L” as shown in the below screen
shot

187 GPACK
 DM Tool – User Guide

To view records from the template [Link] give S as shown below in the
screenshot
The data record is shown below from the template [Link].

188 GPACK
 DM Tool – User Guide

DUMP CREATION FOR SOURCE:

Before running the source build service check the INFO STATUS in [Link] is
completed as shown below in the screen shot.
Dump the source extract in the [Link] folder.
Step1: Check the [Link]
Browser View:

Putty View

189 GPACK
 DM Tool – User Guide

Step 2: Start the [Link] service

Start the TSM first and then start the service [Link] in AUTO mode
Browser View:

Putty View:

This [Link] service will pick the data from [Link] &
[Link]
Start the service “[Link]” to create the source build

190 GPACK
 DM Tool – User Guide

STEP3: Start the TSM service

TAFJ:

STEP 4: Check the [Link]

The status can be checked as shown below
LIST [Link] WITH @ID EQ 'SYSTEM' [Link]

Check whether the date and status has been updated in [Link]

191 GPACK
 DM Tool – User Guide

STEP 5: Check the source dump in [Link]/SOURCE folder under the [Link]

1. Source dump file will be saved in the below directory.

../ [Link]/[Link]/SOURCE

The dump will be saved in the SOURCE path will be as [Link]

(CURRENT System DATE & TIME)
TAFJ:
1. Source dump file will be saved in the below directory.
../ TAFJ/[Link]/SOURCE

192 GPACK
 DM Tool – User Guide

Please select the data table dump folder from Source dump files.
And View of the record contents in the data dump is shown in the below screenshot.

193 GPACK
 DM Tool – User Guide

STEP 6: Pack all the records in source environment

Then pack all the records from [Link] and release in the target environment.

194 GPACK
 DM Tool – User Guide

195 GPACK
 DM Tool – User Guide

DUMP CREATION for Target:

Steps to be done in Target environment
Step 1: Clear files
Before running every service clear the below mentioned files,
[Link] [Link]
[Link] [Link]
[Link] [Link]
Before run the service see the below screen shot SOURCE STATUS is completed and then
input the [Link] name.

Step 2: Check the [Link] before start the agent

196 GPACK
 DM Tool – User Guide

Step 3: Input the Target environment details in [Link] table

STEP 4: Start the TSM service

Start the TSM first and then start the service [Link] in AUTO mode

197 GPACK
 DM Tool – User Guide

Step 5: Start the [Link] service

Browser View:

Putty View:

198 GPACK
 DM Tool – User Guide

STEP 6: Start the TSM service

Start the service “[Link]” to create target dump

TAFJ:

199 GPACK
 DM Tool – User Guide

STEP 7: Check the [Link]

The status can be checked as shown below
LIST [Link] WITH @ID EQ ‘SYSTEM’ [Link]

Check whether the date and status has been updated in [Link]

200 GPACK
 DM Tool – User Guide

STEP 8: List the [Link]

To view the template give the command “[Link] L” as shown in the below screen
shot,

201 GPACK
 DM Tool – User Guide

To view records from the template [Link] give S as shown below in the screenshot

202 GPACK
 DM Tool – User Guide

The data record is shown below from the template [Link].

STEP 9: Check the source dump in [Link]/TARGET folder under the [Link]

Target dump file will be saved in the below directory.

../ [Link]/[Link]/TARGET

The dump will be created in the TARGET path with the ID as [Link]
Current System Date & Time)

203 GPACK
 DM Tool – User Guide

Please select the particular data table dump folder from Target dump files.
View of the record contents in the target data dump is shown in the below screenshot.

204 GPACK
 DM Tool – User Guide

TAFJ:
Target dump file will be saved in the below directory.
./ TAFJ/[Link]/TARGET

Please select the particular data table dump folder from Target dump files.
View of the record contents in the target data dump is shown in the below screenshot.

205 GPACK
 DM Tool – User Guide

206 GPACK
 DM Tool – User Guide

Steps to be done for comparison between Source dump and Target dump
STEP 1: Clear files
Before running every service the below mentioned files have to be cleared,
[Link] [Link]
[Link] [Link]
[Link] [Link]

Before running the service see the below screen shot SOURCE STATUS &
[Link] completed and then input the [Link] - Y/N
Since we have only the testing data's it’s very less than client data’s. To proceed the reverse
process it will take more time to compare. If you wish to continue Press
Y – Comparison of reverse process, it means compares target dump to source dump
N – Skip the reverse process comparison
STEP2: Start the TSM

207 GPACK
 DM Tool – User Guide

Step 3: Start the [Link] service

Start the TSM first and then start the service [Link] in AUTO mode

STEP 4: Start the TSM service

Start the service “[Link]” to compare the data’s

TAFJ
Start the service “[Link]” to compare the data’s

208 GPACK
 DM Tool – User Guide

STEP 5: Check the [Link]

The status can be checked as shown below
LIST [Link] WITH @ID EQ 'SYSTEM' [Link]

209 GPACK
 DM Tool – User Guide

See the below screen shot after completed the dump creation [Link] application is
include the date and completed status

STEP 6: Check the source dump in [Link]/RESULT folder under the [Link]

1. Result dump file will be saved in the below directory.

../ [Link]/[Link]/RESULT

210 GPACK
 DM Tool – User Guide

The dump will be saved in the RESULT path with the ID as [Link] Current
System Date & Time)

211 GPACK
 DM Tool – User Guide

TAFJ:

Result dump file will be saved in the below directory.

../ [Link]/[Link]/RESULT

The dump will be saved in the RESULT path with the ID as [Link] Current
System Date & Time)

212 GPACK
 DM Tool – User Guide

STEP 7: Result files

The result files will be created as,

1) [Link]
2) [Link]
3) [Link]
4) [Link]
5) [Link]

[Link] – The field level mismatches between source and target will be
captured in this file

213 GPACK
 DM Tool – User Guide

TAFJ:

[Link] – The field level and mismatches between source and target will
be captured in this file

214 GPACK
 DM Tool – User Guide

[Link]- The new records in the source environment will be captured in

this file

215 GPACK
 DM Tool – User Guide

[Link] - The new records in the target environment will be captured in this
file

216 GPACK
 DM Tool – User Guide

[Link]- The new record contents in source

environment will be captured in this file

[Link]- The new record contents in target

environment will be captured in this file

TAFJ:
[Link]:

217 GPACK
 DM Tool – User Guide

[Link]

[Link] OBJECT AUDIT BUILD

The prerequisite for T24 Object Audit Automation are as follows.
Check whether below Routines are present in the environment.
The routine creates the records with ID as system date and application name in source
environment. These records are input to create the source dump.
The below routines creates the base file in the Source environment.

✓ [Link]
✓ [Link]
✓ [Link]
✓ [Link]
✓ [Link]
✓ [Link]
✓ [Link]
✓ [Link]

218 GPACK
 DM Tool – User Guide

The below routines creates the base file in target environment.

✓ [Link]
✓ [Link]
✓ [Link]
✓ [Link]
Below routine creates the output dump file, which is comparison of source and target
dump in the target environment.
✓ [Link]
✓ [Link]
✓ [Link]
✓ [Link]

The Object Audit Build tool is developed for all the Local and Core Source.

TAFC:

Create base in source environment

Step 1: Save list creation:
Create a saved list (User defined name) and give the list of BP names.
JED &SAVEDLISTS& [Link]

219 GPACK
 DM Tool – User Guide

Procedure for BASE creation

TAFJ:
Create a saved list (User defined name) and give the jar file folder name.
JED &SAVEDLISTS& [Link]

Create the test3lib under the TAFJ Path and transfer the checked jar in binary mode
t24@localhost:DEV>CREATE-FILE test3lib TYPE=UD

220 GPACK
 DM Tool – User Guide

Step 2: Clear files

Before run the each every service clear below mention file
[Link] [Link]
[Link] [Link]
[Link] [Link]
The inputs required for OAB has to be provided in this record as shown in the below
screenshot.

Step 3: RECORD CREATION

[Link] - The savedlists ID with the selected BP has to be provided in

this field. If not, the build will be created for all the local & core
The BP list has to be provided in the savedlists as shown in the below screenshot,
Browser View:

221 GPACK
 DM Tool – User Guide

222 GPACK
 DM Tool – User Guide

Putty View:

223 GPACK
 DM Tool – User Guide

TAFJ:

Step 4: Start the TSM

224 GPACK
 DM Tool – User Guide

Step 5: Start the [Link] service

To start the TSM first and then start the service [Link] in Auto
mode

Browser View:

225 GPACK
 DM Tool – User Guide

Putty View:

226 GPACK
 DM Tool – User Guide

START THE SERVICE “[Link]” ” to create the dump with the

source provided in savedlists (if savedlists provided) or with all the Bp lists
Step 6: Start the TSM service

TAFJ:

227 GPACK
 DM Tool – User Guide

Step 7: Check the [Link]

The status can be checked as shown below
LIST [Link] WITH @ID EQ 'SYSTEM' [Link]

228 GPACK
 DM Tool – User Guide

Check the [Link] application after completing [Link]

Step 8: Check the source dump in [Link]/SOURCE folder under the [Link]

The Output structure of the base from the Source environment is as follows:

229 GPACK
 DM Tool – User Guide

[Link] source base file will be saved in the below directory.

../ [Link]/[Link]/SOURCE

TAFJ:
../ [Link]/[Link]/SOURCE

The base will be saved in the SOURCE path as [Link] stamped by the
present System DATE & TIME.
To view the source base select the file using the following command in the specified path.

230 GPACK
 DM Tool – User Guide

TAFJ:

231 GPACK
 DM Tool – User Guide

STEP 9: Pack all the records in source environment

Creating base in Target environment

Step 1: Savelist creation:

Create a saved list (User defined name) and give the list of BP names.
JED &SAVEDLISTS& [Link]

232 GPACK
 DM Tool – User Guide

TAFJ:
JED &SAVEDLISTS& [Link]

Procedure for BASE creation

Step 2: Clear files
Before run the each every service clear below mention file

233 GPACK
 DM Tool – User Guide

[Link] [Link]
[Link] [Link]
[Link] [Link]
The inputs required for OAB has to be provided in this record as shown in the below
screenshot.
Step 3: RECORD CREATION
[Link] - The savedlists ID with the selected BP has to be provided in
this field. If not, the build will be created for all the local & core
The BP list has to be provided in the savedlists as shown in the below screenshot,

To start the TSM first and then start the service [Link] in auto
mode

Step 4: Start the TSM

234 GPACK
 DM Tool – User Guide

Step 5: Start the [Link] service

Browser View:

235 GPACK
 DM Tool – User Guide

Putty View:

236 GPACK
 DM Tool – User Guide

START THE SERVICE “[Link]” to create the dump with the source
provided in savedlists (if savedlists provided) or with all the Bp lists
Step 6: Start the TSM service

TAFJ:

237 GPACK
 DM Tool – User Guide

238 GPACK
 DM Tool – User Guide

Step 7: Check the [Link]

The status can be checked as shown below
LIST [Link] WITH @ID EQ 'SYSTEM' [Link]

Check whether the date and status has been updated in [Link]

239 GPACK
 DM Tool – User Guide

Step 8: Check the source dump in [Link]/TARGET folder under the [Link]
The Output structure of the base from the Target environment is as follows:
The target base file will be saved in the below directory.
../ [Link]/[Link]/TARGET

TAFJ:
./TAFJ /[Link]/TARGET

The base will be saved in the TARGET path as [Link] stamped by the
present System DATE & TIME.
To view the source base select the file using the following command in the specified path.

240 GPACK
 DM Tool – User Guide

241 GPACK
 DM Tool – User Guide

TAFJ:
To view the source base select the file using the following command in the specified path.

Comparison between Source base and Target base

Steps to be done for comparison between Source dump and Target dump

Compress the source directory(Base) in the source environment

Move the source base file to ../ [Link]/[Link]/ in the target area.

Step 1: Clear files

Before run the each every service clear below mention file
[Link] [Link]
[Link] [Link]
[Link] [Link]
Step 2: Check the [Link] and [Link] before start the agent
See the below screenshot [Link] AND [Link] is
completed then continue to comparison

242 GPACK
 DM Tool – User Guide

Step 3: Start the TSM

243 GPACK
 DM Tool – User Guide

Step 4: Start the [Link] service

Browser View:
To start the TSM first and then start the service [Link] in AUTO mode

244 GPACK
 DM Tool – User Guide

Putty View:
Start the service “[Link]” to compare the routines

Step 5: Start the TSM service

TAFJ:

245 GPACK
 DM Tool – User Guide

246 GPACK
 DM Tool – User Guide

Step 6: Check the [Link]

The status can be checked as shown below

LIST [Link] WITH @ID EQ 'SYSTEM' [Link]

See the below screen shot after completed the dump creation [Link] application is
include the date and completed status

247 GPACK
 DM Tool – User Guide

Step 7: Check the source dump in [Link]/RESULT folder under the [Link]

The Output structure of the comparison result from the Target environment is as follows:

The output of the comparison will be saved in the below directory.

../ [Link]/[Link]/RESULT

TAFJ:
./TAJ/[Link]/RESULT

STEP 8: Result files

The comparison base will be saved in the RESULT path as [Link]

stamped by the present System DATE & TIME

The comparison result will be saved in 3 different files namely:

1) [Link] (Matched Object Audit)
2) [Link] (Non-Matched Object Audit)
3) [Link] ( new Object Audit)

248 GPACK
 DM Tool – User Guide

TAFJ:

[Link] - It is based on the comparison result between the Source and Target
base. The result contains the matched Contents and also the new routines (routines found in
Source Base and not in Target Base).

All the output files will have the format

<[Link] > [Link]>DD MTH YYYY>HH:MM:SS>NEW>

Where ,<DD MTH YYYY> is the date when the routine was compile Last
<HH:MM:SS>, is the time when the routine was compile Last
<NEW> Applies only when there is a new routine exists and compiled in target
env.

The below is the sample for Matched object audits.

249 GPACK
 DM Tool – User Guide

>
TAFJ:

250 GPACK
 DM Tool – User Guide

[Link] - It is based on the comparison result between the Source and Target
base. The result contains the unmatched Contents. Below is the sample for the unmatched
object audits

251 GPACK
 DM Tool – User Guide

TAFJ:

252 GPACK
 DM Tool – User Guide

[Link] - It is based on the comparison result between the Source and Target base.
The result contains the new routines (routines found in Target Base and not in Source Base).
Below is the sample for the unmatched object audits.

TAFJ:
[Link] - It is based on the comparison result between the Source and Target base.
The result contains the new routines (routines found in Target Base and not in Source Base).
Below is the sample for the unmatched object audits. No new routines in the pack. Hence
blank file generated.

253 GPACK
 DM Tool – User Guide

a. DM Tool Additional Features

i. [Link]

It is data migration reference table for AA Migration. It contains three fields –

DESCRIPTION,
APPLICATION, [Link]. If we want to extract any specific data (field value) from any
valid t24 table, we need to specify the application name and field names for which the values
has to be extracted.

Here you can enter the following fields.

@ID: The ID must be any valid T24 table.

Description: The descriptions of the T24 table.

Application: It specifies the valid T24 table name.

[Link]: It specifies the valid T24 field name for the APPLICATION defined . (Its
multi

value set field).

254 GPACK
 DM Tool – User Guide

ii. [Link]
Description:
The [Link] is a concat table containing arrangement id and proxy
customer id. It is a multi value set. The concat file id must be customer id which provided in
the [Link] record. Before we update the concat file, we need to be
specify the required fields in [Link] (Ref 4.4.1). Based on the reference table it
updates [Link] table.
Functional Process:
The arrangement id and customer id extracted from [Link] table as
based on the certain condition. First select the AA records, if the ACTIVITY field has
‘[Link]-NEW-ARRANGEMENT’ with [Link] has ‘PROXY.
If all the records has the value ‘PROXY’ in field [Link], the corresponding proxy
customer and arrangement id will be updated in concat file.

Sample: [Link] record.

255 GPACK
 DM Tool – User Guide

The file [Link] is built by running the mainline subroutine

[Link] .

This routine will update the [Link] concat table.

256 GPACK
 DM Tool – User Guide

iii. [Link]

The subroutine will be attached as input routine in specified version with creation of PGM .FILE

and [Link] entry. This routine will default the values as ‘[Link]’ in the

fields [Link] and updates the corresponding arrangement id in the [Link] field

in [Link] table (selected from [Link]) . It is

multi value set.

257 GPACK
 DM Tool – User Guide

Prerequisites:

Create the [Link] entry for the [Link]

Create the [Link] entry for the [Link].

258 GPACK
 DM Tool – User Guide

While inputting or Loading the data via this version the specified fields will be defaulted
from the concat table [Link].

259 GPACK
 DM Tool – User Guide

iv. [Link]

Description:

The [Link] table is a concat file containing arrangement id for the

corresponding PROXY CUSTOMER. The arrangement id filed is a multi value set. The concat

file id must be customer id which provided in the [Link] (Proxy)

record. Before we update the concat file, we need to be specify the required fields in

[Link] (Ref 4.4.1). Based on this reference table, it updates the

[Link] table.

Functional Process:

The arrangement id extracted from [Link] table as based on the

certain condition. First select the AA records, if the ACTIVITY field has

260 GPACK
 DM Tool – User Guide

‘[Link]-NEW-ARRANGEMENT’ and update the arrangement id in the concat

table.

Sample: [Link] record.

The [Link] needs to be build by running the program

[Link].

This subroutine will update the [Link] concat table.

261 GPACK
 DM Tool – User Guide

v. [Link]

The subroutine will be attached as input routine in specified version with creation of
[Link]

and [Link] entry. This routine will default the values in the fields ARRANGEMENT from the

concat table [Link] in [Link] table.

Prerequisites

Create the [Link] entry for t he [Link].

262 GPACK
 DM Tool – User Guide

Create the [Link] entry for the [Link].

263 GPACK
 DM Tool – User Guide

While inputting or Loading the data via this version the arrangement id will be defaulted from

the concat table [Link].

264 GPACK
 DM Tool – User Guide

vi. [Link] Load and

[Link] updating

This is used to convert the data file of [Link] into the required utility format file
and

to update the concat File [Link].

Routine Updation

[Link]:

This utility is used to convert the provided data file into [Link] EON

execution format.

Required Input for [Link]:

Steps to be followed for Program execution.

1. Create a directory [Link] in ...[Link] path

2. Enter the path and file name

3. In [Link] directory create a file [Link] and save it

265 GPACK
 DM Tool – User Guide

4. Run the program [Link] it will create a new Data file in [Link].

Expected output
Before Processing [Link] data file in format:

After Processing [Link] data file in format:

266 GPACK
 DM Tool – User Guide

267 GPACK
 DM Tool – User Guide

[Link]

The routine will update the concat file [Link] based on the loaded
[Link] record. It contains the [Link] id with corresponding date
(YYYYMM).

[Link]:

268 GPACK
 DM Tool – User Guide

269 GPACK
 DM Tool – User Guide

Before Processing the [Link]

270 GPACK
 DM Tool – User Guide

Listing [Link] as shown below:

271 GPACK
 DM Tool – User Guide

vii. Data Compare

• Table
[Link]
• Purpose
The scope of the table is to compare both the Extracts and to provide
the output of the comparison.
• Description: The Description for the comparison.
• Compare Type: The field specifies whether to compare environment or file.
• Recon Mapping: The [Link] table record which
will be used for mapping of the reconciliation Extracts.
• Id Key: This field will hold the Primary key (ID) position of the record.
• Legacy File Name: This field is used for information only to store the Legacy
Data Extract.
• Source File Path: The directory Name where the Extract is provided by the
bank.
• Source File Name: The File Name of the Extract provided by the bank.
• Target File Path: The Directory Name where the Recon Extract from T24 is
located.
• Target File Name: The File Name of the Recon Extract from T24.
• Output File Path: The Output File Path where the reconciliation extract is
available after the comparison.
• Output File Name: The Output File name of the reconciliation extract after the
comparison.
• No. Of Agents: The number of agents that will be required to run the
comparison can be
• mentioned in this field.
• Application Name: The application name for the comparison.

272 GPACK
 DM Tool – User Guide

• Field Position.1: This field specifies the position of the field and applicable
only for environment compare.
• Source Field.1: This field specifies the first field of source data file.

Detailed Working Procedure

Verify the record as shown below

273 GPACK
 DM Tool – User Guide

On Verifying you get the below output.

Data File:
In the below source file, the first two string ids are ending with 004,005. But the target file,
the first two string ids are ending with 005,004.
[Link]

[Link]

274 GPACK
 DM Tool – User Guide

[Link] record
Record ID: TEST

Verify the [Link] record

Start the service

275 GPACK
 DM Tool – User Guide

Output:
The source and target new records are created in the separate file.

Source New Records

Target new Records

Mismatch records

• [Link] does one to many comparison.

276 GPACK
 DM Tool – User Guide

In the below source file, the first two string ids are ending with 004,005. But the target file,
the first two string ids are ending with 005,004.

[Link]

[Link]

[Link] record
Record ID: TEST

Verify the [Link] record

277 GPACK
 DM Tool – User Guide

Start the service

The source and target new records are created in the separate file.

Source New Records

Target new Records

278 GPACK
 DM Tool – User Guide

Mismatch records

Mismatch records

[Link] writes the comparison errors in a file.

In the below source file, the first two string ids are ending with 004,005. But the target file,
the first string is in the second position.

[Link]

[Link]

[Link] record
Record ID: TEST

279 GPACK
 DM Tool – User Guide

Verify the [Link] record

Start the service

280 GPACK
 DM Tool – User Guide

The Error log is created.

After updating the error log file, the source and target concat file are clear by the routine.

viii. DM Scheduler
• Table
[Link]
• Purpose
• The services for validating, loading and authorising of Data in T24 is required
to be scheduled and automated. Most of the tasks are manually performed
which needs to be eliminated. The multithread service will perform the tasks
in an automated way to eliminate the manual task to an extent.

• Description: The description of the SCHEDULER.

281 GPACK
 DM Tool – User Guide

• Verification Dss: This field is used to store the [Link]

ID which needs to be completed successfully in order for the current service
to be started.
• Run Status: To indicate whether the service needs to be started or stopped.
The two options available are START and STOP.
• DM Service Id: To store the [Link] ID which needs to be
started. This is a multi-value field.
• Verification: To store the [Link] ID which needs to be
completed successfully in order for the service, associated to the multivalued
set, to be started. This is an associated multi-value field.
• Err Threshold: To specify the maximum number of errors that will be tolerated
before marking the service as failed. This is an associated multi-value field.
• No Of Errors: No input field to update the number of records in error from the
corresponding [Link] after the service is complete. This
is an associated multivalue field.
• Skip Service: To specify if the service needs to be run or can be skipped. The
two options are YES and NO.
• Dsc Status: No input field which will be updated with values 0, 1, 2 or 3 based
on the current status of the service associated with the field DM Service Id.
• Dss Status: No input field which will be updated with values 0, 1, 2 or 3 based
on the current status of all the services in the SCHEDULER.
• Status Detail: No input field which will be updated with some details for
information only.

• Lock Mode - Optional values can be given like JDBC,[Link]. To

specify the Tafj locking mechanism specified in default properties file
([Link]).

282 GPACK
 DM Tool – User Guide

Detailed Working Procedure

Input a Record in [Link].

283 GPACK
 DM Tool – User Guide

Verify the Record.

On verifying the record, we get as below .

On Verifying the DSS, the RUN status becomes Start

284 GPACK
 DM Tool – User Guide

285 GPACK
 DM Tool – User Guide

Data File:

Output:

286 GPACK
 DM Tool – User Guide

Once the Scheduler is completed, the DSS updates with Sceduler Status as
Scheduler [Link] also indicating No of Errors as 0 for both (Positive Test case).

287 GPACK
 DM Tool – User Guide

ix. [Link]
• Table
[Link]
• Purpose
• The data provided by the Client will contain values that correspond to the
Legacy Data Format which cannot be loaded into T24 without any
TRANSLATION. Hence a valid TRANSLATION must be done so that the
Data is converted into a T24 Data format and can be loaded.
• Application: The application for which the TRANSLATION carried out.
• Source Dir: The source directory of the data file consisting of Legacy ID is
provided in this field.
• (Please note that any error log generated from the TRANSLATION will
be available in this directory)
• Source Fname: The Datafile name co
• nsisting of Legacy ID is given.

288 GPACK
 DM Tool – User Guide

• Target Dir: The name of the output directory where the converted file will be
available after the TRANSLATION is over. Any error log generated will be
available as mentioned above.
• By default [Link] is defaulted which can be modified as per the user.
• Target Fname: The name of the converted data file with T24 Ids must be
given here.
• FM Delim: The Field Marker that is used in the datafile to delimit field values.
By default ‘|’ is defaulted which can be modified as per the user.
• VM Delim: The Value Marker that is used in the datafile to delimit field
values. By default ‘::’ is defaulted which can be modified as per the user.
• SM Delim: The Sub Value Marker that is used in the datafile to delimit field
values. By default ‘!!’ is defaulted which can be modified as per the user.
• Mapping Table: Any Concat file name that will be used for the
TRANSLATION can be provided in this field. This is a multivalue field.
• Pos Convert: The positions in the data file where the TRANSLATION has to
be done and replaced with T24 Ids. This is a sub value field associated with
Mapping Table field.
• Pos Value: fixed values change the position in the data file where the
TRANSLATION has to be done and replaced the fixed value. This is an
associated sub value set with Pos Check field.
• Pos Routine: A subroutine can be attached to this field that will be used for
TRANSLATION logic. This is an associated sub value set with Pos Check
field.
• No. Of Service: The number of agents that will be required to run the
TRANSLATION can be mentioned in this field.

Detailed Working Procedure

Input a record.

289 GPACK
 DM Tool – User Guide

Verify the record as shown below.

Data file in which the translation has to be done:

290 GPACK
 DM Tool – User Guide

Output

Thus any changes that are to be done in the data file can me made through this table.

x. Handling BYTE Length in ORD

• When loading the UTF converted data file or data file which consists of
more than 1024 characters, there should not be any broken records in
[Link] which means there is no breakage of record
into 2.

Verifying DSC to start the service:

Start the service

291 GPACK
 DM Tool – User Guide

After starting the service, while listing the [Link], it is found there is
no breakage of record even it consists of special characters or more than 1024
characters.

In the above screenshots, it is found that there is no truncation of record even if there
is special characters or more than 1024 characters.

292 GPACK
 DM Tool – User Guide

xi. [Link]
Balances can be extracted for Reconciliation Purpose using the routine
[Link].
Execution:

OUTPUT File:

Sample Output:

293 GPACK
 DM Tool – User Guide

xii. [Link]

It is possible to extract the Schedules for Reconciliation Purpose

Execution:

OUTPUT File:

Sample Output:

294 GPACK
 DM Tool – User Guide

xiii. [Link]

[Link] can be done via DSC and also it checks for the updation of
[Link] and [Link].

It also checks the ID format for Data capture like Number of characters, prefixed with
DC and the current Julian Date in T24

DSC record:

After verifying DSC, there are no errors

[Link] and [Link] records are updated

accordingly,

295 GPACK
 DM Tool – User Guide

If the batch already exist in the environment then the below error will throw

xiv. Mnemonic duplication:

On loading the file, if there are any duplication of mnemonic it would be captured and
error message will be created for the same.

Starting the [Link]

296 GPACK
 DM Tool – User Guide

Error log is created in the respective path for Mnemonic Duplication.

Error Detail is displayed in the below mentioned screenshot.

297 GPACK
 DM Tool – User Guide

xv. AA - Product Proofing and Publishing

During AA load. Suppose if the AA product is proofed and not published, error log is
created.

[Link] record shows that the product [Link] is in proofed

status.

298 GPACK
 DM Tool – User Guide

After running the service, if in the data file the product used is
[Link] then error log is created as shown below.

xvi. [Link]
It is a program which is used to extract all the fields and properties of any table given in
the saved list.

Create the savedlists by entering the name of a specific application.

299 GPACK
 DM Tool – User Guide

Please logout and login to T24 before running the routine.

At the jshell prompt run the routine [Link].

The save list name must be entered in the below.

Once the savedlists name is given, it will extract the field properties of that application and
also it will get stored in the [Link] directory in the format of .xls.

A sample excel (output) file generated is attached below

300 GPACK
 DM Tool – User Guide

xvii. ENQUIRY [Link]

The purpose of the ENQUIRY [Link] is to get the number of error,
number of records validated and the error details of the load process.

To run the enquiry

Selection Criteria

Output of the selection showing number of error, number of records validated and the
error details

xviii. UTF8 conversion

The UTF8 conversion of data file for swift character handling has to be incorporated in
generic DM Tool.

301 GPACK
 DM Tool – User Guide

The data file with Arabic character.

The above data file should be in [Link] folder.

The DMP will be created and verified as below

302 GPACK
 DM Tool – User Guide

After verifying the DMP we need to specify the value ‘Yes’ for converting the data file and the
converted data file is generated in same path.

303 GPACK
 DM Tool – User Guide

After converting the data file.

xix. [Link]
1. The purpose of the routine is to clean up the existing DMD'S, DSC'S, TSA’s
([Link]) and BATCH records related to DM SERVICE and
VERSIONS and The lib & bin files (GR0800005bin, GR0800005lib) and
[Link] and [Link] folders are decataloged and deleted
2. For this we need to run program [Link].

Prerequisites

To export the corresponding LIB and BIN :

export JBCDEV_LIB=GR0800005lib

304 GPACK
 DM Tool – User Guide

[Link] process flow:

• This routine [Link] has to be run after export the LIB and BIN.

• Run the routine, it has been read the DMD and get the version ID from the
DMD ([Link]).

• Then read version record and get the [Link], based on the [Link] the
record will be delete the Version’s LIVE NAU and HISTORY path.

• [Link] and [Link] routines get decataloged and the folder get deleted.

• The LIB and BIN folders get deleted.

Record count before run the routine

305 GPACK
 DM Tool – User Guide

Clean-up Process:

306 GPACK
 DM Tool – User Guide

307 GPACK
 DM Tool – User Guide

[Link]:
Thus the document explaining the functionality of a non -core T24™ Data Migration Tool that
is used for Data extract from T24 Load into T24 from any Client system. This could be used
as a base for using Data Migration tool in any T24 data Extract & Load process.

308 GPACK