Search results for query: *

No, you really rock! That query gets us a lot, lot closer. Looking back at 17 days worth of data, the sales match 100% on 8 days. The other 9 days are off slightly from Net Sales ... they are values like $3.75, $-40, $29, $30, etc... IE, they're all rather small. Any idea what would be...

Thanks - you rock! Unfortunately, no dice. Same exact totals. -- Anthony

By the way ... if we use the suppressed_rpt_ttl ... revenue center's 3 and 5 match up. Very strange. -- Anthony

Thanks! So, here's what we have (I've pulled the data from the tables into SQLite and a CSV since I don't have continuous access to their Micros system): select count( chk_cnt) as count, sum( rpt_ttl) as sum, rvc_seq from micros0718 where date_time >= '19/07/2012' and date_time <...

Sorry! I didn't get a notification about this response. Not sure why we are using suppressed_rpt_ttl ... we really know very little about Micros, probably saw this somewhere on the web. Using the rpt_ttl doesn't necessarily get us any closer, I'm afraid. Two of our revenue centers stay "spot...

We're trying to extract sales from a Micros RES 4 database, in 15-minute periods, by revenue center. More specifically, we are running this type of query against the database: select count(d.chk_cnt) as count, sum(d.suppressed_rpt_ttl)as sum, tdtl.rvc_seq from trans_dtl as tdtl join dtl as d...

Coorsman, Thanks! Where would winhook.bat be located? I've searched the hard disk, but cannot find a winhook.bat ... this is with AlohaQS. Thanks! -- Anthony

We have several Aloha servers / BOH machines which have our software running on them. In many cases, during the Aloha EOD process, the services are being stopped (we can see this in the logs of the application), and then about 6 or 8 minutes later, it starts up one of our services. The other...

We are building a schedule in Aloha using a 3rd-party program (ours), and not the Aloha basic scheduler. The scheduler is creating the necessary files, and we can open the basic labor scheduler and see that our schedule is there. Unfortunately, the schedule doesn't automatically go from the...

We're finally getting to the point of implementing this (the rest of our Aloha integration is working and stable for several months now). I think the steps for us are pretty straightforward: 1. Our users will create a schedule on our web interface. 2. We'll then create a DBF file in...

Thanks for looking into this! I don't know where the basic scheduler would be, or how my clients would go about turning it on.

Megabyte, Would it make sense to continue here, or to start a new thread? In short, what we're doing is: - Reading through the grind process (which we now launch directly), and getting the EMP.DBF, POS.DBF, etc... files to pull the employees, positions, and sales. This is done, thanks to...

MegaByte, Again ... thanks for your insight! I don't suppose you'd be willing to do some "consulting" with us to help with the labor scheduling portion? It's the last bit that we need (we're pulling sales, employees, positions, and all of the other information we need). Certainly can...

Megabyte, Thanks for chiming in. My last conversation w/ Radiant about the licensing for the COM was about 15 months ago, but I was told there would be an annual, per-site license. Maybe something has changed, or I was misinformed? I was unaware that there were any COM calls that were...

Bo, Thanks for your insight ... yes, I believe they get that information directly from their database (in the DATA/ folder)? However, it's even less documented than the grind files, and Radiant seems to have an issue with people poking around inside of the actual database. Unfortunately, our...

Thanks for your help! I think with this information we should be able to do what we need to do.

Megabyte ... thanks for your pointers. Radiant Corporate. Large national franchisee. Knowledge base? Is it public, with a URL? Thanks!

We're using our own custom software ... which we use to interface to Micros, Dinerware, Restaurant Manager, POSitouch, and a few others, but Aloha continues to give us the fits :-) Basically, our product is a service that sits and waits for the grind files to appear, and then processes them as...

Is it possible to run the Aloha grind process more than once per day? IE, we'd like to get sales data and labor data out of the system, say, 4 - 6 times per business day. How would we go about doing this? Thanks!

I'm looking for some help reading the daily grind files. I'm reading the GNDSLSUM.DBF file, and I'm running into a few issues. 1. The document I have says that the KeyVolume has 3 values (1, 2, and 3). However, my clients KeyVolume values include 4's and 5's. What are 4's and 5's? 2. What...