Song Ratings not exporting from Library - Printable Version +- Kodi Community Forum (https://forum.kodi.tv) +-- Forum: Support (https://forum.kodi.tv/forumdisplay.php?fid=33) +--- Forum: General Support (https://forum.kodi.tv/forumdisplay.php?fid=111) +---- Forum: Linux (https://forum.kodi.tv/forumdisplay.php?fid=52) +---- Thread: Song Ratings not exporting from Library (/showthread.php?tid=104387) |
Song Ratings not exporting from Library - buddiemac - 2011-06-27 I add song ratings within XBMC to each song (NOT from meta mp3 tags) in the music library. I assumed they are saved within the music.db data base. When I export the music data base I do not find any song rating fields. I find album rating fields (loaded from scrapers). I would like to export my library with song ratings - how can this be done? RE: Song Ratings not exporting from Library - hirschma - 2012-03-31 The song ratings are in the Music.db file. This really, really should be part of the exported data. I had the same issue, plus I was using FLAC files, which have some issues regarding song ratings within a tag as far as XBMC is concerned. My solution was to write a script to extract that ratings info from the music.db file, and put them into a FLAC tag that XBMC will understand without issue. This might be useful for your purposes. Note that my scripting abilities are not the best, but this might get you started to your own solution: Code: #!/bin/bash I'm sure someone with more talent than me can make this pretty, and adapt it for import/export of ratings data. RE: Song Ratings not exporting from Library - wilson.joe - 2012-03-31 thanks for sharing... RE: Song Ratings not exporting from Library - buddiemac - 2013-07-05 hirschma, A belated thanks. I will give this a try when I have time. RE: Song Ratings not exporting from Library - sea3pea0 - 2014-03-04 This script by hirschma is exactly what I need, but for a windows environment. Anybody with any coding skills feel inclined to translate this into something for windows? Has anyone had any issues with it? Anyway thanks for the contribution, perhaps this will get people with windows closer to a solution to getting their song ratings from the db to the files themselves. RE: Song Ratings not exporting from Library - Sebastian - 2014-10-31 Hi have had the same problem, It will be great if XBMC (now Kodi) Team can implement a solution for that I have a lot of things in mind on how to do it x) write stars in file tags, (can be turned on-off by configuration, and format can be choosed in configuration) x) when exporting libraries writing a .nfo for each album with this knd of information x) have a cloud server to store all libraries data as backup and be able to retrieve it... in the mean while, this issue cn be solved with a sqlite script that can copy the rating value (last played, playcount, etc) from the old database to the new one... those are the steps to perform it: 1) download sqlitestudie, very helpfull for working with your database 2) copy the old MusicXX.db to a place where it can be found 3) scan the music lib in the new xbmc, and import .nfo files 4) locate the new MusicXX.db in your computer 5) open the sqlitestudio and creates both connections to both databases, for the old database name the connection OldDatabase 6) connect both conection and open a sql editor based on the connection of the new database and run this query: Code: replace into song |