INTERACT FORUM

Please login or register.

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

Author Topic: Is there any way to export data to a graphing program?  (Read 1349 times)

Crayola Boy

  • Regular Member
  • Recent member
  • *
  • Posts: 48
  • Change this by choosing profile
Is there any way to export data to a graphing program?
« on: November 21, 2004, 11:01:29 pm »

Is there any way to gather a report of how many times an artist or song has been played and export it to a graphing program like excell? It seems like it could be simple, just simple enough for me to figure out.
Logged

IanG

  • Regular Member
  • Citizen of the Universe
  • *****
  • Posts: 528
Re:Is there any way ...
« Reply #1 on: November 22, 2004, 03:02:11 am »

Select "Number Plays" as one of the fields you want to display
Select the tracks you're interested in
<ctrl> c
Now paste into Excel

It even manages to handle the ratings ok, though un-rated tracks show as "?".

Ian G.
Logged

Crayola Boy

  • Regular Member
  • Recent member
  • *
  • Posts: 48
  • Change this by choosing profile
Re:Is there any way to export data to a graphing program?
« Reply #2 on: November 22, 2004, 11:36:03 pm »

I was thinking more of a "Export stats" button, but I'll see if I can do it manually. Thanks.
Logged

Crayola Boy

  • Regular Member
  • Recent member
  • *
  • Posts: 48
  • Change this by choosing profile
Re: Is there any way to export data to a graphing program?
« Reply #3 on: December 11, 2004, 10:41:08 pm »

I gave this a try, but it wasn't exactly what I wanted. I want something that will not only tell me how many times a song has been played (as MC does), but how many times an artist has been played, or an album, or genre, etc. 

Is this possible?
Logged

bbrip

  • Regular Member
  • Galactic Citizen
  • ****
  • Posts: 441
  • Change this by choosing profile
Re: Is there any way to export data to a graphing program?
« Reply #4 on: December 12, 2004, 07:34:38 am »

Actually this reminds of a question I wnated to ask for a long time:

Why is it not possible to export the MC Library in ASCII format but only in xml?

If I could have ASCII, this would allow me to export into Access or Excel

Many thanks for giving this some consideration

BB
Logged

Alex B

  • MC Beta Team
  • Citizen of the Universe
  • *****
  • Posts: 10121
  • The Cosmic Bird
Re: Is there any way to export data to a graphing program?
« Reply #5 on: December 12, 2004, 08:29:43 am »

You can export it in ASCII format if you first make a playlist of the library tracks. Right click the playlist and select Export Playlist > ASCII Delimited.
Logged
The Cosmic Bird - a triple merger of galaxies: http://eso.org/public/news/eso0755

bbrip

  • Regular Member
  • Galactic Citizen
  • ****
  • Posts: 441
  • Change this by choosing profile
Re: Is there any way to export data to a graphing program?
« Reply #6 on: December 12, 2004, 09:54:55 am »

Oh thanks - wasnt aware of that. I'll try it out
Logged
Pages: [1]   Go Up