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

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

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: 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