84.4.4.47 CUSTOM > AGB RF

Export Scope
The AGB RF export allows creating a text file (.tel) for various scheduling days according to the following criteria:
Export prerequisites
The following elements must exist in Etere's flexi-metadata structure (in "Configuration > Settings > MAM > Flexi-metadata"):
FILE
ETERE
Exported field - rf_codEmitt
Database field : [current station]
Exported field - rf_data
Database field : [current date]
Exported field - rf_oraI
Database field : tpalinse.ora inizio
Exported field - rf_oraF
Database field : tpalinse.ora fine
Exported field - rf_durata
Database field : filmati.durata
Exported field - rf_codPrg
Database field : filmati.id_filmati
Exported field - rf_desPrg
Database field : filmati.descrizio
Exported field - AGB-codTipo
[AGB type mapped to Etere type]
Exported field - rf_costoSpot
Database field : 0.0
Exported field - rf_costoSpot
Database field : 0.0
Exported field - rf_coefficente
Database field : 1
Exported field - rf_spotPos
Database field : [progressive spot number, 2-chars long]
Exported field - rf_spotTot
Database field : [spots number in cluster, 2-chars long]
Exported field - rf_tipoPubb
Database field : 13 (if promo)
1 (if not promo)
Exported field - rf_codFascia
Database field : flexi-metadata.AGB-CODICE FASCIA
Exported field - rf_desFascia
Database field : flexi-metadata.AGB-DESCRIZIONE FASCIA
Exported field - rf_codAudio
Database field : null
Exported field - rf_desAudio
Database field : null
Exported field - rf_codProdotto
Database field : flexi-metadata.AGB-CODICE PRODOTTO
Exported field - rf_desProdotto
Database field : flexi-metadata.AGB-DESCRIZIONE PRODOTTO
Exported field - rf_notUsed
Database field : 2
Exported field - rf_notUsed
Database field : 2
Exported field - rf_codCategoria
Database field : 78230 (if promo)
99998 (if not promo)
Exported field - rf_desCategoria
Database field : STAZIONI RADIO TV (if promo)
ENTI-SCUOLE-AGENZIE (if not promo)
Exported field - rf_codSettore
Database field : 78 (if promo)
98 (if not promo)
Exported field - rf_desSettore
Database field : ENTI-SCUOLE-AGENZIE (if promo)
null (if not promo)
Exported field - rf_notUsed
Database field : 2
Exported field - rf_codBrand
Database field : null
Exported field - rf_desBrand
Database field : null
Exported field - rf_codAzienda
Database field : flexi-metadata.AGB-CODICE AZIENDA
Exported field - rf_desAzienda
Database field : flexi-metadata.AGB-DESCRIZIONE AZIENDA
Export process
Exported playlists run from 02:00:00 to 25:59:59 of the day after
Each line represents an event, each event field (31 in total) must be separated by a comma
Events are sorted by "Station > Date > Time"
If the “NOTE” field in TPALINSE (Asset Playlists) database table contains formatted data, the “NOTE” field would be exported into column 16 in the exported file.
Note
The AGB RF function is able to export scheduling data previously imported through the RCS standard function.
Export Parameters
Under the Parameters section, other settings that can be configured are:

Export_custom_agb_rf

Period to export - Specify a period over which you wish all schedules to be exported.  Each day will be exported into a different file, saved in the 'Export Path' specified.
Export path - Browse and select the directory on which exported XML files will be stored.
Station code - Select the number of the station from which data will be exported (e.g. 1).
Export filename - Indicate the three characters that made up the prefix to be used for naming the exported file:
rfyymmdd.txt
Parallel export - If enabled, a second file will be also exported containing the same scheduling information as the main one BUT featuring scheduled times shifted by 'x' hours.
•You would need to provide the alternative:
•Export path: the path where the parallel exported file would be stored
•Station code: the station code of the alternate path
•Export filename: enter the first 3 character different from the primary exported file.
Types to be excluded - Select the event types to be excluded from the exported file.  You can click the browse button to select types from the list.
Types for Programs - While the first event always taken before a spot or jingle, you can set the asset types for the Programs to distinguish the actual containers of Break.
Export new mode (with add 2 columns CODE + TITLE at the end of file) - Enable this option to export the schedules into a text file different from the primary file.  2 new columns “Code” and “Title” would be appended at the end of the exported file.
Note: If a spot belong to a same break is separated or moved, the spot would be calculated as individual spot.  For example, if the last spot of the 9 spots is separated or moved from the break, the spots would be indicated as 08/08 and 01/01 (last spot) instead of 08/09 and 09/09 (last spot) in the exported file. 
Launch the export
Once the export has been configured, it can be started just by pressing the <Export> button. 
Sample imported file
3833,20120902,023457,023526,30,0000076642,"PRANK PATROL-SCHERZI DA RAGAZZI","cc",1.00,1.00,1.000000,01,02,13,"3833.AUTO     ","AUTOPUBBLICITA'",2048117069,"LE PRINCIPESSE DEL MARE#RG",782300453,"RAI GULP",5,2,78230,"STAZIONI RADIO TV",78,"ENTI-SCUOLE-AGENZIE",2,002037,"RAI GULP TV DIGIT.",074307,"RAI",3,0,"n.d.",0,"n.d.",0,"n.d.",2,0,"n.d.",0,"n.d.",1,0,"n.d.","Promo","n.d.","AUTOPUBBLICITA'","BRK - AUTOPUBBLICITA'","Promo","n.d.","n.d.","n.d."
3833,20120902,023527,023557,31,0000076642,"PRANK PATROL-SCHERZI DA RAGAZZI","cc",1.00,1.00,1.000000,02,02,13,"3833.AUTO     ","AUTOPUBBLICITA'",2049067100,"VITE SULL'ONDA-BEYOND THE BREA",782300453,"RAI GULP",5,2,78230,"STAZIONI RADIO TV",78,"ENTI-SCUOLE-AGENZIE",2,002037,"RAI GULP TV DIGIT.",074307,"RAI",3,0,"n.d.",0,"n.d.",0,"n.d.",2,0,"n.d.",0,"n.d.",1,0,"n.d.","Promo","n.d.","AUTOPUBBLICITA'","BRK - AUTOPUBBLICITA'","Promo","n.d.","n.d.","n.d."
3833,20120902,030142,030211,30,0000076642,"PRANK PATROL-SCHERZI DA RAGAZZI","cc",1.00,1.00,1.000000,01,02,13,"3833.AUTO     ","AUTOPUBBLICITA'",1118099050,"WINX CLUB#RG",782300453,"RAI GULP",5,2,78230,"STAZIONI RADIO TV",78,"ENTI-SCUOLE-AGENZIE",2,002037,"RAI GULP TV DIGIT.",074307,"RAI",3,0,"n.d.",0,"n.d.",0,"n.d.",2,0,"n.d.",0,"n.d.",1,0,"n.d.","Promo","n.d.","AUTOPUBBLICITA'","BRK - AUTOPUBBLICITA'","Promo","n.d.","n.d.","n.d."
3833,20120902,030212,030241,30,0000076642,"PRANK PATROL-SCHERZI DA RAGAZZI","cc",1.00,1.00,1.000000,02,02,13,"3833.AUTO     ","AUTOPUBBLICITA'",1117101067,"LOLA & VIRGINIA#RG",782300453,"RAI GULP",5,2,78230,"STAZIONI RADIO TV",78,"ENTI-SCUOLE-AGENZIE",2,002037,"RAI GULP TV DIGIT.",074307,"RAI",3,0,"n.d.",0,"n.d.",0,"n.d.",2,0,"n.d.",0,"n.d.",1,0,"n.d.","Promo","n.d.","AUTOPUBBLICITA'","BRK - AUTOPUBBLICITA'","Promo","n.d.","n.d.","n.d."
3833,20120902,032624,032653,30,0000073601,"REBELDE WAY","cg",1.00,1.00,1.000000,01,02,13,"3833.AUTO     ","AUTOPUBBLICITA'",2049077068,"LASSIE E NEEKA#RG",782300453,"RAI GULP",5,2,78230,"STAZIONI RADIO TV",78,"ENTI-SCUOLE-AGENZIE",2,002037,"RAI GULP TV DIGIT.",074307,"RAI",3,0,"n.d.",0,"n.d.",0,"n.d.",2,0,"n.d.",0,"n.d.",1,0,"n.d.","Promo","n.d.","AUTOPUBBLICITA'","BRK - AUTOPUBBLICITA'","Promo","n.d.","n.d.","n.d."
3833,20120902,032654,032723,30,0000073601,"REBELDE WAY","cg",1.00,1.00,1.000000,02,02,13,"3833.AUTO     ","AUTOPUBBLICITA'",2048117069,"LE PRINCIPESSE DEL MARE#RG",782300453,"RAI GULP",5,2,78230,"STAZIONI RADIO TV",78,"ENTI-SCUOLE-AGENZIE",2,002037,"RAI GULP TV DIGIT.",074307,"RAI",3,0,"n.d.",0,"n.d.",0,"n.d.",2,0,"n.d.",0,"n.d.",1,0,"n.d.","Promo","n.d.","AUTOPUBBLICITA'","BRK - AUTOPUBBLICITA'","Promo","n.d.","n.d.","n.d."
3833,20120902,041916,041946,31,0000053164,"GRANI DI PEPE","cc",1.00,1.00,1.000000,01,02,13,"3833.AUTO     ","AUTOPUBBLICITA'",2049067100,"VITE SULL'ONDA-BEYOND THE BREA",782300453,"RAI GULP",5,2,78230,"STAZIONI RADIO TV",78,"ENTI-SCUOLE-AGENZIE",2,002037,"RAI GULP TV DIGIT.",074307,"RAI",3,0,"n.d.",0,"n.d.",0,"n.d.",2,0,"n.d.",0,"n.d.",1,0,"n.d.","Promo","n.d.","AUTOPUBBLICITA'","BRK - AUTOPUBBLICITA'","Promo","n.d.","n.d.","n.d."
3833,20120902,041947,042016,30,0000053164,"GRANI DI PEPE","cc",1.00,1.00,1.000000,02,02,13,"3833.AUTO     ","AUTOPUBBLICITA'",1118099050,"WINX CLUB#RG",782300453,"RAI GULP",5,2,78230,"STAZIONI RADIO TV",78,"ENTI-SCUOLE-AGENZIE",2,002037,"RAI GULP TV DIGIT.",074307,"RAI",3,0,"n.d.",0,"n.d.",0,"n.d.",2,0,"n.d.",0,"n.d.",1,0,"n.d.","Promo","n.d.","AUTOPUBBLICITA'","BRK - AUTOPUBBLICITA'","Promo","n.d.","n.d.","n.d."