This utility imports or exports Menu Items and options to and from Excel files.

Menu Item Import provides the convenience of entering multiple menu items with similar attributes. This is especially useful when you are setting up a new menu and have many items with similar attributes, such as Groups, Categories, Taxes and Printers.

Similarly, the Export Utility allows users to export all menu items and options into an Excel file for reporting or modification.

An Import Excel template is available for download here:

Version 6 - Menu Import Template

NOTE:

For Volanté build number prior than 996, please refer to /wiki/spaces/IS/pages/63610817

Details of Article

Export/Import with GUI

Open the Back Office.
Hold down ALT key
While holding ALT, type mitool to launch GUI
Simple Export will export the menu items in default mode with the following columns
(id,DivisionName,GroupName,CategoryName,CategoryType,MenuitemName,d_printName,MMI,d_plu,
Printers,Taxes,tagId,AutoCombo,ComboPriority,ComboMatchTags,ComboPriceMod,itemCategories,
d_unit,d_count,d_isDiscountable,d_numDiscountsAllowed,d_cost,Price,MenuSets,storeId,Options).

This tool is usually used to export menu items to construct a new store database.

Full export involves exporting menu items in Full Mode. It is usually used to export menu items for use in local modification, or used in rebuilding the database menu.
If the tool is launched from the Enterprise HO, it will prompt you to enter the storeId for Import / Export
Enter the file name you wish to save the .xls as.
After the menu items have been exported, you can edit the .xls document to make changes.
Note you cannot use square brackets in Excel - [ or ]; users are advised to rename the item once the menu is loaded. Avoid using square brackets.

Excel File format

Menu Items

The first sheet in the Excel file is for the menu items.
The first column is always "CopyLink", which is defined as a VLOOKUP function. It is used to copy to Quick Menu Sheets to create new quick menu items.
The second column is always "id". This column should contain unique numbers so that the quick menus can link to specific items
The other columns are defined as menu item detail columns - DivisionName, GroupName, CategoryName, CategoryType, MenuitemName
All other sheets starting from the second tab are Menu Set Sheets. The Tab name represents the name of the Menu Set and the contents of the sheets are the quick menu entries of the menu set.

It is important that all of the Columns listed above are in the exact order as they are found here.

Quick Menus

There are 14 quick menu tabs for each menu sets, each quick menu tab is defined in a 16x5 rectangle. All the quick menu tabs are displayed in order.

The left top cell is the quick menu page name.
The third cell in the top row is the number of rows of this quick menu.
The fifth cell in the top row is the number of columns of this quick menu.
The content in any quick menu entry cell should be a VLOOKUP function.
Cells not adhering to the proper criteria will be ignored during import or export. This includes:
- Cells falling out of the defined area
- Cells with content not written in the proper VLOOKUP function format.

More Info

Importing/exporting with Jshell

Launch Jshell and connect to the server database.
For further details, please refer to: /wiki/spaces/IS/pages/63610817

Development Reference

System Architecture

This program is used to export the Volanté menu item database structures to Excel files, where they can then be easily modified by customers and the technical support team.

There are two steps in these Export/Import processes:

Exporting: Volante Database -> CSV File -> Excel file
Importing: Excel files -> CSV File -> Volante Database structure

The CSV file is an intermediate file; it is stored in export directory.

Related Class files

chezTesoro/console/MITempate.java: Converts between the volante database and csv files.
chezTesoro/console/ExcelConverter.java: Converts between csv files and excel files.
chezTesoro/console/mi.java: Jshell interface to importing and exporting csv files.
chezTesoro/console/MITemplate2.java : GUI interface to importing and exporting excel files.

Related Database Tables

External Libraries

Add new column in menu item structure

There are only two mode for exporting/importing menu items. Default Mode and Full Mode.

The columns in Default Mode is defined in MITemplate.m_defTemplateTable structure and the columns in Full Mode is defined in MITemplate.m_maxTemplateTable. MITemplate.m_minTemplateTable is defined as the minimized columns in exporting/importing file.

So when one new column is added to Menu_Item_Details table, it is necessary to add the column name to both MITempalte.m_defTemplateTable and MITemplate.m_maxTemplateTable

If this new column is not a simple structure type (i.e. int, boolean, double, String, Integer, Timestamp), a converter is required when converting this database column between the java Object.

For example:

cInfo.setTaxes(MICopyManager.transNames2Types(TaxTypesName, taxes));

Taxes is a BitSetString structure stored in the database. When converting tax types to a Java object, we make use of the converter MICopyManager.transName2Types to convert it.

If this new column has a default value when the importing column is missing, the programmer must implement the default value in MITemplate.defaultValue().

More Information

Developer Reference - /wiki/spaces/IS/pages/63359524

Related Articles

Page:

How do I setup combos using menu item tagging?
Page:

How do I setup a multi-topping specialty pizza?
Page:

How do I print barcode labels?
Page:

How do I consolidate kitchen printouts?
Page:

Menu Colours
Page:

What do interface links do?
Page:

POS Change Menu Sets
Page:

Combos - Price Modifier Discount Setup (Old)
Page:

How do I create a pizza menu?
Page:

Tim Horton Menu Setup
Page:

Menu setup - Menu structure function
Page:

What colours can the Quick Menu buttons be?
Page:

Link Menu Item Options
Page:

Barcode Label Printing (Old)
Page:

Combos - Menu Items Tag Combos

See Also:

Troubleshooting Articles

How do I export menus from one store to another using an Excel file?

Browser not supported