Update scheduler data for version 2020.1

In this version of LS One new tables were added for kitchen display configuration and the assembly items that require data replication. There are also some new fields in existing tables so when you update to version 2020.1 from 2020 or 2019.1 you need to create new subjobs for the new tables and do a read database design.

To be able to upgrade you will need the following information

Create both normal and action jobs for the new tables:

Kitchen display configuration

  • KITCHENDISPLAYAGGREGATEGROUPITEM
  • KITCHENDISPLAYAGGREGATEPROFILE
  • KITCHENDISPLAYAGGREGATEPROFILEGROUP
  • KITCHENDISPLAYFUNCTIONALPROFILE
  • KITCHENDISPLAYHEADERPANE
  • KITCHENDISPLAYHEADERPANELINE
  • KITCHENDISPLAYHEADERPANELINECOLUMN
  • KITCHENDSIPLAYHOSPITALITYTYPECONNECTION
  • KITCHENDISPLAYITEMCONNECTION
  • KITCHENDISPLAYITEMSECTIONROUTING
  • KITCHENDISPLAYLINE
  • KITCHENDISPLAYLINECOLUMN
  • KITCHENDISPLAYPRINTER
  • KITCHENDISPLAYPRODUCTIONSECTION
  • KITCHENDISPLAYPROFILE
  • KITCHENDISPLAYSECTIONSTATIONROUTING
  • KITCHENDISPLAYSTATION
  • KITCHENDISPLAYSTATIONSTORE
  • KITCHENDISPALYSTYLEPROFILE
  • KITCHENDISPLAYTERMINALCONNECTION
  • KITCHENDISPLAYTIMESTYLE
  • KITCHENDISPLAYTRANSACTIONPROFILE
  • KITCHENDISPLAYVISUALPROFILE

Assembly item information:

  • RETAILITEMASSEMBLY
  • RETAILITEMASSEMBLYCOMPONENTS

The default replication data package now contains

  • Normal subjob:
    • for all KITCHENDISPLAY... tables
    • for both RETAILASSEMBLY... tables
  • Action subjob:
    • for all KITCHENDISPLAY... tables
    • for both RETAILITEMASSEMBLY... tables
  •  Action subjobs with move action with prefix O-
    • for both RETAILITEMASSEMBLY... tables

Scheduler data update

To update your scheduler data from LS One version 2020 to version 2020.1 you will first have to do a Read design. Then you will have to create subjobs for the new tables and add them to the jobs being sent.

Run Site Manager version 2020.1 and log in to your database.

When you do this the first time your database will be upgraded to 2020.1 version. Make sure to take a backup before updating the database. New tables and fields are added to your database.

  1. Go to Tools > Replication Settings > Distribution locations. Open the location from where you manage your replication and scheduling.
  2. In the right hand navigation press Read design

  3. Select Tables and fields and Update existing database design options and press OK.
  4. Now the Data Director will run through your database design and update it to include all new fields and tables.

Add both action (A-) and normal (N-) and (O-) jobs for the new data table listed above. On further information on how to do so read Subjobs.

Add the new action and normal jobs to the existing jobs. Read this topic: Jobs for more information on how to create and manage jobs.
Below is a list of all the job changes that were made to the demo replication data package:

Hospitality

Added:

  • A-KITCHENDISPLAYAGGREGATEGROUPITEM
  • A-KITCHENDISPLAYAGGREGATEPROFILE
  • A-KITCHENDISPLAYAGGREGATEPROFILEGROUP
  • A-KITCHENDISPLAYFUNCTIONALPROFILE
  • A-KITCHENDISPLAYHEADERPANE
  • A-KITCHENDISPLAYHEADERPANELINE
  • A-KITCHENDISPLAYHEADERPANELINECOLUMN
  • A-KITCHENDSIPLAYHOSPITALITYTYPECONNECTION
  • A-KITCHENDISPLAYITEMCONNECTION
  • A-KITCHENDISPLAYITEMSECTIONROUTING
  • A-KITCHENDISPLAYLINE
  • A-KITCHENDISPLAYLINECOLUMN
  • A-KITCHENDISPLAYPRINTER
  • A-KITCHENDISPLAYPRODUCTIONSECTION
  • A-KITCHENDISPLAYPROFILE
  • A-KITCHENDISPLAYSECTIONSTATIONROUTING
  • A-KITCHENDISPLAYSTATION
  • A-KITCHENDISPLAYSTATIONSTORE
  • A-KITCHENDISPALYSTYLEPROFILE
  • A-KITCHENDISPLAYTERMINALCONNECTION
  • A-KITCHENDISPLAYTIMESTYLE
  • A-KITCHENDISPLAYTRANSACTIONPROFILE
  • A-KITCHENDISPLAYVISUALPROFILE

Item

Added:

  • A-RETAILITEMASSEMBLY
  • A-RETAILITEMASSEMBLYCOMPONENTS

Preload Omni server

Added:

  • N-RETAILITEMASSEMBLY
  • N-RETAILITEMASSEMBLYCOMPONENTS

Preload POS

Added:

  • all N- jobs for KITCHENDISPLAY... tables
  • both N-jobs for RETAILASSMBLY... tables

Preload Store

Added:

  • all N- jobs for KITCHENDISPLAY... tables
  • both N-jobs for RETAILASSMBLY... tables

Synchronize Omni server:

Added:

  • O-RETAILITEMASSEMBLY

  • O-RETAILITEMASSEMBLYCOMPONENTS

for the Omni server it is important to run jobs that also move the actions to the Omni server so that the information will be replicated to the mobile POS.

 

Inserted: October 2020
Version: LS One 2020.1