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 » Mon Sep 26, 2011 5:04 am

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 » Mon Sep 26, 2011 6:33 am

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 » Sun Oct 23, 2011 4:26 am

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 » Sun Oct 23, 2011 2:39 pm

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: 643
Joined: Tue Dec 12, 2006 5:32 pm
Location: The Netherlands

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

Post by Onweerwolf » Mon Nov 14, 2011 8:37 am

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: 643
Joined: Tue Dec 12, 2006 5:32 pm
Location: The Netherlands

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

Post by Onweerwolf » Mon Nov 14, 2011 9:00 am

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: 643
Joined: Tue Dec 12, 2006 5:32 pm
Location: The Netherlands

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

Post by Onweerwolf » Mon Dec 12, 2011 10:40 am

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 » Tue Dec 13, 2011 4:08 am

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: 643
Joined: Tue Dec 12, 2006 5:32 pm
Location: The Netherlands

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

Post by Onweerwolf » Tue Dec 13, 2011 3:13 pm

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 » Tue Dec 13, 2011 5:42 pm

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: 643
Joined: Tue Dec 12, 2006 5:32 pm
Location: The Netherlands

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

Post by Onweerwolf » Tue Dec 13, 2011 6:18 pm

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 » Tue Dec 13, 2011 10:49 pm

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 » Wed Dec 14, 2011 3:57 am

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: 643
Joined: Tue Dec 12, 2006 5:32 pm
Location: The Netherlands

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

Post by Onweerwolf » Wed Dec 14, 2011 12:45 pm

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

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

Post by Big Isch » Tue Mar 13, 2012 12:44 pm

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