On Sunday, November 13, 2016 at 5:07:21 AM UTC-6, Alex Bikadorov wrote: > > yes, in the SQLite database file. Table "songs", column "lastplayed". Date > format is unix time > > On Sunday, November 13, 2016 at 1:34:13 AM UTC+1, at wrote: >> >> On my system it's stored in ~/.config/Clementine/clementine.db >> >> On Saturday, November 12, 2016 at 11:00:55 AM UTC-6, Harpo3 wrote: >>> >>> I am looking at this post from 2011, and I have the same question: Where >>> does Clementine store the last played date? >>> >>> >>> On Thursday, May 5, 2011 at 12:28:00 PM UTC-5, at wrote: >>>> >>>> how does clementine save this data? is it similar to the way that >>>> amarok 1.4 did in a mysql database? Is there a way to export amarok >>>> 1.4 playcounts/last played dates (and other stuff) to clementine? >>> >>> Ok I get it now. Thanks!
What I am trying to do is to transfer the lastplayed dates and playcounts from a MediaMonkey 4 (MM4) db in Windows to a Clementine.db in Debian. I can export these two fields from the MM4 db to a CSV file (I am guessing I can use the filename of the mp3 as the index value) and I plan to use that to replace the data and count values in the Clementine.db. Perhaps one way is to use MySQL, according to this: MySQL 5.7 Reference Manual <http://dev.mysql.com/doc/refman/5.7/en/load-data.html> But will that work if Clementine uses a SQLite schema? Has anyone successfully joined a MM4 db and a Clementine db directly? I want to try because I have this setup: Win 10 and Debian Jessie are each on a different SSD, while music files are on a third (standard drive) on a NTFS partition. -- You received this message because you are subscribed to the Google Groups "Clementine Music Player" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
