Hey guys. I've got an RES 3700 system and an application server. I'd like to push pricing information to the POS and get item counts from the POS system. Also, I would like to see if I could close tabs via the application server on the POS system, that would be awesome. I have no experience with POS but databases are not an issue for me at all. I just need to know the feasability of pushing this data back and forth and where to start? Is there a tutorial somewhere? Most everything I'm finding on the web is a forum with a specific question, leading me to believe what i'm looking to do is possible.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Micros POS interoperability question
- Thread starter chevell
- Start date
Do you have some specifics about your "application server". You can push and pull numbers like you have mentioned.
If you are using MSSQL you can use SSIS to pull data from the system with any "exports" running at the stores. You can also create exports to a flat file.
If you are using MSSQL you can use SSIS to pull data from the system with any "exports" running at the stores. You can also create exports to a flat file.
- Thread starter
- #3
Well, I haven't gotten far enough to design that part of it yet. I will be using some sort of SQL or ODBC compliant database. If I can do two way SQL calls directly to the POS Database that would be perfect. Basically, I want the POS system to tell my app server every time a certain product is purchased, and I want the app server to then change the price of that product based on calculations it makes. Finally, I want the app server to tell the POS database if a tab gets closed in the app server so it will close it out in the DB. Is this asking too much of this relationship?
Are you looking to intercept the order and change the menu item price before it hits the check, or are you changing it for future orders?
Editing the price before the item is posted to the check may be tricky, but updating the database for future orders wouldn't be too hard. You could use the "mi" event in a sim script to put it in action. You'd use the final_tender event in the same way to send a message that the check has been closed. You can access the Micros database with a dll call from inside these events, and the remote system with either another dll call or the sim transmit/receive functions. I'd probably stick with the dll calls if all the logic is inside the remote database.
There was a big database access discussion on here a few weeks ago. AZRobert posted some good info and MikeRose put up a really helpful starter script.
Editing the price before the item is posted to the check may be tricky, but updating the database for future orders wouldn't be too hard. You could use the "mi" event in a sim script to put it in action. You'd use the final_tender event in the same way to send a message that the check has been closed. You can access the Micros database with a dll call from inside these events, and the remote system with either another dll call or the sim transmit/receive functions. I'd probably stick with the dll calls if all the logic is inside the remote database.
There was a big database access discussion on here a few weeks ago. AZRobert posted some good info and MikeRose put up a really helpful starter script.
- Thread starter
- #5
Thanks for all the help guys!
Yes, I'm going to alter the price for future purchases.
I'll take a look for the db discussion you mentioned. I've never worked with Micros before. Just installed it and its sitting at Wiating for MDSHosts file. I'm assuming I'm missing something, so no more questions til I solve this.
Yes, I'm going to alter the price for future purchases.
I'll take a look for the db discussion you mentioned. I've never worked with Micros before. Just installed it and its sitting at Wiating for MDSHosts file. I'm assuming I'm missing something, so no more questions til I solve this.
- Thread starter
- #7
I'd say that your best bet is to get a database backup from your client, restore it on your test server and clear totals. The blank database that the install sticks in really is blank; there's nothing in any of the tables. You'll have to configure at least the employee classes, devices, revenue centers and touchscreens just to get it to a point where OPS can run, then you'll have to put together the menu item classes, levels and actual menu items to be able to test. There's probably more but I haven't started from scratch since putting together a startup database for the distributor I worked for about 10 years ago.
My guess on the MDSHosts file issue you're having is that there aren't any network nodes, devices or workstations defined so OPS has no idea how to start.
My guess on the MDSHosts file issue you're having is that there aren't any network nodes, devices or workstations defined so OPS has no idea how to start.
- Thread starter
- #9
- Status
Similar threads
- Locked
- Question