Backup/Restore/Manipulate database - Revision history

Vtop at 09:44, 2 October 2025

2025-10-02T09:44:44Z

← Older revision		Revision as of 09:44, 2 October 2025
Line 31:		Line 31:
	Note: For more information about setting multi terminal configuration, please refer to [[Link multiple POS device(Multi-Terminal mode and Network database)]] guide.		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 ==		== Database Menu ==
Line 38:		Line 39:
	In order to access Database Menu:		In order to access Database Menu:
	'''Main Menu > Database Setup icon or Cloud Account icon(hold click/tap down)'''		'''Main Menu > Database Setup icon or Cloud Account icon(hold click/tap down)'''


	== Database Backup/Restore ==		== Database Backup/Restore ==

Vtop at 09:44, 2 October 2025

2025-10-02T09:44:12Z

← Older revision		Revision as of 09:44, 2 October 2025
Line 1:		Line 1:
	~~[[File:Database config.png\|thumb\|Database Server Configuration]]~~

	== Database Server Configuration ==		== Database Server Configuration ==
	User able to set the database server connection mode with 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:		In order to access Database Server Configuration:
Line 35:		Line 33:

	== Database Menu ==		== Database Menu ==
			[[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:~~[[File:Database menu.png\|thumb\|Database Menu interface]]~~		In order to access Database Menu:
	'''Main Menu > Database Setup icon or Cloud Account icon(hold click/tap down)'''		'''Main Menu > Database Setup icon or Cloud Account icon(hold click/tap down)'''

Vtop at 09:43, 2 October 2025

2025-10-02T09:43:34Z

@@ Line 6: / Line 6: @@
 In order to access Database Server Configuration:
   '''Main Menu > Database Setup icon'''
 == Database Menu ==

Vtop at 08:41, 2 October 2025

2025-10-02T08:41:26Z

← Older revision		Revision as of 08:41, 2 October 2025
Line 1:		Line 1:
	[[File:Database ~~menu~~.png\|thumb\|Database ~~Menu interface~~]]		[[File:Database config.png\|thumb\|Database Server Configuration]]

			== 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 Menu ==
	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:[[File:Database menu.png\|thumb\|Database Menu interface]]
	'''Main Menu > ~~Hold click/tap~~ Database Setup icon or Cloud Account icon'''		'''Main Menu > Database Setup icon or Cloud Account icon(hold click/tap down)'''

	== Database Backup/Restore ==		== Database Backup/Restore ==

Vtop at 08:18, 2 October 2025

2025-10-02T08:18:49Z

← Older revision		Revision as of 08:18, 2 October 2025
Line 32:		Line 32:

	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 ==

Vtop at 08:17, 2 October 2025

2025-10-02T08:17:30Z

← Older revision		Revision as of 08:17, 2 October 2025
Line 40:		Line 40:

	== Import/Export XLSX ==		== Import/Export XLSX ==
	User able to import or export Group, Department, PLU Item, and Set Menu ~~using~~ XLSX file with Import/Export XLSX menu.		User able to import or export Group, Department, PLU Item, and Set Menu from/to XLSX file with Import/Export XLSX menu.

Vtop: Created page with "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: '''Main Menu > Hold click/tap Database Setup icon or Cloud Account icon''' == Database Backup/Restore == User able to backup or restore Master Database(PLU Item, Menu, Window Layout, Hardware settings, and various configuration settings) from the '''Da..."

2025-10-02T08:11:54Z

Created page with "thumb|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: '''Main Menu > Hold click/tap Database Setup icon or Cloud Account icon''' == Database Backup/Restore == User able to backup or restore Master Database(PLU Item, Menu, Window Layout, Hardware settings, and various configuration settings) from the '''Da..."

New page

[[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.

In order to access Database Menu:
'''Main Menu > Hold click/tap Database Setup icon or Cloud Account icon'''

== 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:
{| class="wikitable"
!Button
!Description
|-
|Backup
|Allow user to backup Master Database to targeted location.
User also able to hold click/tap to quick backup to <code>/sdcard/posdata/export</code> folder, the filename will be auto generate based on current data time stamp.
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.

== 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 using XLSX file with Import/Export XLSX menu.