Creating New Menus

Building menus can be a tedious job, using the Redbox Menu Import and Export functionality allows a user to build their menus quickly and easily. It will require a blank menu to be exported, the .CSV file to be populated with the menu details and imported back into the Redbox System. For other usage scenarios, please see the Menu Import and Export guide.

Exporting

Menus:

Navigate to the Redbox Management Portal → Businesses → Select the required business → Menu → Select ‘Export’ → Select ‘Menu’ → Select ‘Update existing items’ → Click Export. This will create and download a CSV file, ready to be populated with data.

Open the CSV file. This will open a blank file with the following column headings:

Populate the fields with the required data, see Field Values for CSV file for Menus for an indication of the data allowed. DO NOT edit any of the headings, these are used for importing the file back into the Redbox system to identify the relevant import type.

When you have finished making changes save it as a .CSV file.

Menus Items:

Navigate to the Redbox Management Portal → Businesses → Select the required business → Menu → Select ‘Export’ → Select ‘Items’ → Select ‘Update existing items’ → Click Export. This will create and download a CSV file, ready to be populated with data.

Open the CSV file. This will open a blank file with the following column headings:

Populate the fields with the required data, see Field Values for CSV file for Menu Items for an indication of the data allowed. DO NOT edit any of the headings, these are used for importing the file back into the Redbox system to identify the relevant import type.

When you have finished making changes save it as a .CSV file.

Options:

Navigate to the Redbox Management Portal → Businesses → Select the required business → Options → Select ‘Export’ → Select ‘Options’ → Select ‘Update existing items’ → Click Export. This will create and download a CSV file, ready to be populated with data.

Open the CSV file. This will open a blank file with the following column headings:

Populate the fields with the required data, see Field Values for CSV file for Options for an indication of the data allowed. DO NOT edit any of the headings, these are used for importing the file back into the Redbox system to identify the relevant import type.

When you have finished making changes save it as a .CSV file.

Option Items:

Navigate to the Redbox Management Portal → Businesses → Select the required business → Options → Select ‘Export’ → Select ‘Option Items’ → Select ‘Update existing items’ → Click Export. This will create and download a CSV file, ready to be populated with data.

Open the CSV file. This will open a blank file with the following column headings:

Populate the fields with the required data, see Field Values for CSV file for Options Items for an indication of the data allowed. DO NOT edit any of the headings, these are used for importing the file back into the Redbox system to identify the relevant import type.

When you have finished making changes save it as a .CSV file.

Importing

Menu and menu items:

The Redbox system will automatically detect which type of import your are submitting (Menu or Menu Items).

Navigate to the Redbox Management Portal → Businesses → Select the required business → Menu → import → Click ‘Browse’ → Locate the menu or menu items CSV file you would like to import → Click ‘Start Import’ → A view called Import Data will appear with all the data from the CSV file.

From this view, you can:

• make further changes to the menus if necessary.

• select which items you would like to be import or deselect items which you do not want to be imported.

• Allocation menu items to a menu via a pre populated drop down box (menu item imports only).

Once you are happy with the current selection, click Import Selected. One by one, each item will be imported. When the import is complete, you will get a success message. Please refresh the screen after each import is successful to see the updates.

Options and option items:

The Redbox system will automatically detect which type of import your are submitting (Option or Option Items).

Navigate to the Redbox Management Portal → Businesses → Select the required business → Options → import → Click ‘Browse’ → Locate the option or option items CSV file you would like to import → Click ‘Start Import’ → A view called Import Data will appear with all the data from the CSV file.

From this view, you can:

• make further changes to the options if necessary.

• select which items you would like to be import or deselect items which you do not want to be imported.

• allocate option items to an option via a pre-populated drop down box (Option item imports only).

Once you are happy with the current selection, click Import Selected. One by one, each item will be imported. When the import is complete, you will get a success message. Please refresh the screen after each import is successful to see the updates.

How to save the CSV file 

The Redbox systems import facility will only accept file in the .CSV format. Saving the file in the correct format is an important step in setting up the .CSV file.

Saving the CSV using Apple's Numbers program

1. Once you have completed the edits to the file

2. Click ‘File’

3. Click ‘Export to’

4. Select ' CSV

5. On the Export Your Spreadsheet popover, select ‘Next…’

6. Set the name of the file and select where you would like the document to be saved

7. Click ‘Export’

8. Your file is now ready to be imported into the Redbox Management Portal

Saving the CSV file using Windows Excel program

1. Once you have completed the edits to the file

2. Click ‘File’

3. Click ‘Save’

4. Locate the .CSV file on your device (it was most likely saved in your downloads file)

5. Right click the file name, select ‘Open with’ and select ‘Notepad’

6. The file will be opened in Notepad, here you will need to delete any blank spaces trailing the last comma in the document.

7. Once you have deleted all the blank spaces trailing the last comma, click ‘File’

8. Click ‘Save’

9. Your file is now ready to be imported into the Redbox Management Portal

Saving the CSV file using Google’s Google Docs

1. Once you have completed the edits to the file

2. Click ‘File’

3. Click ‘Download’

4. Select ‘Comma Separated Values (.CSV)’

5. The file will now be downloaded to your device and is ready to be imported into the Redbox Management Portal.

Field Values for CSV files

Menus:

Menu Items:

Options:

Option items: