comment / rating issue

General discussions.

Moderator: moderators

comment / rating issue

Postby housekat » Fri May 30, 2008 8:37 pm

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
 
Posts: 5
Joined: Fri May 30, 2008 3:26 pm

Re: comment / rating issue

Postby BluesBoy » Fri Apr 10, 2015 12:46 pm

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.

2,192 artists
7,155 albums
117,779 songs
3128.19 GB (~ 48,594 hours)
User avatar
BluesBoy
 
Posts: 21
Joined: Sat Apr 09, 2011 5:56 pm

Re: comment / rating issue

Postby killj0y » Mon Jun 01, 2015 4:59 am

I'm not currently doing anything like this but being able to have the software automatically add and modify this would be great.
killj0y
 
Posts: 24
Joined: Sun Dec 25, 2011 1:48 am

Re: comment / rating issue

Postby randomuser » Wed Oct 14, 2015 9:58 am

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
randomuser
 
Posts: 1
Joined: Wed Oct 14, 2015 9:40 am


Return to General

Who is online

Users browsing this forum: No registered users and 5 guests