SambaPOS Forum

English Boards => Support => Topic started by: NRIKE on July 09, 2013, 06:09:14 pm

Title: seat numbering on one order , clock in/out for waitress,export customers list
Post by: NRIKE on July 09, 2013, 06:09:14 pm

hi,
already thank you for your concern
-first , i just know if it's possible to assign orders to specific seat positions in ordering (after table's selecting and opening )!!!!!!and how can i configurate sambapos for it
-second  is that it is possible to use samba to have a log of departures and arrivals of cooks, waiters,cashiers and waitresses (restaurant staff)
- and finally I would like to export a list of my customers with contact already stored in my database sambapos

Title: Re: seat numbering on one order , clock in/out for waitress,export customers list
Post by: JohnS on July 11, 2013, 09:15:44 am

1. Yes - see your other thread
2. No - SambaPOS does not do staff timekeeping
3. No - but maybe through a SQL script.

Title: Re: seat numbering on one order , clock in/out for waitress,export customers list
Post by: NRIKE on July 12, 2013, 12:09:00 pm

Quote from: JohnS on July 11, 2013, 09:15:44 am

....."3. No - but maybe through a SQL script."

thanks for your interess but could u help me to do this with a query for example

Title: Re: seat numbering on one order , clock in/out for waitress,export customers list
Post by: lemmings on July 12, 2013, 05:32:57 pm

There are a few ways to accomplish the exporting of data:

You could use the SQL Import and Export Data Wizard.

Or open up SQL Management Studio, select the table Customers. Select the top left corner of the table rows and columns to select all the table, then copy and paste into Excel.

I use Excel directly and link to the SQL Server database tables I want.  That way when I open up the Excel spreadsheet my data is refreshed and up to date as the SambaPos data.

If you wanted you could use a SQLCMD batch script to automate the collection of data and saving to an Excel csv file.

Title: Re: seat numbering on one order , clock in/out for waitress,export customers list
Post by: NRIKE on July 14, 2013, 05:53:59 am

Quote from: lemmings on July 12, 2013, 05:32:57 pm

There are a few ways to accomplish the exporting of data:

...I use Excel directly and link to the SQL Server database tables I want.  That way when I open up the Excel spreadsheet my data is refreshed and up to date as the SambaPos data.

If you wanted you could use a SQLCMD batch script to automate the collection of data and saving to an Excel csv file....

i prefer this solution too but how can i do to create an excel file for this solution

Title: Re: seat numbering on one order , clock in/out for waitress,export customers list
Post by: lemmings on July 14, 2013, 03:49:21 pm

Startup Excel, Select Data Tab, Then Get External Data > From Other Sources > SQL Server

Once the dialog box opens up complete the name of the SQL Server and password

Next box asks which database you want to connect to - so this will be SambaData2, then with the connect to a specific table box ticked you can select the table you wish to load - Customers is the one you require in this instance.

The Next box allows you to save the connection and enter a description against it, click Finish.

At this point you will be asked what type of spreadsheet you require and at what position you need the data, you can leave the defaults which will format a table and position the data at A1.

You can save the spreadsheet at this point with whatever name you require.

You also have the option to Unlink the spreadsheet from the Data Connection - but your data will no longer be updated.

Title: Re: seat numbering on one order , clock in/out for waitress,export customers list
Post by: NRIKE on July 17, 2013, 01:51:38 am

 :D thanks a lot boss  ;D