Open Stats Integration

Post a reply

Smilies
:D :) :( :o :-? 8) :lol: :x :P :oops: :cry: :evil: :roll: :wink:

BBCode is ON
[img] is ON
[url] is ON
Smilies are ON

Topic review
   

Expand view Topic review: Open Stats Integration

Re: Open Stats Integration

by Peke » Sun Jan 15, 2017 9:50 pm

I was reffering to scripts like http://www.mediamonkey.com/addons/brows ... ed-report/ that can be made to export MM.DB in order that Clementine recognize format.

Re: Open Stats Integration

by jcfogerty » Fri Jan 13, 2017 10:18 am

Peke wrote: Regarding MM DB, this can be easily archived with scripts and Exported in almost any format that can be imported to other apps.
Pavle, could you please explain this? I am only aware of a reports function, which is a slow and painful manual process.

Re: Open Stats Integration

by jcfogerty » Wed Jan 11, 2017 4:58 pm

Great idea, Pavle.

There is this page for the database structure: http://www.mediamonkey.com/wiki/index.p ... _structure
It is current to MM3. Has it changed in MM4? I don't see anything in this structure that explains how to extract lastplayed or playcount using the songs table. If there was a way for novice db people like me to SQL data seamlessly between the two dbs, that would be great.

Another thought...what if you released just a simple Linux player available for all, but Gold users would have the added capability to synchronize their Linux stats with the MM db in the Windows partition? There are a lot of Linux users out there who love MM, and it could bring you Gold sales if you had that as a feature.

Re: Open Stats Integration

by Peke » Mon Jan 09, 2017 5:30 pm

Lowlander wrote:MediaMonkey can be enhanced through Addons thus this seems entirely feasible through an Addon.

MediaMonkey runs on SQLite as database.
In addition to above, Plugins would be the right way to access Clementine database. I'm even thinking to see if we can do something in MM to load additional/external SQLite DB and manipulate with it.

Regarding MM DB, this can be easily archived with scripts and Exported in almost any format that can be imported to other apps.

Re: Open Stats Integration

by Lowlander » Mon Jan 09, 2017 12:51 pm

MediaMonkey can be enhanced through Addons thus this seems entirely feasible through an Addon.

MediaMonkey runs on SQLite as database.

Open Stats Integration

by jcfogerty » Sun Jan 08, 2017 5:00 pm

Ability to read/sync statistics with non-MM apps (like Clementine under Linux), or otherwise provide open source data integration.

This means if you play a song on Clementine, MM can read the lastplayed data from the Clementine database (SQLite) to update the MM database (what db type is that?).

Or make a utility (or add on) that allows open source users to access and use MM stats without having to manually generate a csv file in reports just to get our own info out of it. I would like to play my MM playlists while in Linux, and have the play stats (lastplayed, playcount) update like it does syncing a playlist using a phone with MMA.

In summary, an app that syncs like a device and that accepts the same stats from other apps. Since MM already has an android app (MMA), why not just update that app to broadcast track info via bluetooth. Computer users could then connect and download the stats info via bluetooth.

Top