Advanced Report 6.4 - Updated 24/06/2014

Download and get help for different MediaMonkey for Windows 4 Addons.

Moderators: Peke, Gurus

gpzbc
Posts: 1226
Joined: Sat Sep 13, 2008 12:02 am
Location: Colorado, USA

Re: Advanced Report 6.3 - Updated 23/10/2012

Post by gpzbc »

reecemj wrote:How do I add this script to MM? I put installer in MM script folder and hit install but nothing shows up in the scripts in MM. Could someone give me step by step instructions.

Thanks Reece :wink:
This should help you figure it out. Let us know if you need any more help.
http://www.mediamonkey.com/forum/viewto ... ll#p338606

Good luck!

Oh, and the "Search this topic" box is very handy in this forum. I just typed "install" into that box and found the post I provided.
--
The gpzbc
Lowlander
Posts: 56465
Joined: Sat Sep 06, 2003 5:53 pm
Location: MediaMonkey 5

Re: Advanced Report 6.3 - Updated 23/10/2012

Post by Lowlander »

Did you check File > Create Reports?
reecemj
Posts: 13
Joined: Fri Jan 04, 2008 11:11 pm

Re: Advanced Report 6.3 - Updated 23/10/2012

Post by reecemj »

Thanks Mr. Flying Lowlander! Its working now! :)
gpzbc
Posts: 1226
Joined: Sat Sep 13, 2008 12:02 am
Location: Colorado, USA

Re: Advanced Report 6.3 - Updated 23/10/2012

Post by gpzbc »

I guess I assumed it wasn't working as it should, and I was wrong. I'm glad you figured it out.
:D
--
The gpzbc
trixmoto
Posts: 10024
Joined: Fri Aug 26, 2005 3:28 am
Location: Hull, UK
Contact:

Re: Advanced Report 6.3 - Updated 23/10/2012

Post by trixmoto »

You need to double click the installer to start the install. The script will then appear in File > Create Report.
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.
FEB
Posts: 83
Joined: Sat Mar 01, 2008 6:57 pm

Re: Advanced Report 6.3 - Updated 23/10/2012

Post by FEB »

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?
trixmoto
Posts: 10024
Joined: Fri Aug 26, 2005 3:28 am
Location: Hull, UK
Contact:

Re: Advanced Report 6.3 - Updated 23/10/2012

Post by trixmoto »

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.
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.
FEB
Posts: 83
Joined: Sat Mar 01, 2008 6:57 pm

Re: Advanced Report 6.3 - Updated 23/10/2012

Post by FEB »

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
trixmoto
Posts: 10024
Joined: Fri Aug 26, 2005 3:28 am
Location: Hull, UK
Contact:

Re: Advanced Report 6.3 - Updated 23/10/2012

Post by trixmoto »

Ok, thanks. I'll take a look when I get a chance.
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.
DJMattB241
Posts: 22
Joined: Thu Feb 23, 2006 11:09 am

Re: Advanced Report 6.3 - Updated 23/10/2012

Post by DJMattB241 »

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. :\
trixmoto
Posts: 10024
Joined: Fri Aug 26, 2005 3:28 am
Location: Hull, UK
Contact:

Re: Advanced Report 6.3 - Updated 23/10/2012

Post by trixmoto »

You could try manually editing the Scripts.ini file - sounds like you might have multiple copies.
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.
DJMattB241
Posts: 22
Joined: Thu Feb 23, 2006 11:09 am

Re: Advanced Report 6.3 - Updated 23/10/2012

Post by DJMattB241 »

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?
Lowlander
Posts: 56465
Joined: Sat Sep 06, 2003 5:53 pm
Location: MediaMonkey 5

Re: Advanced Report 6.3 - Updated 23/10/2012

Post by Lowlander »

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
DJMattB241
Posts: 22
Joined: Thu Feb 23, 2006 11:09 am

Re: Advanced Report 6.3 - Updated 23/10/2012

Post by DJMattB241 »

Curses. Looked high and low and went right past that. Thank you!
FEB
Posts: 83
Joined: Sat Mar 01, 2008 6:57 pm

Re: Advanced Report 6.3 - Updated 23/10/2012

Post by FEB »

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?
Post Reply