84.4.5.78 CUSTOM > SWOM > PLAYLIST XML

IMPORT SCOPE
The "SWOM - Playlist XML" import is able to import an XML file named as "ddmmyyyy.xml" (e.g. 30112013.XML) which contains data related to a certain daily playlist.

IMPORT TAB

Import_custom_swom_playlist_xml

• File to import: Browse for the file from which data will be imported, only .XML files will be displayed since they are the only supported. The file will be first searched on the path specified in Default import path parameter.

• Last imported playlists: This window displays the filename of the last imported playlists. Maximum of 30 playlists can be displayed.

PARAMETERS 1 TAB

Import_custom_swom_playlist_xml_1

• Always update Live: Allows you to always update the Live events, even if they already exist in the archive.

• Assign same scheduled time for adjacent types: For events that have the same type and fall adjacent to each other in the schedule (e.g. commercials in a cluster) this parameter allows you to assign the same scheduled time to these events.  In the 'Data' to import under the previous tab the field HOUR must not be activated for this parameter to work.

• Import the actual duration if the asset is ingested:  Allows to import the real duration of the asset form in a situation where it has been recorded, even if the scheduled duration is present and different in the imported file.

• Default channel to assign to LIVE assets: Specify the channel to associate to LIVE events.

• Prefix to add to "PRS" codes: Specify the prefix to be added to the "MediaID" when it starts with "PRS".
Events related to SWOM and Discovery have the same MediaID (even if their data is different), using a prefix to differentiate them will prevent processing the wrong asset.
Note: The MediaID is used to generate the code of imported assets.

• Import on daily scheduling: If you are importing the schedule for the current day, this parameter defines what time on the schedule the import starts from. It is calculated as Current time + Time shift. Events with a start time before the current time will not be imported.

• Types excluded from import: Specify the types of assets to be skipped (i..e not imported) during the import process.       

• Check Schedule Discrepancies: This is the build-in function to detect the discrepancies between the imported file and scheduled playlists for comparison.  You can select to generate the output file in text file format (.txt) or Microsoft Excel new format (.xlsx) and save the file in dedicated path. The last 20 discrepancies reports would be retained in the system.

• Default format: Set the format code (e.g. 9) and conversion code (e.g. SA) to be assigned by default to imported assets.

SECONDARY EVENTS

Set here the parameters related to the import behaviour regarding secondary events associated to primary events:

• Type: Enter the code of the secondary object.

• Script: Specify the identification number of the related script.

• Device 1: Indicate the main device to be assigned to the object.

• Device 2: Indicate the simulcast device to be assigned to the object.
Note: Whether 1 or 2 devices are set only 1 secondary object is created.

• Gap between CTM falling at the same time (frames): Specify the time gap to be applied to CTM scripts starting at the same time.

• Gap from the start or end of the first CTM (frames): Specify the time gap between the start and end of the first CTM script.

SCRIPTS

Specify secondary events with the following parameters:

• Code: Enter the code of the secondary object. You can enter up to 3 secondary type objects, with each object separated by a “,” (comma).

• Script preset: Specify the identification number of the script preset.

• Advance (frames): Indicate the time before the event start to performing the Preset script.

• Script take: Indicate the time at which the Take script is performed.

• Script clear delay on take: Indicate the time after the Take script to performing the Clear script. This option is applied only to ELEVATOR objects (i.e. CLAR out-of-range).

• Device1: Indicate the graphic device to be assigned to the object, when the secondary event type defined in this row is found in the xml.

• Device2: Indicate the graphic device to be assigned to the object, when the secondary event type defined in this row is found in the xml.

When importing secondary events, the following conditions are applied:
- If a VOEC object is preceded by a CLAR (within range), only the Preset script will be applied to the latter one, omitting the Take and Clear scripts.
- The TFON parameter determine the mode to import title text during importing of playlist XML and pass the parameter to CTM for processing, the title text can be entered in UPPERCASE, or lowercase, or remain as original letter case.  The TFON indicate begin of title text, where TFOF indicate the end.  The TFON and TFOF have the same features as TCON and TCOF except the countdown.
- The CDON parameter import the secondary type graphic template title and pass parameters with a computed countdown to CTM for processing.  The graphic title can be entered in UPPERCASE, or lowercase, or remain its original letter case.  The FRON and FROF parameters has the similar function as CDON and CDOF except it does not have countdown.
- The Import would consecutively check the presence of secondary event types TCON/TCOF, TFON/TFOF, CDON/CDOF, and FRON/FROF, if any of the “ON/OF” commands is not presence the import would be aborted.

• Clear Advance: Set the number of frames in advance before the launch of Clear command.

• Mode to import params: Select the characters font when entering the values, e.g. Uppercase, Lowercase, or its Original font. 

• Type "TIPM": This parameter manage the secondary event type “TIPM”, only secondary events matched the specified condition (in UPPERCASE) would be imported.

• Type "TDVE": This parameter manages the secondary event type “TDVE” during the import. There are 2 possible values of the secondary events, namely “DVN1” and “DVL1”.
    - DVN1: Same import criteria as “TIPM”.
    - DVL1: The import criteria are defined as follow:
       ◦ Make reference to value indicated in the <Comments> tag, e.g. if the value is “TOD1020” the import would search the program schedule on “today” at “10:20” AM.
       ◦ Make reference to parameter indicated in tag <EPGSeasonsName>, and value in tag <SeasonsID>, e.g. if the value is “MON1125” the import must look for relative program scheduled on next “Monday” at “11:25” AM.
       ◦ The “Day” codes are defined below:
           TOD – Today            TOM – Tomorrow
           MON – Monday       TUE – Tuesday
           WED – Wednesday  THU – Thursday
           FRI – Friday              SAT – Saturday
           SUN - Sunday
When importing TDVE secondary event type, the following conditions are applied:
➢ If a TDVE event is preceded by a CLAR (within range), the Preset script, Take script and Clear script would be applied.
➢ If there is another TDVE event preceded by a CLAR (within range) at the same time, the Take and Clear scripts would be omitted.

• Type "TWON": This parameter manages secondary event type “TWON” which would be broadcast in all “P” type events scheduled between “TWON” and “TWOF”, starting from the “n” frames from the start of “P” type events.
When a “TWON” type secondary event is detected in the playlist, all subsequent events with “P” type would be added to one or more subevents with a “PRESENCE DURATION” and ends with “ABSENCE DURATION”. The subsequent “P” type events would be managed in similar sequence.
The scheduling of “TWON” type secondary events would be stopped when “TWOF” is detected in playlist.

• Mode to import params: Select the characters font when entering the values, e.g. Uppercase, Lowercase, or its Original font.

• Default import path: Choose the default path where Etere Import\Export will look for the file to import, when clicking on Import button. This will be also the path opened when saving the discrepancies xlsx file. Instead, with the txt file type this setting is not considered.

• Jolly Char for row separator (Valid for type: TIPM and TWON): Specify the wildcard character used to substitute one or more characters in a string of events. As the name says, this parameter is applied only to TIPM and TWON types.

• Frames from “P” event start: Specify the number of frames in “P” event to start managing the “TWON” secondary event.
Note: In the imported file, if the duration of the "TWON" secondary event is shorter than “00:03:30:00” the event would not be imported into program.

DISCREPANCIES REPORT

When import completed, a log file containing a list of assets with discrepancies (between the submitted / processed files and scheduled playlists) detected would be launched automatically to alert the users. The comparison of the marks in the schedule is done as the asset had exploded in the schedule. Details information in the log file includes asset ID, asset code, asset type and description of the asset. The discrepancies captured in the log file includes:
- The number of assets in the playlist and all scheduled assets.
- The marks of the assets and those assets scheduled in on-air playlist.
- The marks of the assets of the parties and those assets scheduled in on-air playlist.
- The asset does not contains a compatible file Automation.
- For secondary event type “TIPM” only program type “P” would be taken into account.
The log file can be saved as text file (.txt) or Windows excel open XML format (.xlsx), or printed as hardcopy for follow-up investigation.    
Note: To be saved as .xlsx file, it requires Microsoft Office Professional Plus 2010 (or later) to be installed.

ASSET CREATION FOR SECONDARY EVENTS

This feature allows to create assets for the Secondary Events only. The created assets would have their Code as their Tag MediaID and their Type as Type TAG.

• Quality to be assigned to imported assets: Quality to assign to the imported materials.
• Type Executed from Import: Types to exclude from the import procedure. Multiple types can be inserted, separated by a comma (',').
• Logo Metadevice Main/Backup: feature not managed yet;
• T-WF to be Launched on Asset of each Secondary Events: Etere T-Workflow to launch once the asset is created.

LIVE PROGRAMS

Secondary event types to be manually transmitted: Define which types of secondary events on live events have to be manually transmitted.

PARAMETERS 2 TAB

SECONDARY EVENTS

• Type "TWS1" & "TWS2": This parameter manages secondary event types “TWS1” and “TWS2”, where:
TWS1 = STATIC AUTOMATIC WATERMARK ON
TWS2 = STATIC AUTOMATIC WATERMARK OFF
- The event types are scheduled between “TWON” and “TWOF” starting from the "n" of frames from the starts of the “P” type events.
- The “PRESENCE DURATION” and “ABSENCE DURATION” fields of the events would not be populated into database.
- The event graphics would remain on-air upon import
- The new event types and current event types can be scheduled and co-exist on the same day schedule, occupy the same layer and same position on the screen.
- If event types “TWON” and “TWS1” are overlapped in the same timeslot, the import process would be aborted.
Note: In the import file, if the duration of the “TWS1” secondary event is shorter than “00:03:30:00” the event would not be imported into program.

• Type "DAS": This parameter manages the import of secondary event type “DAS” in the playlist which will identify the break to be replaced. The import of DAS as secondary event is based on the scheduled time and launch relative sequential commands Preset, Take and Clear.
- If the above 3 commands are not launched in sequential order, the import would be aborted.
- If there are others secondary events scheduled at the same time, the DAS type event would take precedence by shipping the time of other secondary events.

• Logo type spot: Define which is the type in the xml file to be managed. All the scripts configured in this row will be applied to every secondary event of that type.

• Mediaid prefixes (A, B, etc.): Specify here all the prefixes of the mediaid in the import file that should have GPI1 applied.

• Advance on take: Set the number of frames in advance before the launch of Take command.

• Script: Specify the identification number of the script for the TAKE and the one for the CLEAR.

• Clear Advance: Set the number of frames in advance before the launch of Clear command.

• Device: Indicate the main graphic device to be assigned to the object, when the secondary event type defined in this row is found in the xml.

• Jolly Char for row separator: Specify the wildcard character used to substitute one or more characters in a string of events.

• Frames from "P" event start: Specify the number of frames from “P” event to start managing the secondary event type defined in this row.

• Frames from "DPRS" event: If in the imported xml, the secondary event type defined in Logo type spot is found, and Mediaid Prefix is empty, the secondary event will be imported a number of frames defined here from the start of the "DPRS" primary event. If Mediaid Prefix is not empty, the secondary event will be imported a number of frames defined here from the start of the primary event (or events) which mediaid start with that prefix.

• Frames from the start of the event following the live: In case of a PPON falling on a live event, indicate here how many frames before the start of the break should it be placed.

Notes:
▪ From EtereInstall_34.2.423.8123.zip the secondary event PPON is positioned 4 sec. after the end of the previous primary event.
▪ From EtImpExp.dll ver. 34.2.31.0 (included from EtereInstall_34.2.429.8129.zip) the PPOF secondary event is positioned 4 sec. after the end of the previous primary event.
▪ From EtImpExp.dll ver. 35.1.7.0 (included from EtereInstall_35.1.335.8480.zip ) the PPON secondary event is positioned 1 sec. after the start of the break, if inside a Live event.

COUNTDOWN (59 58 57 56...)

The IMPORT_CUSTOM_SWOM_PLAYLISTXML procedure supports the automatic insertion of a CTM secondary event used to generate a countdown sequence (59, 58, 57, 56, ...).

The feature is controlled by the following parameters:

• How many secs before TCOF: Specify how many seconds before the corresponding TCOF event the CTM secondary event must be automatically inserted. If set to 0, this function is disabled.

• CTM to use: Specify the CTM script number assigned to the generated countdown event.

The automatic CTM countdown generation is supported only for the following event pairs:

➢ TCON / TCOF

When enabled, the import process analyzes all primary events contained between the opening and closing markers TCON/TCOF and calculates the exact position where the CTM event must be inserted.

The generated CTM event is positioned so that the countdown starts at the configured number of seconds before the corresponding TCOF event.

Example:

TCON 00:00:00
SPOT1 dur=00:00:20
SPOT2 dur=00:00:20
SPOT3 dur=00:00:20
SPOT4 dur=00:00:20
TCOF 00:00:00

Configuration:

▪ How many secs before TCOF = 55

In this example, the import process inserts the CTM event 5 seconds after the start of SPOT2, because from that position to the TFOF event there are exactly 55 seconds remaining.

➢ The Import would consecutively check the presence of secondary event types TCON/TCOF, if any of the “ON/OF” commands is not present the import would be aborted.

DATA FOR SENDING AN ALERT EMAIL

Set the email data to which an alert should be sent in case of errors in the import process. Emails sent through this function contain the list of errors present also in the Errors tab. Click the Configure button to fill the following fields:

• Host (SMTP server), Port: The dedicated SMTP server and its port number.
• Username and password: User login name and password.
• From: Sender's email address.
• To: Recipient's email address.
• CC: Recipient's email address in the CC list.

Once configured, use the Test button to send a dummy email and verify the parameters.

Launch the import
Once all parameters have been correctly set, just press the <Import> button to launch the import operation.

Sample file to import
The file to be imported using this method will have to the following structure in order to be correctly imported:

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<Playlist>
  <!-- ... -->  
</Playlist>