Custom Report 3.2 - Updated 29/07/2014

guest · 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 · Post by **trixmoto** » Mon Sep 26, 2011 6:33 am

Nope, sorry.

reneew · 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 · Post by **trixmoto** » Sun Oct 23, 2011 2:39 pm

You can format it anyway you like using the D format, yes.

Onweerwolf · 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.

Onweerwolf · 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?

Onweerwolf · 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*

trixmoto · 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.

Onweerwolf · 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.

trixmoto · Post by **trixmoto** » Tue Dec 13, 2011 5:42 pm

Well what's the difference between the two?

Onweerwolf · 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.

webmatador · 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 · 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?

Onweerwolf · 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?

Big Isch · 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

Custom Report 3.2 - Updated 29/07/2014

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

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

time setting

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

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

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

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

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

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

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

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

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

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

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

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