Ok, that might work. I exported and renamed the songs table to newsongs.csv. After revising newsongs.csv, I imported the table as newsongs. Both tables are identical, except for the data in the playcounts and last played dates (expressed in Unix time code). I used identical headings for each column.
I am not experienced with SQL language. What I came up with is: Update songs select lastplayed = from newsongs select playcount = from newsongs order by filename I get this error message: near "select": syntax error: What do I need to put to replace all values in the two columns using the imported csv table? 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? -- 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.
