EPOS

 
RTStoreService.exe
Installation and Reference

 


This Comtrex Real Time Store Service is intended to be installed only by Comtrex installation and support personnel.
 
The Comtrex Real Time Store Service periodically reads the local store database and extracts the sales and counts so far for the sales day. This data is sent via TCP/IP to RTData Service running on a Comtrex Server which in turn stores the data in a SQL Express database. This data can then be viewed via the web by brand owners or possibly store owners.
 

 
Mandatory Installation Prerequisites
  1. Get a "Brand ID" number from engineering and confirm with engineering that the central SQL Express database has been updated with the new Brand ID.
  2. Get a User Name and Password for the brand from engineering.
  3. Get a Store Tag (store number) for the store from engineering.
  4. Get a Store Name for the store from engineering.
Installation Instructions
  1. These instructions are assuming you are logged on to, and performing this installation from the actual target machine.
  2. Installation should be on the PC that is hosting the Odyssey databases.
  3. If RTStoreService is already installed, perform the following steps.
    • Administrative Tools > Services > Stop "Comtrex Real Time Service".
    • Control Panel > Add Remove Programs > Remove "RTStoreService".
  4. Click on the installation link below to run or download (ftp) the installation program.
    • If downloading, download it to any temporary directory on your C: drive.
    • If running directly, ignore the security warning.
  5. If you downloaded "RTStoreServiceSetup.msi", execute it to start the installation.
  6. After installation, delete downloaded file "RTStoreServiceSetup.msi".
Installation Followup
Important: Make sure you complete the following steps right away.

 
Cautionary Note!
Support personel will take note that this installation could be performed on a (32 bit) or (64 bit) version of Microsoft Windows. Please pay special attention to the instructions below as the correct choice has to be made. If you are unsure, go to "Control Panel > System" and check the system type. If you do not see a reference to 64 bit, it is probably 32 bit.
  1. Update the registry using regedit.exe. Registry entries required are listed below. The entries in yellow are manditory. You will find the registry entries under one of the following registry keys depending on whether your server is (32 bit) or (64 bit).
    • (32 bit) [HKEY_LOCAL_MACHINE\SOFTWARE\Comtrex Systems\RTStoreService]
    • (64 bit) [HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Comtrex Systems\RTStoreService]
       
      Value NameValue DataDescription
      AccessDatabasePathC:\icom\databaseThis should not be edited normally.
      IntervalMinutes15This is a good compromise. Do not enter less than five (5) minutes.
      BrandID1Replace this with the Brand ID you obtained from engineering.
      StoreTagCX9999Replace this with the Store Tag (number) you obtained from engineering.
      StoreNameStore Name HereReplace this with the Store Name you obtained from engineering.
      RTServerURLrtservice.comtrex.comThis would only be edited if the customer had installed the central software on their own computer.
      RTServerPort5649This should not be changed without direction from engineering.
  2. Go to Administrative Tools --> Services. Find "Comtrex Real Time Store Service" and start the service.
  3. Update BackOffice to force a transmission of totals prior to performing EOD.
    This will initiate an immediate transfer of the current totals. This will prevent the possibility of POS Operators entering transactions, then the BackOffice User performing an end-of-day between transmission of totals every fifteen minutes.
    1. Add two procedures to the end of day routine on the two lines immediately preceeding the clearing of the POS totals. [Usually this procedure is "Access_ClosePOS".] The procedure is entered without the parentheses.
    2. On the immediately preceding two lines, under the column "Application EXE" enter "Access RTStoreService.exe -s" (Do not enter the parentheses); then “Access StopRTStoreService.bat” (Do not enter the paraentheses).
    3. On the same two lines, under the column "Application Path" enter the appropriate path first for the RTStoreService.exe, then for the batch file. If you are unsure which of the following two paths below [for the RTStoreService.exe program] to enter, use Windows Explorer to find the newly created "RTStoreService" directory, and note the full path name. (Do not enter the parentheses).
      • (32 bit) "C:\Program Files\Comtrex Systems\RTStoreService\"
      • (64 bit) "C:\Program Files (x86)\Comtrex Systems\RTStoreService\"
    4. The file listed on the second line (StopRTStoreService.bat) should contain only one line, “net stop RTStoreService” (Do not enter the parentheses). You may locate the batch file in any folder, such as c:\icom\pos2100. Place the folder name under the column “Application Path”
    5. Add another, similar, procedure on the line immediately following the procedure line which clears the POS totals. Under the column “Application EXE” enter “Access StartRTStoreService.bat” (Do not enter the parentheses).
    6. The file StartRTStoreService.bat should contain only one line, “net start RTStoreService” (Do not enter the parentheses). You may locate the batch file in any folder, such as c:\icom\pos2100. Place the folder name under the column “Application Path”
  4. That completes the installation. There should already be data on the RTData Server to view for this new store. See below the URL for viewing the data to verify all is working correctly.
Installation Reference
  1. The URL for viewing real time data. A user name and password is required. This is the user/pass obtained from engineering.
  2. Files and Folders created, installed or updated by this installation.
    • C:\icom\database
      • DataTickler.mdb - Only used with 'Access' database in store.
        The RTStoreService runs the "GetAllRTCStuff" view/query from this database to obtain the counts and amounts that are transmitted to the upstream RTData Server.
    • (32 bit) C:\Program Files\Comtrex Systems\RTStoreService
      (64 bit) C:\Program Files (x86)\Comtrex Systems\RTStoreService
      • RTStoreService.exe - Windows Service.
      • LogFiles - Folder with daily log files.
      • Misc. install/uninstall support files.







 
Page last updated: June 20, 2023