MICROS 3700 Menu Import 1

[RyanCountry]

It has been sometime since my last interaction with the 3700. Looking to update the mi_def table via sql. I would like to import a list of menu items from a flat file into the mi_def table. Getting errors regarding primary and foreign keys, when trying to us the load into statements. Has anyone successfully performed this feat, and would be willing to share the syntax?
Thanks,
Ryan

 

[CathalMF]

Well the menu item table has a bunch of dependencies on other tables like mi_price_def, maj_grp_def, fam_grp_def

You need to make sure everything is in order and correct.

Do you want some custom SIM scripts developed. Contact me via my website

http://www.microspostools.com/

 

[kknoy]

You could create one item of each type you want then copy and paste it in bulk. Then you can rename all before it is rung using sql.
If you want that statement let me know.

 

[Jackba]

@kknoy

If you don't mind sharing the sql , will highly appreciate

 

[BootstrapperRI]

@Jackba

Try this.

David Jenulis
www.ncbpinc.com

 

[Jackba]

@Bootstrapper

Thanx this is a life saver this will help me a lot, have been trying to come up with something similar but haven't been able

 

[kknoy]

Below is what we used in sql. However we also separated out the different menu item groups so when we had more to add there were already areas for it. You could add in updateing prices and what not as well if needed or use price wizard for that. I used a CSV file to save as txt file to convert to sql so I could just copy and paste.

update micros.mi_def set name_1 ='100 Acre WB' where obj_num =5200075 update micros.mi_def set name_2 ='Pink Gold' where obj_num=5200075
update micros.mi_def set name_1='100 Acre WB' where obj_num =5200076 update micros.mi_def set name_2 ='Gold' where obj_num=5200076
update micros.mi_def set name_1='Bindi Chd' where obj_num =5200077 update micros.mi_def set name_2 ='Quartz' where obj_num=5200077
update micros.mi_def set name_1='Brancott SB' where obj_num =5200078 update micros.mi_def set name_2 ='Rsv' where obj_num=5200078
update micros.mi_def set name_1='Brokenwood Sem' where obj_num =5200079 update micros.mi_def set name_2 ='' where obj_num=5200079
update micros.mi_def set name_1='Clos Otto WB' where obj_num =5200080 update micros.mi_def set name_2 ='Boxhead' where obj_num=5200080
update micros.mi_def set name_1='Cloudy Bay Chd' where obj_num =5200081 update micros.mi_def set name_2 ='' where obj_num=5200081
update micros.mi_def set name_1='Cloudy Bay SB' where obj_num =5200082 update micros.mi_def set name_2 ='Te Koko' where obj_num=5200082
update micros.mi_def set name_1='Craggy Range SB' where obj_num =5200083 update micros.mi_def set name_2 ='Te Muna Rd' where obj_num=5200083
update micros.mi_def set name_1 ='AP Vin PN' where obj_num =8500515 update micros.mi_def set name_2 ='Ridgetop ' where obj_num=8500515
update micros.mi_def set name_1='A Rafanelli Cab' where obj_num =8500516 update micros.mi_def set name_2 ='09' where obj_num=8500516
update micros.mi_def set name_1='A Rafanelli Cab' where obj_num =8500517 update micros.mi_def set name_2 ='375' where obj_num=8500517
update micros.mi_def set name_1='AP Vin PN' where obj_num =8500518 update micros.mi_def set name_2 ='Kanzler ' where obj_num=8500518