Just List Albums 2.1 - Updated 17/03/2013
-
- Posts: 13
- Joined: Sat Apr 22, 2006 4:48 am
Well the mask would need to be something like...
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
Dim Mask : Mask = "<Artist> - <Album> (<Tot>/<Max>)"&Chr(13)&"<Comment>"
Code: Select all
str = Replace(str,"<Comment>",SDB.toAscii(comm))
Download my scripts at my own MediaMonkey fansite.
All the code for my website and scripts is safely backed up immediately and for free using Dropbox.
All the code for my website and scripts is safely backed up immediately and for free using Dropbox.
-
- Posts: 13
- Joined: Sat Apr 22, 2006 4:48 am
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?
I use 1.2 script version and MM is 2.5.5.998. Thank you again.
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'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...
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?
Code: Select all
SELECT Comment FROM Albums WHERE IDAlbum = "&itm.Album.ID
Download my scripts at my own MediaMonkey fansite.
All the code for my website and scripts is safely backed up immediately and for free using Dropbox.
All the code for my website and scripts is safely backed up immediately and for free using Dropbox.
-
- Posts: 13
- Joined: Sat Apr 22, 2006 4:48 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?
Download my scripts at my own MediaMonkey fansite.
All the code for my website and scripts is safely backed up immediately and for free using Dropbox.
All the code for my website and scripts is safely backed up immediately and for free using Dropbox.
Compilation
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.
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.
-
- Posts: 13
- Joined: Sat Apr 22, 2006 4:48 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!
@dubmassacre - I'll see what I can do!
Download my scripts at my own MediaMonkey fansite.
All the code for my website and scripts is safely backed up immediately and for free using Dropbox.
All the code for my website and scripts is safely backed up immediately and for free using Dropbox.
-
- Posts: 66
- Joined: Sun Nov 19, 2006 9:39 am
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!
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!
[AMD Athlon 64 FX-60] . [Hiper Type-R 580W] . [Western Digital Raptor X] . [Lian Li PC777B]
[Hightech Excalibur Radeon x1900xtx 512 MB] . [OCZ EB DDR PC-4000 2 GB Pl.Ed. Dual Channel]
[DFI Lanparty UT RDX200 CF-DR] . [Creative SB X-Fi Fatal1ty FPS] . [DELL UltrasSharp 2405 FPW 24"]
3DMark05 : 11043 . 3DMark06 : 5856 . (a non-clocked system) . AudioScrobbler . Xfire . YMDb
[Hightech Excalibur Radeon x1900xtx 512 MB] . [OCZ EB DDR PC-4000 2 GB Pl.Ed. Dual Channel]
[DFI Lanparty UT RDX200 CF-DR] . [Creative SB X-Fi Fatal1ty FPS] . [DELL UltrasSharp 2405 FPW 24"]
3DMark05 : 11043 . 3DMark06 : 5856 . (a non-clocked system) . AudioScrobbler . Xfire . YMDb
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)&")"
Download my scripts at my own MediaMonkey fansite.
All the code for my website and scripts is safely backed up immediately and for free using Dropbox.
All the code for my website and scripts is safely backed up immediately and for free using Dropbox.
Almost certainly, but if I find something I resort to Google!
Download my scripts at my own MediaMonkey fansite.
All the code for my website and scripts is safely backed up immediately and for free using Dropbox.
All the code for my website and scripts is safely backed up immediately and for free using Dropbox.
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.
- 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.
Download my scripts at my own MediaMonkey fansite.
All the code for my website and scripts is safely backed up immediately and for free using Dropbox.
All the code for my website and scripts is safely backed up immediately and for free using Dropbox.
-
- Posts: 5559
- Joined: Wed Feb 07, 2007 11:07 pm
- Location: New Jersey, USA
- Contact:
Trixmoto: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.
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
3.2x - Win7 Ultimate (Zen Touch 2 16 GB/Zen 8GB)
Link to Favorite Scripts/Skins
Join Dropbox, the online site to share your files
Link to Favorite Scripts/Skins
Join Dropbox, the online site to share your files