Backup/Restore/Manipulate database: Difference between revisions
No edit summary |
No edit summary |
||
| (4 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
== Database Server Configuration == | |||
[[File:Database config.png|thumb|Database Server Configuration]]User able to set the database server connection mode with Database Server Configuration | |||
In order to access Database Server Configuration: | |||
'''Main Menu > Database Setup icon''' | |||
{| class="wikitable" | |||
!Database Mode | |||
!Description | |||
|- | |||
|Standalone | |||
|Standalone mode allow the system to run the database server in local hardware and in the same time the database server listening for incoming terminal connection. | |||
{| class="wikitable" | |||
!Parameter | |||
!Description | |||
|- | |||
|Listening Port | |||
|The port for the database server to be listen. Leaving it blank will make the system listen to random port instead. | |||
Valid value 1-65535 range. | |||
|} | |||
|- | |||
|Network | |||
|Network mode allow the system to connect to the database server for multi terminal, sharing database setting, and sales. | |||
{| class="wikitable" | |||
!Parameter | |||
!Description | |||
|- | |||
|Server API Address | |||
|The URL for the device where database server is running on. | |||
The format should be <code>http://<ip address of the database server>:<port></code> | |||
|} | |||
Note: For more information about setting multi terminal configuration, please refer to [[Link multiple POS device(Multi-Terminal mode and Network database)]] guide. | |||
|} | |||
== Database Menu == | |||
[[File:Database menu.png|thumb|Database Menu interface]] | [[File:Database menu.png|thumb|Database Menu interface]] | ||
User able to backup, restore database, archive sales, reset transaction and import/export PLU Item from Database Menu interface. | User able to backup, restore database, archive sales, reset transaction and import/export PLU Item from Database Menu interface. | ||
In order to access Database Menu: | In order to access Database Menu: | ||
'''Main Menu > | '''Main Menu > Database Setup icon or Cloud Account icon(hold click/tap down)''' | ||
== Database Backup/Restore == | == Database Backup/Restore == | ||
| Line 32: | Line 68: | ||
Archiving Sales allows to move any old transaction from current transaction database to cold storage database, allowing to reduce system load, and improve system performance. | Archiving Sales allows to move any old transaction from current transaction database to cold storage database, allowing to reduce system load, and improve system performance. | ||
Note: Please do not do any transaction during archive/restore sales! | |||
== Reset Transaction == | == Reset Transaction == | ||
Latest revision as of 09:44, 2 October 2025
Database Server Configuration
User able to set the database server connection mode with Database Server Configuration
In order to access Database Server Configuration:
Main Menu > Database Setup icon
| Database Mode | Description | ||||
|---|---|---|---|---|---|
| Standalone | Standalone mode allow the system to run the database server in local hardware and in the same time the database server listening for incoming terminal connection.
| ||||
| Network | Network mode allow the system to connect to the database server for multi terminal, sharing database setting, and sales.
Note: For more information about setting multi terminal configuration, please refer to Link multiple POS device(Multi-Terminal mode and Network database) guide. |
Database Menu
User able to backup, restore database, archive sales, reset transaction and import/export PLU Item from Database Menu interface.
In order to access Database Menu:
Main Menu > Database Setup icon or Cloud Account icon(hold click/tap down)
Database Backup/Restore
User able to backup or restore Master Database(PLU Item, Menu, Window Layout, Hardware settings, and various configuration settings) from the Database Backup/Restore menu.
Please refer to the table below for details about its menu:
| Button | Description |
|---|---|
| Backup | Allow user to backup Master Database to targeted location.
User also able to hold click/tap to quick backup to Note: The backup master database does not backup sales transaction! In order to backup transaction, please enable of use Portal Online features. |
| Restore | Allow user to restore Master Database from targeted database file.
Note: Once the system restored successfully, the system will totally erase the current Master Database and restore with the user targeted database file without undo capability! Note: Shop Info ID will be regenerate to new ID once restore successfully. Please do note that you might need to contact your software distributor for reactivate your license! |
| Close | Close the Database Backup/Restore menu |
Archive/Restore Sales
User able to Archive or Restore Transaction sales with Archive/Restore Sales menu.
Archiving Sales allows to move any old transaction from current transaction database to cold storage database, allowing to reduce system load, and improve system performance.
Note: Please do not do any transaction during archive/restore sales!
Reset Transaction
This menu allows user to reset all sales transactions(bill, PORA, stock in/out) to empty state.
User required to enter their email address to request OTP number to reset.
Note: User cannot undo reset transaction once it has been proceed. All the sales will be totally erase, including Online Portal! Please do take caution using this menu!
Import/Export XLSX
User able to import or export Group, Department, PLU Item, and Set Menu from/to XLSX file with Import/Export XLSX menu.
