About Cart Numbers / CutIDs Myriad v5/v6 Multi-Field TSV and XML The contents of an accompanying Myriad XML file can
also be seen in the Show Tags for this File
right-click menu. 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
The following
shows an example of the XML format - some fields (shown in
blue) are obtained from MyLibrary during export, others are
fixed: <mediaItem contentType="AudioFile"
type="song">
Using either Myriad's AutoImporter or the Media Import Wizard, you can
override some of the exported defaults (such as Category, Item
Type).
The Custom 1 field is a string of all the assigned
Genres/Styles. The Custom 2
field currently merges the following properties: Opener, EndType,
Year, Gender and Tempo (with appropriate prefixes). 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.
The Library
Actions page details a new SQL Update generator for putting updated
information into an existing Myriad v5 database - and this is to be
used with
care! Myriad Transport File 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 CartChunk
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.
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
<mediaId>10000</mediaId>
<originalMediaLocation>ABBA -
DANCING QUEEN.mp3
</originalMediaLocation>
<contentExists>Yes</contentExists>
<revision>4</revision>
<title>
<title>DANCING QUEEN
</title>
<id>0</id>
</title>
<artists>
<artist
index="1">
<name>ABBA</name>
<id>0</id>
</artist>
</artists>
<audioFormat>FormatType="WAV"
SampleRate="44100" Channels="2"
WAVFormatTag="1"</audioFormat>
<categoryName>Imported</categoryName>
<itemAttributes>
<itemAttribute
stationId="0" type="Category"
index="1">
<number>0</number>
</itemAttribute>
</itemAttributes>
<firstReleaseYear>1976</firstReleaseYear>
<timings>
<mediaLength>
<end>00:03:47.4800000</end>
</mediaLength>
<intro><end>00:00:19.2100000</end></intro>
<hook><start>00:01:05.2100000</start><end>00:01:12.6500000</end></hook>
<extro><start>00:03:38.6300000</start></extro>
<referenceLength>00:00:00</referenceLength>
<totalLength>00:03:47.4800000</totalLength>
</timings>
<copyright>
<startOffset>00:00:00</startOffset>
<custom
index="1">AC1/ACHITS/DISCO</custom></copyright>
<custom
index="2">O:Opener/E:Fade/Y:1976/G:Group/T:Medium</custom></copyright>
<custom
index="3">Text from MyLibrary CUSTOM
field goes here</custom></copyright>
<ending>Fade</ending>
<created>2019-12-01T12:01:00.00Z</created>
<lastModified>2019-01-12T12:01:00.000Z</lastModified>
<notes>
<note
type="Presenter">
<notes><![CDATA[Presenter
Notes Go Here]]></notes>
</note>
</notes>
</mediaItem>
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.
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:
Cart,Title,Artist1,TrimStart,IntroEnd,HookStart,HookEnd,Extro,EndType,FileName,ContentType,Genre
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.
CutID,Title,Artist,TrimStart,IntroEnd,HookStart,HookEnd,Extro,EndType,ContentType,Genre
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.
Cart,Title,Artist1,AudioStart,IntroEnd,HookStart,HookEnd,Extro,EndType
28808,GOLD ON
THE CEILING,BLACK
KEYS,0.00,27.90,64.96,72.90,217.95,E