How to Add Data to the Portal At One Time Using Mass Import
Table of Contents
Mass import is a time saving tool available to add a large quantity of data to your portal at one time. Mass import is available for all Portal Administrators and is a permission that can be given to DateCodeGenie® Managers.
Mass Import is located in the portal under the Mass Import tab and allows adding data after downloading the most recent version of the Mass Import template, a protected Microsoft Excel based template. Not all data for each tab can be imported. A popup will display on the mass import template with added instructions for each column heading. Data can be added to the following tabs using the mass import template:
- Users tab
- Category tab
- Menu Items tab including location overrides (a purchased software add-on)
Common uses of Mass Import include:
- Adding data to an empty portal
- Adding location overrides to a new location
TIPS & TRICKS
To update data already added to the portal or to add new data to the portal see Updating and Adding data to my portal using Mass Export.
Import instructions are listed in the Mass Import tab and in the steps below.
Steps:
1. Log in to the portal using the preferred browser. See Preferred Portal Browser
2. Scroll and click the Mass Import tab from the sidebar to open.
3. Download the template by clicking the green download template button in the upper right corner of the page.
WARNING
Always download a new template each time. Importing from a template not recently downloaded will not import if changes to the template have been made.
4. Open the download file from your computer's download file or from the bottom left corner.
5. Click Enable Editing in the yellow bar at the top of the template and save the template to your desktop without changing the format type (xlsx).
WARNING
The template is optimized for the desktop version of Microsoft Excel and no changes are allowed to the template columns or rows including adding, deleting, or formatting.
6. Click the tab at the bottom to add the appropriate data to each tab. Click each red triangle for additional instruction. Add data to rows without any blank rows between your data. See
NOTE
The mass import template does not generate barcodes. To generate several 12 digit UPC-A barcodes to add to menu items see How to Generate Several Barcodes at One Time
TIPS & TRICKS
To sort your data for easier updating, highlight all cells with data added NOT column headings. Click "Sort & Filter" from the menu bar and "Custom" to select the column to sort by.
7. Save the completed template to your computer. Go to the open import page and click the Choose File button to select the saved template.
8. The template file name will display. Toggle each tab to Y (orange) to upload the template data to the portal and click the Upload button to begin uploading.
9. Data will display:
- Preview by tab
- Use the legend key for color detail
- Click the arrows to change pages
- Click the three line icon to view additional data for each row
- Click the Import button to confirm and upload to each tab
10. Click the Done button to complete the import and return to the Dashboard tab to see updated data content displayed.
For additional assistance see Contact & Support