I don't think it's visible within the program, but it is accessible through the API, or querying the database. There's a Debug Helper script which gives you access to this level of information in context menus. You may be able to use the RegExp script to copy the details into a custom field, but I'm not sure.

Trix, you mention that the cover created is named after 'AlbumID'. Where, in MM, can I find that info and is it possible to automatically populate one of the custom fields in the GUI with that albumID?

Curses. Looked high and low and went right past that. Thank you!

From the first post you should be able to add:

Code: Select all

[AdvancedReport]
FileName=AdvancedReport.vbs
ProcName=AdvancedReport
Order=22
DisplayName=Advanced Report
Description=Advanced Report
Language=VBScript
ScriptType=1

The Scripts.ini doesn't have an entry for AdvancedReport at all (which explains why it's not showing up).

Not sure what to put in the ini file to make it show up.

The AdvancedReport vbs file is in the scripts folder though so... that's something I guess?

You could try manually editing the Scripts.ini file - sounds like you might have multiple copies.

It's possible I'm an idiot, or finally feeling the effects of this cold medication, but I can't seem to get this script working.

Downloaded the .mmip file, ran it, it said "success" restarted MM, and the File->Create Reports menu is exactly the same as before. I'm not sure how to get to the Advanced Report menu.

Thanks, and again, sorry if this is super obvious. :\

Ok, thanks. I'll take a look when I get a chance.

Hmm, I had a huge reply typed out but it didn't save.

I re-ran the report (with Unicode checked, everything else was default, apart from ignoring prefixes) and got the same error.

: unrecognised token: "THEN Substr(UpperW(Artists.Artist),5) ELSE UpperW(Artists.Artist)END" (1,1) and then I get a -21 error on line 1765, Column 4.


By the way, I thanked you on my music database site - without you, it would have been a lot harder to do!

http://febswebs.herobo.com/index.php

I'll take a look and see if I can replicate. In case I can't, can you be more specific about the error message?

The function "GetAlbumArt" is used to create all of the images - this uses the AlbumID as the filename, but you could easily change it to something else if you wanted to.

Trix, there is a problem with my install of 6.3, running on MM3.

The script falls over when running it when I select the 'ignore prefixes' checkbox. There's a SQL error and a 'catastrophic failure' pointing to that particular statement.
I restarted MM and the problem remains.
Running the script without that checkbox ticked works fine.
Just thought you'd like to know.

Second question: What's the process behind naming the album images? I'd like to take the images the script creates and put them online on my website, but locating them by name's a bit of a struggle! Could you tell me which line to edit to instead save the image name by its album title?

You need to double click the installer to start the install. The script will then appear in File > Create Report.

I guess I assumed it wasn't working as it should, and I was wrong. I'm glad you figured it out.

Thanks Mr. Flying Lowlander! Its working now!

Did you check File > Create Reports?