I answered my own question - yes!
Edit-
One thing, the date is in DDMMYYYY format and here in the US most use MMDDYYYY format. To remedy this, when converting from text to columns in excel, I can format the date column in the text to columns dialogue box to make the change during the conversion.

Thanks

Edit:
On Line 561
fulldate = theday&"/"&themonth&"/"&theyear

I tired fulldate = theyear&"/"&themonth&"/"&theday to get the yyyymmdd format. Did not work for some reason.

[quote="trixmoto"]New version (2.1) is now available to download from my website. Changes include...

- Fixed problems with year in FullDate mask field
- Added last track mask input[/quote]

For the Fulldate mask field change, will one be able to show the full date like 12/05/2013 instead of just 2013 in the output?

I have my output "artist - album title - year" presently, but would like "artist - album title - date". I just wanted to ask before I undo my current settings by upgrading.

I had asked about this a some posts back, see below.
Thanks

-----------------------------------

Re: Just List Albums 1.8 - Updated 27/02/2011

Postby SDJeff » Tue Sep 04, 2012 1:22 pm
I modified the mask for reports a while back to <artist>%<year>%<album> (I use % for when I separate fields to columns in Text to Columns).

When I tag my flac files, I use the release date mm/dd/yyyy when possible. I would like to create a report using the date. I tried <date> and it only returned the year.

Any suggestions?

SDJeff
>
Re: Just List Albums 1.8 - Updated 27/02/2011

Postby trixmoto » Wed Sep 05, 2012 5:28 am
This script only extracts the year at the moment, sorry.

That's one 'hack,' but if you know what you're doing then you can 'add' it yourself. I remember adding Custom 1 in the previous version, as well as an option for the rating decimal limit... though I haven't dove into the new version to make (personally) necessary modifications yet.

I find a solution, I replace the SQL statement for the comment with
sql = "SELECT Custom1 FROM Songs WHERE IDAlbum="&itmID
:D

Thanks for your information.
Thats bad, so your script is not so usefull for me.
Because an album list without the CD index information dont help me.

Custom 1 is a track level field, so it's not valid in the album mask.

I try it on the album mask (just list albums 2.1) on MM4.07.
The script is working with other fields, genre a.s.o, but not with "Custom 1".
I try different writings like Custom1 also. All the same.
I use the custom 1 for a backup-cd index.

Are you trying to use it in one of the album masks, or one of the track masks?

It working fine, but I can not use the <Customer 1> field.
<Custom 1>;<Album>;<Artist> result f.e in <Custom 1>;Clapton;Eric Clapton

Any helpfull information to use this field?

Thanks

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

- Fixed problems with year in FullDate mask field
- Added last track mask input

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

- Added unicode support (outputs in UTF-8)
- Added Delimiter option for genre mask field
- Added additional 34 fields to TrackMask
- Added additional 6 fields to AlbumMask
- Added graphical interface for settings

[quote="trixmoto"]Sorry, what I implied but realised I haven't made clear is that the script processes the current tracks in order, therefore if you sort the tracks by artist then album before you run the script, the output should be in the same order.[/quote]
Thanks for that ... I had thought I tried that but guess I didn't. Not having tried vbs against MM, one more thing on my plate may just break it :) ) I am wondering ... Couldn't this simply go against the DB? Like I said I haven't had any time to play with scripting with MM so am probably talking/asking out of ignorance. Users HUH :)

It seems to me that is more a list of Artists and associated albums. Is there a way to modify the script to find unique albums and then list artists?

Also, in the screen shot below, notice that about half way down, in the "Alison Krauss" section there i " - Lightning in a Bottle (27/27)". Is this because you are showing 'Album Artist(s)' and not 'Artists'?

Thanks again for the quick replies ...

[img]http://img715.imageshack.us/img715/3551/18705507.jpg[/img]

[quote="mjkassoc"]I am producing great reports with this add-on. Thanks so much. There is one minor glitch that maybe someone can help with. My genre field in MM looks like this: W.Coast; Combo; Jazz

Just List Albums produces: Combo, Jazz, W.Coast in one column.

Semi-colons are replaced with commas, which is OK. Genres are rearranged alphabetically, which is not helpful.[/quote]

The reason for this is that there is no album genre field, therefore I have to query the database to find all genres that are associated with the album, therefore there is no order. I understand that what you probably mean is that the genre in all of the tracks in the album is the same, and I could check for this first, but it would be rather inefficient. Is it really worth preserving the order that much?

Sorry, what I implied but realised I haven't made clear is that the script processes the current tracks in order, therefore if you sort the tracks by artist then album before you run the script, the output should be in the same order.

I've moved this into the addons section, as you're talking about my "JustListAlbums" script, but it probably would have been better in the thread of the script itself.

I'll try not to get hung up on the "kind of useless" comment :) The way the script works is by looping through all of the tracks in the list and then outputting the album information for each one, checking for duplicate albums along the way so that each album is only listed once. It used to use the internal method for extracting all the albums from the track list, but this doesn't work anymore. But it's due to this method that sorting is rather tricky, and would certainly be horrendous performance-wise.

My "CustomReport" script is a track based script, and therefore cannot be used to report on albums.