POS – Mini Market (VB) Installation Guide

Owned by l (Unlicensed)
Last updated: 2015-Aug-20 by Thirisaah A/P G. Noel Emile (Unlicensed)
4 min read

Note : If the PC already has MySQL and previous version’s Thick Client installed, you might want to remove them and start fresh

1. Uninstall MySQL Server
  • go to Control Panel > Programs and Features, uninstall MySQL Server
  • go to C:/Program File, remove the MySQL Server folder
  • go to Control Panel > Administrator Tools > Services, stop the MySQL Server
  • now, to remove MySQL service
  • Click Start and type CMD in the Start search box
  • Right click on CMD in the list and click on "*Run as administrator*"
  • Type sc delete MySQL
  • will then prompt DeleteService SUCCESS
  • restart the PC now
2. Uninstall Thick Client
  • go to Control Panel > Programs and Features, uninstall Thick Client

Required components to set up POS.

  • Microsoft .NET Framework 3.5 (You can skip this step. As Windows 7 should already come with .Net Framework installed. When you install Thick Client later on, if this is not installed yet, it will prompt you for the installation through the net)
  • MySQL
  • MySQL Tools for 5.0
  • ThickClientSetup.zip (attached below this page)
  • Minimum 150Mb of free space

1. If you are running any other operating system than Windows Vista, kindly ensure that you have Microsoft .NET Framework 3.5 installed. This is a redistributable software and can be downloaded directly from Microsoft.

2. Once your computer is installed with Microsoft .NET Framework 3.5, you will need to download and install the following:

Installing MySQL
  • Run the installation mysql-5.0.51b-win32.exe
  • Click Next
  • Select Complete, and click Next. Proceed to click Install
  • Proceed to clicking Next until you have reached a prompt where Configure MySQL Server Now (Should be automatically ticked)
  • Click Finish

Configuring MySQL (Please wait awhile until the next prompter appears. If it doesn’t pop up, go to All Programs -> MySQL -> MySQL Server 5.0 -> MySQL Server Instance Config Wizard)

  • Click Next
  • Select Detailed Configuration and click Next
  • Select Dedicated MySQL Server Machine and click Next
  • Select Multifunctional Database and click Next
  • It is recommended that the drive and directory be left as default, which will show you C:Installation Path, click Next
  • Select Decision Support (DSS)/ OLAP and click Next
  • Ensure that both TCP/IP Networking and Strict Mode are enabled. The port number is recommended to be left as default. Click Next
  • Select Best Support For Multilingualism and click Next
  • Ensure that Install As Windows Service is enabled and the Service Name should be MySQL. Also, ensure that Launch the MySQL Server automaticallyis enabled. Click Next
  • Ensure that Modify Security Settings is ticked. Key in the Root password as root and retype root in the column below. Ignore Enable Root Access from Remote Machines. Click Next
  • Click Execute
  • When Processing Configuration is running, please check if all configurations are ticked :
  • Configuration file created
  • Windows service MySQL installed
  • Service started successfully
  • Security settings applied

Click Finish

Installing MySQL Tools for 5.0

  • Run the installation file mysql-gui-tools-5.0-r17-win32.exe
  • Click Next
  • Should you agree with the license agreement, select I accept the terms in the license agreement and click Next
  • Destination Folder – Click Next to install to this folder or click change to install to different folder
  • Click Next
  • Select Complete and click Next
  • Click Install
  • Followed by Finish

Installing the Point Of Sales

  • Download the POS program here
  • Click Next
  • To install in this folder, click Next. To install to a different folder, click Browse. Then, click Next
  • Click Next to start installation.
  • Click Close

Set up Data or Memory size of MySQL

  • Go to windows - Start > MySQL > MySQL Administrator (IMPORTANT: right click > Run as administrator)
  • Just ignore Stored Connection.
  • Ensure that the name for Server Host is stated as localhost, user name should be root, and key in the password you have entered before when Configuring MySQL (referring above is wavelet). Click OK
  • Click Startup Variables > Advanced Networking tab
  • At Data / Memory size section > check Max packet size and key in 1000*M . Check *Net buffer length and key in *1000*K.
  • Click Apply changes
  • Click Service Control
  • Click Stop Service
  • After server was stopped, click Start Service
  • Exit

First Time Open POS (setting up of the wsemp database)

  • Click on ThickClient Launcher (on your desktop) or Go to C:\Program Files > Wavelet > ThickClient > ThickClient.exe (IMPORTANT: right click > Run as administrator)
  • The Thick Client Installation will appear > Click Next
  • The ‘Application is successfully installed.’ will shown > Click OK
  • Login – Username: Developer, Password: wavelet
  • Configuration > click Import and Export Tab
  • Go to EMP server to Export Master Data file (see below - How to export from EMP)**
  • Go back to the POS, at Import Master Data from EMP > click Browse, select the import file that you exported from EMP
  • Click Import > Please wait until finish > popup success message
  • Click OK to Exit POS Configuration
  • Login again to use the POS.

**How to export from EMP

At EMP Server > Trading > Thick Client Management > Export Master Data > click Export

To check if a database exists

  • Open MySQL Administrator
  • Login
  • Click Catalogs
  • Select wsemp to view all tables of wsemp schema.

Open POS

  • Click on ThickClient Launcher (on your desktop)
  • Login – The username and password are the same as in EMP.
  • Username : XXX
  • Password : YYY

Linking the POS to EMP Server

VERY IMPORTANT:
Download both:
xstream-1.3.jar
xpp3_min-1.1.4c.jar

and copy these files into the /usr/java/jboss-4.0.1RC2/server/default/lib/ directory as the root user on the EMP server (e.g. test.wavelet.biz).

  • Open POS by double clicking ThickClient Launcher on desktop.
  • Go to Configuration > Synchronization > Web Services, enter http://cloud.wavelet.biz/demo-ws/EMPThickClientService?wsdl
  • Click on "*Download Now*" button, to synchronize all master data from EMP server’s database into the POS. Example : Item codes, Stock balance and Pricing.
  • Click Start

NOTE: If you encounter Password Error 1045 during the above steps and Error messages show "Access denied for user 'root'@'localhost'(using password:YES)":

You may go to Start > MySQL Command Client and:

1. Hit 'Enter' (or if it does not work, try typing 'wavelet' before hitting Enter)
2. Key in the following command:

set password for 'root'@'localhost' = password('root')\g

3. Hit Enter
4. Key in exit and hit enter again.
5. Re-do whatever it was you were trying to do.

HOW TO DELETE THE TXN AND START NEW
1. Go to MySQL admin
2. password: root
3. click "Catalogs" 
4. Right click on the "WSEMP" 
5. Select "Drop Schema" 
6. and click yes
After the txn deleted, just run the Jimmy Pos to start new txn

Also available in: PDF HTML TXT

Private & Confidential