Page 47 of 51

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

Posted: Wed Mar 13, 2013 12:40 pm
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.

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

Posted: Wed Mar 13, 2013 12:42 pm
by Lowlander
Did you check File > Create Reports?

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

Posted: Wed Mar 13, 2013 3:55 pm
by reecemj
Thanks Mr. Flying Lowlander! Its working now! :)

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

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

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

Posted: Wed Mar 13, 2013 5:12 pm
by trixmoto
You need to double click the installer to start the install. The script will then appear in File > Create Report.

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

Posted: Sat Apr 20, 2013 10:08 am
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?

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

Posted: Sat Apr 27, 2013 2:05 pm
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.

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

Posted: Thu May 02, 2013 2:29 pm
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

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

Posted: Fri May 03, 2013 3:02 am
by trixmoto
Ok, thanks. I'll take a look when I get a chance.

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

Posted: Wed May 08, 2013 6:25 pm
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. :\

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

Posted: Thu May 09, 2013 2:13 am
by trixmoto
You could try manually editing the Scripts.ini file - sounds like you might have multiple copies.

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

Posted: Thu May 09, 2013 4:36 pm
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?

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

Posted: Thu May 09, 2013 4:54 pm
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

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

Posted: Thu May 09, 2013 5:00 pm
by DJMattB241
Curses. Looked high and low and went right past that. Thank you!

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

Posted: Tue May 21, 2013 3:59 pm
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?