I'm trying to define a csv file containing the tags of my mp3 collection for onward processing in Excel.
I'm able to get most of the tags I'm interrested in, except the rating (MM, WMP and Winamp) tags.
Any idea how to get these exported?
Thanks for your help!
These fields should get exported just like any other field ... so what have you tried so far to get them?
AFAIK is it up to the data format for the interpretation whether it is MM, WMP or WA as all these ratings all refer to the same atom POPM.
Find the names of the rating related tag-fields, ... as provided in the dialog "Extended Tags",
... for example ... RATING MM or RATING WMP.
Use the content of the tag-field, ... for example ...
%RATING MM% or %RATING WMP%
DD.20150107.1244.CET
This is the string I'm using so far:
$filename(csv,utf-8)PathFilename;Artist;Album Artist;Album;Title;Year;genre;comment;disc;track;Rating;Rating;Rating;
$loop(%_filename_ext%)%_path%;%artist%;%albumartist%;%album%;%title%;%year%;%genre%;%comment%;%discnumber%;%track%;%rating mm%;%rating winamp%;%rating wmp%;
$loopend()
As you can see I used %rating mm%, %rating winamp% and %rating wmp%, but none of the values come through in the csv, see below:
Path;Filename;Artist;Album Artist;Album;Title;Year;genre;comment;disc;track;Rating;Rating;Rating;
N:\download\Music\various\Jaarmix 2014\DSR - Yearmix 2014;2nd Phase - DSR Yearmix 2014 - 17 - Synapse.mp3;2nd Phase;2nd Phase;DSR Yearmix 2014;Synapse;2014;Pop;;1;17;;;;
N:\download\Music\various\Radio 538 Dance Smash Hits Of The Year 2014;Afrojack Ft. D-Wayne & Jack McManus - Radio 538 Dance Smash Hits Of The Year 2014 (cd01) - 07 - Freedom.mp3;Afrojack Ft. D-Wayne & Jack McManus;Afrojack Ft. D-Wayne & Jack McManus;Radio 538 Dance Smash Hits Of The Year 2014;Freedom;2014;Pop;;1;07;;;;
N:\download\Music\various\Radio 538 Dance Smash Hits Of The Year 2014;Afrojack Ft. Snoop Dogg - Radio 538 Dance Smash Hits Of The Year 2014 (cd02) - 17 - Dynamite.mp3;Afrojack Ft. Snoop Dogg;Afrojack Ft. Snoop Dogg;Radio 538 Dance Smash Hits Of The Year 2014;Dynamite;2014;Pop;;2;17;;;;
N:\download\Music\various\Radio 538 Dance Smash Hits Of The Year 2014;Afrojack Ft. Thirty Seconds To Mars - Radio 538 Dance Smash Hits Of The Year 2014 (cd02) - 10 - Do Or Die.mp3;Afrojack Ft. Thirty Seconds To Mars;Afrojack Ft. Thirty Seconds To Mars;Radio 538 Dance Smash Hits Of The Year 2014;Do Or Die;2014;Pop;;2;10;;;;
N:\download\Music\various\Jaarmix 2014\DSR - Yearmix 2014;Aimoon - DSR Yearmix 2014 - 11 - Summer.mp3;Aimoon;Aimoon;DSR Yearmix 2014;Summer;2014;Pop;;1;11;;;;
N:\download\Music\various\Jaarmix 2014\DSR - Yearmix 2014;Alex Ft. Petar - DSR Yearmix 2014 - 08 - Momentum.mp3;Alex Ft. Petar;Alex Ft. Petar;DSR Yearmix 2014;Momentum;2014;Pop;;1;08;;;;
N:\download\Music\various\Top 100 2014;Ariana Grande Ft. The Weeknd - Top 100 2014 - 1123 - Love Me Harder.mp3;Ariana Grande Ft. The Weeknd;Ariana Grande Ft. The Weeknd;Top 100 2014;Love Me Harder;2014;Pop;;1;1123;;;;
N:\download\Music\various\Radio 538 Dance Smash Hits Of The Year 2014;Ariana Grande Ft. Zedd - Radio 538 Dance Smash Hits Of The Year 2014 (cd01) - 10 - Break Free.mp3;Ariana Grande Ft. Zedd;Ariana Grande Ft. Zedd;Radio 538 Dance Smash Hits Of The Year 2014;Break Free;2014;Pop;;1;10;;;;
N:\download\Music\various\Radio 538 Dance Smash Hits Of The Year 2014;Armin van Buuren - Radio 538 Dance Smash Hits Of The Year 2014 (cd01) - 12 - Save My Night.mp3;Armin van Buuren;Armin van Buuren;Radio 538 Dance Smash Hits Of The Year 2014;Save My Night;2014;Pop;;1;12;;;;
What does the extended tags dialogue say which field you have stored? Use that name. It could be that you still have to good ole POPULARIMETER as field.
Well, one or two lines would have been sufficient to demonstrate the result.
Your CSV result data let assume, that there are no "RATING XXX" tag-fields, which contain some value.
You can check for and display existing values in the Mp3tag listview by setting up a column.
Column Name: PopMeter
Value: $if(%RATING WINAMP%,$repeat('#',%RATING WINAMP%),$if(%RATING WMP%,$repeat('*',%RATING WMP%),$if(%RATING MM%,$repeat('+',%RATING MM%),$repeat('=',$if2($ifgreater($regexp(%POPULARIMETER%,'^.+|(\d{1,3})|\d+','$1'),196,5,$ifgreater($regexp(%POPULARIMETER%,'^.+|(\d{1,3})|\d+','$1'),128,4,$ifgreater($regexp(%POPULARIMETER%,'^.+|(\d{1,3})|\d+','$1'),64,3,$ifgreater($regexp(%POPULARIMETER%,'^.+|(\d{1,2})|\d+','$1'),1,2,$ifgreater($regexp(%POPULARIMETER%,'^.+|(\d)|\d+','$1'),0,1,))))),0)))))
Sort by: $left($replace($if2(%RATING WINAMP%,$if2(%RATING WMP%,$if2(%RATING MM%,$if2($ifgreater($regexp(%POPULARIMETER%,'^.+|(\d{1,3})|\d+','$1'),196,5,$ifgreater($regexp(%POPULARIMETER%,'^.+|(\d{1,3})|\d+','$1'),128,4,$ifgreater($regexp(%POPULARIMETER%,'^.+|(\d{1,3})|\d+','$1'),64,3,$ifgreater($regexp(%POPULARIMETER%,'^.+|(\d{1,2})|\d+','$1'),1,2,$ifgreater($regexp(%POPULARIMETER%,'^.+|(\d)|\d+','$1'),0,1,))))),0)))),'.',)'0',2)
Numerical: no
... or simple values ...
Column Name: Rating
Value: $if2(%RATING WINAMP%,$if2(%RATING WMP%,$if2(%RATING MM%,$if2($ifgreater($regexp(%POPULARIMETER%,'^.+|(\d{1,3})|\d+','$1'),196,5,$ifgreater($regexp(%POPULARIMETER%,'^.+|(\d{1,3})|\d+','$1'),128,4,$ifgreater($regexp(%POPULARIMETER%,'^.+|(\d{1,3})|\d+','$1'),64,3,$ifgreater($regexp(%POPULARIMETER%,'^.+|(\d{1,2})|\d+','$1'),1,2,$ifgreater($regexp(%POPULARIMETER%,'^.+|(\d)|\d+','$1'),0,1,))))),))))
Sort by: $left($replace($if2(%RATING WINAMP%,$if2(%RATING WMP%,$if2(%RATING MM%,$if2($ifgreater($regexp(%POPULARIMETER%,'^.+|(\d{1,3})|\d+','$1'),196,5,$ifgreater($regexp(%POPULARIMETER%,'^.+|(\d{1,3})|\d+','$1'),128,4,$ifgreater($regexp(%POPULARIMETER%,'^.+|(\d{1,3})|\d+','$1'),64,3,$ifgreater($regexp(%POPULARIMETER%,'^.+|(\d{1,2})|\d+','$1'),1,2,$ifgreater($regexp(%POPULARIMETER%,'^.+|(\d)|\d+','$1'),0,1,))))),0)))),'.',)'0',2)
Numerical: no
... or create one column for each rating tag-field.
DD.20150107.1737.CET