Much of the following (especially with v5) is a result of
to'ing and fro'ing with users of this software rather than relying on any vendor
documentation. YMMV. About Cart Numbers / CutIDs Myriad v5 Multi-Field TSV Warning! The EndType does not seem to "take"
unless there's an accompanying Myriad v5 .xml file alongside the audio.
file title artist1 album item
type category year cutid audiostartms audioendms introstartms introendms hookstartms hookendms extroms endtype issweeper Myriad v5 CSV/TSV
You do not have necessarily to have any defined Cart Numbers for Myriad to import from a MyLibrary CSV Export - However, it is advisable as once you've assigned a Cart Number and sent the file to Myriad, if a matching filename appears later on (such as from a compilation album) it will have a Cart Number as well as all the other attributes. This would alert you to a potential duplicate in the playout system (or your music library).
This is a tabbed-text file and similar to the older style used by v4 however, at this time, the EndType does not seem to work unless you also export an accompanying .xml meta-data file for each track. Not all fields are required/exported - and MyLibrary will only output the fields that have a value. With regards Intro1/2/3 in MyLibrary, the highest Intro Marker will be used.
C:\SONGS\10CC - DREADLOCK HOLIDAY.wav DREADLOCK HOLIDAY 10CC Song Imported 1978 12345 0 266843 0 18341 0 0 259029 Fades
Much of the following (especially with v5) is a result of to'ing and fro'ing with users of this software rather than relying on any vendor documentation. YMMV.
About Cart Numbers / CutIDs
Myriad v5 Multi-Field TSV
Warning! The EndType does not seem to "take" unless there's an accompanying Myriad v5 .xml file alongside the audio.
file title artist1 album item
type category year cutid audiostartms audioendms introstartms introendms hookstartms hookendms extroms endtype issweeper
Myriad v5 CSV/TSV
The CSV is a simple MediaId (cart number) and Filename reference which can be used by the Media AutoImporter to import a specific list of audio files in various locations (as opposed to a single folder of audio). This simple method allows, for example, C:\SONGS\A\ABBA - DANCING QUEEN.wav to always be imported into Cart 10000 on the MediaWall.
Importing a list of songs from MyLibrary into Myriad v5:
The SongCard can automatically save the accompanying XML file via a setting in the Configuration .
Here's an example of the CSV produced:
10000,C:\SONGS\A\ABBA - DANCING QUEEN.wav
19999,C:\SONGS\C\CLASH - LONDON CALLING.wav
25000,C:\SONGS\Z\ZZ TOP - GIMME ALL YOUR LOVIN'.wav
Or... The XML export allows for additional meta-data to be included during import of the above CSV list or when dropping a file onto a spare Mediawall "cart". If you do drag+drop an audio file onto a specific empty Mediawall cart, the Cart Number within MyLibrary will be ignored. These XML files sit alongside the audio file and have a .xml extension (instead of .mp3 or .wav).
The following shows an example of the XML format - some fields (shown in blue) are obtained from MyLibrary during export, others are fixed:
<originalMediaLocation>ABBA - DANCING QUEEN.mp3 </originalMediaLocation>
<title>DANCING QUEEN </title>
<audioFormat>FormatType="WAV" SampleRate="44100" Channels="2" WAVFormatTag="1"</audioFormat>
<itemAttribute stationId="0" type="Category" index="1">
<notes><![CDATA[Presenter Notes Go Here]]></notes>
You can use the Myriad's AutoImporter to "override" Category (and other) fields during import - so if you need items to go into a specific Category, this can be changed in the "Import Group" settings. The "highest" Intro value in MyLibrary is used for the Myriad Intro point, eg: the definte vocal start point.
The Custom 1 field currently merges the following properties: Opener, Year, Style, EndType, Gender. This can be helpful when managing data within AutoTrack, eg: find all tracks with a "Talkup" opener which can then be set as a Song "Type" in AutoTrack. This allows you to specify an A-List song with a "Type" as a "Talkup" meaning the song has a significant intro time for voice-tracking. An actual "Opener" value could be used at the top of hour or out of ad-breaks for a high impact return to music.
Myriad v5 Transport File
A Myriad Transport file is a ZIP file containing audio and meta-data allowing you to move a Mediawall item from one system to another whilst preserving the name+timing information. The ZIP file is named CART-ARTIST-TITLE.zip enabling the Media AutoImporter to ingest them automatically into the same MediaID value as MyLibrary's Cart field.
The audio MUST be a WAV file. If MP3, the Extro defaults to "auto-detect" (as per your Station Database settings). This could be related to the "FormatType" parameter or your global Mediawall config (WAV vs MP3). As linear WAV is typically used for playout systems, I've yet to see what an MP3 export looks like!
To create the Transport File, you must first export the relevant XML file/s. These will be placed alongside your audio file as will the resulting Transport File. The AutoImporter can read the Cart-Number portion of the filename when deciding where to place it on the target Myriad Mediawall.
Myriad v3/4+v5 CartChunk
The CartChunk PostTimer values are the same across versions but some of the "extra" data within the Chunk may vary between major Myriad versions.
AUDs - CueIn
INTe - Intro 1
SEG1 - Segue/Extro
MRK1 - Hook In
MRK2 - Hook Out
Myriad v3/v4 Legacy Support
Myriad v3/v4 Bug Alert - In older versions (3.6.3, 3.6.6 and 4.0.14) there appears to be an issue with importing Intro+Segue timings using the CSV files - The Artist, Title, EndType and Content/Genre import OK but the Segue icon shows a warning sign (exclamation mark). v3.6.2 is OK as is v4.0.15 onwards. For users of the last few v4 releases - this is NOT an issue for you.
AutoTrack v4 Issue - When you import an XLS spreadsheet into AutoTrack v4.x, the "sheet" must be named Sheet1. If you've converted it from a CSV/TXT, the sheet is generally titled as per the filename - which doesn't appear to work. AutoTrack v3 did not have this "bug". This is no longer an issue with the current AutoTrackSE product.
In addition to the WAV CartChunk tag, you can also import a selection of songs using Myriad's Import Wizard by offering it a CSV file containing your song data. This is an example of the format used:
28808,GOLD ON THE CEILING,BLACK KEYS,0.00,27.90,64.96,72.90,217.95,End,C:\My Music\BLACK KEYS - GOLD ON THE CEILING.mp3,Music,Pop
Due to the delmiter used - you must not have any commas in your Artist/Title/Filename!
When importing into Myriad, the AudioStart refers to the CueIn from MyLibrary - if this is set, there is an Import Wizard option to trim the audio to this marker, ie: delete all audio before that cue point. In most cases, you would want this to happen.
Myriad Audio Single CSV - to accompany each audio file
The single CSV file accompanies an audio file and allows you to specify ContentType+Genre which some v3 versions of Myriad did not allow you to specify via the CSV Import List.
28808,GOLD ON THE CEILING,BLACK KEYS,0.00,27.90,64.96,72.90,217.95,End,Music,10s
Myriad Audio CSV - for Advanced Tools Pack (a legacy v3 utility)
With this export option, you can create a CSV list of songs with override information for your Myriad Audiowall. A good example of this feature is "slipstreaming" new cue data (such as Hooks) into your Myriad system as well as correcting bad intro/segue points. This makes it possible to import songs into Myriad but later update their Intro/Hook/Segue markers having set them in MyLibrary - which not only offers a faster way of tagging the files but can be done at home or any computer where you have a copy of the audio tracks (they don't even need to be in Cart filename format!). So long as you have the JMD files that preserve the filename-vs-cart-number, it's easy to manage a Myriad system away from your studio.
28808,GOLD ON THE CEILING,BLACK KEYS,0.00,27.90,64.96,72.90,217.95,E