59.5.8.4 Daily Runs

Report Description

The Daily Runs report allows for generating a document detailing the recurrence of a particular event (asset code) on schedule or recurrences of all events in a break and based on other search parameters.

Using the button Columns, it's possible to include the most common event properties such as code, description, scheduled date and time, duration, type code, genres, etc. 

NB: From Etere version 33.2.182.6699, selecting and exporting the Broadcast type and Linked asset columns is possible. The first one refers to the column of the same name in Executive Editor and contains the values Repeat, Prime or Premiere. In the case of a live event, the word "LIVE" is added beside the value. The second one contains the asset linked to the aired event as a child.

Report Filters

All the parameters that permit detailed report generation have been spread across seven different tabs to allow for a more straightforward configuration. By Default, all filters are disabled (i.e., either blank or unselected); to enable them, it is enough to configure at least one parameter inside. Available filters include:

• Code

The code area permits, as its name suggests, to narrow the retrieved results by specifying any of the following filters concerning the code field:
- Starts with: Enter the string with which the asset's codes must begin to be retrieved in the report (e.g., code like 'test*'),
- Between: Insert two values, and only those assets whose code is comprehended between them will be retrieved (e.g., code between '500' and '600'),
- Contains: To be retrieved, assets' code must contain the string inserted here (e.g., code like 'test'),
- It doesn't contain: To be retrieved, assets' code must NOT contain the string inserted here (e.g., code not like 'test'),
- Empty: Only the empty events will be retrieved (e.g., code = '').

• Description

As with the code, the description field permits the retrieval of only those events which the description field matches (entirely or partially) with the selected filter:
- Starts with: Enter the string with which the asset's supplier must begin to be retrieved in the report (e.g., a description like 'test*'),
- Between: Insert two values, and only those assets whose description is comprehended between them will be retrieved (e.g., the description between '50' and '60'),
- Contains: To be retrieved, the asset's description field must contain the string inserted here (e.g., a description like 'test'),
- It doesn't contain: To be retrieved, events' description must NOT contain the string inserted here (e.g., description not like 'test'),
- Empty: Only those events for which the description field is empty will be retrieved (e.g., description = '').

• Asset

Search and add the asset(s) to which the report will be referred. If no support is added, all purchases present within the period will be included in the report.

•Date

Indicate the time criteria to be used for filtering events; it is possible to define any of the following methods:
- Period: It allows to specify if the days to be included will be taken from a given custom date or one of the standard filters (i.e.: 'customized dates', 'current day', 'this week', 'next week', 'current month', 'current year', 'today's month date', 'today's  year date', 'previous month', 'previous year', 'last 30 days, 'following 30 days' or 'all dates'). From and To filters, are enabled only if "customized dates" is selected.
- Time: Indicate if the report will include the whole day scheduling or only a specific time range. In this last case, two additional From and To filters will be visible, to specify the time range.

Note: To print the Daily Runs report for the past weeks, past months or past year, you can use the Historical Daily Runs report in the Historical Reports section.

• Type

Indicate the event type(s) that will be used to filter the events included in the report. Use the 'hide groups and system types' option to display only those types defined by the station and hide those created by default by Etere.

• Supplier

The supplier area permits, as its name suggests, to narrow the retrieved results by specifying any of the following filters concerning the supplier field:
- Starts with: Enter the string with which the asset's supplier must begin to be retrieved in the report (e.g., supplier like 'test*'),
- Between: Insert two values, and only those assets which the supplier is comprehended between them will be retrieved (e.g., supplier between '50' and '60'),
- Contains: To be retrieved, the asset' supplier field must contain the string inserted here (e.g., supplier like 'test'),
- It doesn't contain: To be retrieved, the assets' supplier field must NOT contain the string inserted here (e.g., supplier not-like 'test'),
- Empty: Only those events in which the supplier field is empty will be retrieved (e.g., supplier = '').

• Agency

Set there the field from which the agency information will be retrieved:
- Air Sales agency: The agency specified in the order (only for Air Sales contractual events),
- Asset Form agency: The agency is specified as the tapeless supplier in the asset form.

• Networks

Select the split networks on which the events to be retrieved must have been transmitted to be included in the report:
- Principal network: It's the leading network on which events are mainly scheduled,
- Secondary networks: Select one of the split networks configured in the Etere Configuration > Settings > Air Sales > Stations section,
- All networks: If selected, the report will include the events scheduled across all the leading and split networks. In this case, adding the 'split' column under the properties tab is suggested to identify the network to which events belong.

• Properties

This tab permits the customization of the layout of the report by selecting the complementary information that will be displayed on it. You can also decide to include some standard info, such as:
- Print date: Enable it to display the date (and time) in each page footer,
- Page Number: If active, a progressive number will be displayed in the footer on all pages across the report,
- Operator: It is the login name of the person who performs the report,
- Station name: The name of the station from which the report is being performed,
- Multiple lines text: Enable this option to continue printing a detail in another line instead of truncating it (as by Default).
- Interline: Enable this option to increase the space between lines to 1.5 cm (one-and-one-half) by Default -when disabled- this space is set to 1 cm (single).

- Columns: It permits to specify the database fields that will be included in the report. The column headers at the top of the columns window will be displayed as shown in the report. It is possible to arrange them by using the drag-and-drop method. When column arrangement is fixed, click the <Apply> button to confirm settings and the <OK> button to close the dialogue and proceed with the printing of the report. Use the < Default> button to reset the columns to their original arrangement for reversion.
- Parameters: The parameter properties allow you to print all exploded event segments by simply enabling the option. When publishing the Daily Runs report for multiple stations/channels, the option "Print all segments of the exploded events" must be enabled in all stations.

This configuration can be exported and imported, using the related buttons in this tab.

• Flexi-metadata

This tab allows filtering only those events matching a set of one or more SMPTE metadata fields (e.g. campaign, agency, etc).

Note: Please note that the "SMPTE Metadata" tab will be available only if at least one SMPTE metadata field is configured in the system.

Display Active Filters

In the middle of the form, a summarizing list will be displayed containing all the filters enabled for the current report:
3707_Display_Active_Filters

Report Preview

The [Settings] allow the configuration of the page layout for the outgoing document; once filters and settings have been set, it will be possible to select between displaying a preview using the related [Preview] button or printing the document directly using the [Report] button. Please note that some reports permit the export of the generated document in the most common formats (pdf, CSV, doc, xls, XML, etc) just by using the [Export] button.
Daily_Runs

Memory cut

The Memory cut button, allows to retrieve the memory files related to the time range when a specified asset has been aired, in the date range set in the report parameters.

If memory files are found, the system launches the default wf for Memory Cut and creates a new asset for each of the asset's runs. Memory files are then transcoded into new files, which contain only the part when etere memory recorded the selected asset, in the date range selected, and linked to the assets just created.

For example, this is the playlist aired, where the second and third columns contain the start time and the end time of each event:
PROMO 30s - 09:00:00.00 - 09:00:29.24
COMMERCIAL 30s - 09:00:30.00 - 09:00:59.24
MOVIE 2h - 09:01:00.00 - 11:00:59.24
PROMO 30s - 11:01:00.00 - 11:01:29.24
COMMERCIAL 30s - 11:01:30.00 - 11:01:59.24
MOVIE 2h - 11:02:00.00 - 13:01:59.24

To extract the memory recordings only of the asset "MOVIE", do the following:

1. Search for the asset "MOVIE" and specify the day when the given playlist has been aired
2. Click on Memory Cut button

The default wf for memory cut will be launched and the path where the cut files should be saved is taken from the memory cut action.
2 files will be created:
- The first, taking the portion of file recorded between 09:01:00.00 and 11:00:59.24;
- The second, taking the portion of file recorded between 11:02:00.00 and 13:01:59.24.