Subsonic Forum

It seems that the comments and the ratings are stored only in the database.
This is not convenient. Why?

Sometimes album folders should be renamed or moved to another subdirectory (i use genre based subdirectories for prefiltering). So the comments and ratings are lost. This is really annoying cause writing comments on a bigger collection is lot of work! Besides i'm little bit sceptical about database migration between different versions of subsonic.

Maybe it is not much additional work using a (human readable please!) textfile for the comments on each album folder? Just like the "folder.jpg" for the album art there could be a "comments.txt" for the comments. Maybe the ratings could be stored in the "comments.txt" too or in another file. Or maybe you can store the ratings in the tags on each file. But please do not store it in the DB.

Thank you!

housekat wrote:It seems that the comments and the ratings are stored only in the database.

This is not convenient. Why?



Sometimes album folders should be renamed or moved to another subdirectory (i use genre based subdirectories for prefiltering). So the comments and ratings are lost. This is really annoying cause writing comments on a bigger collection is lot of work! Besides i'm little bit sceptical about database migration between different versions of subsonic.



Maybe it is not much additional work using a (human readable please!) textfile for the comments on each album folder? Just like the "folder.jpg" for the album art there could be a "comments.txt" for the comments. Maybe the ratings could be stored in the "comments.txt" too or in another file. Or maybe you can store the ratings in the tags on each file. But please do not store it in the DB.



Thank you!

I have a large collection of music with over 7,000 folders of music. Each folder has a text file in it that describes the content of the folder. Information like track names, how the recording was made, when it was made etc. It would be fantastic if Subsonic could read this text file and add automatically add the text to the comments.

As it is now I have to go folder by folder and copy the contents of this text file by hand into the comments section. I any folder gets moved because of organization the comments have to get re-added. I recently re-organized my entire collection and now I have having to go by hand through over 7,000 folders to add back in the contents of the comments section.

Please consider adding this tweak to Subsonic.

I'm not currently doing anything like this but being able to have the software automatically add and modify this would be great.

Hi,

I'd like such a feature too. I'm managing my audiobooks with subsonic and use the comment field to provide a short description. While I synchronize the audiofiles from my nas to the subsonic server, it would take much work off my shoulders if I only need to add a comment.txt into the albums folder.

For the initial work of adding 1000s of descriptions I wrote a script which reads all comment.txt files under a directory and creates a database query, which could be submitted via the /db.view site. But an automated way would reduce a lot of work for maintaining these two sources for the description.

For the meanwhile this script might help the linux guys

Code: Select all

#!/bin/bash
test -z "$1" | echo "please provide your music-root folder: $0 FOLDER" && exit 1

find "$1" -name comment.txt | while read line; do
        CONTENT=$(cat "$line" | tr -d "'")
        PATHNAME="$(dirname "$line")"

        echo "UPDATE MEDIA_FILE SET COMMENT='$CONTENT' WHERE PATH='$PATHNAME';"
done