Custom Report 3.2 - Updated 29/07/2014

Download and get help for different MediaMonkey Addons.

Moderators: Peke, Gurus

NWDreamer
Posts: 103
Joined: Fri Aug 24, 2012 4:12 am

Re: Custom Report 3.0 - Updated 16/03/2013

Post by NWDreamer » Thu Jul 04, 2013 12:47 pm

Discovered Notepad++ (not sure why the script didn't come up in my Visual Studio 2008, maybe because I have it set for C#?).

Anyway, here's the function that had the error. The actual line is the Set DoCreateFile = fso.CreateTextFile(loc,True,utf) under the Else. I was only trying to create the file on my desktop...

Code: Select all

Function DoCreateFile(fso,loc,utf)
  If utf = 2 Then
    Set DoCreateFile = CreateObject("Adodb.Stream")
    DoCreateFile.CharSet = "UTF-8"
    DoCreateFile.Type = 2
    Call DoCreateFile.Open() 
  Else        
    Set DoCreateFile = fso.CreateTextFile(loc,True,utf)
  End If
End Function
Craig B. (a.k.a., NW Dreamer - Gold MediaMonkey user.)

NWDreamer
Posts: 103
Joined: Fri Aug 24, 2012 4:12 am

Re: Custom Report 3.0 - Updated 16/03/2013

Post by NWDreamer » Thu Jul 04, 2013 1:00 pm

Didn't have any brain power at 2am to try anything but, today, I changed the path to simply be e:\test.csv (E is the drive with my portable MM installation on it) and it worked. Not sure about the other issue, but at least I'm able to continue doing what I need to for now.

Interestingly, before trying the above, I brought up the Custom Report, hit "Save" and then specified to put the .dat file on my desktop. Then I got this error from the same line in the script:

Code: Select all

Error #76 - Microsoft VBScript runtime error
Path not found
File: "E:\MediaMonkey\Scripts\CustomReport.vbs", Line: 3187, Column: 4
Not sure if that helps or not! Oh well, at least I can continue work.
Craig B. (a.k.a., NW Dreamer - Gold MediaMonkey user.)

trixmoto
Posts: 10024
Joined: Fri Aug 26, 2005 3:28 am
Location: Hull, UK
Contact:

Re: Custom Report 3.0 - Updated 16/03/2013

Post by trixmoto » Fri Jul 05, 2013 5:12 am

I think it means that whatever location you were trying to write to before was blocked. You could try running MM as administrator, if you weren't already. It's a file permissions issue though, not something I can do anything about in the script.
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.

NWDreamer
Posts: 103
Joined: Fri Aug 24, 2012 4:12 am

Re: Custom Report 3.0 - Updated 16/03/2013

Post by NWDreamer » Fri Jul 05, 2013 7:59 am

Ok, thanks. It just seems like I should be able to write to the desktop... I was thinking it might have something to do with all those blocked folders that Windows 7 creates just to be backward compatible. But, as long as I can get the reports to write SOMEWHERE, I'm good! :wink:
Craig B. (a.k.a., NW Dreamer - Gold MediaMonkey user.)

IAN D
Posts: 3
Joined: Sun Aug 25, 2013 10:51 pm

Re: Custom Report 3.0 - Updated 16/03/2013

Post by IAN D » Sun Aug 25, 2013 11:10 pm

please can somebody help me i don´t know how to fix the bitrate. i would like to get the bitrate without comma and only 3 numbers...
Image
and is there anyway to create a total lengh of all songs in the end of my exellist.
how to put the frontcover in my exellist....
sorry for my bad enghlish, thank you very much in advance.

best regards ian

trixmoto
Posts: 10024
Joined: Fri Aug 26, 2005 3:28 am
Location: Hull, UK
Contact:

Re: Custom Report 3.0 - Updated 16/03/2013

Post by trixmoto » Sun Sep 01, 2013 3:22 pm

With regards to the bitrate, I think you want to put "&M1024" in the format field, this will multiple the bitrate.

To create a total for a column at the bottom, you just need to tick the "Sum" checkbox for that column, and it should appear automatically.

There's no way to insert album artwork into an Excel document at the moment - it may be possible, but I'm not sure how to do this, so the script can't.
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.

IAN D
Posts: 3
Joined: Sun Aug 25, 2013 10:51 pm

Re: Custom Report 3.0 - Updated 16/03/2013

Post by IAN D » Wed Sep 04, 2013 8:40 pm

trixmoto wrote:With regards to the bitrate, I think you want to put "&M1024" in the format field, this will multiple the bitrate.

To create a total for a column at the bottom, you just need to tick the "Sum" checkbox for that column, and it should appear automatically.

There's no way to insert album artwork into an Excel document at the moment - it may be possible, but I'm not sure how to do this, so the script can't.

Hello,

thank you very much for the quick reply. but i still got the same problem. I write &M1024 in the format field and get for example following bitrate: 511699968 - I never saw this sybol & bevor.....
when i click on the sum checkbox for filelengh (D1024 D1024 N1) i´m getting following false resolt: 921072507 and in the end the euro sign. I dont know how to fix this one eather.
one other problem. when i click on the sum checkbox for titel i´m getting following false resolt: 0

i want to mention i´m using your reports for years, thank you very much for the great service you did. i just installed windows 7 new, and all my setting was gone...
please help me one more time, thank you very much in advance

best regards ian

trixmoto
Posts: 10024
Joined: Fri Aug 26, 2005 3:28 am
Location: Hull, UK
Contact:

Re: Custom Report 3.0 - Updated 16/03/2013

Post by trixmoto » Sun Sep 08, 2013 1:35 am

Thanks, I'm glad you've found the script useful. Could you please save your settings and email/PM them to me, so that I can take a look?
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.

IAN D
Posts: 3
Joined: Sun Aug 25, 2013 10:51 pm

Re: Custom Report 3.0 - Updated 16/03/2013

Post by IAN D » Sun Sep 08, 2013 7:36 am

trixmoto wrote:Thanks, I'm glad you've found the script useful. Could you please save your settings and email/PM them to me, so that I can take a look?
Sorry to bother you again. sometimes i think i´m to old (62) for this kind of things. i searched everywhere, i cant find a way to pm you or to get your email. feel like an idiot. please tell me how to contact you: thank you very much in advance.

best regards ian

wileewonka
Posts: 7
Joined: Fri Sep 13, 2013 11:42 am

Custom Report 3.0 MIA

Post by wileewonka » Fri Sep 13, 2013 2:19 pm

I downloaded Custom Report 3.0. I installed it. Now, I cannot find it. Any help as to where to look?
Thanx
Last edited by Lowlander on Fri Sep 13, 2013 3:06 pm, edited 1 time in total.
Reason: Merged with existing topic

Lowlander
Posts: 45905
Joined: Sat Sep 06, 2003 5:53 pm
Location: MediaMonkey 5

Re: Custom Report 3.0 - Updated 16/03/2013

Post by Lowlander » Fri Sep 13, 2013 3:06 pm

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

trixmoto
Posts: 10024
Joined: Fri Aug 26, 2005 3:28 am
Location: Hull, UK
Contact:

Re: Custom Report 3.1 - Updated 25/10/2013

Post by trixmoto » Fri Oct 25, 2013 1:42 am

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

- Fixed save and load settings buttons not working
- Fixed time not displaying correctly due to hours missing
- Added W format now works for Excel reports as well
- Added J format for justifying text in columns
- Added two new columns for displaying rating stars and bombs
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.

Bill
Posts: 74
Joined: Wed Jun 21, 2006 5:03 pm
Location: Myrtle Beach, SC USA

Re: Custom Report 3.1 - Updated 25/10/2013

Post by Bill » Tue Nov 05, 2013 10:07 am

I have downloaded Custom Report 3.1 and I cannot find it after a successful install. When I look at the "Extensions" is see it. What are the steps to run this script?
Thanks in advance for your help,
Bill
Desktop/Win7/Router: Motorola SURFboard/DLNA Media Player: Sony Blu-ray DVD BDP-S5100 /MM4/AV Sound System

Mizery_Made
Posts: 2283
Joined: Tue Aug 29, 2006 1:09 pm
Location: Kansas City, Missouri, United States

Re: Custom Report 3.1 - Updated 25/10/2013

Post by Mizery_Made » Tue Nov 05, 2013 2:03 pm

It's under "File -> Create Reports"

Onweerwolf
Posts: 642
Joined: Tue Dec 12, 2006 5:32 pm
Location: The Netherlands

Re: Custom Report 3.1 - Updated 25/10/2013

Post by Onweerwolf » Thu Nov 07, 2013 7:13 pm

trixmoto wrote:New version (3.1) is now available to download from my website. Changes include...

- Fixed time not displaying correctly due to hours missing
Thank you very much for fixing this! :D
Image

Post Reply