Grid Import with Excel File
The grid import is a generic program schedule import that enables you to create a break schedule in MYDAS without an upstream planning system.
File description
Under this text, you will find a template that you can use for the upload. The file is an .xlsx file and should contain this file identifier even after editing.
Basically, you can use any name to name the file. However, the channel identifier stored in MYDAS should be at the beginning. For better identification, we recommend, based on our experience, that you include the period from and to in the name. This will make it easier for you to find the files in the import area. (Any file you import to Mydas shall not have more than 60 characters as file name!)
Field Specification
Of course, there is no plausibility check in Excel itself, so it is all the more important that you strictly adhere to the following specification.
- Period to be imported (Mandatory)
- Channel Identifier in MYDAS (Mandatory)
- Channel Name in MYDAS (Mandatory)
- Timezone of the channel (Mandatory)
- ID for the Program element of the slot. Advisable if it is the same for the same Program Name all the time. (Mandatory)
- Title of the Program element (Mandatory)
- Start time of the Program (=Slot Start time) (Mandatory)
- Genre Information (Optional)
- Program category (Optional)
- Always SAT (Mandatory)
- Number of interruptions in the program slot (Mandatory)
- Break in front of the program. Y for Yes, N for No. (Mandatory)
- Break after the program (=Endbreak) Y for Yes, N for No. (Mandatory)
- Total seconds of advertisement in the program slot. This will define the duration of each break (total duration/number of interruptions)
- Program Slot duration. It is advisable to not have any overlapping to the following program slot (e.g. start time of the slot + duration should be less than the start time of the following slot) due to the risk of a strange display of breaks in the booking modules
- = 15 from above
- Price Group (= multiplier for the base rate calculation e.g. 4 for fringe time and 5 for prime time)
- Here the template name needs to be entered which needs to be applied. On the Singapore MYDAS installation this is "Starhub".
- Definition on which weekday the program is to be scheduled.
Creating a Advertising Template as a condition for the import of the Excel grid file
In order to be able to import a break file, you need a template. This template is an instruction for the BreakBuilder how the breaks are to be interpreted. To create such a template you have to select <BreakBuilder> in the module header and then click on the link <Advertise template> in the MD BreakBuilder.
General Information
First you should enter the conditions that apply to the template.
- Name and Identifier should be named in a way to identify it later on
- Time & Weekday validity
- Active has to be checked otherwise the template will not be used
- If the template should be used as default, activate this checkbox - but you can of course have only one default template for a channel
Media
Define in the next step, all the channels that use this template. Click on the magnifier to open the select box and click on the channels to be selected. If you want to remove a channel, just click on the cross at the left side of the row.
Details
The details characterize the structure of the interruptions within a template. The commercial elements are then defined within a detailed data record. But we'll get to that later. First, we create the rough structure.
This process can best be explained with the following example:
The template is intended to interrupt a program twice. Elements should also be inserted at the beginning and at the end of a program.
The structure should look like this:
ELEMENT - BEFORE
Content
FIRST BREAK
Content
SECOND BREAK
Content
ELEMENT - AFTER
In order to implement this structure, we first have to create a framework in which we then incorporate the advertising elements. To do this, we go to the TAB <DETAILS> and click on the special action button <Enter Detail> (1)
MYDAS will show you that the task has been executed (2) and you will see a new line in the Details table. (3)
Double-click on this line to get to the data record. Two inputs are important here:
- Name of the element
- Position of the element in the process
You can also define whether an element should be placed at the beginning of the content or at the end of a content. In this case, the 1st element is one position before the content.

We repeat these steps until the structure is created.
It makes sense to first create the number of elements and secondly, to define the elements from top to bottom in the table.
If you have carried out the steps as described, the following structure should be shown in the table.

Parts
After we have defined the structure of the interrupter, it is now time to configure the individual elements.
To do this, we select an element from the details table and go directly to the <Details> folder. After clicking on the <Create Advertising Element> action button, you will be notified that MYDAS has carried out the task. A new entry now appears in the table which we open directly with a double click.
In this view it is now a matter of specifying the element. Basically, this requires the following information:
- Type = Is it advertising or content promo
- Break Category = What form of advertising will the item take
- Sort = at which position within the interruption is the element (we will show an example in a moment)
- Length in sec
- MYDAS length in sec
We can ignore all other fields at this point.
A break can contain one or more advertising elements. In the example below, the interruption is defined as follows:
- Sponsoring opener 10 sec
- Commercial break 360 sec
- Sponsoring Closer 10 sec
Please make sure that you set the sorting correctly because this determines the sequence of the elements.
Template graphical display
As you have probably noticed, there are many steps and details to consider here in order to create a template. It makes perfect sense to first think carefully about a possible template structure and record it. Then go step by step. So first, the rough breaker structure and then the configuration in the following steps.
You can check the result of your work at any time in the form of a graphic representation. To do this, click on the action button with the magnifying glass icon in the detail tab of your template.

In a pop-up, the structure of your template is shown in a graphical overview. Compare this overview with the steps already done so far.
Import of Grid - Files
You can now import your finished grid file into MYDAS. To do this, go to the <Break Builder> menu in MYDAS via the module header. In the section <Interfaces BreakBuilder> you will find the entry Import dummy planing BB xls (x).
Select the file that you have saved on your computer by clicking the <Choose File> button and then following the instructions.
You can see that you have selected a file for upload by the fact that the file name is displayed next to the button. Now execute the upload by clicking on the <Upload Button>.
The selected file will now be uploaded to the server. When this is done, it will be displayed in the file list.If you now click on the <Import> link, the data will be imported, the breaks will be inserted and are available for booking.