Menu and Sales Category Export and Import

From RPOWERWiki

Jump to: navigation, search

Contents


RPOWER includes the ability to export and import Menu Panels, Menu Sales Categories, Menu Items and Menu Buttons. This ability proves extremely useful when managing multi-store installations, entering large scale price changes, or when building pizza or other menus using compound items.

To export Menu Panels, Menu Sales Categories, Menu Items and Menu Buttons, from Manager Functions touch Run Script, enter MENUEXP at the prompt and touch Enter.

Four comma separated value files: RPMIT-1-Panels.csv, RPMIT-2-SlsCats.csv, RPMIT-4-Items.csv and RPMIT-6-Buttons.csv containing Menu Panels, Menu Sales Categories, Menu Items and Menu Buttons, respectively, are created in the folder:

Sys\RPOWER\EXPORTS

Any of the files may then be opened in Microsoft Excel.

  • Tip: To force Excel to automatically widen its cells to fit each data field, first click the top-left box, above 1 and to the left of A, which selects the entire sheet, then double click the line separating column A from B.

Menu Panels

Looking at Menu Panels first, RPOWER exports each Menu Panel as a record in the csv file.

To add a new menu panel, insert a new blank worksheet row, it doesn't matter where, and cut and paste an existing record with similar behaviors and appearance to that required, then edit the record fields as necesssary. While it is possible to create a new menu panel by only populating the !ITEM_TYPE, PRINT_NAME, and MOD_FLAGS fields, it is recommended that an entire, existing record be cut and pasted, and then edited as necessary.

!ITEM_TYPE is a required field and is always j

PRINT_NAME, SPEC_NAME and ALT_NAME correspond to Name, Addl Name and Lng 2 Name respectively. PRINT_NAME is a required field. Note that the total menu panel name is actually a concatenation of the PRINT_NAME and SPEC_NAME fields; removing an existing SPEC_NAME will not remove it from an existing panel, but will instead create a new menu panel upon import, as RPOWER will recognize the total menu panel name as new.

The three PRICEX fields are not actually part of the database, but are generated during the export from the contents of LAYOUTS, and reflect the number of columns and rows (C.R) displayed in the left, middle and right sections of the panel, respectively. These fields may be edited but may only by incremented, that is, made larger. RPOWER will ignore edits that decrement, or make these fields smaller. This is intentional and is to prevent accidentally hiding menu items. To force RPOWER to accept a smaller entry it must be made negatively, e.g. -1.05 or 2.-04.

LAYOUTS is a decimal representation of the hexadecimal equivalent of the three PRICEX fields, e.g., 2570023 converted to hexadecimal becomes 273727, representing 2x7, 3x7, 2x7, the default menu panel layout. This field should not be edited, use the three PRICEX fields to enter changes to a menu panel's layout.

MOD_FLAGS represents a combination all of the parameters available in the Modifier Menu Behavior box within Menu Information, except for the #Forced (Minimum), #Auto-Done After and Count up-to settings, which see below. MOD_FLAGS is a required field. Copy values from another known, working menu panel record.

BMP_NAME reflects the name of the bit map file, if any, used to display a picture on the menu switch. Enter the name of any existing .bmp file if desired.

MOD_REQ and MOD_ADONE represent the value of #Forced (Minimum) and #Auto-Done After. Copy values from a known, working menu panel record if needed.

DTM_ISSP is a reserved field and is unused at this time.

COLOR reflects the color value of the border of the menu panel's corresponding menu switch. Enter color values as desired, or copy from another menu panel record. The color values are:

1 Red
2 Burnt Orange
3 Brown
4 Olive
5 Green
6 Bluegrass
7 Teal
8 RPOWER Blue
9 Blue
10 Purple
11 Magenta
12 Plum
13 Salmon
14 Orange
15 Yellow
16 Khaki
17 Mint
18 Seafoad
19 Aqua
20 Tan
21 Sky Blue
22 Lavender
23 Fuchsia
24 Patty Pink
25 Black
26 Grey
27 Light Grey
28 White

BTN_FLAG is a reserved field and is unused at this time.

COUNT_UPTO reflects the Count up-to value of the menu panel. Copy values from a known, working menu panel record.

CAT_NAME reflects

DESC_PIN reflects the Description of the menu panel and is used for digital signage and online ordering web site maintenance. Enter a description of the menu panel, 1499 characters maximum.

To import the file back into RPOWER it must be saved to the folder:...

\Sys\RPOWER\IMPORTS

...in csv format. Create the folder if necessary. Note that during the save operation Excel will warn that the file may contain features that are not compatible with CSV - click Yes at the prompt to keep the format.

Important note: Be sure to close Excel, or at least the export file that is being edited before executing the import. The import will fail silently (no errors displayed) if the .csv file is still open within Excel. Excel will ask if you want to save changes - since you just did it's okay to click No.

To execute the import, from Manager Functions touch System Maintenance and then Execute Imports. Import records identical to existing records are skipped, new records are added, and changed records are updated.

Menu Sales Categories

Now let's look at a Menu Sales Categories export.

To add a new menu sales category, insert a new blank worksheet row, it doesn't matter where, and cut and paste an existing record with similar behaviors and appearance to that required, then edit the record fields as necesssary. While it is possible to create a new menu sales category by only populating the !ITEM_TYPE and PRINT_NAME fields, it is recommended that an entire, existing record be cut and pasted, and then edited as necessary.

!ITEM_TYPE is a required field and is always c.

PRINT_NAME corresponds to Name in Menu Sales Categories and is a required field.

CAT_ID is a reserved field and is unused at this time.

GL_NUM is the General Ledger account number to be credited for sales in this category. Copy and paste the G/L number from an existing record, or simply enter it here if desired.

GL_NAME is the General Ledger account name and is exported by RPOWER for the convenience of the operator in identifying G/L account numbers. This field is not required to be populated in order for the GL_NUM to be correctly imported.

COLOR reflects the default color value of this category. Enter color values as desired, or copy from another category record. The color values are detailed above in the Menu Panel discussion.

ITEMIZERS reflects the itemizers selected for this category. Copy and paste this field from an existing category with identical itemizer behavior.

PRINTERS reflects the default printers and printer behaviors selected for this category. Copy and paste this field from an existing category with identical printer behavior.

DTM_MASK reflect the Day/Time periods selected for this category. Copy and paste this field from an existing category with identical Day/Time period selection.

MOD1 - MOD4 reflect the Special Modifier panels available to menu items defined in the category. Note that MOD1 and MOD2 only are currently used by RPOWER. Enter Special Modifier panel names as desired, or copy and paste from another category record.

Menu Items

A Menu Item export is next.

To add a new menu item, insert a new blank worksheet row, it doesn't matter where, then cut and paste an existing record with similar behaviors and appearances to those required, then edit the record fields as necesssary. While it is possible to create a new menu sales category by only populating the !ITEM_TYPE, PRINT_NAME and CAT_NAME fields, it is recommended that an entire, existing record be cut and pasted, and then edited as necessary.

!ITEM_TYPE is a required field. Valid item types are:

R (R)egular Menu Item
P (P)rice Hidden Add-on
A Calculated Item
B (B)uilt-In Modifier
L Scale/Quantity Item
M (M)odifier or Prep
K Note to the (K)itchen
C Discount or (C)oupon
G Calculated (G)ratuity
H (H)idden Gratuity
I House Gratuity
N Pop-Up (N)ote Add-On
T Item Kit
V (V)oid/Comp Prefix

PRINT_NAME, SPEC_NAME and ALT_NAME correspond to Name, Addl Name and Lng 2 Name respectively. PRINT_NAME is a required field. Note that the total menu panel name is actually a concatenation of the PRINT_NAME and SPEC_NAME fields; removing an existing SPEC_NAME will not remove it from an existing panel, but will instead create a new menu panel upon import, as RPOWER will recognize the total menu panel name as new.

Views
Personal tools