84.4.5.92 SONAPS
Import Scope
The SONAPS import is exclusively used by Active Sync to enrich assets related to synchronized video files with metadata retrieved from XML files stored along video files:
Active_sync_integration
Here below is the list of the information stored in the ETERE database for every asset imported through the SONAPS function:
ETERE
SONAPS
Metadata - Inf_Digit
Type : integer
Description : Logical offset for playout
Source tag in XML : <FilingMetadata>.SOM
Metadata - DUR
Type : integer
Description : File duration
Source tag in XML : <FilingMetadata>.EOM - <FilingMetadata>.SOM
Metadata - Title
Type : string
Description : Short description
Source tag in XML : <ArchiveList>.Title
Metadata - Aspect
Type : string
Description : Aspect ratio
Source tag in XML : <MaterialMetadata>.AspectRatio
Metadata - Code
Type : string
Description : File code
Source tag in XML : <MaterialMetadata>.MaterialID
Import with ActiveSync
In case this import is enabled in Etere ActiveSync, every time a new video file is detected ActiveSync will also search for a related XML descriptive file named according to the following convention:
[VideoFileName].xml
(e.g. if the video file is named truyenhinhquando.xml then the descriptive file should be truyenhinhquando.xml)
NB: If no XML descriptive file is found the video file is not imported.
In order to be imported, XML descriptive files must be valid, that it's, they must meet the following requirements:
✓The <ArchiveList> tag must be the first in the XML file
✓The <MessageID> must exists in the XML file
If the file is valid, metadata are imported into the matched asset
Once imported, the descriptive file is automatically renamed appending the ".done" suffix (e.g. truyenhinhquando.xml.done)
Import parameters
The parameters of this import are internally managed, they are fixed and cannot be modified.
Sample file to import
In order to be imported into Etere, the XML file must be structured as in the following example:
<?xml version="1.0" encoding="UTF-8"?>
<ArchiveList>
<!-- THIS TAG MUST BE THE FIRST ONE -->
<MessageID>3f7874a0bbcd47358c78e248bb63626c</MessageID>
<!-- THIS TAG MUST EXISTS AT LEAST ONCE -->
<TimeStamp>2012-06-11 14:31:18</TimeStamp>
<MediaID />
<Title>10s</Title>
<!-- "TITLE" TAG IS IMPORTED INTO METADATA: _desc -->
<Comments />
<Archivist />
<ArchiveTime />
<ProavIDRef />
<mosObj>
<objID>64ad45da2d7d41a4871e84a710926315</objID>
<!-- "ObjID" TAG IS IMPORTED INTO METADATA: _umid -->
<objSlug>10s</objSlug>
<description />
<objType>VIDEO</objType>
<objTB>50</objTB>
<objRev />
<objDur>250</objDur>
<objAir />
<objFrameMode>1</objFrameMode>
<createdBy>jx</createdBy>
<created>2012-06-21T16:19:55</created>
<changedBy>sj02</changedBy>
<changed>2012-06-11T14:19:21</changed>
<mosExternalMetadata>
<mosSchema />
<mosPayload>
<ArchiveInfo>
<HRPath>\\172.16.134.250\X\64ad45da2d7d41a4871e84a710926315_10s.mxf</HRPath>
<LRPath />
<FileName>64ad45da2d7d41a4871e84a710926315_10s.mxf</FileName>
<ArchivedHRPath />
<UMID />
<Comments />
</ArchiveInfo>
<PlanningMetadata>
<ItemName />
<Journalist />
<Category />
<ProgramName />
<Place />
<Time>2012-06-11 14:21:19</Time>
<Director />
<InputBy>jx</InputBy>
<Photographer />
<Reporter />
<OtherEngineer />
<Equipment />
<ContactInfo />
</PlanningMetadata>
<OriginalMetadata>
<DiscMetadata>
<MainTitle />
<UserMediaID />
<Description />
</DiscMetadata>
<NonRealtimeMetadata>
<TargetMaterial umidRef="" status="" />
<ClipTitle />
<Creator />
<CreationDate>1899-12-30 00:00:00</CreationDate>
<Duration>0</Duration>
<VideoFormat />
<AudioFormat />
<AudioCh />
<Device />
<Description />
</NonRealtimeMetadata>
</OriginalMetadata>
<MaterialMetadata>
<TimeStampFrame>0</TimeStampFrame>
<Rights />
<Address>\\Public Material\Ingest Material\20120611</Address>
<AspectRatio>16:9</AspectRatio>
<!-- "ASPECTRATIO" TAG IS IMPORTED INTO METADATA: ASPECT -->
<MaterialID>20120621000000000000</MaterialID>
<!-- "MATERIALID" TAG IS IMPORTED INTO METADATA: CODE -->
</MaterialMetadata>
<FilingMetadata>
<InputSource>VTRTest</InputSource>
<VideoFormat />
<AudioFormat />
<Framerate>25.000000</Framerate>
<AudioCh>8</AudioCh>
<SOF>1803150</SOF>
<FilingDuration>250</FilingDuration>
<SOM>0</SOM>
<!-- "SOM" TAG IS IMPORTED INTO METADATA: INF_DIGIT -->
<EOM>250</EOM>
<!-- "EOM" TAG minus "SOM" TAG IS IMPORTED INTO METADATA: DUR -->
<SourceTapeID />
<BackupTapeID />
<Non-audioChannel>0</Non-audioChannel>
</FilingMetadata>
<OriginalUMID>
<FrameNumber />
<BasicUMID />
<Who />
<When />
<Where />
</OriginalUMID>
<Custom>
<Custom1 />
<Custom2 />
<Custom3 />
<Custom4 />
<Custom5 />
<Custom6 />
<Custom7 />
<Custom8 />
<Custom9 />
<Custom10 />
<Custom11 />
<Custom12 />
<Custom13 />
</Custom>
<History>
<UpdateTime>2012-06-11 14:19:21</UpdateTime>
<UpdateUser>sj02</UpdateUser>
<UpdateTerminal>zengjuan-PC</UpdateTerminal>
<FilingStartTime>2012-06-11 14:14:53</FilingStartTime>
<FilingEndTime>2012-06-11 14:24:24</FilingEndTime>
<FilingUser>jx</FilingUser>
<FilingTerminal>Ingest Terminal</FilingTerminal>
<EditingTime />
<EditingUser />
<EditingTerminal />
</History>
<LoggingMark>
<Position>107</Position>
<InOffset>0</InOffset>
<OutOffset>1</OutOffset>
<Duration>1</Duration>
<Color>8515314</Color>
<Actions>
<Action Language="-1">
</Action>
<Action Language="4">453</Action>
<Action Language="1000">wwwwwwwwwwwwww</Action>
<Action Language="1002">2</Action>
<Action Language="1110">535</Action>
</Actions>
<Members>
<Member Language="0">2 2</Member>
</Members>
<Titles>
<Title Language="0">1</Title>
</Titles>
<Comment>mark1
</Comment>
<Type>32</Type>
</LoggingMark>
<LoggingMark>
<Position>61</Position>
<InOffset>61</InOffset>
<OutOffset>439</OutOffset>
<Duration>500</Duration>
<Color>14664098</Color>
<Actions>
<Action Language="1110">eeefggg</Action>
<Action Language="1002">fgdg</Action>
<Action Language="1000">www</Action>
<Action Language="4">qqq</Action>
<Action Language="-1">
</Action>
</Actions>
<Members>
<Member Language="0">2 2</Member>
</Members>
<Titles>
<Title Language="0">3</Title>
</Titles>
<Comment>mark3</Comment>
<Type>32</Type>
</LoggingMark>
<LoggingMark>
<Position>20</Position>
<InOffset>20</InOffset>
<OutOffset>230</OutOffset>
<Duration>250</Duration>
<Color>5263597</Color>
<Actions>
<Action Language="4">1</Action>
<Action Language="1000">2</Action>
<Action Language="1002">3</Action>
<Action Language="1110">4</Action>
<Action Language="-1">
</Action>
</Actions>
<Members>
<Member Language="0">2 2</Member>
</Members>
<Titles>
<Title Language="0">2</Title>
</Titles>
<Comment>mark2
</Comment>
<Type>32</Type>
</LoggingMark>
<LoggingMark>
<Position>166</Position>
<InOffset>166</InOffset>
<OutOffset>584</OutOffset>
<Duration>750</Duration>
<Color>5758890</Color>
<Actions>
<Action Language="1110">4</Action>
<Action Language="1002">3</Action>
<Action Language="1000">4444444444</Action>
<Action Language="4">1</Action>
<Action Language="-1">
</Action>
</Actions>
<Members>
<Member Language="0">2 2</Member>
</Members>
<Titles>
<Title Language="0">3</Title>
</Titles>
<Comment>mark4</Comment>
<Type>32</Type>
</LoggingMark>
<OnAir>
<Material>
<MaterialID />
<Title />
<TitlePicture />
<Comments />
<Rights />
<STC />
<Duration />
<Editor />
<EditTerminal />
</Material>
<EventProperty>
<ID />
<Title />
<Comments />
<SOM />
<EOM />
<Duration />
<Channel />
<Version />
<MOSitemID />
<LastUpdated />
<UpdateUser />
<UpdateTerminal />
<PlayoutStart />
<PlayoutEnd />
</EventProperty>
<StoryTitle />
<ProgramTitle />
<RawMaterialList>
<MaterialID />
<Title />
<In />
<Out />
<Address />
<LastUpdated />
<Order />
</RawMaterialList>
</OnAir>
</mosPayload>
</mosExternalMetadata>
</mosObj>
</ArchiveList>
5308_Active_sync_integration