SambaPOS Forum

English Boards => Support => Topic started by: Ali on March 06, 2013, 10:44:11 am

Title: Clear All orders work periods etc Script
Post by: Ali on March 06, 2013, 10:44:11 am

Hi Guys,

I had seen a script file on here to clear all history of orders on here, but i cant seem to find it.
cant you point me to the link or post the script?

Thanks

Title: Re: Clear All orders work periods etc Script
Post by: emre on March 06, 2013, 11:24:14 am

http://forum2.sambapos.org/index.php/topic,60.msg251.html#msg251 (http://forum2.sambapos.org/index.php/topic,60.msg251.html#msg251)

Title: Re: Clear All orders work periods etc Script
Post by: Ali on March 11, 2013, 05:39:19 pm

thanks Emre,

I did see this but I has seen a post by JohnS where he had a script also maybe i think this was the one.

thanks again I will check this out and try to run it later and let you know the outcome.

Kind Regards.

Title: Re: Clear All orders work periods etc Script
Post by: tonishala on March 12, 2013, 08:46:33 am

Hi there,

How do I connect the script (dtrain.sqle) on management studio?
cause im not able to execute it without being connected, im not that familiar with sql management studio,
Thanks in advance
Tony.

Title: Re: Clear All orders work periods etc Script
Post by: emre on March 12, 2013, 09:42:12 am

when you first start management studio it should ask connection properties. You'll enter server name, user, password as you entered on SambaPOS connection.

You'll click on new query and select "sambadata2" database from the database selection combobox. You'll find it on top left toolbar.

dtran file is a txt file. You'll open it copy & paste script in management studio.

Title: Re: Clear All orders work periods etc Script
Post by: icemax on March 16, 2013, 08:11:51 am

this a sample batch file

via command line :)  http://forum2.sambapos.org/index.php/topic,1303.0.html
 (http://forum2.sambapos.org/index.php/topic,1303.0.html)

bye