It is done by transferring an XML form into an exchange folder with MusicMaster.
Whenever a sound is created or modified, Federall Service scans the database and when it detects a new item, it exports the record as a tuple to MusicMaster.
The configuration of Federall service is done in its interface:
In the "Exports config" group, "Use Standard Export" option:
Here we scan the ABC8 database of RadioAssist every minute.
A category filter is only interested in music: Type_Item = 1 and Type1_item = 2
Depending on the final workflow, it will have to be more selective by integrating the fields of ABC8 State, Virtual, etc. The Num_Selector column is used to indicate the status of the transfer to MusicMaster. It is also thanks to this column that an already treated element is not returned. This is not the unique identifier that serves as a link between MML and RA.
A path indicates where the XML records will be placed: \\ RAD-SV-MED-02 \ MusicMaster \ Item
Example of XML files:
<?xml version="1.0" standalone="yes"?>
<DbEntity>
<DbTuple table="T_ITEM">
<ALGO datatype="long">9</ALGO>
<ARCHIVABLE datatype="double">0</ARCHIVABLE>
<ARCHIVED datatype="double">0</ARCHIVED>
<BROADCASTABLE datatype="double">1</BROADCASTABLE>
<CATEGORY datatype="string"><![CDATA[]]></CATEGORY>
<CATEGORY2 datatype="string"><![CDATA[]]></CATEGORY2>
<COUNT_BROADCAST datatype="long">0</COUNT_BROADCAST>
<DATE_ARCHIVE datatype="timestamp"></DATE_ARCHIVE>
<DATE_BEG_ITEM datatype="timestamp">2017-09-06 11:06:30</DATE_BEG_ITEM>
<DATE_DELETE datatype="timestamp"></DATE_DELETE>
<DATE_END_ITEM datatype="timestamp">2017-10-02 11:56:02</DATE_END_ITEM>
<DATE_FIRST_BROADCA datatype="timestamp"></DATE_FIRST_BROADCA>
<DATE_KILL datatype="timestamp"></DATE_KILL>
<DATE_LAST_BROADCAS datatype="timestamp"></DATE_LAST_BROADCAS>
<DATE_TIME_1 datatype="timestamp"></DATE_TIME_1>
<DATE_TIME_2 datatype="timestamp"></DATE_TIME_2>
<DATE_TIME_3 datatype="timestamp"></DATE_TIME_3>
<DATE_TIME_4 datatype="timestamp"></DATE_TIME_4>
<DATE_TIME_5 datatype="timestamp"></DATE_TIME_5>
<END_BROADCAST datatype="timestamp"></END_BROADCAST>
<FILE datatype="string"><![CDATA[ac7f204d-2f8c-4b6e-bcf2-bf07579e99db.BWF]]></FILE>
<FILE_LENGTH datatype="int64">281386</FILE_LENGTH>
<FORMAT datatype="long">8</FORMAT>
<FREQUENCY datatype="long">48</FREQUENCY>
<GUID_CHANNEL datatype="guid">00000000-0000-0000-0000-000000000000</GUID_CHANNEL>
<GUID_ITEM datatype="guid">ac7f204d-2f8c-4b6e-bcf2-bf07579e99db</GUID_ITEM>
<GUID_PLAN_GRID1 datatype="guid">00000000-0000-0000-0000-000000000000</GUID_PLAN_GRID1>
<GUID_PLAN_GRID2 datatype="guid">00000000-0000-0000-0000-000000000000</GUID_PLAN_GRID2>
<ID_ITEM datatype="long">183330</ID_ITEM>
<ID_ITEM_ORG datatype="long">0</ID_ITEM_ORG>
<ID_PLANNING datatype="long">0</ID_PLANNING>
<INTRO_DURATION datatype="double">0</INTRO_DURATION>
<INTRO_DURATION2 datatype="long">0</INTRO_DURATION2>
<INTROMS datatype="long">0</INTROMS>
<ITEM_DURATION datatype="double">8760</ITEM_DURATION>
<ITEM_DURATION2 datatype="long">0</ITEM_DURATION2>
<ITEM_LANGUAGE datatype="string"><![CDATA[]]></ITEM_LANGUAGE>
<ITEM_REMARKS datatype="string"><![CDATA[]]></ITEM_REMARKS>
<LINK_DURATION datatype="double">0</LINK_DURATION>
<LINK_DURATION2 datatype="long">0</LINK_DURATION2>
<LIST_MARK datatype="string"><![CDATA[]]></LIST_MARK>
<LOCK datatype="double">0</LOCK>
<MODE datatype="string"><![CDATA[1]]></MODE>
<NAME_ARCHIVE datatype="string"><![CDATA[]]></NAME_ARCHIVE>
<NUM_CD datatype="string"><![CDATA[]]></NUM_CD>
<NUM_SELECTOR datatype="string"><![CDATA[]]></NUM_SELECTOR>
<OBJ_ID datatype="string"><![CDATA[]]></OBJ_ID>
<OUTTRO_DURATION datatype="double">0</OUTTRO_DURATION>
<OUTTRO_DURATION2 datatype="long">0</OUTTRO_DURATION2>
<OUTTROMS datatype="long">0</OUTTROMS>
<PATH datatype="string"><![CDATA[\\10.3.0.13\SONS$\2017\10\]]></PATH>
<PATH_SERVER1 datatype="string"><![CDATA[]]></PATH_SERVER1>
<PATH_SERVER2 datatype="string"><![CDATA[]]></PATH_SERVER2>
<PLAN_COUNT datatype="long">0</PLAN_COUNT>
<PLANNED datatype="double">0</PLANNED>
<PROTECTED datatype="long">0</PROTECTED>
<QUALITY datatype="long">0</QUALITY>
<RECORDED datatype="double">1</RECORDED>
<ROTATION datatype="long">0</ROTATION>
<RTA datatype="double">0</RTA>
<RTB datatype="double">1</RTB>
<RTW datatype="long">0</RTW>
<SOURCE_REC datatype="long">0</SOURCE_REC>
<START_BROADCAST datatype="timestamp"></START_BROADCAST>
<STATE datatype="long">2</STATE>
<STATION_DELETE datatype="string"><![CDATA[]]></STATION_DELETE>
<STATION_REC datatype="string"><![CDATA[RAD-WS-DDO-71]]></STATION_REC>
<STRING_1 datatype="string"><![CDATA[Mr. Scruff2]]></STRING_1>
<STRING_10 datatype="string"><![CDATA[]]></STRING_10>
<STRING_11 datatype="string"><![CDATA[]]></STRING_11>
<STRING_12 datatype="string"><![CDATA[]]></STRING_12>
<STRING_13 datatype="string"><![CDATA[]]></STRING_13>
<STRING_14 datatype="string"><![CDATA[]]></STRING_14>
<STRING_15 datatype="string"><![CDATA[]]></STRING_15>
<STRING_16 datatype="string"><![CDATA[]]></STRING_16>
<STRING_17 datatype="string"><![CDATA[]]></STRING_17>
<STRING_18 datatype="string"><![CDATA[]]></STRING_18>
<STRING_19 datatype="string"><![CDATA[]]></STRING_19>
<STRING_2 datatype="string"><![CDATA[Kalimba2]]></STRING_2>
<STRING_20 datatype="string"><![CDATA[]]></STRING_20>
<STRING_3 datatype="string"><![CDATA[]]></STRING_3>
<STRING_4 datatype="string"><![CDATA[]]></STRING_4>
<STRING_5 datatype="string"><![CDATA[]]></STRING_5>
<STRING_6 datatype="string"><![CDATA[]]></STRING_6>
<STRING_7 datatype="string"><![CDATA[]]></STRING_7>
<STRING_8 datatype="string"><![CDATA[]]></STRING_8>
<STRING_9 datatype="string"><![CDATA[]]></STRING_9>
<TIMEZONE datatype="long">0</TIMEZONE>
<TYPE_ITEM datatype="long">1</TYPE_ITEM>
<TYPE1_ITEM datatype="long">2</TYPE1_ITEM>
<USER_DELETE datatype="string"><![CDATA[]]></USER_DELETE>
<USER_REC datatype="string"><![CDATA[NETIA]]></USER_REC>
<VALUE_1 datatype="long">0</VALUE_1>
<VALUE_10 datatype="long">0</VALUE_10>
<VALUE_2 datatype="long">0</VALUE_2>
<VALUE_3 datatype="long">0</VALUE_3>
<VALUE_4 datatype="long">0</VALUE_4>
<VALUE_5 datatype="long">0</VALUE_5>
<VALUE_6 datatype="long">0</VALUE_6>
<VALUE_7 datatype="long">0</VALUE_7>
<VALUE_8 datatype="long">0</VALUE_8>
<VALUE_9 datatype="long">0</VALUE_9>
<VIRTUAL datatype="long">7</VIRTUAL>
<X_INLINK datatype="double">0</X_INLINK>
<X_INLINK2 datatype="double">0</X_INLINK2>
<X_INTRO_BEG datatype="double">0</X_INTRO_BEG>
<X_INTRO_BEG2 datatype="double">0</X_INTRO_BEG2>
<X_INTRO_END datatype="double">0</X_INTRO_END>
<X_INTRO_END2 datatype="double">0</X_INTRO_END2>
<X_OUTLINK datatype="double">0</X_OUTLINK>
<X_OUTLINK2 datatype="double">0</X_OUTLINK2>
<X_OUTTRO_BEG datatype="double">0</X_OUTTRO_BEG>
<X_OUTTRO_BEG2 datatype="double">0</X_OUTTRO_BEG2>
<X_OUTTRO_END datatype="double">0</X_OUTTRO_END>
<X_OUTTRO_END2 datatype="double">0</X_OUTTRO_END2>
<Y_INTRO_BEG datatype="long">0</Y_INTRO_BEG>
<Y_INTRO_BEG2 datatype="long">0</Y_INTRO_BEG2>
<Y_INTRO_END datatype="long">0</Y_INTRO_END>
<Y_INTRO_END2 datatype="long">0</Y_INTRO_END2>
<Y_OUTTRO_BEG datatype="long">0</Y_OUTTRO_BEG>
<Y_OUTTRO_BEG2 datatype="long">0</Y_OUTTRO_BEG2>
<Y_OUTTRO_END datatype="long">0</Y_OUTTRO_END>
<Y_OUTTRO_END2 datatype="long">0</Y_OUTTRO_END2>
</DbTuple>
</DbEntity>