Difference between revisions of "POS USER'S MANUAL"
| (16 intermediate revisions by the same user not shown) | |||
| Line 11: | Line 11: | ||
[[File:1.png|center|400px]] | [[File:1.png|center|400px]] | ||
| − | '''Figure 1. Installing the MariaDB installer.''' | + | <center>'''Figure 1. Installing the MariaDB installer.'''</center> |
''On figure 1 you will see the installer for iPosWare. Click the installer named mariadb-10.0.21-win32 and run it.'' | ''On figure 1 you will see the installer for iPosWare. Click the installer named mariadb-10.0.21-win32 and run it.'' | ||
| Line 17: | Line 17: | ||
| − | [[File:2.JPG|center| | + | [[File:2.JPG|center|300px]] |
| − | '''Figure 2. MariaDB 10.0 Setup''' | + | <center>'''Figure 2. MariaDB 10.0 Setup'''</center> |
''On figure 2 will show a confirmation that you want to install the setup. Click Next.'' | ''On figure 2 will show a confirmation that you want to install the setup. Click Next.'' | ||
| Line 24: | Line 24: | ||
| − | [[File:3.JPG|center| | + | [[File:3.JPG|center|300px]] |
| − | '''Figure 3. End-User License Agreement''' | + | <center>'''Figure 3. End-User License Agreement'''</center> |
''On figure 3, you will see all the terms in the License Agreement. Click I accept the terms in the License Agreement and click Next.'' | ''On figure 3, you will see all the terms in the License Agreement. Click I accept the terms in the License Agreement and click Next.'' | ||
| − | [[File:4.JPG|center| | + | [[File:4.JPG|center|300px]] |
| − | '''Figure 4. Custom Setup''' | + | <center>'''Figure 4. Custom Setup'''</center> |
''On figure 4, you will select or change the way features will be installed. In our case, just click Next.'' | ''On figure 4, you will select or change the way features will be installed. In our case, just click Next.'' | ||
| − | [[File:5.JPG|center| | + | [[File:5.JPG|center|300px]] |
| − | '''Figure 5. User settings''' | + | <center>'''Figure 5. User settings'''</center> |
''On figure 5, you will modify password for database user ‘root’. On the new root password and confirm field, type limsehleng then click Next.'' | ''On figure 5, you will modify password for database user ‘root’. On the new root password and confirm field, type limsehleng then click Next.'' | ||
| − | [[File:6.JPG|center| | + | [[File:6.JPG|center|300px]] |
| − | '''Figure 6. Database settings''' | + | <center>'''Figure 6. Database settings'''</center> |
''Figure 6 shows the Instance properties of your database. No need to modify any field just click Next.'' | ''Figure 6 shows the Instance properties of your database. No need to modify any field just click Next.'' | ||
| − | [[File:7.JPG|center| | + | [[File:7.JPG|center|300px]] |
| − | '''Figure 7. Submit usage information''' | + | <center>'''Figure 7. Submit usage information'''</center> |
''Figure 7 will give you a choice if you want to participate in giving feedback that will be used to improve MariaDB. Click Next.'' | ''Figure 7 will give you a choice if you want to participate in giving feedback that will be used to improve MariaDB. Click Next.'' | ||
| − | [[File:8.JPG|center| | + | [[File:8.JPG|center|300px]] |
| − | '''Figure 8. Ready to install MariaDB''' | + | <center>'''Figure 8. Ready to install MariaDB'''</center> |
''Figure 8 will give you a chance if you want to go back to previous step. If there is nothing to configure, click Install.'' | ''Figure 8 will give you a chance if you want to go back to previous step. If there is nothing to configure, click Install.'' | ||
| − | [[File:9.JPG|center| | + | [[File:9.JPG|center|300px]] |
| − | '''Figure 9. Ready to install MariaDB''' | + | <center>'''Figure 9. Ready to install MariaDB'''</center> |
''The figure 9 will show the progress of installation. Wait until finished, then click Next.'' | ''The figure 9 will show the progress of installation. Wait until finished, then click Next.'' | ||
| − | [[File:10.JPG|center| | + | [[File:10.JPG|center|300px]] |
| − | '''Figure 10. Installation completed''' | + | <center>'''Figure 10. Installation completed'''</center> |
''Figure 10 is the last step in installing MariaDB. It shows the installation is done, just click Finish.'' | ''Figure 10 is the last step in installing MariaDB. It shows the installation is done, just click Finish.'' | ||
| Line 67: | Line 67: | ||
| − | '''*''' | + | '''*'''Step 2: Install SQLyog |
| − | [[File:11.JPG|center| | + | [[File:11.JPG|center|300px]] |
| − | '''Figure 11. Choose Install Location''' | + | <center>'''Figure 11. Choose Install Location'''</center> |
''On figure 11, you will choose the destination folder of the SQLyog. Place it on drive C: and click Install.'' | ''On figure 11, you will choose the destination folder of the SQLyog. Place it on drive C: and click Install.'' | ||
| − | [[File:12.JPG|center| | + | [[File:12.JPG|center|300px]] |
| − | '''Figure 12. Choose Components''' | + | <center>'''Figure 12. Choose Components'''</center> |
''You will ask what components you want to install on your computer. Select all and click Next. '' | ''You will ask what components you want to install on your computer. Select all and click Next. '' | ||
| − | [[File:13.JPG|center| | + | [[File:13.JPG|center|300px]] |
| − | '''Figure 13. License Agreement''' | + | <center>'''Figure 13. License Agreement'''</center> |
''On figure 13, you will see all the terms in the License Agreement. Click I accept the terms in the License Agreement and click Next.'' | ''On figure 13, you will see all the terms in the License Agreement. Click I accept the terms in the License Agreement and click Next.'' | ||
| − | [[File:14.JPG|center| | + | [[File:14.JPG|center|300px]] |
| − | '''Figure 14. SQLyog Setup Wizard''' | + | <center>'''Figure 14. SQLyog Setup Wizard'''</center> |
''Figure 14 is the welcome page on the setup wizard. Click Next to continue.'' | ''Figure 14 is the welcome page on the setup wizard. Click Next to continue.'' | ||
| − | [[File:15.JPG|center| | + | [[File:15.JPG|center|200px]] |
| − | '''Figure 15. Installer Language''' | + | <center>'''Figure 15. Installer Language'''</center> |
''You will ask to select what language to use on installation. Select English and click OK.'' | ''You will ask to select what language to use on installation. Select English and click OK.'' | ||
| − | [[File:16.JPG|center| | + | [[File:16.JPG|center|300px]] |
| − | '''Figure 16. Installing SQLyog''' | + | <center>'''Figure 16. Installing SQLyog'''</center> |
''Wait until the installation is finished and click Next.'' | ''Wait until the installation is finished and click Next.'' | ||
| − | [[File:17.JPG|center| | + | [[File:17.JPG|center|300px]] |
| − | '''Figure 17. Install completed''' | + | <center>'''Figure 17. Install completed'''</center> |
''Figure 17 shows that the installation is done. Click Finish.'' | ''Figure 17 shows that the installation is done. Click Finish.'' | ||
[[File:18.JPG|center|400px]] | [[File:18.JPG|center|400px]] | ||
| − | '''Figure 18. Creating a new connection''' | + | <center>'''Figure 18. Creating a new connection'''</center> |
''On figure 18, you need to create a new database connection. To create, click New.'' | ''On figure 18, you need to create a new database connection. To create, click New.'' | ||
| − | [[File:19.JPG|center| | + | [[File:19.JPG|center|300px]] |
| − | '''Figure 19. Naming the connection''' | + | <center>'''Figure 19. Naming the connection'''</center> |
''Figure 19 will ask for the name of connection. Just leave as it is and click OK.'' | ''Figure 19 will ask for the name of connection. Just leave as it is and click OK.'' | ||
| − | [[File:20.JPG|center| | + | [[File:20.JPG|center|600px]] |
| − | '''Figure 20. Filling out the password''' | + | <center>'''Figure 20. Filling out the password'''</center> |
''On this step, you need to fill out the field for password with limsehleng. After filling out the password field, click Connect.'' | ''On this step, you need to fill out the field for password with limsehleng. After filling out the password field, click Connect.'' | ||
| − | [[File:21.JPG|center| | + | [[File:21.JPG|center|500px]] |
| − | '''Figure 21. Create your database''' | + | <center>'''Figure 21. Create your database'''</center> |
''Once you are connected, you can now create your database. Right click [1] shown on figure 21.'' | ''Once you are connected, you can now create your database. Right click [1] shown on figure 21.'' | ||
[[File:22.JPG|center|400px]] | [[File:22.JPG|center|400px]] | ||
| − | '''Figure 22. Create your database (2)''' | + | <center>'''Figure 22. Create your database (2)'''</center> |
''Click Create Database shown on figure 22.'' | ''Click Create Database shown on figure 22.'' | ||
| − | [[File:23.JPG|center| | + | [[File:23.JPG|center|200px]] |
| − | '''Figure 23. Naming your database''' | + | <center>'''Figure 23. Naming your database'''</center> |
''It is important to name your database correctly so that you may not encounter any errors during the system execution. For the database name field, name it as db_iposdata.'' | ''It is important to name your database correctly so that you may not encounter any errors during the system execution. For the database name field, name it as db_iposdata.'' | ||
[[File:24.JPG|center|400px]] | [[File:24.JPG|center|400px]] | ||
| − | '''Figure 24. Database successfully created''' | + | <center>'''Figure 24. Database successfully created'''</center> |
''When the database was successfully created, you will see your database at the left part of the screen. See figure 24 for the actual image.'' | ''When the database was successfully created, you will see your database at the left part of the screen. See figure 24 for the actual image.'' | ||
[[File:25.JPG|center|400px]] | [[File:25.JPG|center|400px]] | ||
| − | '''Figure 25. Execute SQL Script''' | + | <center>'''Figure 25. Execute SQL Script'''</center> |
''For the database to have all the needed tables at values, you must execute SQL script. To do this, just right click your database and go to import and click Execute SQL Script.'' | ''For the database to have all the needed tables at values, you must execute SQL script. To do this, just right click your database and go to import and click Execute SQL Script.'' | ||
| − | [[File:26.JPG|center| | + | [[File:26.JPG|center|300px]] |
| − | '''Figure 26. Locating your SQL File''' | + | <center>'''Figure 26. Locating your SQL File'''</center> |
''You will be asked to locate where your sql file is located. This may vary on where you place your sql file. In my case, I place it on the desktop. After locating, just click Execute.'' | ''You will be asked to locate where your sql file is located. This may vary on where you place your sql file. In my case, I place it on the desktop. After locating, just click Execute.'' | ||
| − | [[File:27.JPG|center| | + | [[File:27.JPG|center|300px]] |
| − | ''' | + | <center>'''Figure 27. Executing query'''</center> |
| − | '' | + | ''After locating your SQL file, wait until the queries are executed. It may take few minutes based on your computer performance.'' |
| − | [[File:28.JPG|center| | + | [[File:28.JPG|center|500px]] |
| − | ''' | + | <center>'''Figure 28. Adding user (1)'''</center> |
| − | '' | + | ''The next thing you should do is to add user. To do this, just click the user icon shown on figure 28.'' |
| − | [[File:29.JPG|center| | + | [[File:29.JPG|center|500px]] |
| − | ''' | + | <center>'''Figure 29. Adding users (2)'''</center> |
| − | '' | + | ''Click Add New User shown on figure 29.'' |
| − | [[File: | + | [[File:31.JPG|center|300px]] |
| − | ''' | + | <center>'''Figure 30. Filling out the needed information'''</center> |
| − | '' | + | ''Fill out the fields with this following information:'' |
| + | [[File:32.JPG|center|300px]] | ||
| − | [[File: | + | [[File:33.JPG|center|300px]] |
| − | ''' | + | <center>'''Figure 31. Selecting Privileges'''</center> |
| − | '' | + | ''Click Select/Deselect All to configure and click Save Changes.'' |
| − | [[File: | + | [[File:34.JPG|center|600px]] |
| − | ''' | + | <center>'''Figure 32. Adding another user'''</center> |
| − | '' | + | ''Click Add User again to add another user.'' |
| − | [[File: | + | [[File:35.JPG|center|300px]] |
| − | ''' | + | <center>'''Figure 33. Filling out the needed information'''</center> |
| − | '' | + | ''Fill out the fields with this following information:'' |
| + | [[File:36.JPG|center|300px]] | ||
| − | [[File: | + | [[File:37.JPG|center|300px]] |
| − | ''' | + | <center>'''Figure 34. Selecting Privileges for another user'''</center> |
| − | '' | + | ''Click Select/Deselect All to configure and click Save Changes and close the window.'' |
| − | + | '''*''' Step 3: Copy the required files on drive C: | |
| − | ''' | + | |
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
[[File:38.JPG|center|400px]] | [[File:38.JPG|center|400px]] | ||
| − | ''' | + | <center>'''Figure 35. Open the C Folder'''</center> |
| − | '' | + | ''There are files that need to be copy on you drive C:, to get them you must open the C Folder.'' |
[[File:39.JPG|center|400px]] | [[File:39.JPG|center|400px]] | ||
| − | ''' | + | <center>'''Figure 36. Copy all files'''</center> |
| − | '' | + | ''Copy all files inside the C Folder.'' |
[[File:40.JPG|center|400px]] | [[File:40.JPG|center|400px]] | ||
| − | ''' | + | <center>'''Figure 37. Paste files on your Drive C:'''</center> |
| + | |||
| + | ''Paste all files that you copied on C Folder on drive C:'' | ||
| + | |||
| + | '''*''' Step 4: Installing the EPSON Printer | ||
| + | |||
| + | [[File:41.JPG|center|200px]] | ||
| + | <center>'''Figure 38. Run the EPSON setup'''</center> | ||
| − | '' | + | ''Run the EPSON setup to start installing.'' |
| − | [[File: | + | [[File:42.JPG|center|300px]] |
| − | ''' | + | <center>'''Figure 39. Preparing the setup'''</center> |
| − | '' | + | ''Figure 39 shows that EPSON is preparing setup.'' |
| − | [[File: | + | [[File:43.JPG|center|300px]] |
| − | ''' | + | <center>'''Figure 40. Welcome page'''</center> |
| − | '' | + | ''After preparing the setup, EPSON will show a welcome page. Click Next.'' |
| − | [[File: | + | [[File:pos44.JPG|center|300px]] |
| − | ''' | + | <center>'''Figure 41. Selecting the setup type'''</center> |
| − | '' | + | ''Choosing for the type of setup is mostly shown when we are installing a software. For our case, just click Standard.'' |
| − | [[File: | + | [[File:45.JPG|center|300px]] |
| − | ''' | + | <center>'''Figure 42. Printer Configuration'''</center> |
| − | '' | + | ''On this part, we need to plug in the printer in the Computer so that the software can recognize which printer we are using. Also, on setting up the software, it is a must.'' |
| − | [[File: | + | [[File:46.JPG|center|600px]] |
| − | ''' | + | <center>'''Figure 43. Add printer'''</center> |
| − | '' | + | ''On this part, we will ask to select driver and what type of port to be use. For the driver, we will be using EPSON TM-U220 Receipt and for the Port Type, select Create a USB port.'' |
| + | [[File:Pos47.JPG|center|300px]] | ||
| + | <center>'''Figure 44. Printer Configuration'''</center> | ||
| − | + | ''After adding a printer, the computer already recognized what printer we will be using. Click Next.'' | |
| − | '' | + | |
| − | '' | + | [[File:48.JPG|center|300px]] |
| + | <center>'''Figure 45. Copying files'''</center> | ||
| − | + | ''The summary of the configuration we made during set up is shown on figure 45. Click Next to continue.'' | |
| − | '' | + | |
| − | '' | + | [[File:49.JPG|center|300px]] |
| + | <center>'''Figure 46. Setup Status'''</center> | ||
| − | + | ''Wait until the installation is done. '' | |
| − | '' | + | |
| − | '' | + | [[File:50.JPG|center|300px]] |
| + | <center>'''Figure 43: Installation complete'''</center> | ||
| − | + | ''The printer is now ready! Lastly, we need to install iPosWare.'' | |
| − | '' | + | |
| − | '' | + | '''*''' Install the iPosWare |
| − | [[File: | + | [[File:51.JPG|center|300px]] |
| − | ''' | + | <center>'''Figure 44: Run the setup'''</center> |
| − | '' | + | ''Run the setup application file to start the installation.'' |
| − | [[File: | + | [[File:52.JPG|center|300px]] |
| − | ''' | + | <center>'''Figure 45: Install the set up'''</center> |
| − | '' | + | ''Click Install to start the installation of iPosWare.'' |
| − | [[File: | + | [[File:53.JPG|center|200px]] |
| − | ''' | + | <center>'''Figure 46: iPosWare installing'''</center> |
| − | '' | + | ''Wait until the installation is done. It may take few minutes based on your computer performance. When it is done, you can run the application and use it.'' |
Latest revision as of 15:36, 5 January 2018
* POS INSTALLATION *
* Step 1: Install Maria DB on your PC.
On figure 1 you will see the installer for iPosWare. Click the installer named mariadb-10.0.21-win32 and run it.
On figure 2 will show a confirmation that you want to install the setup. Click Next.
On figure 3, you will see all the terms in the License Agreement. Click I accept the terms in the License Agreement and click Next.
On figure 4, you will select or change the way features will be installed. In our case, just click Next.
On figure 5, you will modify password for database user ‘root’. On the new root password and confirm field, type limsehleng then click Next.
Figure 6 shows the Instance properties of your database. No need to modify any field just click Next.
Figure 7 will give you a choice if you want to participate in giving feedback that will be used to improve MariaDB. Click Next.
Figure 8 will give you a chance if you want to go back to previous step. If there is nothing to configure, click Install.
The figure 9 will show the progress of installation. Wait until finished, then click Next.
Figure 10 is the last step in installing MariaDB. It shows the installation is done, just click Finish.
*Step 2: Install SQLyog
On figure 11, you will choose the destination folder of the SQLyog. Place it on drive C: and click Install.
You will ask what components you want to install on your computer. Select all and click Next.
On figure 13, you will see all the terms in the License Agreement. Click I accept the terms in the License Agreement and click Next.
Figure 14 is the welcome page on the setup wizard. Click Next to continue.
You will ask to select what language to use on installation. Select English and click OK.
Wait until the installation is finished and click Next.
Figure 17 shows that the installation is done. Click Finish.
On figure 18, you need to create a new database connection. To create, click New.
Figure 19 will ask for the name of connection. Just leave as it is and click OK.
On this step, you need to fill out the field for password with limsehleng. After filling out the password field, click Connect.
Once you are connected, you can now create your database. Right click [1] shown on figure 21.
Click Create Database shown on figure 22.
It is important to name your database correctly so that you may not encounter any errors during the system execution. For the database name field, name it as db_iposdata.
When the database was successfully created, you will see your database at the left part of the screen. See figure 24 for the actual image.
For the database to have all the needed tables at values, you must execute SQL script. To do this, just right click your database and go to import and click Execute SQL Script.
You will be asked to locate where your sql file is located. This may vary on where you place your sql file. In my case, I place it on the desktop. After locating, just click Execute.
After locating your SQL file, wait until the queries are executed. It may take few minutes based on your computer performance.
The next thing you should do is to add user. To do this, just click the user icon shown on figure 28.
Click Add New User shown on figure 29.
Fill out the fields with this following information:
Click Select/Deselect All to configure and click Save Changes.
Click Add User again to add another user.
Fill out the fields with this following information:
Click Select/Deselect All to configure and click Save Changes and close the window.
* Step 3: Copy the required files on drive C:
There are files that need to be copy on you drive C:, to get them you must open the C Folder.
Copy all files inside the C Folder.
Paste all files that you copied on C Folder on drive C:
* Step 4: Installing the EPSON Printer
Run the EPSON setup to start installing.
Figure 39 shows that EPSON is preparing setup.
After preparing the setup, EPSON will show a welcome page. Click Next.
Choosing for the type of setup is mostly shown when we are installing a software. For our case, just click Standard.
On this part, we need to plug in the printer in the Computer so that the software can recognize which printer we are using. Also, on setting up the software, it is a must.
On this part, we will ask to select driver and what type of port to be use. For the driver, we will be using EPSON TM-U220 Receipt and for the Port Type, select Create a USB port.
After adding a printer, the computer already recognized what printer we will be using. Click Next.
The summary of the configuration we made during set up is shown on figure 45. Click Next to continue.
Wait until the installation is done.
The printer is now ready! Lastly, we need to install iPosWare.
* Install the iPosWare
Run the setup application file to start the installation.
Click Install to start the installation of iPosWare.
Wait until the installation is done. It may take few minutes based on your computer performance. When it is done, you can run the application and use it.
