Just List Albums 2.1 - Updated 17/03/2013

dubmassacre · Post by **dubmassacre** » Sun Mar 30, 2008 3:37 pm

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

trixmoto · Post by **trixmoto** » Sun Mar 30, 2008 4:02 pm

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

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 · Post by **dubmassacre** » Mon Mar 31, 2008 4:21 pm

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 · Post by **trixmoto** » Tue Apr 01, 2008 3:12 am

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 · Post by **dubmassacre** » Fri Apr 04, 2008 6:14 pm

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 · Post by **trixmoto** » Sat Apr 05, 2008 3:01 am

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 · Post by **hans123** » Sat Apr 05, 2008 9:55 am

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 · Post by **dubmassacre** » Sat Apr 05, 2008 10:04 am

trixmoto wrote: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 · Post by **trixmoto** » Sat Apr 05, 2008 10:36 am

@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 · Post by **MonkeyBone** » Mon Apr 07, 2008 6:06 pm

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 · Post by **trixmoto** » Tue Apr 08, 2008 3:19 am

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 · Post by **sommo** » Tue Apr 15, 2008 10:44 am

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

trixmoto · Post by **trixmoto** » Tue Apr 15, 2008 10:48 am

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

trixmoto · Post by **trixmoto** » Sun Apr 27, 2008 5:25 pm

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 · Post by **nynaevelan** » Sun Apr 27, 2008 5:44 pm

trixmoto wrote: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