Hi Theo,
yes, you should use the ProppFrexx Export feature to export your library tracks to Music1 and yes, the "MUSIC 1 v7 Export" format is the right one.
The main issue is, that Music1 doesn't have a real 'import' standard on their side - as such I am affraid, that a little bit of 'custom' settings/mappings are required on the Music1 side.
On the ProppFrexx side, you might even change the "MUSIC 1 v7 Export" definition - but all changes might also be done on the Music1 side.
Just to give you the full picture...
The export format definition is located in a file called "ProppFrexx.exportformats" - this file is located in the ProppFrexx installation folder (as it is normally considered to be fixed and should normally not be changed). It is a plain xml file containing a <format name="MUSIC 1 v7 Export"... section, which looks like this:
Code: Select all
<format name="MUSIC 1 v7 Export" type="CSV" extension=".csv" delimiter="TAB" useHeader="True" quote="" quoteEsc="" quoteHeader="False" trim="True" encoding="utf-8">
<fields>
<field name="GUID" start="0" length="0" align="left" pad=" ">${guid}</field>
<field name="Artist" start="0" length="0" align="left" pad=" ">${artist}</field>
<field name="Title" start="0" length="0" align="left" pad=" ">${title}</field>
<field name="Duration" start="0" length="0" align="left" pad=" ">${lengthms}</field>
<field name="Directory" start="0" length="0" align="left" pad=" ">${directoryname}</field>
<field name="Filename" start="0" length="0" align="left" pad=" ">${filename}</field>
<field name="Genre" start="0" length="0" align="left" pad=" ">${genre}</field>
<field name="Year" start="0" length="0" align="left" pad=" ">${year}</field>
<field name="Album" start="0" length="0" align="left" pad=" ">${album}</field>
<field name="BPM" start="0" length="0" align="left" pad=" ">${bpm}</field>
<field name="Grouping" start="0" length="0" align="left" pad=" ">${grouping}</field>
<field name="Mood" start="0" length="0" align="left" pad=" ">${mood}</field>
<field name="ISRC" start="0" length="0" align="left" pad=" ">${isrc}</field>
<field name="Rating" start="0" length="0" align="left" pad=" ">${rating}</field>
<field name="TrackType" start="0" length="0" align="left" pad=" ">${tracktype}</field>
<field name="AlbumArtist" start="0" length="0" align="left" pad=" ">${albumartist}</field>
<field name="Composer" start="0" length="0" align="left" pad=" ">${composer}</field>
<field name="Copyright" start="0" length="0" align="left" pad=" ">${copyright}</field>
<field name="EncodedBy" start="0" length="0" align="left" pad=" ">${encodedby}</field>
<field name="TrackNumber" start="0" length="0" align="left" pad=" ">${tracknumber}</field>
<field name="DiscNumber" start="0" length="0" align="left" pad=" ">${discnumber}</field>
<field name="Publisher" start="0" length="0" align="left" pad=" ">${publisher}</field>
<field name="Conductor" start="0" length="0" align="left" pad=" ">${conductor}</field>
<field name="Lyricist" start="0" length="0" align="left" pad=" ">${lyricist}</field>
<field name="Remixer" start="0" length="0" align="left" pad=" ">${remixer}</field>
<field name="Producer" start="0" length="0" align="left" pad=" ">${producer}</field>
<field name="Bitrate" start="0" length="0" align="left" pad=" ">${bitrate}</field>
<field name="Options" start="0" length="0" align="left" pad=" ">${options}</field>
<field name="TrackEnd" start="0" length="0" align="left" pad=" " mapping="TrackEndIndicator">${trackendindicator}</field>
<field name="CueIn" start="0" length="0" align="left" pad=" ">${cueinms}</field>
<field name="FullLevel" start="0" length="0" align="left" pad=" ">${fulllevelms}</field>
<field name="Ramp" start="0" length="0" align="left" pad=" ">${rampms}</field>
<field name="Ramp2" start="0" length="0" align="left" pad=" ">${ramp2ms}</field>
<field name="Outro" start="0" length="0" align="left" pad=" ">${outroms}</field>
<field name="FadeOut" start="0" length="0" align="left" pad=" ">${fadeoutms}</field>
<field name="Next" start="0" length="0" align="left" pad=" ">${nextms}</field>
<field name="CueOut" start="0" length="0" align="left" pad=" ">${cueoutms}</field>
<field name="HookCueIn" start="0" length="0" align="left" pad=" ">${hookcueinms}</field>
<field name="HookFullLevel" start="0" length="0" align="left" pad=" ">${hookfulllevelms}</field>
<field name="HookRamp" start="0" length="0" align="left" pad=" ">${hookrampms}</field>
<field name="HookRamp2" start="0" length="0" align="left" pad=" ">${hookramp2ms}</field>
<field name="HookOutro" start="0" length="0" align="left" pad=" ">${hookoutroms}</field>
<field name="HookFadeOut" start="0" length="0" align="left" pad=" ">${hookfadeoutms}</field>
<field name="HookNext" start="0" length="0" align="left" pad=" ">${hooknextms}</field>
<field name="HookCueOut" start="0" length="0" align="left" pad=" ">${hookcueoutms}</field>
<field name="Comment" start="0" length="0" align="left" pad=" " mapping="ReplaceCRLF">${comment}</field>
<field name="ModText" start="0" length="0" align="left" pad=" " mapping="ReplaceCRLF">${moderatortext}</field>
</fields>
<mappings>
<mapping name="ReplaceCRLF">
<map value="${CRLF}">-CRLF-</map>
<map value="${CR}">-CR-</map>
<map value="${LF}">-LF-</map>
</mapping>
<mapping name="TrackEndIndicator">
<map value="|">Cold</map>
<map value="\">Fade</map>
</mapping>
</mappings>
</format>
As this export format is a simple TAB separated file format (in the order of the above fields), you might adopt the related Music1 import/mapping accordingly.
To your detailed questions:
Filename and Cart:
Yes, we decided to split this (path and filename) into 2 fields, as Music1 has some internal limitations with repect the total length of a single Music1 field - which is (if I remember it correctly) something like 128 or 160 characters.
A fully qualified filename however might be up to 260 characters long!
So we decided to use 2 fields in the export - so that you might combine them on the Music1 side.
So you might do 2 alternative things:
a) change the ProppFrexx.exportformats definition (e.g. by using the ${filenameandpath} instead of the ${directoryname} macro)
b) change the Music1 import settings/mappings and combine the 2 fields into a single combined one
TrackEnd:
That must be a pure settings/mapping thing on the Music1 side!
HookIn, HookOut:
That must be a pure settings/mapping thing on the Music1 side! But I am not sure, if those fields do exist in the Music1 standard.
Note, that you can create any number of 'custom' fields within Music1 and if so, you must adopt the import settings/mappings of Music1 accordingly.
When talking about 'seamless integration' I was mainly talking about the scheduler log-import and the ProppFrexx side of the world.
Unfortunately I can not force 3rd party companies to do the same...
Exporting meta data to Music1 and setting up of custom attributes within Music1 is always a 'custom' processing step - at least that is the point of view of Music1.
So I am also contacting the Music1 guys again to ask for a more 'streamlined' import on their side!