MusicMaster Export Format

You have a question or need an advice about how to do something? Ask it here!
Post Reply
marinohb
Posts: 48
Joined: 27 Feb 2017 22:30
MusicMaster Export Format

Post by marinohb »

Hello,

Is there someone who uses MusicMaster who can send me the file Proppfrexx.exportformats with Length on Minutes and Intro information.

How Can I change the export csv file?
User avatar
radio42
Site Admin
Posts: 8295
Joined: 05 Apr 2012 16:26
Location: Hamburg, Germany
Contact:
Re: MusicMaster Export Format

Post by radio42 »

Not sure, if anybody ever used a dedicated MusicMaster export, as most users I know use the MusicMaster import only or have adjusted their format on the MusicMaster side - I even don't know, if there is a standrad MusicMaster format to read-in meta data from an external system.

However, you can use all track MACROS as described in the User Manual Appendix in your Proppfrexx.exportformats file, e.g.:
${length} : the track’s total length (duration) as a string ([HH:]MM:SS)
${lengthsec} : the track’s total length (duration) in seconds (3 decimal places)
${lengthms} : the track’s total length (duration) in whole milliseconds
${duration} : the track’s effective duration (CueIn to CueOut) as a string ([HH:]MM:SS)
${durationsec} : the track’s effective duration (CueIn to CueOut) in seconds
${durationms} : the track’s effective duration (CueIn to CueOut) in whole milliseconds
${playtime} : the track’s effective play time (CueIn to Next) as a string ([HH:]MM:SS)
${playtimesec} : the track’s effective play time (CueIn to Next) in seconds
${playtimems} : the track’s effective play time (CueIn to Next) in whole milliseconds
${ramptime} : the track’s ramp time (CueIn to Ramp/2) as a string ([HH:]MM:SS[/[HH:]MM:SS])
${ramptimems} : the track’s ramp time (CueIn to Ramp) in whole milliseconds
${ramp2timems} : the track’s ramp2 time (CueIn to Ramp2) in whole milliseconds
${outrotime} : the track’s outro time (Outro to Next/CueOut) as a string ([HH:]MM:SS[/[HH:]MM:SS])
${outrotimems} : the track’s outro time (Outro to Next/CueOut) in whole milliseconds
${cuein} : the track’s CueIn position as a string ([HH:]MM:SS)
${cueinsec} : the track’s CueIn position in seconds (3 decimal places)
${cueinms} : the track’s CueIn position in whole milliseconds
${fulllevel} : the track’s FullLevel position as a string ([HH:]MM:SS)
${fulllevelsec} : the track’s FullLevel position in seconds (3 decimal places)
${fulllevelms} : the track’s FullLevel position in whole milliseconds
${ramp} : the track’s Ramp position as a string ([HH:]MM:SS)
${rampsec} : the track’s Ramp position in seconds (3 decimal places)
${rampms} : the track’s Ramp position in whole milliseconds
${ramp2} : the track’s Ramp2 position as a string ([HH:]MM:SS)
${ramp2sec} : the track’s Ramp2 position in seconds (3 decimal places)
${ramp2ms} : the track’s Ramp2 position in whole milliseconds
${outro} : the track’s Outro position as a string ([HH:]MM:SS)
${outrosec} : the track’s Outro position in seconds (3 decimal places)
${outroms} : the track’s Outro position in whole milliseconds
${fadeout} : the track’s FadeOut position as a string ([HH:]MM:SS)
${fadeoutsec} : the track’s FadeOut position in seconds (3 decimal places)
${fadeoutms} : the track’s FadeOut position in whole milliseconds
${next} : the track’s Next position as a string ([HH:]MM:SS)
${nextsec} : the track’s Next position in seconds (3 decimal places)
${nextms} : the track’s Next position in whole milliseconds
${cueout} : the track’s CueOut position as a string ([HH:]MM:SS)
${cueoutsec} : the track’s CueOut position in seconds (3 decimal places)
${cueoutms} : the track’s CueOut position in whole milliseconds
${hookcuein} : the track’s Hook-CueIn position as a string ([HH:]MM:SS)
${hookcueinsec} : the track’s Hook-CueIn position in seconds (3 decimal places)
${hookcueinms} : the track’s Hook-CueIn position in whole milliseconds
${hookfulllevel} : the track’s Hook-FullLevel position as a string ([HH:]MM:SS)
${hookfulllevelsec} : the track’s Hook-FullLevel position in seconds (3 decimal places)
${hookfulllevelms} : the track’s Hook-FullLevel position in whole milliseconds
${hookramp} : the track’s Hook-Ramp position as a string ([HH:]MM:SS)
${hookrampsec} : the track’s Hook-Ramp position in seconds (3 decimal places)
${hookrampms} : the track’s Hook-Ramp position in whole milliseconds
${hookramp2} : the track’s Hook-Ramp2 position as a string ([HH:]MM:SS)
${hookramp2sec} : the track’s Hook-Ramp2 position in seconds (3 decimal places)
${hookramp2ms} : the track’s Hook-Ramp2 position in whole milliseconds
${hookoutro} : the track’s Hook-Outro position as a string ([HH:]MM:SS)
${hookoutrosec} : the track’s Hook-Outro position in seconds (3 decimal places)
${hookoutroms} : the track’s Hook-Outro position in whole milliseconds
${hookfadeout} : the track’s Hook-FadeOut position as a string ([HH:]MM:SS)
${hookfadeoutsec} : the track’s Hook-FadeOut position in seconds (3 decimal places)
${hookfadeoutms} : the track’s Hook-FadeOut position in whole milliseconds
${hooknext} : the track’s Hook-Next position as a string ([HH:]MM:SS)
${hooknextsec} : the track’s Hook-Next position in seconds (3 decimal places)
${hooknextms} : the track’s Hook-Next position in whole milliseconds
${hookcueout} : the track’s Hook-CueOut position as a string ([HH:]MM:SS)
${hookcueoutsec} : the track’s Hook-CueOut position in seconds (3 decimal places)
${hookcueoutms} : the track’s Hook-CueOut position in whole milliseconds

As you can see, there are basically 3 formats for any given time-span value:
1. '...ms' : a integer number in whole milliseconds
2. '...sec' : a decimal number in seconds (3 decimal places)
3. plain : as a string ([HH:]MM:SS)
marinohb
Posts: 48
Joined: 27 Feb 2017 22:30
Re: MusicMaster Export Format

Post by marinohb »

I changed lengthms to ${length}. I can't see any change.

<format name="Default CSV" type="CSV" extension=".csv" delimiter="," useHeader="True" quote="&quot;" quoteEsc="&quot;" quoteHeader="False" trim="True" encoding="latin1">
<fields>
<field name="Filename" start="0" length="0" align="left" pad=" ">${filenameandpath}</field>
<field name="Title" start="0" length="0" align="left" pad=" ">${title}</field>
<field name="Artist" start="0" length="0" align="left" pad=" ">${artist}</field>
<field name="Album" start="0" length="0" align="left" pad=" ">${album}</field>
<field name="Year" start="0" length="0" align="left" pad=" ">${year}</field>
<field name="Genre" start="0" length="0" align="left" pad=" ">${genre}</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="BPM" start="0" length="0" align="left" pad=" ">${bpm}</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="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="Length" start="0" length="0" align="left" pad=" ">${length}</field>
</fields>
</format>
User avatar
radio42
Site Admin
Posts: 8295
Joined: 05 Apr 2012 16:26
Location: Hamburg, Germany
Contact:
Re: MusicMaster Export Format

Post by radio42 »

I just did the same and it was working as expected. Maybe you didn't close and reopen the export dialog in between?

with ${lengthsec} I got : ...,"345.000"
with ${length} I got : ...,"5:45"

Post Reply