Once the software has been configured the sales data can be exported on a scheduler or by pressing the export data button.
The sales data will be written out to a file in the folder specified in the previous setup process. The file name consists of the date and time of the export followed by the text rawsalesout.csv.
2018-09-19-16-43-21rawsalesout.csv
The Data is written out in a comma separated Value format. It starts with two GUID values that are generated by the cloud.
The data that follows is the Header Data it consists of things like the date, transaction total Vat totals Etc.. The Detail part shows each line of the transactions such as the PLU, quantity and amount. As well as function keys like discount and even the finalization method. This is repeated for each transaction.
To interpret the DATA you need to look at the 'v-regi_sales_trn_db_en.pdf' Manual. The tables to look at are the CST004 Daily sales index for the header and CTS005 Daily sales details for the details.
(Header Data)
02c4c6ae-79f9-4066-bc2f-36ecf4198dc4,38698511-846a-4610-a40f-e60811967f7c,1,19/09/2018 00:00:00,1,1,19/09/2018 00:00:00,19/09/2018 16:29:00,1,1,CASHIER#001,1,1,1,2,2000,333,0,0,1667,0,0,0,0,0,0,0,1,0,,,,0,0,0,19/09/2018 00:00:00,19/09/2018 16:29:22,19/09/2018 00:00:00,19/09/2018 16:29:22,0,19/09/2018 00:00:00,19/09/2018 00:00:00,0,0,19/09/2018 16:29:22,144168
(Detail Data)
1,1,CASHIER#001,1,1,01,1,PLU0001,0,,0,,,,0,1,GROUP01,1,DEPT01,0,0,False,False,False,False,False,False,False,False,False,False,1,1,0,1,1000,1000,01,,,,,0,0,,,19/09/2018 00:00:00,19/09/2018 16:29:22,001,,0,19/09/2018 16:29:22,28
2,1,CASHIER#001,1,1,01,5,PLU0005,0,,0,,,,0,1,GROUP01,1,DEPT01,0,0,False,False,False,False,False,False,False,False,False,False,1,1,0,1,1000,1000,01,,,,,0,0,,,19/09/2018 00:00:00,19/09/2018 16:29:22,001,,0,19/09/2018 16:29:22,120
3,1,CASHIER#001,2,1,01,0,,1001,CASH,1,,,,0,0,,0,,,0,False,False,False,False,False,False,False,False,False,False,0,0,0,1,2000,2000,,,,,,0,0,,,19/09/2018 00:00:00,19/09/2018 16:29:22,001,,0,19/09/2018 16:29:22,0
4,1,CASHIER#001,1,6,06,0,,0,,0,,,,0,0,,0,,,0,False,False,False,False,False,False,False,False,False,False,0,0,0,0,0,2000,,,,,,0,0,,,19/09/2018 00:00:00,19/09/2018 16:29:22,001,,0,19/09/2018 16:29:22,0