TSP Lab Sga-CellSMS_DB - The Cell SMS Database module Sga-CellSMS_DB

The Cell SMS Database module
("Sga-CellSMS_DB")

Table of Contents

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)
[Actions]      
  Go on / Pause (Ctrl+P or ) Enables input data processing
  Re-enter client password   The password used for authentication can be re-entered
  Flush counters   Writes status line counters into the log
  Flush & reset counters   Writes the counters into the log and zeroes them
  Re-load cell names   Reloads cell names file
  Save PerCell list, excl. 4G cells.   Generates cell usage statistics, excluding 4G cells
  Save PerCell list, incl. 4G cells.   Generates cell usage statistics, including 4G cells
  Re-load IMSI prefix names   Reloads IMSI prefix names list
  Re-load operator prefix names   Reloads operator prefix names list
  Re-load ECI −−−> LAC table   Reloads ECI −−−> LAC conversion table
  Check all these tables above...   ... for last 1/3/10/30/all days
  Save in-memory IMSI records   Dumps records from memory into a backup file
  Drop old in-memory IMSI records   currently not available option
  Drop very old in-memory IMSI records   currently not available option
  DEBUG: list in-memory IMSI records (first few)   Dumps records from memory onto the screen (and the log file)
[Options]      
  Auto scroll () Allow automatic scrolling of the log screen
  Save settings   Save settings into INI file

The bottom status-line

Configuration (Sga-CellSMS_DB.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 added
[Subscribers in memory]      
  dwIMSIMaxCount 6000000 Size of IMSI memory
  dwPeriodicBackupSec 900 Time period of regular IMSI record backup
  sPeriodicBackupPath d:\Backup Path for IMSI record backup files
  wLocalTCPPort 9010 Local TCP port for current location information qeuries (single)
  sClientPassword pwd Client password for current location information qeuries (if it is not given then it can be defined on the GUI)
[Kat-SMS query]      
  wLocalTCPPort 9019 Local TCP port for current location information qeuries (mass)
  sTemporaryFilesPath = c:\GyCellInfoDB\TempFolderForKatSMS d:\Backup Path for temp files
[PerCell list]      
  dwMaxTimeBehindSec 11400 ...
  sOutputFileName d:\PerCellList\PerCellList.csv Path and name of cell usage list file triggered by operator on GUI
  dwPeriodicOutputSec 900 Time period of cell usage list generation
  sPeriodicOutputPath d:\PerCellList_Periodic Path for periodic cell usage list files
  bPeriodicOutputIncludes4Gcells True Whether periodic cell usage list would contain 4G cells (True) or not (False)
[PerCell query files]      
  dwPeriodicInputCheckingSec 10 Time period for checking PerCell query files
  sInputPath d:\PS_QueryInputFolder Path for input query files
  sOutputPath d:\PS_QueryOutputFolder Path for result files
  sECILACtableFile ECI_LAC_table.csv Defines ECA-LAC table file
  sIMSIPrefFile IMSIPref.lst Path and name of the IMSI prefix file
  sOpPrefFile OpPref.lst Path and name of the operator prefix file
[Output DAT files]      
  wOutFilePeriod 15 Defines period of CDR files
  dwOutFileUseCrypto 1 Enables encryption of CDR files; 0 means 'off', any other value means 'on'.
  byOutFilePathModulo 3 Defines the number of CDR file destinations
  sOutFilePathPrimary_N e:\CDR\ Path(s) for CDR files. As many path should be defined as the value of byOutFilePathModulo.
N runs from 0 to byOutFilePathModulo-1.
  dwOutFilePreallocationSize 500000000 Preallocated size of CDR files, in bytes
  sOutFilePathAlternate g:\CDR_alternate\ Alternative path for location information CDRs when sOutFilePathPrimary_N is inaccessible.
[Output INDEX files]      
  byOutFilePathModulo 3 Defines the number of index file destinations
  sOutFilePathPrimary_N e:\CDR\ Path(s) for index files. As many path should be defined as the value of [Output INDEX files] / byOutFilePathModulo.
N runs from 0 to byOutFilePathModulo-1.
  dwOutFilePreallocationSize 500000000 Preallocated size of index files, in bytes
[Advanced]      
  wLogDetailLevel 3 (Equals to the listed order; refer to the [Log]/Details menu item!)
  wMaxCPUUsagePercent 90 Limit for CPU usage
  dwMaxLinesInLogWindow 500 Number of lines in the log window on screen
  sCellNamesFile CellNames.csv Path and filename of CellNames.csv file
  sLogFilesPath D:\LogFiles\ Path of directory of log files
[Friendly IMSIs]      
  216301234123455F someone ...

Version history