SambaPOS Training Mode

[JohnS]

Welcome to SambaPOS Training Mode.

What I have created is a tool to enable a SambaPOS Training Mode on SambaPOS.
What the tool actually does is to copy the SambaPOS Microsoft SQL Express 2005/2008 Server instance or Microsoft Compact SQL Server database to a Microsoft Compact SQL Server database file called SambaTrain.sdf, and change the SambaPOS data source settings automatically with the click of a single icon and once you exit SambaPOS, the data source settings are returned to the live settings.

Latest version - V4.0 - http://forum2.sambapos.org/index.php/topic,184.msg6222.html#msg6222


You can also have the database refresh each time you run SambaPOS Training Mode, or to refresh on-demand if you are developing new features, or expanding the POS system.

[jenem]

Cheers John,

I'll try it out later.

By the way, Thanks!

Edgar

[emre]

John your latest update is a big improvement and that makes you a SambaPOS Dev
I want to include your script in SambaPOS setup. Is it possible to get rid of c:\sambatrain and use current directory instead?

[JohnS]

I was thinking the same.

Do you want it in a sub directory under SambaPOS2 called Training or just in the main directory?

[emre]

It will be fine if it works under a sub directory. If it helps during setup I can call install.vbs with current installation directory information or anything else.

[JohnS]

The install script is designed to be run once you have SambaPOS up and running in your production environment.

As it is right now, if you change the database connection or location of the SambaSettings.txt file, after you have run install.vbs, the training scripts will not work.
I will change this to read the settings each time you run training mode, that way if you change databases or location of the settings file, it will work it out and run training mode.

[JohnS]

Emre,

Well its at V3.0 now. Rewrote most of it so it's now just one script to do everything.
The script discovers its location and folder name, but it has to be placed in a sub directory under SambaPOS2 to work.

Test it, and let me know if you have any issues.

Features
- Will work with SQL Server Compact & SQL Server Express Databases (both local and networked)
- Checks if SQL Compact Server is installed
- Dynamic execution - no configuration required

[emre]

On my first test it worked great... Really good idea, awesome solution.
I'll test it more but I think it is ready for next release.. Thank you very much!

[emre]

For the record: Training script included in setup.

[jenem]

Hi John,
Tried running training mode today and got error shown on screen shot.

What are the conditions for the script to work.

Could it be because I have sql server and sql compact on my laptop?

Edgar

[JohnS]

Edgar,

Its a file permission error.

You need SQL CE on the system to run training mode. Both MS SQL & SQL CE can exist on the same system.
Are you logged in as an administrator or restricted user?

Try this
1. Log into SambaPOS, go to Local Settings and make sure you are using MS SQL and not CE and exit.
2. Run Training.vbs again

I just tested and it has worked fine, but I did need to log into SambaPOS first.

[JohnS]

Updated version to fix file permission errors on restricted user accounts.

I have tested on both Win 7 and Server 2003 with both standard and administrator accounts.
Please let me know if you have any issues.

Notes
- Training Compact SQL file is now located in the same folder as SambaSettings.txt file.
- Training SQL file called SambaTrain.sdf

[emre]

Thank you John. Good solution.
I'll update your script on next release.

[jenem]

Hi John,

Run training mode script shortcut on desk top and found sambapos would start up in normal mode, ie ticket no would increment and when I restarted Sambapos from normal shortcut, found the next ticket no was incremented the last ticket no generated in training mode.

Edgar

[JohnS]

Edgar,

Are you running Compact SQL ? If so, whats the location of your sdf file.
Whats the location of your SambaSettings.txt file ?