Raw Price Checker FAQ & User Documentation

Application Usage

• Accessing the Settings Menu

  There are two methods to open the Settings menu:

  Method 1 – Using an Unlock Barcode

  1. Encode your passcode in Code 128 format.
  2. Scan the generated barcode as you would any other item.
  3. The application will open the Settings menu immediately.

  Method 2 – Tap Gesture Unlock

  1. Quickly tap the Scan Barcode icon 7 times in succession.
  2. When prompted, enter your passcode.
  3. Tap the Scan Barcode icon once more to reveal the Settings menu.

  Default Passcode: The passcode field is empty by default. Simply click Unlock.

  For security, set a passcode in Settings and optionally create a Code 128 unlock barcode.

• Preventing Users from Exiting the App

  To ensure the application cannot be closed by unauthorized users, run it in lockdown mode using a kiosk software.

  We recommend Fully Single App Kiosk (www.fully-kiosk.com) for Android devices.

• Auto-Starting the Application

  The method for auto-starting the app is the same as for lockdown mode. Fully Single App Kiosk allows you to configure the application to launch automatically when the device is powered on.

• Internet Connection Requirements

  An active internet connection is not required for normal use. The application connects directly to your L-Boss MSSQL database over the local network.

  Internet access is only required once for license activation.

• Application Configuration

  To configure the app:

  1. Access the Settings menu (see 1.1 above).
  2. Adjust the available parameters:

  Parameter	Description
  MS SQL IP Address	The IP address of the MSSQL server
  MS SQL Port	TCP port number for the MSSQL instance
  Database Name	Name of the database
  Database Username	Database access username
  Database Password	Database access password
  Unlock PIN	Passcode for Settings menu (default empty)
  Barcode Prefix	Optional prefix for scanned barcodes. Example: If Prefix is set to 0, a scanned barcode like 1234567890123 will be treated as 01234567890123.
  Padding for Missing Digits	Character used to pad barcodes under 13 digits. Example: If Padding is set to 0 and a barcode 12345 is scanned, the app treats it as 000000012345 (for 13-digit EAN).
  Currency Symbol	Symbol displayed before price. Example: If Currency is set to CA$ , a price of 9.99 will be displayed as CA$ 9.99. Note the space is not added automatically.
  Timeout	Duration in seconds that a price is displayed before returning to the Scan prompt
  Logo Path	File path to the logo image
  Primary Colour	Main interface colour in HEX
  Secondary Colour	Accent colour in HEX
  License Activation	License key entry

• Configuring the Barcode Reader
  1. Connect the scanner to the device (USB or BT) if it is not build into the kiosk.
  2. If required, scan the manufacturer’s configuration barcodes to:
     • Set the scanner to Keyboard Input mode.
     • Use Enter as the end-of-input marker.
• Finding the Correct MSSQL Port

  If you do not know your MSSQL port:

  1. 1. Run the following PowerShell command on the MSSQL server. You will be provided with a few ports that the server uses.

     Method 1:

     Get-NetTCPConnection -State Listen | Where-Object {  
     
         (Get-Process -Id $_.OwningProcess).ProcessName -eq "sqlservr" 
     
     } | Select-Object -ExpandProperty LocalPort 
     
     

     Method 2:

     $base = 'HKLM:SOFTWAREMicrosoftMicrosoft SQL Server'
     
     $instances = Get-ItemProperty "$baseInstance NamesSQL"
     
     $rows = foreach ($p in $instances.PSObject.Properties) {
     $instanceName = $p.Name
     $instanceId = $p.Value
     $ipAllKey = "$base$instanceIdMSSQLServerSuperSocketNetLibTcpIPAll"
     $props = Get-ItemProperty $ipAllKey
     $staticPort = $props.TcpPort
     $dynPorts = $props.TcpDynamicPorts
     [pscustomobject]@{
     Instance = $instanceName
     Port = if ($staticPort) { $staticPort } else { $dynPorts }
     }
     }
     $rows | Format-Table -AutoSize
     

  2. Enter the port numbers from step 1 & Database, Username, etc into the Port Finder The Port Finder tool has a Magnifying glass icon & accessible from the settings page.
  3. Click on Scan Ports.
  4. After a few minutes, the tool will list the port that is open. This is the correct port.

  5.