Export   

Purpose

The Select Menu Item Fields Window is used to export the selected fields from the Menu Item database. Items that appear in the Included Fields section will be exported in the order they are listed.

 

Accessing the Export Menu Item Fields

While in Focus Setup, select Menu > Menu Items > Tools > Export.

 

Figure 9.18 Select Menu Item Fields Window

 

Figure 9.19 Select Menu Item Fields Window Commands

Field

Description

File Name

Specify the path for the export file.

Moves all items in the Available Fields list to the Included Fields list.

Moves the selected item in the Available Fields list to the position above the selected item in the Included Fields list.

Moves the selected item in Available Fields list to the last position in the Included Fields list.

Moves the selected item from the Included Fields list to the Available Fields list.

Moves the selected item in the Included Fields list up one position.

Moves the selected item in the Included Fields list down one position.

Moves all items in the Included Fields list to the Available Fields list.

 

Figure 9.17.1 Menu Items Export Fields

Field

Import Format

Menu Name

The Menu Name, up to 32 alphanumeric characters.

Check Name

The Check Name, up to 23 alphanumeric characters.

Remote Name

The Remote Name, up to 23 alphanumeric characters.

ID

The ID, up to 25 alphanumeric characters. Note: If a Menu Item is found with the same ID, it is updated with the imported information.

Inventory ID

The Inventory ID, up to 25 alphanumeric characters.

Picture

The Picture name and extension, up to 20 alphanumeric characters. Example: “cheeseburger. jpg”

Price 1

The Price 1, up to 9999.99.

Price 2

The Price 2, up to 9999.99.

Price 3

The Price 3, up to 9999.99.

Price 4

The Price 4, up to 9999.99.

Price 5

The Price 5, up to 9999.99.

Price 6

The Price 6, up to 9999.99.

Sub Price

The Sub Price, up to 9999.99.

Extra Price

The Extra Price, up to 9999.99

No Price

The No Price, up to 9999.99.

Mod. Price

The Mod Price, up to 9999.99.

Dbl %

The Dbl% Percentage. Example: 1 = 100%, .5 = 50%

Taxes

Y or N for the taxes. Example: “YNNNNN” will set the first Tax as active and the next 5 Taxes as not active.  

Variable Price

Y or N

Repeat Round

Y or N

Kitchen Comment

Y or N

Follow Item

Y or N

Requires Beverage

Y or N

Satisfies Beverage

Y or N

Kitchen Price

Y or N

Out of Stock

Y or N

Scale

Y or N

Request Tare Weight

Y or N

Increment Guests

Y or N

Include in Item Price

Y or N

Countdown

Y or N

Guest Check

Y or N

Fraction Quantity

Y or N

Inventoried

Y or N

Cost From Recipe

Y or N

Timed Rate

Y or N

Type

“Food”, “Bar” or “Other”

Report Group

The name of the Report Group, up to 15 alphanumeric characters.

Meal Stage

“<None>”, “Appetizer”,” Dessert”, “Entrée, “Beverage” or “Other”

Printer Group

The Printer Group, up to 15 alphanumeric characters.

Printer Format

The Printer Format, up to 15 alphanumeric characters.

Price Level

The Price Level, up to 15 alphanumeric characters.

Sort

The Sort key, up to 2 alphanumeric characters.

Modifier Unit

The number of Units, up to 99.

Priority

The Priority, 0-9.

Effective Start Date

mm/dd/yyyy

Effective End Date

mm/dd/yyyy

Effective Time Range

The Time Range, up to 15 alphanumeric characters.

Count

The Count, up to 9999.

Cost

The Cost, up to 999.99.

Tare Weight

The Tare Weight, up to 15 alphanumeric characters.

Audio File

The Audio File name and extension. Example: “hello.avi”

Recipe File

The Recipe File name and extension. Example: “recipe.bmp”

Training File

The Training File name and extension. Example: “traning.jpg”

Nutrition File

The Nutrition File name and extension. Example: “nutrition.jpg”

Mod. Canvas 1

The Modifier Canvas 1 name, up to 30 alphanumeric characters.

Mod. Canvas Min. 1

The Minimum number of Mod Units, up to 99.

Mod. Canvas Max. 1

The Maximum number of Mod Units, up to 99.

Mod. Canvas Free 1

The number of Free Mod Units, up to 99.

Mod. Canvas 2

The Modifier Canvas 2 name, up to 30 alphanumeric characters.

Mod. Canvas Min. 2

The Minimum number of Mod Units, up to 99.

Mod. Canvas Max. 2

The Maximum number of Mod Units, up to 99.

Mod. Canvas Free 2

The number of Free Mod Units, up to 99.

Mod. Canvas 3

The Modifier Canvas 3 name, up to 30 alphanumeric characters.

Mod. Canvas Min. 3

The Minimum number of Mod Units, up to 99.

Mod. Canvas Max. 3

The Maximum number of Mod Units, up to 99.

Mod. Canvas Free 3

The number of Free Mod Units, up to 99.

Mod. Canvas 4

The Modifier Canvas 4 name, up to 30 alphanumeric characters.

Mod. Canvas Min. 4

The Minimum number of Mod Units, up to 99.

Mod. Canvas Max. 4

The Maximum number of Mod Units, up to 99.

Mod. Canvas Free 4

The number of Free Mod Units, up to 99.

Mod. Canvas 5

The Modifier Canvas 5 name, up to 30 alphanumeric characters.

Mod. Canvas Min. 5

The Minimum number of Mod Units, up to 99.

Mod. Canvas Max. 5

The Maximum number of Mod Units, up to 99.

Mod. Canvas Free 5

The number of Free Mod Units, up to 99.

Mod. Canvas 6

The Modifier Canvas 6 name, up to 30 alphanumeric characters.

Mod. Canvas Min. 6

The Minimum number of Mod Units, up to 99.

Mod. Canvas Max. 6

The Maximum number of Mod Units, up to 99.

Mod. Canvas Free 6

The number of Free Mod Units, up to 99.

Mod. Canvas 7

The Modifier Canvas 7 name, up to 30 alphanumeric characters.

Mod. Canvas Min. 7

The Minimum number of Mod Units, up to 99.

Mod. Canvas Max. 7

The Maximum number of Mod Units, up to 99.

Mod. Canvas Free 7

The number of Free Mod Units, up to 99.

Mod. Canvas 8

The Modifier Canvas 8 name, up to 30 alphanumeric characters.

Mod. Canvas Min. 8

The Minimum number of Mod Units, up to 99.

Mod. Canvas Max. 8

The Maximum number of Mod Units, up to 99.

Mod. Canvas Free 8

The number of Free Mod Units, up to 99.

Price Time 1

The Price Time 1 name, up to 15 alphanumeric characters.

Price Time 2

The Price Time 2 name, up to 15 alphanumeric characters.

Price Time 3

The Price Time 3 name, up to 15 alphanumeric characters.

Price Time 4

The Price Time 4 name, up to 15 alphanumeric characters.

Price Time 5

The Price Time 5 name, up to 15 alphanumeric characters.

Price Time 6

The Price Time 6 name, up to 15 alphanumeric characters.

Suggestion ID

The Suggestion ID, up to 25 alphanumeric characters.

Suggestion Text

The Suggestion Text, up to 80 alphanumeric characters.

Automatic Canvases

Y or N Example: “YNNNNN” will assign the Menu Item to the first Automatic Canvas but not the 2nd-5th.

Inv. Subgroup

The Inventory Subgroup name, up to 15 alphanumeric characters.

Inv. Vendor

The Inventory Vendor name, up to 15 alphanumeric characters.

Inv. Vendor Item Number

The Inventory Vendor Item Number, up to 20 alphanumeric characters.

Inv. Recipe/Sales Unit

The Inventory Sales Unit name, up to 4 alphanumeric characters.

Inv. Stock Unit

The Inventory Stock Unit name, up to 4 alphanumeric characters.

Inv. Purchase Unit

The Inventory Purchase Unit name, up to 4 alphanumeric characters.

Inv. Par Level

The Inventory Par Level, up to 99999.99.

Inv. Minimum Purchase

The Inventory Minimum Purchase, up to 99999.99.

Inv. Recipe -> Stock Conversion

The Inventory Stock Conversion number, up to 9999.99.

Inv. Stock -> Purchase Conversion

The Inventory Purchase Conversion number, up to 9999.99.

Cook Time

The Cooke Time in minutes, up to 99.

 

Procedure to Export Menu Items

Enter the File Name and path for the export.

Select the fields to export.

Click OK.

 

Related Topics

Job Right ‘Office – Menu’

 

 
Copyright © 2010 Focus POS Systems