View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0000833 | MMW v4 | Framework: Scripts/Extensions | public | 2003-10-30 14:22 | 2005-01-07 17:41 |
| Reporter | rusty | Assigned To | |||
| Priority | immediate | Severity | feature | Reproducibility | always |
| Status | closed | Resolution | fixed | ||
| Fixed in Version | 2.3 | ||||
| Summary | 0000833: Statistics pane | ||||
| Description | Some users have requested a statistics pane. It could work as follows: User clicks File | Generate Reports | Statistics --> HTML page appears in the tracklist area that has the same Look and feel as the Tracklist html report: MediaMonkey Library Statistics Totals: Tracks - xxx Space (MB) - xxx Time - hh:mm Time Played - hh:mm Artists - xxx Albums - xxx CDs - xxx ===================================== Averages: Track length: mm:ss Encoding quality (kbps): xxx Tracks per Album: xxx Tracks per CD: xxx Tracks played per day: xx ===================================== Top 10 --------- By Artist [bar chart] Artist1 ------------------ (x) Artist2 ------------- (y) .. Artist 10 ------- (z) By Genre Genre1 -------------------- (x) Genre2 -------------- (y) .. Genre10-------- (z) By Encoding MP3 ------------------ (x) OGG ---------- (y) .. MPC -------- (z) ======================================= Most Played Tracks 1) Track1 ------------------------ (x) 2) Track2 -------------- (y) .. 10) Track 10 ------ (z) Artists 1) Artist1 ------------------------ (x) 2) Artist2 -------------- (y) .. 10) Artist10 ------ (z) Genres 1) Genre1 ------------------------ (x) 2) Genre2 -------------- (y) .. 10) Genre10 ------ (z) ============================== Ratings Graph: 5 -------------------------- 4.5 -------------- 4 ----------- 3.5 ----------------- 3 -------------------- 2.5 -- 2 -- 1.5 -- 1 -- .5 ---------- 0 -------------- Unrated ============================== Problems Tracks: Missing Artist: x Missing Title: x Missing Album: x Missing Genre: x Missing Year: x Missing Rating: x Dead links: x Note: [Save] and [Print] buttons should also be present in the report. | ||||
| Additional Information | http://www.songs-db.com/forum/viewtopic.php?t=1277 | ||||
| Tags | No tags attached. | ||||
| Fixed in build | 831 | ||||
|
|
Possible stats from Jiri: # of tracks, total length, ... Another option is to show some graphs showing how many tracks were played during the last month, how many each day of the week, etc. |
|
|
Raising priority to urgent. I'll spec it, and hopefully one of our users will run with the spec. |
|
|
Note: we could just use Lowlander's implementation which is fairly close to the spec. |
|
|
E-mails from Martin: You're more than welcome to use the statspage in any which way you see fit. A mention for effort would always be appreciated. I am glad to hear that some stats will be included in MM, it's always interesting to know some tidbits about your collection. You guys might want to think about print capability (reports or from MM interface). BTW, I'm planning on revising the html report to update the code to a better standard of html. Are you interested in this? ... As for the stats page, I can certainly update the looks of it. But I guess you guys will need to rewrite the code to MM scripting to have the same functionality as my ASP version. So if the code (functionality wise) needs to be rewritten you guys might want to tackle that before I take the HTML formatting and the design under hand. Let me know what your thoughts are on this. I'm not sure that I would know how to access the DB for statistics thru MM scripting. But I can certainly finalize the HTML part based on your specs. Jiri: Please let me know how you'd like to proceed... |
|
|
I think that it could work as 'Sample New Window - Report.vbs' that is at http://www.mediamonkey.com/developers.htm (the actual URL is http://www.mediamonkey.com/sw/webhelp/Sample%20New%20Window%20-%20Report.vbs). It shows how to use scripting API to create a window, place a WebBrowser control there and put any content into it. This way users could see statistics comfortably in MM UI and also could send it directly to a printer. I also think that conversion of ASP code to this version would be quite easy. |
|
|
My skills in creating stats from a DB aren't that good unfortunately. The Rocket and b0b0b0b-guest might be of help. The Rocket has his own stats in his project and b0b0b0b-guest has created the top 10 artist code I use. As for editing the html and design of the report that's no problem. |
|
|
Included in build 827. |
|
|
Jiri, the report doesn't appear in 827 (it's not copied to the scripts directory)! Re-opening. |
|
|
I didn't include it because I support someone (lowlander?) will make some corrections to it, e.g. changes in formatting, making it an ordinary script (not-auto script), etc. |
|
|
The script provided by the Rocket is great, though the following issues remain: Functional: 1) Length: In all cases where this field is used, the value is displayed as hh:mm AM instead of hh:mm (note: I think it would be reasonable to just display hh:mm and forget about the seconds. The important thing is that AM/PM is not relevant). 2) Averages - Rating: This value is inaccurate because tracks that have a blank average, have a value of '-1'. i.e. for an accurate calculation, tracks with '-1' value should be ignored (note: this applies to any numeric field). 3) The Script should be changed to standard script rather than an Auto script Cosmetic: 10) Bitrate (kbps) should be changed to 'Bitrate (Kbps)' -- DONE 11) File Size: In all cases where this field appears, the Gb and Mb indicators should be changed to GB and MB for accuracy (Mb means Megabits and not Megabytes). -- DONE 12) In all cases, 'Files' should be changed to 'Tracks' -- DONE 13) Change 'Lengh' to 'Length' -- DONE 14) Change Total & Average columns to 'Library' -- DONE 15) Remove Top Ten Albums table since the stats don't mean much -- DONE 16) Tracks played per day should be in the right column -- DONE 17) Cells that will never have a value should have a '-' to indicate this -- DONE 18)) Correct Case for 'Files per xxx' - DONE 19) In all cases where 'Files' is in the header, a number only needs to be displayed in the column below. i.e. 'xx' can be displayed instead of 'xx files' -- DONE 20) There should be a header for the Report along the lines of 'Music Library Statistics' 21) It should have a look and feel of the MediaMonkey tracklist reports (perhaps a common .css file). 22) There should be a footer similar to that of the MediaMonkey tracklist reports. 23) Each of the tables should be split apart from neighboring ones (currently a blank cell is used, which results in vertical lines appearing between neighboring tables). |
|
|
There's a bug with the CCur function when NULL data is used. I've asked TheRocket if he can follow up on it. |
|
|
I've received a final version of the script from the Rocket and forwarded it. Re-assigning to Jiri for inclusion. |
|
|
Included in build 830. |
|
|
Tested in 830. The images that are supposed to be in the report are missing (Rocket didn't include them in the latest version because he was only including the changed components). The graphics were included in earlier versions of the scripts that I'd emailed. |
|
|
Fixed in build 831. - This was a bug in installer. |
|
|
Verified 831. |
