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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
micros RES 3700 -Customer display
- Thread starter mxap
- Start date
Yes you could if you are familiar with programming. We do that - have a DLL that runs on the workstation that passes the information to a fullscreen program running on the workstation. We use the Aures Yuno for it: [URL unfurl="true"]https://www.aures.com/var/aures/storage/images/point-of-sale-equipment-solutions-systems/yuno-touchscreen-terminal-multi-configuration/explore-yuno/yuno_04/3166-1-eng-GB/YUNO_04_s1.png[/url]
Quite attractive; we have it setup to run a video when there isn't an open check, and it is touch screen so we played around with the customer actually being able to interact with things.
We actually use the same DLL to push the same details to our digital menu board in the drive through, showing basically order confirmation. We use the digitalsignage.com software and wrote a nwjs component that it runs which displays the order confirmation piece. The board is used to show our menu, and we also put some software in the back which automatically updates the prices on the board when they are changed. Digital Signage is quite a flexible piece of software.
Quite attractive; we have it setup to run a video when there isn't an open check, and it is touch screen so we played around with the customer actually being able to interact with things.
We actually use the same DLL to push the same details to our digital menu board in the drive through, showing basically order confirmation. We use the digitalsignage.com software and wrote a nwjs component that it runs which displays the order confirmation piece. The board is used to show our menu, and we also put some software in the back which automatically updates the prices on the board when they are changed. Digital Signage is quite a flexible piece of software.
- Thread starter
- #3
I wrote all of the code, so I certainly know how to do it, but unfortunately I can't give it out or sell it. I suppose at some later date while at home and not on company time I could remake the product and as long as I make sure not to reuse anything, it shouldn't have any ownership issues, but as it stands I can't give out any of the stuff I already have.
I can point you in the right direction though...
You'll need a SIM file that is hooked into the DTL_CHANGED, FINAL_TENDER, BEGIN_CHECK and PICKUP_CHECK events. You would then basically just loop through the entire check whenever one of those are fired, and pass the data as an array to a DLL file using the CDECL call commands. That DLL could then pass it to the program that displays the information; in my case I'm using UDP, and while there is inherently the risk of data loss with that, the machine doing the broadcasting is also the machine doing the receiving, so its unlikely to have issues. The other advantage is that because there is almost no overheard (no doing the back and forth required with TCP) it is essentially instant and doesn't cause any noticeable lag on the system. The DLL just formats the array into XML and broadcasts it on UDP. The program that runs is a WPF application using the MVVM pattern; when it receives the UDP broadcast all it does is update the array containing the list of items, and the UI automatically updates.
I know that might not be a lot of help if you aren't a programmer, but I can't give much more than that, especially as I'm at work. This is all obviously owned by my company given I used company resources and time to develop it specifically for the company.
I can point you in the right direction though...
You'll need a SIM file that is hooked into the DTL_CHANGED, FINAL_TENDER, BEGIN_CHECK and PICKUP_CHECK events. You would then basically just loop through the entire check whenever one of those are fired, and pass the data as an array to a DLL file using the CDECL call commands. That DLL could then pass it to the program that displays the information; in my case I'm using UDP, and while there is inherently the risk of data loss with that, the machine doing the broadcasting is also the machine doing the receiving, so its unlikely to have issues. The other advantage is that because there is almost no overheard (no doing the back and forth required with TCP) it is essentially instant and doesn't cause any noticeable lag on the system. The DLL just formats the array into XML and broadcasts it on UDP. The program that runs is a WPF application using the MVVM pattern; when it receives the UDP broadcast all it does is update the array containing the list of items, and the UI automatically updates.
I know that might not be a lot of help if you aren't a programmer, but I can't give much more than that, especially as I'm at work. This is all obviously owned by my company given I used company resources and time to develop it specifically for the company.
- Thread starter
- #5
Moregelen,
I really appreciate the facts. Thanks.
I have a good friend who is a programmer. Maybe I can seek some help form him. I don't think he knows about micros though. Mostly MSSQL and programming language.
Let me talk to him.
I may bug you time and time if that is OK.
Again, thanks a lot for the info.
mxap
I really appreciate the facts. Thanks.
I have a good friend who is a programmer. Maybe I can seek some help form him. I don't think he knows about micros though. Mostly MSSQL and programming language.
Let me talk to him.
I may bug you time and time if that is OK.
Again, thanks a lot for the info.
mxap
- Thread starter
- #6
- Thread starter
- #8
- Thread starter
- #9
- Thread starter
- #11
Thanks, Moregelen.
My developer says he can create the DLL file just fine. May need help on Creating SIM file. How can he start on creating a SIM file for this secondary display so it ONLY displays the Items customer order with all the optional items as well such as NO Cheese.
Thanks again for all your help
My developer says he can create the DLL file just fine. May need help on Creating SIM file. How can he start on creating a SIM file for this secondary display so it ONLY displays the Items customer order with all the optional items as well such as NO Cheese.
Thanks again for all your help
C:\MICROS\Documentation\Help\SIMHelp.chm"
That file contains most of the documentation.
Essentially he will need to tie into the dtl_changed event:
Then from there you can loop through each item using the system variables.
for example:
That will loop through and just show a popup with the name of everything on the check. You will need to pass them to the DLL obviously.
Keep in mind that if you are writing your DLL for a CE device you have to compile it using the right version of C++. The regular old visual studio won't work.
That file contains most of the documentation.
Essentially he will need to tie into the dtl_changed event:
Code:
event dtl_changed:
... do stuff here...
endeventThen from there you can loop through each item using the system variables.
for example:
Code:
event dtl_changed:
[indent]var i : n9[/indent]
[indent]for i = 1 to @numdtlt[/indent]
[indent][indent]infomessage @dtl_name[i][/indent][/indent]
[indent]endfor[/indent]
endeventThat will loop through and just show a popup with the name of everything on the check. You will need to pass them to the DLL obviously.
Keep in mind that if you are writing your DLL for a CE device you have to compile it using the right version of C++. The regular old visual studio won't work.
- Thread starter
- #13
- Thread starter
- #14
Moregelen,
I know you helped me before exporting menu_items and it worked just fine.
Now for my other store, the export SQL query you gave me will only export three rows. so someone gave me this query and that seemed to export the entire menu.
Here it is:
select micros.mi_def.obj_num,micros.mi_def.name_1,micros.mi_def.name_2,micros.mi_slu_def.name,micros.mi_price_def.preset_amt_1,micros.prn_class_def.name from micros.mi_def
INNER JOIN micros.mi_slu_def on micros.mi_slu_def.mi_slu_seq = micros.mi_def.mi_slu_seq
INNER JOIN micros.mi_price_def on micros.mi_price_def.mi_seq = micros.mi_def.mi_seq
INNER JOIN micros.prn_class_def on micros.prn_class_def.prn_def_class_seq = micros.mi_def.prn_def_class_seq
ORDER BY micros.mi_def.obj_num;
OUTPUT TO C:\EXPORT.txt FORMAT ASCII DELIMITED BY ';'
Now, I am trying to import back the changed price but do not have the query.
Can you please help?
thanks a lot .
mxap
I know you helped me before exporting menu_items and it worked just fine.
Now for my other store, the export SQL query you gave me will only export three rows. so someone gave me this query and that seemed to export the entire menu.
Here it is:
select micros.mi_def.obj_num,micros.mi_def.name_1,micros.mi_def.name_2,micros.mi_slu_def.name,micros.mi_price_def.preset_amt_1,micros.prn_class_def.name from micros.mi_def
INNER JOIN micros.mi_slu_def on micros.mi_slu_def.mi_slu_seq = micros.mi_def.mi_slu_seq
INNER JOIN micros.mi_price_def on micros.mi_price_def.mi_seq = micros.mi_def.mi_seq
INNER JOIN micros.prn_class_def on micros.prn_class_def.prn_def_class_seq = micros.mi_def.prn_def_class_seq
ORDER BY micros.mi_def.obj_num;
OUTPUT TO C:\EXPORT.txt FORMAT ASCII DELIMITED BY ';'
Now, I am trying to import back the changed price but do not have the query.
Can you please help?
thanks a lot .
mxap
- Status
Similar threads
