Overview

The Mass Write Schedules with Sheet feature allows users to update schedules in bulk through a spreadsheet upload. Unlike the standard Mass Write, where a single schedule is applied to all selected schedules, this functionality enables:

• Applying different weekly times to each schedule individually

• Scheduling updates to take effect on different dates across schedules

This provides greater flexibility and control when managing multiple schedules across stores or locations.

Access Requirements

Before using this feature, we need to confirm that the correct permissions are enabled. Access can be verified in Launchpad by checking the Mass Write permissions for the user role. The role must have Read and Write access for Schedule Mass Write.

Enabling Permissions

To enable the required permission:

1. Open Launchpad -> Apps -> KODE OS -> Roles -> Edit Role

2. Locate and select the relevant user role

3. Edit the Mass Write permissions

4. Enable Read and Write access for Schedule Mass Write

Only Launchpad Admin can update role permissions. If you do not have admin access, please raise a support ticket to request this change.

How to Update Schedules Using a Sheet

This feature is available in KODE OS at the Portfolio level. From the Mass Write section, we can manage points and schedules, only if the required permissions are enabled. To update schedules, select Write Schedules from the top right corner.

This opens a new window where schedule information can be reviewed and updated, including the option to import schedules using an Excel sheet is available at the bottom of the left panel.

Selecting the “Import Schedules with Sheet” button, opens a dialog where users can download the Excel template. 

The template contains only the column headers by default and can be viewed here.

Required Sheet Information

After downloading the sheet, we must fill in the following columns.

Identifier
Represents store ID and it can be added when adding the store in Launchpad, usually the ID is defined with up six/seven numbers such as 1210168

EffectiveStart
Defines the date when the schedule update will take effect. This date can be different for each store.

• Required format: MM/DD/YYYY

• The date must be in the future

Daily Start and End Times
Each day of the week has separate Start and End time columns. The columns begin with Saturday and continue through Friday.

Examples:

• SaturdayStart, SaturdayEnd

• SundayStart, SundayEnd
  …

• FridayStart, FridayEnd

All days must be filled in.

• Required format: 24 hour time

• Examples: 22:00 for PM, 07:00 for AM

Once all required fields are completed, we can upload the Excel sheet using the same Import Schedules with Sheet.

Any missing or invalid values will be flagged during the upload process.  Once the import is completed it will select those stores with specified Identifiers and show all available schedules. Then we can proceed to select the schedules we want to update and click Execute. 

The Weekly Schedule of each selected schedule will be updated at the specified effective date provided in the sheet while the special events won’t be touched.

Overall Functionality

Mass Write Schedules with Sheet workflow looks like:

• Users download a template sheet

• They fill it with required information:

• Identifier 

• ID of the store which can be added in Launchpad

• EffectiveStart

• The date on which the update will take place

• Start and end times for each day of the week

• E.g MondayStart - 9:00 & MondayEnd 22:00 - which represents the time slot of the Monday for that schedule

• Upload the sheet and we will select those stores

• Users then proceed to select which schedules they want to update

• And click Execute