English Boards > Tutorials

Configuration backup

(1/5) > >>

fabos:
hi,

I've created restaurant menus, inserted items, inventory, departments and recipes and make a lot of tests.
the problem now is that I nees to start up a fresh installation with all the configuration made but without the testing data of ticket and bills 

How can I copy only the configuration data to a fresh installation? how can I make separated backups of configuration and data?


thanks for your support

fabio

emre:
Hello fabos.
If you didn't take a backup before adding test data you won't be able to rollback to the previous state.
Backing up or clearing transaction data is not supported in current release.

If you are familiar with SQL databases you can try clearing transaction tables (Tickets,TicketItems,Payments) manually with SQL Management Studio.

balitaly:
hi to all,
i've the same problem, during the settings i've made many simulations of bills and purchase ingredients. now if i want start to use the software in my restaurant how can i have a clean version without lose all the settings? i could instal again the software, but make again all the settings is a very long process and also i can not remind all the settings that i did before.... i tried also to clean the data base with sql management studio, but i can not open the file.... any suggestion?

emre:
Hello balitaly,
Normally we create backups before entering trial data and restore it before real usage.

I attached a SQL Script for you to clear all transaction data from database. If you run this script it will keep your settings but clear all tickets, work periods etc.

USE IT AT YOUR OWN RISK...
Take your backups before running this script. It will not generate backups. It will clear data without confirmation.

For SQL Server Express you can easily create backups and execute it with SQL Management Console.

If you are using SQL Compact Edition (CE) you can download a handy Management Tool from http://sqlcetoolbox.codeplex.com/ website.

The SQL CE database file stored under MyDocuments\SambaPOS2 folder. Create a copy of SambaData2.sdf file to create a backup

After running SQL CE Toolbox application:

* Right click on "No SQL Connections found .... etc" title on the right and click "Add .. Connection" (First item). A popup window will appear.
* Click [Browse] button, locate SambaData2.sdf file.
* Click [Close] button at the bottom of the screen.
* Popup window should disappear and you should see your database file listed under connections list.
* Right click on the file name and click "Open SQL Editor". This will display an editor screen on the right.
* Click "Open" from toolbar and locate script file (dtran.sqlce).
* Click Execute...
For security reasons we didn't implemented that feature inside sambapos application but we'll implement "Training Mode" on further releases so you'll be able to enable training mode when needed.

JohnS:
Emre,

Would it be possible to setup a training mode by

- Set an option in Local Settings to Copy Live Database to Training Database - with an 'Are You Sure' prompt.
- Setting a Live/Training toggle on the login screen
- When Training is selected, the Local Settings get changed to the Training Database settings.
- You login with your pin number and use the system as normal - Training Mode is either watermarked across the screen or at the top/bottom of the screen.
- When you log out, and select Live, the system changes Local Settings back to the Live database.

This means that you overwrite the Training Database as required, not automatically. Gives better control for experiments and customization. Also means that this would be a terminal by terminal setting, so you would not impact other uses on a production system while testing.

Navigation

[0] Message Index

[#] Next page