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.
Thank you,
Ronak
Last edit: Ronak 2014-01-18
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
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.
Marty.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hi...has anyone figured out a way to export data into excel in a clean format? Each time I try, the data has blank rows and such, which makes analsis difficult.
I need to be able to export into Excel in order to link to my accounting. Any ideas?
Thanks!
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hi-
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.
Thank you,
Ronak
Last edit: Ronak 2014-01-18
Ronak
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.
Jack
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.
Marty.
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
Hi...has anyone figured out a way to export data into excel in a clean format? Each time I try, the data has blank rows and such, which makes analsis difficult.
I need to be able to export into Excel in order to link to my accounting. Any ideas?
Thanks!