TSP Lab	SgaUTI_DBLoader - Universal Traffic Information Provider Database Loader	SgaUTI_DBLoader

Universal Traffic Information Provider Database Loader
`("SgaUTI_DBLoader")`

Goal

Data stream loading to ITIS Dispatcher.

Basic operation

Reads intermediate data files (Sga-9004.xxx) generated by SgaUTI_Poller module
Collects and integrates BSSAP CDR information
Provides system status information for SgaUTI_StatusRequester module
Sends alarms of system events to the Network Operation Centre
Write log records into log file about system events

User's Interface

Main screen

After starting the program main window appears:

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)
[Dispatcher]
	Go on/pause processing	(Ctrl-P, or )	Enable/disable processing
	Disconnect DataStream now!		Disconnect data stream interface to Dispatcher module
[Options]
	Auto scroll	()	Allow automatic scrolling of the log screen
	Save settings		Save settings into INI file

The bottom status-line

System status information
IN file: <<name of input file being processed>>
Records read/sent last, total: number of read and sent records of last file and total after system start-up
Time elapsed from last start of program
Connection status
DispatcherDataStream: Records read/sent last/total: number of read and sent records of last file and total after system start-up
Bytes sent/received total: number of total sent and received bytes to/from Dispatcher

Details about data being loaded

Location Events Message is being sent

Currently Location Event - Including Event Type messages are being sent.

Event messages are sent in the data feed

The Event Type Field Values and the descriptions of the events to be sent:

0 - Handover
1 - SMS Originate
2 - SMS Terminate
3 - Call Initiation
4 - Normal Location Update
5 - Periodic Location Update
255 - Other

In the current implementation of the Monitoring System all BSSAP MSU's containing CellID(s) that can be related to a certain call are transferred (with depersonalization, of course) to the ITIS dispatcher, having the Event Type Field Value set as shown above.

Configuration (`SgaUTI_DBLoader.ini`) file settings

This file has to be placed in the same directory as the executable file placed!
Program saves the actual settings selecting Options/Save settings menu item.

Section	Entry	Example	Meaning
[Position]
	iLeft	132	The initial horizontal position of the Main screen, in pixel
	iTop	132	The initial vertical position of the Main screen, in pixel
	iWidth	770	The initial width of the Main screen, in pixel
	iHeight	558	The initial height of the Main screen, in pixel
[Options]
	bAutoScroll	True	If True, log list automatically scrolls to the last line, when a new item inserted
[Dispatcher / StatusStream]
	wLocalTCPPort	9100	The local port to connection of SgaUTI_StatusRequester
[Dispatcher / DataStream]
	sRemoteIPAddress	127.0.0.1	The Dispatcher's IP address
	wRemoteTCPPort	9104	The remote port of Dispatcher
	wSecondsToWaitBetweenConnectionTrials	3	The seconds between each trials of connecting to Dispatcher
	wSecondsToWaitBeforeReconnecting	3	The seconds before first trial of reconnecting to Dispatcher after the connection cut
[Advanced]
	dwLogLevel	3	(Equals to the listed order; refer to the [Log]/Details menu item!)
	wMaxCPUUsagePercent	69	Maximum allowed usage of CPU in percentage by this application
	dwMaxLinesInLogWindow	500	Number of lines in the log window on screen
	dwNoRecordTrapTimeout	15	This time (in seconds) has to elapse without any record receiving to send error message about
	sLogFilesPath	D:\SGA\Sga-UTI\Log	Path of directory of log files
	sTrapFilesPath	D:\SGA\Sga-UTI\Trap	Path of directory of trap files

Sample of INI (`SgaUTI_DBLoader.ini`) file

[Position]
iLeft=123
iTop=69
iWidth=1080
iHeight=750

[Options]
bAutoScroll=True

[Dispatcher / StatusStream]
; entry is loaded at start-up
wLocalTCPPort=9100

[Dispatcher / DataStream]
; entries are (re)loaded on-the-fly
sRemoteIPAddress=127.0.0.1
wRemoteTCPPort=9104
wSecondsToWaitBetweenConnectionTrials=3
wSecondsToWaitBeforeReconnecting=9

[Advanced]
wLogDetailLevel=3
wMaxCPUUsagePercent=69
dwMaxLinesInLogWindow=1000
dwNoRecordTrapTimeout=15
sLogFilesPath=D:\SGA\Sga-UTI\Log
sTrapFilesPath=D:\SGA\Sga-UTI\Trap

Universal Traffic Information Provider Database Loader("SgaUTI_DBLoader")