| 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 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
...
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
...
- 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.
...
- 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
| 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 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 automatically is enabled. ClickNext
- 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
...
- 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 Open 'MySQL AdministratorTo check if a database exists
...
'
- Login
- Click Catalogs
- Select wsemp to view all tables of wsemp schema.
...
Linking the POS to EMP Server
| Note | ||
|---|---|---|
| ||
Download both: |
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
...
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
...
How to delete the Txn and Start New
- Go to MySQL admin
...
- password: root
...
- click "Catalogs"
...
- Right click on the "WSEMP"
...
- Select "Drop Schema"
...
...
- and click yes
- After the txn deleted, just run the Jimmy Pos to start new txn