I want to create a smartplaylist, where the lastplayed field should be the trigger. What i want is a list with songs, not played in the last year or older. This list should be sorted first by lastplayed field, then by Albumname, then by Tracknumber, so that the oldest, not played titles comes first, but the album should stay intact in order of the tracknumber.

Currently i have no idea how to build this list. Can anyone please help?

If i right-click my songs or songs in a playlist, I can reorganize them. There is a field for naming conventions, where i can enter placeholders to rename the files and folders. Normally, I use a pattern like %albumartist/%album{/%disc}/{%track - }%title.%extension. This creates a album folder under the albumartist folder, followed by a disc number folder, if a disc number is set in the tags.

Is there some way to replace the placeholder {/%disc} with a placeholder, where disc is only created, when there is more than 1 disc (e.g. disc count > 1), instead of disc <> empty?

Ahh found it. You can define the behavior in Tools > Settings > Behavior > Double click a song > Open in new playlist

There is a plugin/way to sync stats like playcount and lastplayed from last.fm to Strawberry. Is it possible to code a similar plugin/way for libre.fm?

Or can someone please tell me, how I can create such a plugin by myself? Is there some plugin template?

@torgo i have not tested this, but maybe you can use a 'bind mount', instead of a symlink.

@orinovet

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.

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.

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)?

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.

@buffalo many thx. Done

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?