INTERACT FORUM

Please login or register.

Login with username, password and session length
Advanced search  
Pages: [1]   Go Down

Author Topic: graphs for playcounts  (Read 2872 times)

urlwolf

  • Regular Member
  • World Citizen
  • ***
  • Posts: 235
  • building gomotron!
graphs for playcounts
« on: August 31, 2004, 07:23:26 pm »
Hi,

audioscrobbler got me thinking. Is there any way to display graphs for MC's playcounts? Because i have statistics on my listening habits logged by MC for some time now. I'd just like  to be able to display them somehow, or to dump them to a file and plot them with an external program.

It'd be nice to have an 'statistics' view. Maybe there is one, i just couldn't find it in the help.
Logged

kaiynne

  • Regular Member
  • World Citizen
  • ***
  • Posts: 225
  • I Changed this by choosing profile
Re:graphs for playcounts
« Reply #1 on: August 31, 2004, 07:32:13 pm »
there is a statistics section but it is a little minimalist at the moment.  It would be nice to see some work on it allowing for customization and whatnot, but it is there and its a start.

click on file properties in the action window and then stats are at the bottom of the next pane.

Logged

Alex B

  • MC Beta Team
  • Citizen of the Universe
  • *****
  • Posts: 10121
  • The Cosmic Bird
Re:graphs for playcounts
« Reply #2 on: August 31, 2004, 07:38:21 pm »
Copy selected files by right clicking (Edit -> Copy) and paste to Excel (or other spreadsheet). Make graphs there.

I don't think MC has graphical statistics display plugin. (Yet?)

Edit

Make the fields you like to copy visible (in Customize Current View). It copies everything you can see.
Logged
The Cosmic Bird - a triple merger of galaxies: http://eso.org/public/news/eso0755

urlwolf

  • Regular Member
  • World Citizen
  • ***
  • Posts: 235
  • building gomotron!
Re:graphs for playcounts
« Reply #3 on: August 31, 2004, 07:39:01 pm »
Quote from: kaiynne on August 31, 2004, 07:32:13 pm
there is a statistics section but it is a little minimalist at the moment.  It would be nice to see some work on it allowing for customization and whatnot, but it is there and its a start.

click on file properties in the action window and then stats are at the bottom of the next pane.



Yes, that's what I do, but I get only the files, artists, albums, file size, and duration. No reference to playcounts. And also, it's averaged if you select more than one file, not detailed.
Logged

IlPadrino

  • MC Beta Team
  • Galactic Citizen
  • *****
  • Posts: 496
Re:graphs for playcounts
« Reply #4 on: August 31, 2004, 08:04:35 pm »
Export the data using the built-in Export Playlist or the better MC XML Export plugin.   You can then choose to create the graphs with Excel, Access, SVG/HTML, or something else.

Excel would be easy, but you'd need to adjust the graph every time you do a data transport or build the graph extra big.  Access might be nice and there's already a preset for MC XML Export that will help you get it in.  

SVG would be the best bet, but you'd need to learn it first and then write XSLT that goes from the exported data to HTML with embedded SVGs.  I once gave some thought to doing this, but it became a little disheartening to see no built-in MC support for doing the transformations.  Would JRiver add this, it would be a very slick ability indeed.  Imagine...  from within MC, select the data, export the XML, do the transform, save the transform, and MOST IMPORTANTLY, render the HTML within MC itself.
Logged

paulr

  • Regular Member
  • Citizen of the Universe
  • *****
  • Posts: 527
  • nothing more to say...
Re:graphs for playcounts
« Reply #5 on: August 31, 2004, 09:22:44 pm »
What would be really fantastic is if we could connect to the MC database with an external SQL front end.  That way you could just run queries against the live data any time you wanted.
Logged

IlPadrino

  • MC Beta Team
  • Galactic Citizen
  • *****
  • Posts: 496
Re:graphs for playcounts
« Reply #6 on: August 31, 2004, 10:04:04 pm »
Quote from: paulr on August 31, 2004, 09:22:44 pm
What would be really fantastic is if we could connect to the MC database with an external SQL front end.  That way you could just run queries against the live data any time you wanted.

Requested and responded to long ago...  if I remember correctly, it was an issue of licensing.  JRiver decided to use their own DBMS rather than license something exisitng.  I'm not sure why they didn't use something like SQLite.

And, yes, a way to externally connect to the database would be great.  Another product (which must remain nameless, else it'll get edited by JRiver) offers this feature and its great.  But at another $40, I can't see buying it just for a better Theater View.
Logged

hit_ny

  • Citizen of the Universe
  • *****
  • Posts: 3310
  • nothing more to say...
Re:graphs for playcounts
« Reply #7 on: September 01, 2004, 03:12:02 am »
Quote
SVG would be the best bet, but you'd need to learn it first and then write XSLT that goes from the exported data to HTML with embedded SVGs.

SVG needs an adobe plugin which only works with IE (i think)

To work in IE natively it would need to be done in VML (think thats right), which means no for any non-IE users out there.
Logged

IlPadrino

  • MC Beta Team
  • Galactic Citizen
  • *****
  • Posts: 496
Re:graphs for playcounts
« Reply #8 on: September 01, 2004, 09:37:57 am »
Quote from: hit_ny on September 01, 2004, 03:12:02 am
Quote
SVG would be the best bet, but you'd need to learn it first and then write XSLT that goes from the exported data to HTML with embedded SVGs.

SVG needs an adobe plugin which only works with IE (i think)

To work in IE natively it would need to be done in VML (think thats right), which means no for any non-IE users out there.

If I remember correctly, VML is a Microsoft standard that isn't supported by any other browser.  SVG is a W3C standard which has implementations for MSIE, Firefox, Opera, etc.

Logged

hit_ny

  • Citizen of the Universe
  • *****
  • Posts: 3310
  • nothing more to say...
Re:graphs for playcounts
« Reply #9 on: September 01, 2004, 09:55:53 am »
Quote from: IlPadrino on September 01, 2004, 09:37:57 am
If I remember correctly, VML is a Microsoft standard that isn't supported by any other browser.  SVG is a W3C standard which has implementations for MSIE, Firefox, Opera, etc.

The web was always meant to be browser agnostic - in my humbe opinion, anyone who supports only MSIE is a close relative to lucifer!

Sure

Doesn't MC use IE to browse ?

..so if the graphics were done in SVG will it work in MC or does one need to fire up a browser seprately.
Logged

JimH

  • Administrator
  • Citizen of the Universe
  • *****
  • Posts: 72448
  • Where did I put my teeth?
Re:graphs for playcounts
« Reply #10 on: September 01, 2004, 10:50:36 am »
Quote from: IlPadrino on August 31, 2004, 10:04:04 pm
Quote from: paulr on August 31, 2004, 09:22:44 pm
What would be really fantastic is if we could connect to the MC database with an external SQL front end.  That way you could just run queries against the live data any time you wanted.

Requested and responded to long ago...  if I remember correctly, it was an issue of licensing.  JRiver decided to use their own DBMS rather than license something exisitng.  I'm not sure why they didn't use something like SQLite.
No.  It is an issue of speed.  It's not about licensing.
Logged

IlPadrino

  • MC Beta Team
  • Galactic Citizen
  • *****
  • Posts: 496
Re:graphs for playcounts
« Reply #11 on: September 01, 2004, 11:05:16 am »
Quote from: JimH on September 01, 2004, 10:50:36 am
Quote from: IlPadrino on August 31, 2004, 10:04:04 pm
Quote from: paulr on August 31, 2004, 09:22:44 pm
What would be really fantastic is if we could connect to the MC database with an external SQL front end.  That way you could just run queries against the live data any time you wanted.

Requested and responded to long ago...  if I remember correctly, it was an issue of licensing.  JRiver decided to use their own DBMS rather than license something exisitng.  I'm not sure why they didn't use something like SQLite.
No.  It is an issue of speed.  It's not about licensing.

I stand corrected.  But I've got to wonder:  How is it that in a field that has been around for more than three decades, JRiver was able to develop a faster DB engine than Oracle, Microsoft, IBM, or Sybase?
Logged

JimH

  • Administrator
  • Citizen of the Universe
  • *****
  • Posts: 72448
  • Where did I put my teeth?
Re:graphs for playcounts
« Reply #12 on: September 01, 2004, 11:07:19 am »
Scott,
Don't you have anything more important to do?

Jim
Logged

IlPadrino

  • MC Beta Team
  • Galactic Citizen
  • *****
  • Posts: 496
Re:graphs for playcounts
« Reply #13 on: September 01, 2004, 11:10:10 am »
Quote from: JimH on September 01, 2004, 11:07:19 am
Scott,
Don't you have anything more important to do?

Jim


Not this morning.
Logged

CDvd

  • Regular Member
  • World Citizen
  • ***
  • Posts: 208
Re:graphs for playcounts
« Reply #14 on: September 01, 2004, 11:39:57 am »
Quote from: IlPadrino on September 01, 2004, 11:05:16 am
How is it that in a field that has been around for more than three decades, JRiver was able to develop a faster DB engine than Oracle, Microsoft, IBM, or Sybase?
I't's perhaps because Oracle's DB engine can do "much more" things than the embeded one in your favorite media player. The bigger, the faster? not sure... ::)

JimH : would it be feasible to allow users to interact in a closer way with the MC database? I mean not just refering to fields but allowing us to compute some results.
I'm thinking about someone that asked if he could substract 1 hour to the date field of some photos....
Logged
A computer without COBOL and Fortran is like a piece of chocolate cake without ketchup and mustard.

IlPadrino

  • MC Beta Team
  • Galactic Citizen
  • *****
  • Posts: 496
Re:graphs for playcounts
« Reply #15 on: September 03, 2004, 12:35:47 am »
Quote from: hit_ny on September 01, 2004, 09:55:53 am
Quote from: IlPadrino on September 01, 2004, 09:37:57 am
If I remember correctly, VML is a Microsoft standard that isn't supported by any other browser.  SVG is a W3C standard which has implementations for MSIE, Firefox, Opera, etc.

The web was always meant to be browser agnostic - in my humbe opinion, anyone who supports only MSIE is a close relative to lucifer!

Sure

Doesn't MC use IE to browse ?

..so if the graphics were done in SVG will it work in MC or does one need to fire up a browser seprately.

I see your point about rendering the graphics from within MC.  But seeing as MC currently has no way of displaying the dynamic content, it's not really an issue.  Also, I'd think that the Adobe SVG plugin would work fine within MC.

If only I didn't have anything more important to do, I'd try a proof-of-concept with MC XML Export.  Maybe after I relocate to Ventura County (California)...
Logged

hit_ny

  • Citizen of the Universe
  • *****
  • Posts: 3310
  • nothing more to say...
Re:graphs for playcounts
« Reply #16 on: September 03, 2004, 09:51:52 am »
Quote from: IlPadrino on September 03, 2004, 12:35:47 am
I see your point about rendering the graphics from within MC.  But seeing as MC currently has no way of displaying the dynamic content, it's not really an issue.  Also, I'd think that the Adobe SVG plugin would work fine within MC.


Exactly, VML would be quicker than SVG and would require nothing to install.

I was even thinking of flash.

But i'm not so familiar how MC would handle this. Is it possible for instance to have a few web pages that would display pretty graphs within MC. Maybe a way to create a list of links that would live on the hardrive.
Logged
Pages: [1]   Go Up
« previous next »