Posts made by DrMartinus

Thanks for your suggestions. it seems to work now, but I don't remember what I did, sorry. At least most of the stuff I wanted to be transferred has been transferred. I haven't used the script, at least I think I haven't. (I'm sorry, my memory plays tricks on me sometimes).

Hi,

I would like to order my playlist which includes a few hundred LPs (CDs) as follows:

1. all the albums of one artist:

• albums according to creation year , tracks according to track number

2. artists in alphabetical order

• I actually do not really care about the order of the artists, but it's easier to find a particular one if I don't want to listen to another one at the current time

That's it, but it seems quite difficult. In Clementine, I had it to some extent, I believe. I noted down to sort the different columns in the following order:

1. number (of track)
2. artist / interpreter
3. year
4. album name

Doing this, it apparently got sorted in the order I wanted it to be sorted (at least with Clementine), but it seems it doesn't work now as expected. is there an established and tested way for sorting a long playlist? I need this sorting because there are a number of concept albums among them, and it would sound awkward if the tracks of these albums are shuffled around.

I did a little bit of research and tried

COALESCE(filename,NULL) AS url,

which made the process work without an error, but the result isn't what I hoped for. After completing all steps given on the above mentioned Wiki page, when starting strawberry, it's still empty, i.e. there is no library, no playlists etc. The entire process to import the data from Clementine didn't work, it seems. Or my solution to the COALESCE-issue isn't the right one?

Hi,
I just liked Clementine, now I'm forced to move to Strawberry and wanted to transfer all data from Clementine to Strawberry, following the guide on https://wiki.strawberrymusicplayer.org/wiki/Import_collection_library_and_playlists_from_Clementine. I get stuck at the command

INSERT INTO strawberry.playlist_items
   (ROWID,
   playlist,
   collection_id,
   title,
   album,
   artist,
   albumartist,
   track,
   disc,
   year,
   originalyear,
   genre,
   compilation,
   composer,
   performer,
   grouping,
   comment,
   lyrics,
   beginning,
   length,
   bitrate,
   samplerate,
   directory_id,
   url,
   filetype,
   filesize,
   mtime,
   ctime,
   unavailable,
   playcount,
   skipcount,
   lastplayed,
   compilation_detected,
   compilation_on,
   compilation_off,
   compilation_effective,
   art_automatic,
   art_manual,
   effective_albumartist,
   effective_originalyear,
   cue_path,
   rating
   )
   SELECT ROWID,
      playlist,
      library_id,
      title,
      album,
      artist,
      albumartist,
      track,
      disc,
      year,
      originalyear,
      genre,
      compilation,
      composer,
      performer,
      grouping,
      comment,
      lyrics,
      beginning,
      length,
      bitrate,
      samplerate,
      directory,
      COALESCE(filename, ) AS url,
      filetype,
      filesize,
      mtime,
      ctime,
      unavailable,
      playcount,
      skipcount,
      lastplayed,
      sampler,
      forced_compilation_on,
      forced_compilation_off,
      effective_compilation,
      art_automatic,
      REPLACE(art_manual, '.config/Clementine/albumcovers','.local/share/strawberry/strawberry/collectionalbumcovers') AS art_manual,
      effective_albumartist,
      effective_originalyear,
      cue_path,
      rating FROM clementine.playlist_items WHERE type = 'Library';

sqlite3 throws an error:

Parse error near line 25: near ")": syntax error
  lerate,       directory,       COALESCE(filename, ) AS url,       filetype,   
                                      error here ---^

I don't know how to remedy this, I am not well versed in SQL, I only know that COALESCE takes at least two arguments, and I don't think that a space is considered an argument. But what else should be there?
Thanks for your help!