Custom Report 3.2 - Updated 29/07/2014

Download and get help for different MediaMonkey Addons.

Moderators: Peke, Gurus

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

Re: Custom Report 2.7 - Updated 14/11/2010

Post by trixmoto »

What is the date in the OriginalDate field?
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.
dlm1129
Posts: 7
Joined: Sun Apr 26, 2009 7:22 pm
Contact:

Re: Custom Report 2.7 - Updated 14/11/2010

Post by dlm1129 »

trixmoto wrote:What is the date in the OriginalDate field?
Well I'm using that field for the date that a song originally hit the Billboard Hot 100 or R&B charts. It's always in the mm/dd/yy format.

I've been using it for that purpose ever since I converted my old iTunes library into MediaMonkey a couple of years ago. It was a field that didn't exist within iTunes so I just used it as an extra date field in a way that met my needs. I don't know if the MM developers had some other purpose in mind for Original Date.
trixmoto
Posts: 10024
Joined: Fri Aug 26, 2005 3:28 am
Location: Hull, UK
Contact:

Re: Custom Report 2.7 - Updated 14/11/2010

Post by trixmoto »

Sorry, I meant more specifically relating to the example where the report is saying "1/1/1991".
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.
dlm1129
Posts: 7
Joined: Sun Apr 26, 2009 7:22 pm
Contact:

Re: Custom Report 2.7 - Updated 14/11/2010

Post by dlm1129 »

Well a specific example that best exemplifies what's happening is The Beatles "Got to Get You Into My Life". The song was released in 1966 on Revolver but here in the U.S. was originally released as a single 10 years later (6/12/1976).

So here's how I entered the metadata into MediaMonkey:
Date: 1966
Original Date: 6/12/1976

But in the Custom Report it shows the following:
Year: 1966
OriginalDate: 1/1/1966
OriginalYear: 30/11/1975

I know that I've entered the date as mm/dd/yyyy vs the UK method of dd/mm/yyyy. I don't know if that's the problem. I do know that when I sort my music by Original Date within MediaMonkey it sorts them as I would expect -- e.g. 10/31/1976 comes immediately before 11/1/1976, etc.

I'm really interested in how OriginalYear shows up as 30/11/1975. It shows some parallel to
trixmoto
Posts: 10024
Joined: Fri Aug 26, 2005 3:28 am
Location: Hull, UK
Contact:

Re: Custom Report 2.7 - Updated 14/11/2010

Post by trixmoto »

Ok, well I'll take a look. Presumably your computer is localised to the american date format as well?
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.
dlm1129
Posts: 7
Joined: Sun Apr 26, 2009 7:22 pm
Contact:

Re: Custom Report 2.7 - Updated 14/11/2010

Post by dlm1129 »

trixmoto wrote:Ok, well I'll take a look. Presumably your computer is localised to the american date format as well?
Yes it is. Thanks and happy new year!
ashenkin
Posts: 138
Joined: Sun Oct 30, 2005 12:03 pm
Contact:

Re: Custom Report 2.7 - Updated 14/11/2010

Post by ashenkin »

Hi There,

I'd like to run a report which gives me an html file with album art, artist name and album name each in a column, and with track names in the last column. However, I don't want multiple copies of the album art, artist name or album name. That is, I'd like to have the track names grouped under each album. Hope that makes sense. Can I do that with Custom Report?

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

Re: Custom Report 2.7 - Updated 14/11/2010

Post by trixmoto »

No you can't, this script does track level reporting. My "Advanced Report" might help you, but it might be too much for what you want.
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.
ashenkin
Posts: 138
Joined: Sun Oct 30, 2005 12:03 pm
Contact:

Re: Custom Report 2.7 - Updated 14/11/2010

Post by ashenkin »

thanks trixmoto,

i tried installing advanced report, but have a similar problem as others do where it doesn't show up in MM (i'm running win 7 pro x64). In any case, yeah, sounds like your advanced report sets up a clickable html file - i'm just looking to produce something nice i can send to someone so they can pick some tracks they'd like to hear.
dlm1129
Posts: 7
Joined: Sun Apr 26, 2009 7:22 pm
Contact:

Re: Custom Report 2.7 - Updated 14/11/2010

Post by dlm1129 »

trixmoto wrote:Ok, well I'll take a look. Presumably your computer is localised to the american date format as well?
Hi Trixmoto-- It's been awhile but I'm just wondering if you've been able to figure this out yet. It's basically a great script and the ability to export this field as entered would be just solidify that.
trixmoto
Posts: 10024
Joined: Fri Aug 26, 2005 3:28 am
Location: Hull, UK
Contact:

Re: Custom Report 2.7 - Updated 14/11/2010

Post by trixmoto »

It's on my list, but I've not had a look yet.
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.
trixmoto
Posts: 10024
Joined: Fri Aug 26, 2005 3:28 am
Location: Hull, UK
Contact:

Re: Custom Report 2.8 - Updated 05/03/2011

Post by trixmoto »

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

- Fixed "OriginalDate" was looking at the "Date" fields
- Added "OriginalDay" and "OriginalMonth" fields
- Added "StartTime", "StopTime", "SkipCount" and "TrackType" (MM4 only)
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.
SupERS

error Custom Report 2.8

Post by SupERS »

When I create long custom report and total time is more then 24hours in 'SongLenghString' - option 'sum'

There is error 13; FormatDateTime, CustomReport.vbs line 2863, column 2 'Type mismatch'
trixmoto
Posts: 10024
Joined: Fri Aug 26, 2005 3:28 am
Location: Hull, UK
Contact:

Re: Custom Report 2.8 - Updated 05/03/2011

Post by trixmoto »

Yeah, this is a string value so you won't be able to sum it properly. Try "SongLength" and then format the value instead.
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.
jeg3698

Re: Custom Report 2.8 - Updated 05/03/2011

Post by jeg3698 »

I am trying to create a report that would show just the artist and the album but everthing I try keeps showing artist and album for every single track. I just want the artist and album for each album
Post Reply