Difference between revisions of "POS USER'S MANUAL"

From SPGC Document Wiki
Jump to: navigation, search
Line 12: Line 12:
 
  [[File:1.png|center|400px]]
 
  [[File:1.png|center|400px]]
 
'''Figure 1. Installing the MariaDB installer.'''
 
'''Figure 1. Installing the MariaDB installer.'''
 +
 
''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 18: Line 19:
 
  [[File:2.JPG|center|400px]]
 
  [[File:2.JPG|center|400px]]
 
'''Figure 2. MariaDB 10.0 Setup'''
 
'''Figure 2. MariaDB 10.0 Setup'''
 +
 
''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.''
  
  
  
  [[File:3.png|center|400px]]
+
  [[File:3.JPG|center|400px]]
 
'''Figure 3. End-User License Agreement'''
 
'''Figure 3. End-User License Agreement'''
 +
 
''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:.png|center|400px]]
+
  [[File:4.JPG|center|400px]]
 +
'''Figure 4. Custom Setup'''
 +
 
 +
''On figure 4, you will select or change the way features will be installed. In our case, just click Next.''
 +
 
 +
[[File:5.JPG|center|400px]]
 +
'''Figure 5. User settings'''
 +
 
 +
''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|400px]]
 +
'''Figure 6. Database settings'''
 +
 
 +
''Figure 6 shows the Instance properties of your database. No need to modify any field just click Next.''
 +
 
 +
[[File:7.JPG|center|400px]]
 +
'''Figure 7. Submit usage information'''
 +
 
 +
''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|400px]]
 +
'''Figure 8. Ready to install MariaDB'''
 +
 
 +
''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|400px]]
 +
'''Figure 9. Ready to install MariaDB'''
 +
 
 +
''The figure 9 will show the progress of installation. Wait until finished, then click Next.''
 +
 
 +
[[File:10.JPG|center|400px]]
 +
'''Figure 10. Installation completed'''
 +
 
 +
''Figure 10 is the last step in installing MariaDB. It shows the installation is done, just click Finish.''
 +
 
 +
 
 +
 
 +
'''*''' Step 1: Step 2: Install SQLyog
 +
 
 +
[[File:11.JPG|center|400px]]
 +
'''Figure 11. Choose Install Location'''
 +
 
 +
''On figure 11, you will choose the destination folder of the SQLyog. Place it on drive C: and click Install.''
 +
 
 +
[[File:12.JPG|center|400px]]
 +
'''Figure 12. Choose Components'''
 +
 
 +
''You will ask what components you want to install on your computer. Select all and click Next. ''
 +
 
 +
[[File:13.JPG|center|400px]]
 +
'''Figure 13. License Agreement'''
 +
 
 +
''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|400px]]
 +
'''Figure 14. SQLyog Setup Wizard'''
 +
 
 +
''Figure 14 is the welcome page on the setup wizard. Click Next to continue.''
 +
 
 +
[[File:15.JPG|center|400px]]
 +
'''Figure 15. Installer Language'''
 +
 
 +
''You will ask to select what language to use on installation. Select English and click OK.''
 +
 
 +
[[File:16.JPG|center|400px]]
 +
'''Figure 16. Installing SQLyog'''
 +
 
 +
''Wait until the installation is finished and click Next.''
 +
 
 +
[[File:17.JPG|center|400px]]
 +
'''Figure 17. Install completed'''
 +
 
 +
''Figure 17 shows that the installation is done. Click Finish.''
 +
 
 +
[[File:18.JPG|center|400px]]
 +
'''Figure 18. Creating a new connection'''
 +
 
 +
''On figure 18, you need to create a new database connection. To create, click New.''
 +
 
 +
[[File:19.JPG|center|400px]]
 +
'''Figure 19. Naming the connection'''
 +
 
 +
''Figure 19 will ask for the name of connection. Just leave as it is and click OK.''
 +
 
 +
[[File:20.JPG|center|400px]]
 +
'''Figure 20. Filling out the password'''
 +
 
 +
''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|400px]]
 +
'''Figure 21. Create your database'''
 +
 
 +
''Once you are connected, you can now create your database. Right click [1] shown on figure 21.''
 +
 
 +
[[File:22.JPG|center|400px]]
 +
'''Figure 22. Create your database (2)'''
 +
 
 +
''Click Create Database shown on figure 22.''
 +
 
 +
[[File:23.JPG|center|400px]]
 +
'''Figure 23. Naming your database'''
 +
 
 +
''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]]
 
'''Bold text'''
 
'''Bold text'''
 +
 
''Italic text''
 
''Italic text''

Revision as of 13:58, 5 January 2018



* POS INSTALLATION *


* Step 1: Install Maria DB on your PC.
1.png

Figure 1. Installing the MariaDB installer.

On figure 1 you will see the installer for iPosWare. Click the installer named mariadb-10.0.21-win32 and run it.


2.JPG

Figure 2. MariaDB 10.0 Setup

On figure 2 will show a confirmation that you want to install the setup. Click Next.


3.JPG

Figure 3. End-User License Agreement

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.


4.JPG

Figure 4. Custom Setup

On figure 4, you will select or change the way features will be installed. In our case, just click Next.

5.JPG

Figure 5. User settings

On figure 5, you will modify password for database user ‘root’. On the new root password and confirm field, type limsehleng then click Next.

6.JPG

Figure 6. Database settings

Figure 6 shows the Instance properties of your database. No need to modify any field just click Next.

7.JPG

Figure 7. Submit usage information

Figure 7 will give you a choice if you want to participate in giving feedback that will be used to improve MariaDB. Click Next.

8.JPG

Figure 8. Ready to install MariaDB

Figure 8 will give you a chance if you want to go back to previous step. If there is nothing to configure, click Install.

9.JPG

Figure 9. Ready to install MariaDB

The figure 9 will show the progress of installation. Wait until finished, then click Next.

10.JPG

Figure 10. Installation completed

Figure 10 is the last step in installing MariaDB. It shows the installation is done, just click Finish.


* Step 1: Step 2: Install SQLyog
11.JPG

Figure 11. Choose Install Location

On figure 11, you will choose the destination folder of the SQLyog. Place it on drive C: and click Install.

12.JPG

Figure 12. Choose Components

You will ask what components you want to install on your computer. Select all and click Next.

13.JPG

Figure 13. License Agreement

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.

14.JPG

Figure 14. SQLyog Setup Wizard

Figure 14 is the welcome page on the setup wizard. Click Next to continue.

15.JPG

Figure 15. Installer Language

You will ask to select what language to use on installation. Select English and click OK.

16.JPG

Figure 16. Installing SQLyog

Wait until the installation is finished and click Next.

17.JPG

Figure 17. Install completed

Figure 17 shows that the installation is done. Click Finish.

18.JPG

Figure 18. Creating a new connection

On figure 18, you need to create a new database connection. To create, click New.

19.JPG

Figure 19. Naming the connection

Figure 19 will ask for the name of connection. Just leave as it is and click OK.

20.JPG

Figure 20. Filling out the password

On this step, you need to fill out the field for password with limsehleng. After filling out the password field, click Connect.

21.JPG

Figure 21. Create your database

Once you are connected, you can now create your database. Right click [1] shown on figure 21.

22.JPG

Figure 22. Create your database (2)

Click Create Database shown on figure 22.

23.JPG

Figure 23. Naming your database

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.

24.JPG

Bold text

Italic text