Importing Category and Attribute names from an Excel Spreadsheet

Introduction

Myriad Schedule v6.8 adds in the ability to import a list of Category/Type/Energy etc. names from an Excel Spreadsheet. This makes it very easy to build a list of new Categories and Attributes or to import from another system just by preparing the list in Excel then importing that list into Myriad.

Spreadsheet format

Each Attribute Type (e.g. Category, Type, Gender, Energy, Styles etc.) are entered onto specifically named Excel Sheets and each row is then imported into the database. Any names that already exist are skipped to avoid duplicates, and any new names are added to the end of the list in the order they are entered into the spreadsheet.

Note: Tempos, Eras and Genders will only only be imported if your Station is enabled for Myriad Schedule Pro. 

Template file

Attached to this article is a template Excel spreadsheet file that you can use that has all of the Sheets named correctly.