Advanced Report 6.4 - Updated 24/06/2014

Download and get help for different MediaMonkey 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 » Wed Mar 13, 2013 12:40 pm

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

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

Post by Lowlander » Wed Mar 13, 2013 12:42 pm

Did you check File > Create Reports?
Lowlander (MediaMonkey user since 2003)

reecemj
Posts: 13
Joined: Fri Jan 04, 2008 11:11 pm

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

Post by reecemj » Wed Mar 13, 2013 3:55 pm

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 » Wed Mar 13, 2013 4:24 pm

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: Barton, UK
Contact:

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

Post by trixmoto » Wed Mar 13, 2013 5:12 pm

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.
Send me BTC: 34VQPVsf9mCeR4nfhFvvBYZqQ7LkqNZ8Mn
Send me LTC: 3P1mzrfbyscdhbxRpXLgKz7tufGAU3SrEG
Send me DOGE: 9xPpYSqgF7P5yQiqvE1VqWb4UjxVCCLFJ6
Check out these great cryptocurrency faucets... BTC / LTC / DOGE

FEB
Posts: 81
Joined: Sat Mar 01, 2008 6:57 pm

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

Post by FEB » Sat Apr 20, 2013 10:08 am

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: Barton, UK
Contact:

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

Post by trixmoto » Sat Apr 27, 2013 2:05 pm

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.
Send me BTC: 34VQPVsf9mCeR4nfhFvvBYZqQ7LkqNZ8Mn
Send me LTC: 3P1mzrfbyscdhbxRpXLgKz7tufGAU3SrEG
Send me DOGE: 9xPpYSqgF7P5yQiqvE1VqWb4UjxVCCLFJ6
Check out these great cryptocurrency faucets... BTC / LTC / DOGE

FEB
Posts: 81
Joined: Sat Mar 01, 2008 6:57 pm

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

Post by FEB » Thu May 02, 2013 2:29 pm

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: Barton, UK
Contact:

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

Post by trixmoto » Fri May 03, 2013 3:02 am

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.
Send me BTC: 34VQPVsf9mCeR4nfhFvvBYZqQ7LkqNZ8Mn
Send me LTC: 3P1mzrfbyscdhbxRpXLgKz7tufGAU3SrEG
Send me DOGE: 9xPpYSqgF7P5yQiqvE1VqWb4UjxVCCLFJ6
Check out these great cryptocurrency faucets... BTC / LTC / DOGE

DJMattB241
Posts: 22
Joined: Thu Feb 23, 2006 11:09 am

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

Post by DJMattB241 » Wed May 08, 2013 6:25 pm

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: Barton, UK
Contact:

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

Post by trixmoto » Thu May 09, 2013 2:13 am

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.
Send me BTC: 34VQPVsf9mCeR4nfhFvvBYZqQ7LkqNZ8Mn
Send me LTC: 3P1mzrfbyscdhbxRpXLgKz7tufGAU3SrEG
Send me DOGE: 9xPpYSqgF7P5yQiqvE1VqWb4UjxVCCLFJ6
Check out these great cryptocurrency faucets... BTC / LTC / DOGE

DJMattB241
Posts: 22
Joined: Thu Feb 23, 2006 11:09 am

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

Post by DJMattB241 » Thu May 09, 2013 4:36 pm

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

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

Post by Lowlander » Thu May 09, 2013 4:54 pm

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
Lowlander (MediaMonkey user since 2003)

DJMattB241
Posts: 22
Joined: Thu Feb 23, 2006 11:09 am

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

Post by DJMattB241 » Thu May 09, 2013 5:00 pm

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

FEB
Posts: 81
Joined: Sat Mar 01, 2008 6:57 pm

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

Post by FEB » Tue May 21, 2013 3:59 pm

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