export a list of all complete albums

Support
1

hi there,
i have a very huge mp3 collection. all complete albums have got a tag called COMPLETE_ALBUM=1 All incomplete have set this to 0 or don't have the tag at all.
How can i now create a list with all complete albums in the following form:

artist1

- album1
- album2
- album3

artist2

- album1

artist3

- album1
- album2

.....

2

Apply a filter with
%COMPLETE_ALBUM% IS 1

Create a report with:

$filename(csv,utf-16)$loop(%artist%)%artist%
$loop(%album%)- %album%
$loopend()$loopend()
3

01: $filename($getEnv('USERPROFILE')'\Desktop\Mp3tag.Report.txt',UTF-8)
02: $loop($if2(%ALBUMARTIST%,%ARTIST%),1)$if2(%ALBUMARTIST%,%ARTIST%)
03: $loop(%ALBUM%,1)$ifgreater(%COMPLETE_ALBUM%,0,' '%ALBUM%,)
04: $loopend()$loopend()

DD.20140831.2002.CEST

4
QUOTE (ohrenkino @ Aug 31 2014, 19:51) <{POST_SNAPBACK}>
Apply a filter with

%COMPLETE_ALBUM% IS 1

Create a report with:

$filename(csv,utf-16)$loop(%artist%)%artist%
$loop(%album%)- %album%
$loopend()$loopend()<!--QuoteEnd--></div><!--QuoteEEnd-->

this does unfortunately create a list that gives for every song of a album an album entry with the album name. i only want to see the album once per artist

but thx

5

So, modify the code then to...

$filename(csv,utf-16)$loop(%artist%,1)%artist%
$loop(%album%,1)- %album%
$loopend()$loopend()
6

this does also not work, i geht mostly a correct list, but lots of entries at the end and the very first entry have wrong artist names
if i dont use the filter first i get almost an empty list

7

Note: The output result depends on the input data ... and on the export script, of course!

External filtering not needed.

$filename($getEnv('USERPROFILE')'\Desktop\Mp3tag.Report.txt',UTF-8)$loop(%ARTIST%,1)$ifgreater(%COMPLETE_ALBUM%,0,%ARTIST%$char(13)$char(10),)$loop(%ALBUM%,1)$ifgreater(%COMPLETE_ALBUM%,0,' '%ALBUM%$char(13)$char(10),)$loopend()$loopend()

Note: This is a one line script.

Output example:

Beatles Album A Album B Album C Depeche Mode Any Album Some Artist Some Album

This export script delivers the same output ...

01: $filename($getEnv('USERPROFILE')'\Desktop\Mp3tag.Report.txt',UTF-8)$puts(

02: )$loop(1,1)$puts(crlf,$char(13)$char(10))$puts(br,'{br}')$loopend()$replace(
03:
04: $loop(%ARTIST%,1)$replace(
05: $ifgreater(%COMPLETE_ALBUM%,0,%ARTIST%$get(br),)
06:
07: $loop(%ALBUM%,1)$replace(
08: $ifgreater(%COMPLETE_ALBUM%,0,' '%ALBUM%$get(br),)
09:
10: ,$get(crlf),,$get(br),$get(crlf))$loopend()
11: ,$get(crlf),,$get(br),$get(crlf))$loopend()
12: ,$get(crlf),,$get(br),$get(crlf))

DD.20140831.2130.CEST, DD.20150305.1035.CET

8
QUOTE (ohrenkino @ Aug 31 2014, 20:31) <{POST_SNAPBACK}>
So, modify the code then to... 
$filename(csv,utf-16)$loop(%artist%,1)%artist%
$loop(%album%,1)- %album%
$loopend()$loopend()<!--QuoteEnd--></div><!--QuoteEEnd-->

perfect that works exactly as i want .... THX alot.

thread closed

9

sorry, thread opened again,

this does unfortunately not work if i have a huge collection with e.g. 100 thousand mp3 files:
the list is a bit mixed, not alphabetically through the whole file.

partly it is sorted alphabetically, but then it begins with 'a' agan. this repeats a lot of times.

what can cause that?

i correct myself, becasue with the same export again it works well, i dont know what happend in the first place. it seems that the correct list was exported the first time thousands of times and was mixed ...... 4mb large file instead of only 350kb

ok, thread closed again