Custom Report 3.2 - Updated 29/07/2014

Download and get help for different MediaMonkey Addons.

Moderators: Peke, Gurus

guest

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

Post by guest »

trixmoto wrote:This is a track report. If you just want to list the artists and albums try my "Just List Albums" and "Just List Artists" scripts.
Understood... but if one wanted the XLS output of Custom Reports, and ability to sort/hide/etc columns of values from other MM fields once in Excel, IS there a setting for CR that would 'dumb it down' to the equivalent of JLAbums -- i.e. one row per album?
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 »

Nope, sorry.
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.
reneew
Posts: 1
Joined: Sun Oct 23, 2011 4:23 am

time setting

Post by reneew »

Hello,

Time is set to m:ss Excel says that it is h:mm.
So can the time setting hh:mm:ss, excel has the good time then
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 »

You can format it anyway you like using the D format, yes.
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.
Onweerwolf
Posts: 663
Joined: Tue Dec 12, 2006 5:32 pm
Location: The Netherlands
Contact:

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

Post by Onweerwolf »

How do i get this script to show the correct songlength in excel?

Edit: nevermind, I got it, I was using SongLength instead of SongLengthString.
Image
Onweerwolf
Posts: 663
Joined: Tue Dec 12, 2006 5:32 pm
Location: The Netherlands
Contact:

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

Post by Onweerwolf »

Okay, so there is still a problem with track length. It displays the minutes as hours and seconds as minutes in excel. How do I fix this?
Image
Onweerwolf
Posts: 663
Joined: Tue Dec 12, 2006 5:32 pm
Location: The Netherlands
Contact:

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

Post by Onweerwolf »

Onweerwolf wrote:Okay, so there is still a problem with track length. It displays the minutes as hours and seconds as minutes in excel. How do I fix this?
*bump*
Image
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 »

I don't know, but you could try prefixing them with "00:" to represent hours.
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.
Onweerwolf
Posts: 663
Joined: Tue Dec 12, 2006 5:32 pm
Location: The Netherlands
Contact:

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

Post by Onweerwolf »

That doesn't work because Excel now sees the output as text instead of time.

Fwiw: the build-in report function from MediaMonkey works the way it should.
Image
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 »

Well what's the difference between the two?
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.
Onweerwolf
Posts: 663
Joined: Tue Dec 12, 2006 5:32 pm
Location: The Netherlands
Contact:

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

Post by Onweerwolf »

Your script incorrectly displays minutes as hours and seconds as minutes in Excel and the build-in script gets it correctly.
Image
webmatador

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

Post by webmatador »

Since I've upgraded to MM 4, this script no longer works. Using an XP, I'm the admin, etc.

Any ideas?
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 »

Onweerwolf wrote:Your script incorrectly displays minutes as hours and seconds as minutes in Excel and the build-in script gets it correctly.
Thanks, but that's not helpful. In what way are the FILES different?
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.
Onweerwolf
Posts: 663
Joined: Tue Dec 12, 2006 5:32 pm
Location: The Netherlands
Contact:

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

Post by Onweerwolf »

trixmoto wrote:
Onweerwolf wrote:Your script incorrectly displays minutes as hours and seconds as minutes in Excel and the build-in script gets it correctly.
Thanks, but that's not helpful. In what way are the FILES different?
Which files do you mean exactly?
Image
Big Isch
Posts: 112
Joined: Mon Mar 12, 2007 8:34 am
Location: Austria
Contact:

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

Post by Big Isch »

Hi,

I just exported the "DateAdded" and "LastPlayed".
When using NO formatting, everything is fine and the Date/Time is displayed with Date and Time,
e.g. "2012-02-15 17:32:04".

When using format "FY-m-dTH:i:s", the output is not ok,
e.g. "2012-02-15TH:i:s".

Are the options for time wrong ? (what are the correct ones?) Or what did I do wrong ?

Help is appreciated :D
Post Reply