Ahh found it. You can define the behavior in Tools > Settings > Behavior > Double click a song > Open in new playlist
Latest posts made by OriNOVet
RE: Define action doubleclick on Playlist/Smart Playlist
Sync from libre.fm?
Or can someone please tell me, how I can create such a plugin by myself? Is there some plugin template?
RE: Playcounts/Lasted played not showing up for tracks opened via playlist
@torgo i have not tested this, but maybe you can use a 'bind mount', instead of a symlink.
RE: Moving collection/config
maybe its much easier in your case. after thinking again, you should also be succesfull by using a update sql like this:
update songs set url = 'newpath' where url = 'oldpath';
in the new column within libre office. set the fieldnames according to your current table. ratings are already set in your case, you have only to update the path.
RE: Moving collection/config
Yes, you can move your music, or copy it.
First, you should copy the library:
cp -R /home/olduser/Music /home/newuser/Music
Then look for the database. This is saved in .local/share/strawberry/strawberry/strawberry.db.
This is a SQLite database. You can use "DB Browser for SQLite" to such files or the shell ith sqlite3 command, but its easier with the editor.
In the db there is a table "songs". In this table, the column 'url' saves the path to your music file and the column 'rating' holds the ratings for the song. You can use standard SQL syntax to edit the fields. You have to edit the path to the new path. Be careful to identify the correct song, since there is no unique id linked to the song.
For example you can get a list with the following syntax (in tab "execute SQL"):
SELECT title, album, artist, track, disc, url, rating FROM songs;
Save the result as CSV file. Open the CSV file with Libre Office Calc (or any other calculation software, like Excel).
Add a new column in the csv file and enter the following formula (Keep the Quotes):
=CONCAT("UPDATE songs SET url = '";F2;"' WHERE title = '";A2;"' AND album = '";B2;"' AND artist = '";C2;"' AND track = ";D2;" AND disc = ";E2;";")
Use autofill for all the other entries. This creates a new set of SQL commands in this new column to UPDATE the mentioned table.
Copy the database to the new location, DON'T open strawberry. Open the database on the new location with the SQLite editor. Paste new created SQL commands in the execute tab and execute the commands. Save the database/write the changed entries. Close the SQLite editor.
Open Strawberry on the new profile, ratings and path should now be edited. To be save, you can create backups of the database files.
Sounds complicated, but it should work. I have migrated my Media Monkey data from Windows by a similar way, and it worked like a charm.
UPDATE: Sorry forgot that the path/url changes, during this operation. In this case, you can search and replace in the textfile, to change the parts of the path, which changes.
How to understanding "Organize Files"?
If i select a bunch of files from any playlist and rightclick them, i can choose from the context menu "Organize files". If i choose in the dialog "Keep the original files" and select as Destination a other folder as the preselected library folder, I assume that the original files stay at the original file path, but do they stay also in the current library? I see that they are copied to the new location via file manager. But do this mean, that they are now also a duplicate in the library (since i added the folder as additional folder via Tools > Settings > Collection)?
New extract SQL from Media Monkey
I have reworked my initial SQL to extract the data from Media Monkey database for importing to Strawberry a little bit:
This ne one, extracts also filesize (can be used to identify the song in strawberry), mtime and ctime, where the 2 additional date fields are used for date added to database and modified last time. You can use filesize to identify easier the song in Strawberry. Mostly this can be unique, but sometimes you will have multiple files with the same filesize. In this case, you should use additional conditions to find the right entries.
To find if filesize is unique across your database, you can use:
SELECT FileLength, Count(FileLength) FROM Songs GROUP BY FileLength HAVING Count(FileLength) > 1;
If the result is empty, FileLength is unique across the database. If the result contains entries, you should use additionally markers to find the right song, but all you need is in the next SQL:
SELECT Artist as artist, Album as album, AlbumArtist as albumartist, TrackNumber as track, DiscNumber as disc, SongTitle as title, PlayCounter as playcount, IIF(LastTimePlayed > 1, strftime('%s', datetime(LastTimePlayed + 2415019.0)), -1) as lastplayed, FileLength as filesize, strftime('%s', datetime(FileModified + 2415019.0)) as mtime, strftime('%s', datetime(DateAdded + 2415019.0)) as ctime FROM Songs ;
This extracts the whole database, the last SQL extracted only songs with playcount > 0, because now i include also mtime and ctime.
Have fun with migrating.
RE: Sync/Transfer songs to Android?
I really have no idea, how i can get the titles of the current playlist to my device. I have read some topics about MTP. As a result, I have disabled automount for MTP and any other USB device. If i now doubleclick the Android device, something accesses the device and counts the media. But i cant open the device. If i rightclick and choose "device settings", the spinner loads now since 1 hour without an end. If i rightclick a song 2 minute mp3 file and choose "copy to device" and select OK in the dialog, i get "organize files" in the statusbar... also for ever... but nothing is transfered. The device is not mounted and never was in this session... Im a little bit clueless. How can i transfer the songs to my device?
Define action doubleclick on Playlist/Smart Playlist
As a new Strawberry user. I wish that I could doubleclick on a Playlist/Smartplaylist which replaces the current playlist.
Currently, doubleclicking a playlist will append the playlist to the current one. I understand that this is the default variant. But maybe there could be an option to re-configure the standard behavior, to define doubleclick to replace the current list or open a new list in another tab.