question about database & song ratings

[spike66]

Hi

I'm almost a newcomer, so please forgive me if I'm asking something very obvious or that is explained somewhere else, I just haven't found it so far.

My question is, is there a way to upload to the database the song ratings for my music, other than "manually" one by one? Is there a special ID3 tag I should consider, a database file I could modify... Or should I just stop wondering and keep on rating them as I listen to them

Thanks in advance!

[bascule]

Unfortunately for you, there is  no other way...

[spike66]

It's allright, I'll just do it little by little.

Thanks for your answer!!

[ts-x]

It can be done but it's tricky...

[1] Rate your music using the MediaMonkey rating functionality, which writes the rating to its database library as well as the tag.
[2] Export your Rockbox database using the 'Export modifications' feature.
[3] Open the back end MediaMonkey database using a compatible database program (I use Microsoft Access but others may work as well).
[4] Create SQL and/or a macro that imports the file generated by the Rockbox, joins it with the MediaMonkey database using key fields (artist, song, album, etc) and then updates the ratings field of the Rockbox database based on the MediaMonkey ratings.
[5] Save the modified file in Rockbox compatible format on your player.
[6] Import the modified database file into Rockbox.

This is time consuming and not for the faint of heart, but at this point I don't think there's another way.  You have to work around a major database bug as well, see my open bug report here => http://www.rockbox.org/tracker/task/8360.

I'm hoping one day a "read rating from tag" feature in Rockbox may eliminate the need for this workaround.