Custom Report 3.2 - Updated 29/07/2014

[trixmoto]

What is the date in the OriginalDate field?

[dlm1129]

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]

Sorry, I meant more specifically relating to the example where the report is saying "1/1/1991".

[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]

Ok, well I'll take a look. Presumably your computer is localised to the american date format as well?

[dlm1129]

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]

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]

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.

[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]

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]

It's on my list, but I've not had a look yet.

[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)

[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]

Yeah, this is a string value so you won't be able to sum it properly. Try "SongLength" and then format the value instead.

[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