INTERACT FORUM

More => Old Versions => Media Center 11 (Development Ended) => Topic started by: Crayola Boy on November 21, 2004, 11:01:29 pm

Title: Is there any way to export data to a graphing program?
Post by: Crayola Boy 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.

Title: Re:Is there any way ...
Post by: IanG 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.

Title: Re:Is there any way to export data to a graphing program?
Post by: Crayola Boy 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.

Title: Re: Is there any way to export data to a graphing program?
Post by: Crayola Boy 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?

Title: Re: Is there any way to export data to a graphing program?
Post by: bbrip 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

Title: Re: Is there any way to export data to a graphing program?
Post by: Alex B 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.

Title: Re: Is there any way to export data to a graphing program?
Post by: bbrip on December 12, 2004, 09:54:55 am

Oh thanks - wasnt aware of that. I'll try it out