I would like to export all the data in my POS system to excel, so that I cant run my own reports. is this possible? If so can someone please explain how I could do this.
I am not an SQL user but could pick this up pretty quickly, if it is the only way to do this.
The main thing I would like in excel is a table showing the following: Transaction Date. Transaction Time. Cashier. Product Sold. Product Price.
This would give me the flexibility to run the reports I would like. Would really appreciate any help here.
All uniCenta reports can be saved to various formats - see icon floppy disk icon top left of report view window - and Excel is one of those.
Just as a follow on to this, I'm looking to export some data to Excel too, and like Ronak I'm not an SQL user but could probably pick it up pretty quickly. (Using MySQL by the way)
I've tried exporting some of the reports to Excel format, but the problem is they have a lot of headings, blank rows etc, which means it requires a lot of manipulation before the data is really useable in Excel. (Sometimes it spits out extra cells too so the data goes out of line, making it impossible to automate the manipulation process).
So the question is, what's the best way to export data to Excel in simple tabular format with no breaks or other formatting? (For example, if I wanted to see nothing other than the sales total per product category for a given period in a simple list.)
Any help or advice greatly appreciated.
just came across this. why don't you find a tool like this for free if there is 1 or just purchase this.
EMS Data Export for MySQL (Non-commercial) + 1 Year Maintenance $47.00