Export Formats

84.4.4.72 CUSTOM > IMPARJA MORPHEUS XML

Export Scope
The Imparja Morpheus XML export allows to create a XML file containing all primary (and secondary) events scheduled across broadcast playlists within a given period of dates and times.
Export process
Any data can be exported from the Filmati (assets repository), Tpalinse (broadcast playlists) and Tsec (secondary events of scheduled assets) tables, whereas from other tables only specific fields are retrieved:
Etere Data
Exported Tag - <CL>
Exported Tag - Filmati.Parent_Rate¹
Description : Classification
Exported Tag - <CA>
Exported Tag - ParentalAdvice.Description
Description : Consumer Advice
Exported Tag - <SPOTCODE>
Exported Tag - Query
Kind of commercial order
Exported Tag - <SEASONS_TITLE>
Exported Tag - FSerie.Descrizio
Description : string
Exported Tag - <FLAG_NON_UDENTI>
Exported Tag - Filmati.Flag_Non_Udenti
Description : Closed Captions
Exported Tag - <TRAMA>
Exported Tag - Filmati.Trama
Description : Storyline
Exported Tag - <DATA>
Exported Tag - TPalinse.Data
Description : Actual air date
Exported Tag - <ORA>
Exported Tag - TPalinse.Ora
Description : Actual air time
Exported Tag - <DATA_P>
Exported Tag - TPalinse.Data_P
Description : Expected air date
Exported Tag - <ORA_P>
Exported Tag - TPalinse.Ora_P
Description : Expected air time
Exported Tag - <PUNTATA>
Exported Tag - FSerie.Puntata
Description : Episode number
Exported Tag - <CRAWL_DESC>
Exported Tag - Filmati.Crawl_Desc
Description : Notes
¹ : The table value (e.g. MA) is converted (e.g. V.M. 18).
Fields measured in frames (e.g. duration, mark-in, etc.) are exported in "hh:mm:ss.ff" format
Export Parameters
In order to use this export function the following fields must be compiled:

Export_custom_imparja_morpheus_xml

Export tab
Period to export (from date - to date) - Specify the date range from which events will be exported.
Note: Each day will be exported as a separate file.
Time slot to export (from time - to time) - Specify the time range from which events will be exported.
Export filename - Shows the fixed naming format of exported files:
DDMMYY.XML (e.g. 250114)
Alternative Schedule - If you wish to export an alternative schedule instead of the real schedule, select one of the ten available alternative schedules from the list.
Parameters tab
Export path - Browse and select the directory on which exported XML files will be stored.
Fields to export - Select all the fields you intend to export on the XML file(s).
Note: Data can be exported from tables Filmati, TPalise and Anagraf.(cod_conto and Rag_Social).
Note: The TPALINSE.EXTERSTRID field, consists of value= ID (2 characters) + ID_TPALINSE (10 characters) e.g. 020015625810, if selected during the export, would be export into the XML file to be used as a reconcile key during the execution of IMPORT_STANDARD_MORPHEUSASRUNXML ( If parameter “Import based on ReconcileKey” is enabled ) to achieve accuracy.
Include all the schedule's secondary events¹ - If enabled, the export will also include the secondary events eventually associated to the asset across the playlists on which it's scheduled within the given period.
Export events with times beyond midnight as zero-based and with the next-day date - If disabled (default), all those events scheduled beyond the 24:00:00 will be exported featuring a continuous time (e.g. 24:10:37, 25:23:41, 26:12:45) and keep the exported television day (e.g. 06/12/2011).
Instead, if enabled, they will be exported featuring a zero-based time (e.g. 00:10:37, 01:23:41, 02:12:45) and a date belonging to the next television day (e.g. 07/12/2011).
It is suggested to enable this parameter only in case the system on which the exported schedule will be used is not based on the 24-hour day format (e.g. 26 hour day format).
¹ Secondary events
Secondary events related to scheduled events (TSEC) and assets (FSEC) are exported into a <Secondary_Event> node as described in the chapter "Secondary events on XML" according to the following overall structure:
<Secondary_Event>
<TSec>
<Name>AST</Name>
...
</TSec>
<TFSec>
<Name>FADE</Name>
...
</TSec>
<Secondary_Event>
Launch the export
Once the export has been configured, it can be started just by pressing the <Export> button.
Sample exported file
100914.xml
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<data datetime="2015-01-27 16:37">
<TPALINSE lastrevision="2015-01-27 16:37" description="Station=CHANNEL 1 (Level=0) Date Exported=2014-09-10 06:00:00 User=1">
<row>

<ASPECT>4</ASPECT>
<ASRUN_INFO></ASRUN_INFO>
<ASRUN_STATUS_C></ASRUN_STATUS_C>
<ASRUN_STATUS_M></ASRUN_STATUS_M>
<ASRUN_STATUS_O></ASRUN_STATUS_O>
<AUDIO>1234</AUDIO>
<AUDIO_TY>M</AUDIO_TY> <COD_PROGRA>3530</COD_PROGRA>
<COD_USER>1</COD_USER> <CODE_PRIMECAST>1</CODE_PRIMECAST>
<COLOR>FF000005</COLOR>
<COSTO>0</COSTO>
<CRAWL_DESC>[Crawl]
LogoEffect=leCustom
[Aspect Conversion]
Code=4P</CRAWL_DESC>
<CRAWL_IN>0</CRAWL_IN>
<CRAWL_SPEE>0</CRAWL_SPEE>
<CRAWL_VOL>0</CRAWL_VOL>
<CRYPTATO></CRYPTATO>
<DATA>10/09/2014</DATA>
<DATA_P>10/09/2014</DATA_P> <DATA_PREV>10/09/2014</DATA_PREV>
<DSK1>NN</DSK1>
<DSK1_DUR>0</DSK1_DUR>
<DSK1_IN>0</DSK1_IN>
<DSK2>NN</DSK2>
<DSK2_DUR>0</DSK2_DUR>
<DSK2_IN>0</DSK2_IN>
<DSK3>NN</DSK3>
<DSK3_DUR>0</DSK3_DUR>
<DSK3_IN>0</DSK3_IN>
<DSKA>NA 0000000000000000</DSKA>
<DSKB>NA 0000000000000000</DSKB>
<DSKC>NA 0000000000000000</DSKC> <DURATION>00:00:14:24</DURATION> <DURATION_P>00:00:00:00</DURATION_P>
<ERRORCODE>0</ERRORCODE>
<EVENT>317315512133</EVENT>
<EVENT_P>317315512133</EVENT_P>
<EVENT_TYPE>T</EVENT_TYPE>
<EXPECTEDDURATION></EXPECTEDDURATION>
<EXTERNALID>0</EXTERNALID>
<EXTERSTRID></EXTERSTRID>
<GPI>000000000</GPI>
<GPI2>000000000</GPI2>
<GPID1>0</GPID1>
<GPID2>0</GPID2>
<ICON></ICON>
<ID_DOCUMENT>0</ID_DOCUMENT> <ID_FATTURAAGENZIA>0</ID_FATTURAAGENZIA>
<ID_FATTURAEMITTENTE>0</ID_FATTURAEMITTENTE>
<ID_FILMATI>3530</ID_FILMATI>
<ID_SPLIT_START></ID_SPLIT_START>
<ID_SUPPORT>0</ID_SUPPORT>
<ID_TPALINSE>53544</ID_TPALINSE>
<ID_TPALINSE_APP></ID_TPALINSE_APP>
<LASTUPDATE>09/09/2014 12:32:57</LASTUPDATE>
<LASTUPDATETIME>09/09/2014 12:32:35</LASTUPDATETIME>
<LIVELLO>0</LIVELLO>
<MEDIA_ID></MEDIA_ID>
<MEDIA_TY></MEDIA_TY>
<NEWTYPE>GPRO</NEWTYPE>
<NOTE></NOTE>
<ORA>06:00:00:00</ORA>
<ORA_P>06:00:00:00</ORA_P>
<ORA_PREV>06:00:00:00</ORA_PREV>
<ORDINALE>505</ORDINALE>
<OUTPUT_M></OUTPUT_M>
<PART>0</PART>
<PROVENIENZA>TRAFFIC_NEW</PROVENIENZA>
<RECORDABLE></RECORDABLE>
<RIMAND>0</RIMAND>
<RIMAND_IN>0</RIMAND_IN>
<RIMAND_VOL>0</RIMAND_VOL>
<SCHEDULE_CHECKSUM>-2122973176</SCHEDULE_CHECKSUM>
<SPLIT>0</SPLIT>
<SPLIT_LENGTH></SPLIT_LENGTH>
<STATUS>I</STATUS>
<STATUS_CA></STATUS_CA>
<STATUS_MM></STATUS_MM>
<STATUS_RC></STATUS_RC>
<SUBTITLE></SUBTITLE>
<SUPPORTO></SUPPORTO>
<SUPPORTOB></SUPPORTOB>
<SUPPORTORC></SUPPORTORC>
<TIMECODE_I>00:00:00:00</TIMECODE_I>
<TIMECODE_O>00:00:14:23</TIMECODE_O>
<TIPO_TC>C</TIPO_TC>
<TITLE>PROMO EtereTV 2012 (brand promotion)</TITLE>
<TITLER>0</TITLER>
<TITLER_DUR>0</TITLER_DUR>
<TITLER_IN>0</TITLER_IN>
<TRAFFICID>31938</TRAFFICID>
<TRANS>CT</TRANS>
<TRANS_DUR>00:00:00:00</TRANS_DUR>
<TRF_EVENTLEVEL></TRF_EVENTLEVEL>
<TVGUIDE>NN000</TVGUIDE>
<TYPE></TYPE>
<VISIONATO></VISIONATO>
<VOICEOVR_A>0</VOICEOVR_A>
<VOICEOVR_B>0</VOICEOVR_B>
<VOICEOVR_C>0</VOICEOVR_C>
<VOICEOVR_D>0</VOICEOVR_D>
<XORDER>10000</XORDER>

<ANNO_P>0</ANNO_P>
<ANNULLATO></ANNULLATO>
<ARCHIVIATO></ARCHIVIATO>
<ASPECT>4</ASPECT>
<AUDIO>1234</AUDIO>
<AUDIO_LANGUAGE></AUDIO_LANGUAGE>
<BIANCONERO></BIANCONERO>
<BITRATE>0</BITRATE>
<BPM>0</BPM>
<CAD_APPROVAL></CAD_APPROVAL>
<CLIP_SIZE>0</CLIP_SIZE>
<CLOCK></CLOCK>
<COD_PROGRA>3530</COD_PROGRA>
<COMUN_GRAT>0</COMUN_GRAT>
<COMUN_PREV>0</COMUN_PREV>
<CONTROL_CODE>0</CONTROL_CODE>
<COPIA_ANAL></COPIA_ANAL>
<COPIA_DIGI></COPIA_DIGI>
<CREATIONDATE>20/12/2010 17:57:57</CREATIONDATE>
<CRYPTATO></CRYPTATO>
<CTL_LQ>0</CTL_LQ>
<DATA_ACQUI></DATA_ACQUI>
<DATA_ANNULL></DATA_ANNULL>
<DATA_ARRIVO>20/10/2010</DATA_ARRIVO>
<DATA_DIGIT></DATA_DIGIT>
<DATA_INIZIO_VALIDITA>01/01/2010</DATA_INIZIO_VALIDITA>
<DATA_MISU>01/01/1900</DATA_MISU>
<DATA_PROD></DATA_PROD>
<DATA_QUALITA></DATA_QUALITA>
<DATA_SCAD>31/12/2015 23:59:58</DATA_SCAD>
<DATA_TRASM></DATA_TRASM>
<DESCRIZIO>PROMO EtereTV 2012 (brand promotion)</DESCRIZIO>
<DESCRIZIO_1></DESCRIZIO_1>
<DESCRIZIO_2></DESCRIZIO_2>
<DUR_FISICA>00:00:15:00</DUR_FISICA>
<DURATA>00:00:15:00</DURATA>
<DURATA_PUB>00:00:15:00</DURATA_PUB>
<ENABLEDDAYS>1111111</ENABLEDDAYS>
<EXPORT>0</EXPORT>
<EXTERNALID>0</EXTERNALID>
<FADEIN>0</FADEIN>
<FADEOUT>0</FADEOUT>
<FILELQ></FILELQ>
<FLAG_NON_UDENTI>0</FLAG_NON_UDENTI>
<FLAGS></FLAGS>
<HIDDEN>False</HIDDEN>
<ID_ASPECTRATIOCONV>1</ID_ASPECTRATIOCONV>
<ID_FILMATI>3530</ID_FILMATI>
<ID_FORNITORE>31</ID_FORNITORE>
<ID_PROG_COLLE>0</ID_PROG_COLLE>
<ID_PROG_RIFERI>0</ID_PROG_RIFERI>
<ID_PROMOSOURCE>0</ID_PROMOSOURCE>
<ID_REGMASTER>0</ID_REGMASTER>
<ID_RESPONSABILE>0</ID_RESPONSABILE>
<ID_SERIE>3450</ID_SERIE>
<ID_TRAFFICDEPRECIATION>0</ID_TRAFFICDEPRECIATION>
<ID_VIRTUALDOCUMENT>0</ID_VIRTUALDOCUMENT>
<INF_DIGIT>00:00:00:00</INF_DIGIT>
<INF_LQ>00:00:00:00</INF_LQ>
<INFO_PROGR></INFO_PROGR>
<INSTALLATION>701</INSTALLATION>
<INTRO>0</INTRO>
<JINGLEIN>0</JINGLEIN>
<LASTUPDATE>09/09/2014 12:32:57</LASTUPDATE>
<LINGUA></LINGUA>
<LIVE_ID></LIVE_ID>
<LOC_NAZ></LOC_NAZ>
<MAGAZZINO></MAGAZZINO>
<MESI></MESI>
<NEWTYPE>GPRO</NEWTYPE>
<NIELSEN></NIELSEN>
<NONTRASMISSIBILE>False</NONTRASMISSIBILE>
<NOTE_A></NOTE_A>
<NOTE_AMM></NOTE_AMM>
<NOTE_B></NOTE_B>
<NOTE_C></NOTE_C>
<NOTE_COMM>[Crawl]
LogoEffect=leCustom</NOTE_COMM>
<OPENER>0</OPENER>
<OPERATORE></OPERATORE>
<OPERATORE_REC></OPERATORE_REC>
<ORDER_REFERENCE></ORDER_REFERENCE>
<OUTRO>0</OUTRO>
<CL>G</CL>
<PERC_AUTOP>0</PERC_AUTOP>
<POS_FIN>00:00:14:24</POS_FIN>
<POS_INI>00:00:00:00</POS_INI>
<PRIORITA>0</PRIORITA>
<PROD_INDIPENDENTE>False</PROD_INDIPENDENTE>
<PRODUZIONE></PRODUZIONE>
<PUNTATA>1</PUNTATA>
<QUALITA>0</QUALITA>
<RECFLAG>0</RECFLAG>
<ROTAZIONE>0</ROTAZIONE>
<SCH_DAYS></SCH_DAYS>
<SCH_HOURS></SCH_HOURS>
<SCH_MONTHS></SCH_MONTHS>
<SCHEDULE_CHECKSUM>-2122973176</SCHEDULE_CHECKSUM>
<SETT></SETT>
<SOSPESO></SOSPESO>
<SPLITS></SPLITS>
<SPONS_DES></SPONS_DES>
<SPONS_DUR>0</SPONS_DUR>
<SPONS_FROMBEGIN>S</SPONS_FROMBEGIN>
<STATUS_MM></STATUS_MM>
<STATUS_RC></STATUS_RC>
<TEMPO_INT>0</TEMPO_INT>
<TIPO>T</TIPO>
<TIPO_TC>C</TIPO_TC>
<TRAMA></TRAMA>
<TRASCODING_FLAG></TRASCODING_FLAG>
<VERSION>1</VERSION>
<VIDEOAPPROVAL></VIDEOAPPROVAL>
<VIRTUAL>False</VIRTUAL>
<SPOTCODE></SPOTCODE>
<CA></CA>

<SECONDARY_EVENT>
<TSEC>
<NAME>AST</NAME>
<Active>1</SOM>
<SOM>50</SOM>
<ICON>>*T_WORL</ICON>
<EOM>0</EOM>
<PARAMS>50</PARAMS>
<CODE>1</CODE>
<CODETYPE>C</CODETYPE>
<INT1>0</INT1>
<INT2>0</INT2>
<INT3>0</INT3>
<INT4>0</INT4>
<INT5>0</INT5>
<STR1>N</STR1>
<STR2>A</STR2>
<STR3> </STR3>
<STR4> </STR4>
<STR5> </STR5>
<Description>Logo news</Description>
<Provenienza> </Provenienza>
<ExternalID> </ExternalID>
<XMLParams> </XMLParams>
<OUTPUT>
<output.info> <virtual.device>LOGO6</virtual.device>
</output.info>
<OUTPUT>
</TSEC>
</SECONDARY_EVENT>
</row>
...
</data>

5182_Export_custom_imparja_morpheus_xml