Micros 9700 Menu items w/prices

[ttrain68]

Hello All,

Anyone have a script that will pull the menu item names with the prices?

 

[ttrain68]

Came across the following in case anyone else is looking: Not my work!

Copy the following code and paste it into a text file. save the file with the .sh (shell script) extension.
You may have to create the def_exports folder, I did.

# Menu Item Report
#
# Description:
# This script exports the menu items for a specified Revenue center
# Exports following information: Menu Item #, Class, SLU, Sequence and Price
#
# a file named mi_def.[RVC#] will be saved to the 9700 folder (d:/micros/les/pos/9700/def_exports
#
# Usage (Run on the Micros Application Server):
# Open Cygwin window and type: bash mi_list.sh [RVC#]
# to run for Revenue Center 1; enter bash mi_list.sh 1
# to run for Revenue Center 4; enter bash mi_list.sh 4
#

echo "Be Patient, this may take a few minutes..."
echo "OUTPUT_TO def_exports/mi_def_and_price.$1" > cmd_file
echo "FIELD_SEPARATOR , " >> cmd_file
#echo "SELECT number,def_seq_num,name_1,name_2,mi_class,slu,nlu FROM mi_def.$1 mdef" >> cmd_file
echo "SELECT number,def_seq_num,name_1,name_2,mi_class,slu,nlu FROM mi_def.$1 mdef" >> cmd_file
echo "AND price FROM mi_price.$1 mprc" >> cmd_file
echo "WHERE mdef.number = mprc.number" >> cmd_file
d:/micros/les/pos/9700/bin/8700sql -ef cmd_file

 

[hosehead78]

You didn't give us time to answer.

However, yes, that is the best way and easiest (and looks a little familiar). What are you looking for exactly to accomplish?

 

[ttrain68]

Client wanted to print MI names with the price for reference. This did the trick, I just imported into excel, deleted the blanks and it looks pretty good.

 

[hosehead78]

Good to hear.