User Tools

Site Tools


tutorials:musicmaster:mairlistdb-sync-files

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
tutorials:musicmaster:mairlistdb-sync-files [2017/08/21 13:40] – [Schedule Export (and Import)] twtutorials:musicmaster:mairlistdb-sync-files [2019/07/09 16:18] (current) – external edit 127.0.0.1
Line 73: Line 73:
  
 We assume that you have used the Automatic Scheduler in MusicMaster to create some music schedules. We use one export file per day, so you should have scheduled at least one entire day that we are now going to export. We assume that you have used the Automatic Scheduler in MusicMaster to create some music schedules. We use one export file per day, so you should have scheduled at least one entire day that we are now going to export.
- 
-==== MusicMaster setup ==== 
  
 The file format being used is mAirList's [[reference:text_playlist_import_format_specification|Text Playlist Import (TPI) Format]], essentially a special kind of CSV format (which is good because you can easily open and review the files in any text editor). We use //I// lines ("Internal ID") most of the time, so it is important that MusicMaster has the mAirListDB internal IDs stored in one of its fields. The file format being used is mAirList's [[reference:text_playlist_import_format_specification|Text Playlist Import (TPI) Format]], essentially a special kind of CSV format (which is good because you can easily open and review the files in any text editor). We use //I// lines ("Internal ID") most of the time, so it is important that MusicMaster has the mAirListDB internal IDs stored in one of its fields.
 +
 +==== MusicMaster setup ====
  
 Before you can export the schedule from MusicMaster, you must create an appropriate export definition in the MusicMaster Export File Designer. Before you can export the schedule from MusicMaster, you must create an appropriate export definition in the MusicMaster Export File Designer.
Line 110: Line 110:
  
 {{ :tutorials:musicmaster:pasted:20170821-153931.png?400 }} {{ :tutorials:musicmaster:pasted:20170821-153931.png?400 }}
 +
 +Note: Use //Music block// instead of //Fill with music// in order to import the entire log MusicMaster generated for that hour, including any possible overplanning.
 +
 +Next, we create a new Music Template. In the definition of Block 1 (we only work with Block 1 all the time), set the source to //External scheduler//:
 +
 +{{ :tutorials:musicmaster:pasted:20170821-154306.png?400 }}
 +
 +Then click //Configure// and set up the import file location and format:
 +
 +{{ :tutorials:musicmaster:pasted:20170821-154502.png?400 }}
 +
 +The important bits are:
 +
 +  * File format: TPI
 +  * File style: One file per day
 +  * Split hour by: automatic
 +  * Split block by: automatic
 +  * Source folder: ''C:\MM_Sync\Schedule''
 +  * Filename format: ''%Y%M%D.TPI''
 +
 +The import tasks can be left untouched as we will not deal with unknown files.
 +
 +Save the template, and assign it to all 24x7 hours in the Template Assignments grid.
 +==== Peform the import ====
 +
 +Once the Hour Template and Music Template have been set up, run the Mini Scheduler (click the //Generate// button in the main toolbar of the //Playlist// tab). The scheduler will now generate the playlists for the selected hours, picking up the TPI files and using their content for the //Fill with music// etc. sections.
 ===== Reconciliation ===== ===== Reconciliation =====
  
tutorials/musicmaster/mairlistdb-sync-files.1503322824.txt.gz · Last modified: 2019/07/09 16:19 (external edit)

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki