Micros ISL script for cutomer list

[Karliio]

I'm trying to make a ISL that we can enter our "vip" customers in that we can contact about promos and deals etc..
Though with a script where does the entered data get stored??
I want to be able to enter their name, phone number and maybe another field..

This will be my first script and I would really appreciate any guidance. I have already read the 3700 SIM Manual.

 

[pmegan]

Wow, that's pretty ambitious for a first script!

You determine where data is stored through your script. The most common destinations are probably flat files or custom tables in the Micros database. Writing back to a file on the server through a UNC path or mapped drive get's sketchy when techs replace equipment, so if you're comfortable with SQL I'd suggest the going database route.

If you do, write a stored procedure to do the inserts that can check for existing key fields, (phone#, email, etc...), so you're not entering the same people over and over. Putting that logic in the database is much faster and easier than doing it in the SIM script.