Import Formats

84.4.5.3 STANDARD > AVID SUNDANCE PLAYLIST TXT

Import Scope
The AVID Sundance Playlist TXT allows importing a file in TXT format containing the events scheduled in the playlist of a specific day.
The import will be performed under the following specifications:
Prerequisites
The following types must exist in the system, associated to the relative programs:
Type - COM
Programme : Commercial
Type - J
Programme
: Promo
Type - PROG
Programme
: Program
File structure
The filename must contain the date of the playlist to import, which must be specified in the following format:
mmddyy.txt   (e.g. 052814.txt)
Only dates in the future will be imported, dates in the past will be ignored.
Each line must contain one scheduled event
Import process
Check the validity of the file structure
Verify the unicity of the ReconcileKey, that is, it must not be imported in other days or by other users
ST1 programs are considered as "LIVE" and their event type property is set to "manual".
Import parameters
This import allows the following parameters to be set and then [saved]:

Import_standard_avid_sundance_playlist_txt

Import tab
File to import - 
Browse and select the folder where files to be imported will be stored.
Note: Files must be named according to what specified in the previous "File Structure" section.
Parameters tab
Always update Live - 
If enabled, "live" events will be always updated, even if they already exist in the database.
Delete events not present in the file - If enabled, events missing in the imported file but found in the imported date's playlist will be deleted.
Assign same scheduled time for adjacent types - If enabled, the same scheduled time will be set for events that have the same type and fall adjacent to each other in the playlist (e.g. commercials in a cluster).
Import the actual duration if the asset is recorded - If enabled, the actual duration of the asset will be imported if it's already recorded, even if the scheduled duration exists and it's different than the one in the imported file.
Always update the asset - If enabled, assets (live and not) will be always updated even if they already exist in the database.
Updated fields include Duration, Mark in/Mark out, Type, Description and Insertion points.
Channel to assign to LIVE- Specify here the channel to be set by default on imported "live" events.
Import on daily scheduling - If you are importing the schedule for the current day, this parameter indicates what time on the schedule the import starts from (calculated as [current time] + [time shift]).
Events with a start time before the current time will not be imported. 
Launch the import
Once all parameters have been correctly set, just press the <File 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:
MetroTV News 052814
 ++++BREAK++++
04:30:00.00 F ST1                METRO PAGI SEG 1                This is a Programme        00:08:00.00 ST1        0300001
 ++++BREAK++++
04:38:00.00 M CM14030367        WORLD CLASS UNIVERSITY        This is a Commercial        00:00:15.00 VS        0300002
04:38:15.00 F CM14040672        AMAN                                This is a Commercial        00:00:30.00 VS        0300003
04:38:45.00 F CM13120494        I3L                                This is a Commercial        00:00:30.00 VS        0300004
04:39:15.00 F CM14020308        PR B-NEWS NEW 19:25                This is a Commercial        00:00:30.00 VS        0300005
04:39:45.00 F CM14050549        PR THE MANSION 1/06/14        This is a Commercial        00:00:30.00 VS        0300006
04:40:15.00 F PG1405296        EAGLE DOCUMENTARY EP.V        This is a Promo        00:00:30.00 VS        0300007
04:40:45.00 F PM1405137        STING TEA TIME WITH DESI        This is a Promo        00:00:05.00 VS        0300008
04:40:50.00 F ST1                METRO PAGI SEG 2                This is a Programme        00:08:00.00 ST1        0300009
 ++++BREAK++++
04:48:50.00 M CM14050288        LIPUTAN MAKAN GRATIS                This is a Commercial        00:00:15.00 VS        0300010
04:49:05.00 F CM14040672        AMAN                                This is a Commercial        00:00:30.00 VS        0300011
04:49:35.00 F CM14050530        JKW JK PEMIMPIN JUJUR ADIL        This is a Commercial        00:00:30.00 VS        0300012
04:50:05.00 F CM14050546        PR MENTENG PARK 31/05/14        This is a Commercial        00:00:30.00 VS        0300013
04:50:35.00 F PG1405284        KICK ANDY 30/05 EP.V                This is a Promo        00:00:30.00 VS        0300014
04:51:05.00 F CM14040672        AMAN                                This is a Commercial        00:00:30.00 VS        0300015
04:51:35.00 F PM1312440        STING BINCANG PAGI 2014        This is a Promo        00:00:05.00 VS        0300016
04:51:40.00 F ST1                METRO PAGI SEG 3                This is a Programme        00:06:15.00 ST1        0300017

5201_Import_standard_avid_sundance_playlist_txt