Versions Compared

Version Old Version 2 New Version 3
Changes made by

l (Unlicensed)

l (Unlicensed)

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Info

If the PC already has MySQL and previous version’s Thick Client installed, you might want to remove them and restart.

1. Uninstall MySQL Server 

  • go to Control Panel > Programs and Features, uninstall MySQL uninstall “MySQL Server”
  • go to Cto “C:/Program File”, remove the MySQL the “MySQL Server folderfolder”
  • go to Control Panel > Administrator Tools > Services, stop the MySQL Serverthe “MySQL Server”
  • now, to remove MySQL serviceClick Start and type CMD“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 Clientuninstall “Thick Client”
  • Required components to set up POS.

...

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

...

Info

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 NextClick “‘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 Cyou “C:Installation PathPath”, click Next
  • Select Decision Select “Decision Support (DSS)/ OLAP and click NextOLAP” and click “Next”
  • Ensure that both TCPboth “TCP/IP Networking and Strict Mode are 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 Click “Next”
  • Select “Best Support For Multilingualism” and click “Next”
  • Ensure that “Install As Windows Service” is enabled and the Service Name should be MySQLbe “MySQL”. Also, ensure that Launch that “Launch the MySQL Server automatically is automatically” is enabled. Click Next“Next”
  • Ensure that Modify Security Settings is that “Modify Security Settings” is ticked. 
  • Key in the Root password as root and retype root in as “root” and retype “root” in the column below. Ignore Enable  
    • Ignore “Enable Root Access from Remote
    Machines
    • Machines”.
    Click NextClick Execute
    • 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 FinishClick “Finish”

Installing MySQL Tools for 5.0

  • Run the installation file mysql-gui-tools-5.0-r17-win32.exe
  • Click NextClick “Next”
  • Should you agree with the license agreement, select  
    •  select  “I accept the terms in the license
    agreement
    • agreement” and click Next
  • Destination Folder – 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 FinishClick “Next”
  • Select “Complete” and click “Next”
  • Click “Install”
  • Click “Finish”

Installing the Point Of Sales

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

Set up Data or Memory size of MySQL

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

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

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

Open 'MySQL AdministratorTo check if a database exists'

  • Login
  • Click Click "Catalogs"
  • Select Select "wsemp" to view all tables of wsemp schema.

Open POS

  • Click on on "ThickClient Launcher" (on your desktop)
  • Login – The username and password are the same as in EMP.

...

After download, copy these files into the /usr/java/jboss-4.0.1RC2/server/default/lib/ directory as the root user on the EMP server 

  • Open POS by double clicking clicking "ThickClient Launcher" on desktop.
  • Go to Configuration > Synchronization > Web 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 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:

...

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
  7. After the txn deleted, just run the Jimmy Pos to start new txn

...