TSP Lab	Sga-BSSAP OraLoader/TMSI - Lister	SgaBSSAPOraLoaderTMSI_Lister

Sga-BSSAP OraLoader/TMSI - Lister
`("SgaBSSAPOraLoaderTMSI_Lister")`

Basic Operation

Periodically scans the working directory for Sga-700T.xxx files, created by the SgaBSSAPCDR module
Historically lists the TMSI-IMSI associations and their timestamps
Prepares Oracle Loader files (CTL) to load the associations into an Oracle database

User Interface

The main menu

Menu	Menuitem	Shortcut(s)	Meaning
[Log]
	Find line containing...	(Ctrl-F)	Finds text in log window
	Find next matching line	(F3)	Finds next occurrence of text in log window
	Details		Detail level of logging (Off, Normal, Detailed or Debug)
[Actions]
	Go on/Pause processing	(CTRL-P or )	Allows/Prohibits processing of Sga-700T.xxx files
[Options]
	Auto scroll	(ScrollLock, or )	Allows automatic scrolling of the log screen
	Save settings		Saves actual settings into the configuration (`SgaBSSAPOraLoaderTMSI_Lister.ini`) file

The bottom status-line

Uptime: time elapsed since module has been started up.
Status of program (Idle, Loading...).
IN file: Name of actual input Sga-700T.xxx file being processed
Number of records processed last / total.

Configuration (`SgaBSSAPOraLoaderTMSI_Lister.ini`) file settings

Section	Entry	Example	Meaning
[Position]
	iLeft	132	Position of the program module on the display screen
	iTop	132	Position of the program module on the display screen
	iWidth	768	Position of the program module on the display screen
	iHeight	558	Position of the program module on the display screen
[Options]
	bAutoScroll	True	(Refer to the `[Options]/Auto scroll` menuitem!)
[CTL Files]
	sPath	D:\SGA\Sga-BSSAP OraLoader\OraLoader_CTLfiles	Path for the CTL Oracle loader files
	dwNextFileID	1969	Identification number of the next CTL file. Default value is 1.
	dwMaxEntryCount	1000	Maximum number of entries a CTL file can contain. Default value is 100.
	dwFlushPeriod	30	Output file will be flushed after this time even if less than `dwMaxEntryCount` records have been collected. Default value is 15.
	sFileNamePostFix	_SgaPC9	This prefix will be added to the CTL filename
[Advanced]
	wLogDetailLevel	3	(Equals to the listed order; refer to the `[LOG]/Details menuitem!)`
	wMaxCPUUsagePercent	93	Limit of CPU-usage for this module
	dwMaxLinesInLogWindow	1000	Number of lines in the log window on screen
	sLogFilesPath	d:\LogFiles	Path for the LOG files

Version history

SgaBSSAPOraLoaderTMSI_Lister.exe

v1.24

(c) Handles Sga-700T.xxx data from "CDR Assembler v1.24" as well. (PART field)

v1.00

(n) Brand-new application

Other modules

Sga-BSSAP CDR - UpdateTMSIBackup112

Converts the TMSI based IMSI memory savings into SgaBSSAPCDR v1.12 compatible format
It has to be executed only once at each sites

Sga-BSSAP OraLoader/TMSI_ConvertCDRBackup

v0.90

Generates a Sga-700T.xxx file from CDR backup
It is recommended to run before starting SgaBSSAPCDR program to make a total projection of IMSI-TMSI association
It has to be executed only once at each sites