This features allows exchanges of sounds and broadcast informations between RadioAssist and a third party apllication. We'll use MusicMaster as an example.
The validated sounds in RadioAssist will be sent in the MusicMaster database (as an XML file by sound) in order to prepare a musical playlist. Once the playlist is ready, it will be sent to RadioAssist thanks to a Federall Service setting.
Once the playlist is broadcasted using Air-DDO, the broadcasting log will be sent to MusicMaster for reconciliation.
Click on 
:
The setting is divided in 2 parts :
1- Setting for sound exchanges between RadioAssist and the third party application.
2- Setting for broadcasting logs exchanges (reconciliation) between RadioAssist and the third party application.
Media XML export periodicity : Duration in minutes between 2 scans of the database. Find the right value that will not overload the server with scan requests and for MusicMaster users not to wait too long for the database update.
Media XML export SQL filter : Which sounds ill be used for the export (RTB, production, etc...). This filter applies to the T_ITEM table.
Media XML export process column : Which T_ITEM column will be flagged for a an export already done for a sound.
Media XML export folder : Folder path where the XML sound file will be sent. Variable macros $YEAR (AAAA), $MONTH(MM) et $DAY (DD) are used. The XML name format will be "Guid-Item.xml".
AsRun export schedule : Time of recovery of the broadcast log from T_AIR_RUN.
AsRun export SQL filter : Which sound type will be used for the export (Music, ads, etc...). This filter is applied on the T_AIR_RUN table
AsRun export XSL filepath : Full path for the XSL file for export log transformation. The file will be transformed to the import format for the third party application.
Example :
AsRun file from the database :
<?xml version="1.0" standalone="yes"?>
<DbEntity> <DbTuple table="T_AIR_RUN"> <AIR_DURATION datatype="string"><![CDATA[00:03:09]]></AIR_DURATION> <END_TIME datatype="timestamp">2014-12-03 05:19:04</END_TIME> <EXT_RUN_ID datatype="string"><![CDATA[(null)]]></EXT_RUN_ID> <GUID_ITEM datatype="string"><![CDATA[84FF8943-D72D-40AB-B16D-00E99C8A7023]]></GUID_ITEM> <START_TIME datatype="timestamp">2014-12-03 05:15:55</START_TIME> </DbTuple> <DbTuple table="T_AIR_RUN"> <AIR_DURATION datatype="string"><![CDATA[00:00:06]]></AIR_DURATION> <END_TIME datatype="timestamp">2014-12-03 20:18:42</END_TIME> <EXT_RUN_ID datatype="string"><![CDATA[]]></EXT_RUN_ID> <GUID_ITEM datatype="string"><![CDATA[50EF34D9-BD47-4692-91B5-A22D18EF9562]]></GUID_ITEM> <START_TIME datatype="timestamp">2014-12-03 20:18:36</START_TIME> </DbTuple> > > > > </DbEntity> |
Example of an XSL transformation sheet allowing to generate an ASCII file of broadcasted sounds.
<?xml version="1.0" encoding="iso-8859-1"?> <xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:msxsl="urn:schemas-microsoft-com:xslt" xmlns:var="urn:var" xmlns:userStyle="urn:userStyle" xmlns:userJScript="urn:userJScript" exclude-result-prefixes="msxsl var userStyle userJScript" version="1.0">
<xsl:output method="text" omit-xml-declaration="yes" encoding="iso-8859-1" />
<msxsl:script language="VBScript" implements-prefix="userStyle"><![CDATA[
'-------------------------------------------------------------------------------
function VBDateTime2Time (strDateTime)
VBDateTime2Time = Mid(strDateTime,InStr(strDateTime," ")+1)
end function
]]></msxsl:script>
<xsl:template match="/"> <DbEntity> <xsl:for-each select="//DbTuple"> <DbTuple table="T_AIR_RUN"> <xsl:value-of select="userStyle:VBDateTime2Time(string(START_TIME))"/><xsl:text>	</xsl:text> <xsl:value-of select="AIR_DURATION"/><xsl:text>	</xsl:text> <xsl:value-of select="GUID_ITEM"/><xsl:text>	</xsl:text> <xsl:text> </xsl:text> </DbTuple> </xsl:for-each> </DbEntity> </xsl:template> </xsl:stylesheet> |
Result :
05:19:04 00:03:09 84FF8943-D72D-40AB-B16D-00E99C8A7023 20:18:36 00:00:06 50EF34D9-BD47-4692-91B5-A22D18EF9562
|
AsRun export Filepath : Path for the broadcasting log from T_AIR_RUN
During the export, all metadatas from T_AIR_RUN will be available as well as AIR_DURATION who is equal to "END_TIME" - "START_TIME"