SQLite has the ".import" command. You can insert the data from CSV to a temporary table with it and use an "UPDATE" statement to replace the columns in table "songs".
Cheers Alex On 19.11.2016 01:42, Harpo3 wrote: > 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.
