English Boards > Support

Connection MS Excel to SambaPOS database

(1/2) > >>

lewasabisushi:
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

One33Seven:
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.

lewasabisushi:
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.

lemmings:
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

lewasabisushi:
Yes, It was Ticket Properties.
Thank You.

Navigation

[0] Message Index

[#] Next page