84.4.4.85 CUSTOM > TELETICINO ASRUN XLS

Export scope
The "Teleticino AsRun Plus" export allows generating an XLSX file containing the broadcast playlists transmitted on a specific day on the current station.
Prerequisites
In "Etere Configuration > Settings > Types", the following types should be linked to an "standard export":
Type - Spot
Standard export : B31
Type - Televendite
Standard export : B3
Type - Programmi
Standard export : 11
Export process
Export only events which transmission status is "D" (transmitted), "Q" (transmitted and certified) or "A" (transmitted and skipped).
Every transmitted event will be exported in a single line, where all its data will be specified (e.g. channel, time, title, etc.)
Spots will be grouped into a single break with the following properties:
▪Duration : Sum of all spots contained in the break
▪Description : Name of the Air Sales segment where spots are scheduled.
For every event, its "standard export" property will be exported in the "Code (programe / Adv)" column.
In case said property is empty for a certain event, a warning message will be displayed:
"Etere Type=XXX  as the type has not a corresponding fidenogg (i.e. Standard Export)"   
Export parameters
This export allows the following parameters to be set and then [saved]:

Export_custom_teleticino_asrun_xls

Export tab
Day to export - Indicate the date from which transmitted events will be exported
Export path - Browse for the path to export files for the current station
Channel identifier - Enter the code with which the station will be identified
Export filename - Shows the naming format with which files will be exported:
         YYYYMMDD_S1.xlsx                (e.g. 20140330_S1.xlsx)
where:
▪YYYYMMDD : Year, month and day of the exported playlist
▪S1 : Station 1 
Launch the export
Once all parameters have been correctly set, just press the <Export> button to launch the export operation. 
Sample exported file
Channel Code    ;Date/Time stare        ;Date/Time end          ;Title                                          ;Subtitle       ;Code (programe / Adv)  ;Time planned   ;ADH1   ;ADH2   ;ADH3   ;Det    ;Sequence Id    ;SeqText;Cost   ;First broadcast channel;Date of first broadcast;
569             ;30.03.2014 03:35:50    ;30/03/2014 04.20.35    ;Im Netz der Mafia - Die Geheimakten des FBI    ;               ;11                     ;               ;       ;       ;       ;       ;               ;       ;       ;                       ;                       ;
569             ;30.03.2014 04:20:35    ;30.03.2014 05:05:14    ;Im Netz der Mafia - Die Geheimakten des FBI    ;               ;11                     ;               ;       ;       ;       ;       ;               ;       ;       ;                       ;                       ;
569             ;30.03.2014 05:05:14    ;30.03.2014 06:00:00    ;Swiss View                                     ;               ;11                     ;               ;       ;       ;       ;       ;               ;       ;       ;                       ;                       ;
569             ;30.03.2014 06:00:00    ;30.03.2014 06:10:59    ;Das Dschungelbuch                              ;               ;11                     ;               ;       ;       ;       ;       ;               ;       ;       ;                       ;                       ;