ISL Script For ZIP Codes

[paul4867]

Guys - I'm looking to write a ISL script that will require a cashier to enter our customer ZIP codes. So before transaction is closed, there is a screen or button that points to a SIM that would require a cashier to enter ZIP code and post it to transaction detail and print it on recipe. Any idea how to accomplish this goal. We are currently using Micros 3700.

 

[Moregelen]

It would be a lot easier to just include a macro in your 'start check' button that adds a menu item called 'ZIP Code' with a reference required.

 

[paul4867]

We don't have the start check button but I could create a separate button or hooked it up within screen flow. I'm not sure how to enable reference required for that menu item. Can you help?

 

[Moregelen]

Well, to do it with a SIM I would still suggest going with the reference required Menu Item, and then you could just tie it into the SIM event:

event Begin_Check:

    loadkybdmacro key(3, MI_OBJECT_NUMBER_GOES_HERE)

endevent

To make the menu item require a reference, you will need to create a new menu item class. Take on of the ones you are currently using, and click the copy and then paste button on it. Then under the options check reference required. Create a menu item called ZIP Code and then set the menu item class to the one you just created. When you ring in the menu item, it will force them to type something in, though they could just hit enter and enter in a blank zip code, though this sounds like something you don't have to really worry about them trying to bypass.

 

[paul4867]

MI item class! I new that that must be somewhere there Grate! I will set it up on Tuesday and let you know how it goes. Thanks a lot!

 

[Netvoid]

This will do it also, can be better but this will put the zip in the check info line which should print with the check. Dozens of ways you can do it in SIM and POS Config... The user can just press "clear" and they wont be forced to perform the input. Same with the macro method. It can be popped into a loop and input forced... Not to say the input has to be accurate, that would take even more code.

But here is a pretty simple method.

Event Begin_Check

   Var zipInput      :a50=""
   Var infoLine      :a50=""
   
   //Put your numeric keypad touchscreen number here
   TouchScreen 42

   Input zipInput,"Enter Zip Code"

   Format infoLine as "ZIP: ",zipInput
   SaveChkInfo zipInput

EndEvent

 

[paul4867]

Ok, I was able to make a reference with MI to work but here is the challenge: as long as the ZIP MI and the reference is printed on a check or actually in the Micros journal, I need to be able to pull those ZIP codes from there into my SAS database. Currently there is a store procedure running every night generating a little text file with transactions detail unfortunately, it looks like it is not putting the reference information into it. Below is an example of an information that is included within the file
16,2013-09-03,11:38:47,2268,120,ZIP,1,0,,,,9000,1 AM CAS 1 AM CASHIER,,, ,1.21,19.78

So what I need to accomplish is weather be able to automatically add a zip code number to a menu item name or be able to add the reference column into it or, maybe there is some other way of doing it?
Just to clarify it, I have little experience with programing in Micros. I'm more on management and gui site of the business.

Any thoughts?

 

[Moregelen]

I think he meant to say: SaveChkInfo infoLine

Then if you want to find all of that information you could do an SQL to get that info. Assuming that it is line 1 every time, you could do something like:

SELECT SUBSTRING(line_01,6,5) FROM MICROS.chk_info_dtl WHERE line_01 LIKE 'ZIP: %'

That would give you all of the zip codes...

 

[Netvoid]

Moregelen is right that is what I meant and his SQL sample is good for a total dump of all zip's also.

Thanks

 

[paul4867]

Thanks guys! I'm going to play around, test it, see if it works for me, and let you know.