Ratings are native to LMS.
LMS stores ratings in the database persist.db, table tracks_persistent,
column rating
TrackStat stores rating in the database persist.db, table
track_statistics, column rating
TrackStat synchronizes LMS' ratings (e.g. at startup, iirc)
persist.db is a SQLite database, there are lots of tools to browse it (I
use sqlitestudio, which might be overkill). If you really want to use
Excel (I wouldn't...), there is a ODBC driver available.
technical details:
Code:
--------------------
CREATE TABLE tracks_persistent (
id INTEGER PRIMARY KEY AUTOINCREMENT,
url TEXT NOT NULL,
musicbrainz_id VARCHAR (40),
added INT (10),
rating TINYINT (1),
playCount INT (10),
lastPlayed INT (10),
urlmd5 CHAR (32) NOT NULL
DEFAULT '0'
);
--------------------
Code:
--------------------
CREATE TABLE track_statistics (
url TEXT NOT NULL,
musicbrainz_id VARCHAR (40),
playCount INT (10),
added INT (10),
lastPlayed INT (10),
rating INT (10),
urlmd5 CHAR (32) NOT NULL
DEFAULT '0'
);
--------------------
'Various SW' (https://www.nexus0.net/pub/sw/): Web Interface | Playlist
Editor / Generator | Music Classification | Similar Music | Announce |
EventTrigger | LMSlib2go | ...
'Various HowTos' (https://www.nexus0.net/pub/documents/LMS/): build a
self-contained LMS | Bluetooth/ALSA | Control LMS with any device | ...
------------------------------------------------------------------------
Roland0's Profile: http://forums.slimdevices.com/member.php?userid=56808
View this thread: http://forums.slimdevices.com/showthread.php?t=112532
_______________________________________________
ripping mailing list
[email protected]
http://lists.slimdevices.com/mailman/listinfo/ripping
