Just List Albums 2.1 - Updated 17/03/2013

[dubmassacre]

Thanks for this great script. How could I add album's 'Comment' field below the 'Artist - Album name' line?
thanks

[trixmoto]

Well the mask would need to be something like...

Code: Select all

Dim Mask : Mask = "<Artist> - <Album> (<Tot>/<Max>)"&Chr(13)&"<Comment>"

Around line 101 you'd need to do an SQL statement to get the comment and put it in variable "comm". Finally around line 112 you'd need to add the line...

Code: Select all

str = Replace(str,"<Comment>",SDB.toAscii(comm))

[dubmassacre]

Thank you for the reply.

Since I'm no coder I can't figure out how to execute the SQL query. I opened the MM database and I managed to spot that by saying 'comment' I meant the MemoText field of Memos table. The script query is based on IDAlbum, so I assume that I have to use Memos' IdSong field to get the MemoText values. I 'improvised' a little bit with SQL and script code. No success. I'm afraid it's too difficult for me. Is it something like this?

Code: Select all

SELECT MemoText AS comm FROM Memos WHERE IDSong=...

I use 1.2 script version and MM is 2.5.5.998. Thank you again.

[trixmoto]

I've not got an MM2 database here to check but I'm pretty sure the album level comments are on the albums table, so something like...

Code: Select all

SELECT Comment FROM Albums WHERE IDAlbum = "&itm.Album.ID

I assume it was this comment you wanted? If you wanted track comments then are you just taking the first track from the album, or appending them all together, or what?

[dubmassacre]

I was wrong about the 'album comment'. I realized that I want the track comment and not the album comment but I don't have the skills to add a single line in your script. If you have time I'd appreciate to post a 'how-to'.
thank you.

[trixmoto]

Which track comment do you want, the comment of every track on a new line or just the comment of the first track of the album at the beginning?

[hans123]

I have downloaded today the latest version of this script. In support of previous posts: The Compilation processing in the script is not fully working. I would expect each <Artist> to show up in the list, but only the first one (in the alphabet, e.g. Albert King in a Chess compilation) shows up, the next one (e.g. Bo Diddley) does not.
I have marked each song entry for compilation albums in their properties with 'various' for <Album Artist> and have changed your script to Dim TrackMask : TrackMask = "" to skip the Track Titles.

Thanks.

[dubmassacre]

Which track comment do you want, the comment of every track on a new line or just the comment of the first track of the album at the beginning?

the comment of the first track of the album.

[trixmoto]

@hans123 - yes I'm aware of this bug and it will be fixed in the next version.

@dubmassacre - I'll see what I can do!

[MonkeyBone]

Hello!

Could someone help me, please?


I would really like for the output to be like this;


"AlbumList" (<total_of_albums>)
Artist1 - Album1
Artist1 - Album2
Artist2 - Album1
Artist3 - Album1
Artist3 - Album2
Artist3 - Album3
Artist3 - Album4
..and so on..


Thanks in advance!

And Thanks for all the effort and for a great script!

[trixmoto]

On line 55 (after the progress bar but before the for loop) add something like this...

Code: Select all

Dim dit : Set dit = SDB.Database.OpenSQL("SELECT Count(*) FROM Albums WHERE Album != ''")
fout.WriteLine """AlbumList"" ("&dit.StringByIndex(0)&")"

[sommo]

thanks for this!
Is there anything you cant do!?

[trixmoto]

Almost certainly, but if I find something I resort to Google!

[trixmoto]

New version (1.4) is now available to download from my website. Changes include...

- Fixed <Artist> in Mask and CompMask not referencing album artist
- Added FirstMask for the first track in an album
- Added <Comment> to TrackMask and FirstMask

If you leave "FirstMask" blank then the "TrackMask" will always be used.

[nynaevelan]

New version (1.4) is now available to download from my website. Changes include...

- Fixed <Artist> in Mask and CompMask not referencing album artist
- Added FirstMask for the first track in an album
- Added <Comment> to TrackMask and FirstMask

If you leave "FirstMask" blank then the "TrackMask" will always be used.

Trixmoto:

We are in business, thank you. Now I have the fun task of reviewing them to make sure I do not have duplicates when I shouldn't.

Nyn