SambaPOS Forum

English Boards => Support => Topic started by: lewasabisushi on February 18, 2013, 03:59:40 am

Title: Connection MS Excel to SambaPOS database
Post by: lewasabisushi on February 18, 2013, 03:59:40 am

Hi all
I want to use MS Excel to retrieve data from sambapos instead of using csv from reports. I just don't know which table should I connect to. I tried almost all table but I could not find the transaction data (even from transaction table).
Any suggestion?
Thank you.

NB: I want to know which data should I retrieve if I want:
waitress performance, most wanted items, gifted items, ticket tag, item's value, and some others

Title: Re: Connection MS Excel to SambaPOS database
Post by: One33Seven on February 18, 2013, 04:49:42 am

You can do it by adding a data connection to your excel sheet and then adding a macro script to retrieve and format the data.

Title: Re: Connection MS Excel to SambaPOS database
Post by: lewasabisushi on February 18, 2013, 03:27:54 pm

Yes I already done that but I cannot find which table holds transaction history. I have blank table when I connect Excel with Transaction table.

Title: Re: Connection MS Excel to SambaPOS database
Post by: lemmings on February 18, 2013, 04:10:50 pm

Transaction table is for inventory and recipe (tracking stock use)

You need to look at tables Tickets, TicketItems and TicketProperties

These will show you the sales data, the menu items and any modifiers you may have set up

Title: Re: Connection MS Excel to SambaPOS database
Post by: lewasabisushi on February 19, 2013, 11:13:45 am

Yes, It was Ticket Properties.
Thank You.

Title: Need Help Connection MS Excel to SambaPOS database
Post by: Buscad0r on February 04, 2014, 11:28:27 am

Hi, I found your lines looking for ways to use Ms Excel to query the database, can you please help me with some example of how to do it? maybe a step by step procedure? which db connector should I use?  which is the macro scrip?

best regards