atreiu
Great, that's very promising! Thanks! :-)
It would be excellent, if you could implement Song-Identification via File-Hash, too (not only by tags).
RatingFile rsjtdrjgfuzkfg
Im-/export Ratings, Play- and Skipcount!
Description
This Add-On gives you the opportunity to im-/export Ratings, Play- and Skipcount from/to a file.
You can find it in the Tools Menu.
Features:
Version 0.0
Simple Im-/Export
Version 0.1
Progress-bar
Options Dialog
Version 1.1
Compare File-Hash
Version 1.2
Im-/Export also Last-Played-Date
Im-/Export also Imported-Date
Will come in future releases:
Without Version
Support for the rockbox-export format (by luffedelly)
If you like the Add-On you might translate it into your language:
Click here to go to Babelzilla.org
If the Add-On doesn't work at your machine, please post here!
Please post a comment and/or rate, don't be afraid posting bugs and ideas!
Release Notes
Added Option to im-/export Date Added
Images
(2)Comments
(72)Subscribe
rsjtdrjgfuzkfg
@atreiu:
Nice idea!
atreiu
Oh, I just tried an import (only ~2400 Songs) and Songbird was totally unresponsive for about 4min. I would prefer to see a status-bar and still be able to minimize/maximize Songbird.
But otherwise, it worked well! Everything is imported correctly, no problem. Good job! :-)
Jerome
Yes!!!!!!! Thanks!
rsjtdrjgfuzkfg
@atreiu:
progress-bar will definitely come. I didn't see the problem with my small (~400 Songs) Library.
topdownjimmy
Brilliant! I found myself just recently wishing for this functionality; definitely essential if you want to delete a messy profile and start fresh. Thanks!
SirSid
Thank you so much!
SirSid
You are my favorite plugin dev
GeekShadow
fr translation done :)
luffedelly
it is very good idea. thanks!
can you give me specifications of this file-format?
I just want to make a simple program for writing rating-info from rockbox-DB to this format, and back.
rsjtdrjgfuzkfg
@luffedelly:
Up to now the file-format is:
first line (version control) currently:
SB_RatingFile:
Later (when adding Hashes) there will be another header, but the Add-On will stay compartible.
After that, every line describes one song:
var line= escape(artistName)+unescape("\001")+ escape(trackName)+unescape("\001")+ escape(albumName)+unescape("\001")+ duration+unescape("\000")+ rating+unescape("\001")+ playCount+unescape("\001")+ skipCount
So there ist the escaped ArtistName, TrackName and Album Name and the plain text duration (each seperated by the character 1), after that the character 0 and the plain rating, play- and skipcount (also seperated by character 1)
All numbers are plain text, so for example 32 is the text "32", not the character 32.
luffedelly
ok. thanks! (:
and what about your source-code? is it available anywhere?
luffedelly
ok! no more need. I've found already (:
rsjtdrjgfuzkfg
@atreiu:
the progress-bar is there!
Hiromacu
@ rsjtdrjgfuzkfg: Good stuff! I see you put into my Hungarian [hu-HU] translation. Thanks! :P
luffedelly
excuse me, rsjtdrjgfuzkfg, are your sources free for use?
I want to make similar add-on to work with rockbox-database export format.
I don't know Javascript at all (never wrote before, never seen before). But yesterday I've tried to make minimum of required changes in your code (only import) and it works!
rsjtdrjgfuzkfg
@luffedelly:
The source is free for use (but it would be great to link this addon and register me as contributor)
If you want, you could also help me adding support for the rockbox-export-db format (maybe send me the xpi, you can find my email at the googlecode site of foldersync in the project owner section), so this addon could also export to the rockbox-export-db format. Of course you would be registered as contributor, too!
luffedelly
I don't know what is better, cause I want to make synchronization, instead of import/export. Import is simple, but I don't know how to export songbird-db to rockbox-export-db format, because it has some additional strange information.. Instead of that I can update rating and playcounter info in the existing rockbox-export-db file.
I'll send you code and explanation via e-mail.
rsjtdrjgfuzkfg
@luffedelly:
I think if import and export is theoretically possible, RatingFile would be a good place. If you want to make a real sync, you could try adding support to FolderSync. If there is no real sync possible, cause some data for new songs is missing and so on, you should release a seperate Add-On (maybe "rockbox-export-db file updater" or something like that)
rsjtdrjgfuzkfg
Version 1 is out!
topdownjimmy
This seems to stall Songbird completely for me when I try to export. Using Songbird 1.1.2 (build 1042) with Ubuntu 9.04 32-bit, and version 1.0.0.0 of this add-on.
luffedelly
2 topdownjimmy,
how big is your media-library? does progress-bar move or does everything just stall?
topdownjimmy
Sorry, I should have been more specific. I have 1835 albums. The progress bar doesn't move, nor does the percentage increase. Everything in Songbird becomes unresponsive and I have to kill the process.
rsjtdrjgfuzkfg
@topdownjimmy:
Does Songbird takes full CPU?
topdownjimmy
@rsjtdrjgfuzkfg:
It doesn't take full CPU (in fact not much at all), and to be more accurate, it doesn't stall Songbird completely; Songbird becomes unresponsive, but music continues to play.
The RatingFile progress window just sits there at 0% indefinitely.
rsjtdrjgfuzkfg
@topdownjimmy:
Here you can find a debug Version. Please post the messages you get!
sauntimo
I think this is an awesome idea, but evertime i run it, it crashes at 98% on an export. I'm on Xp SP3 - any advice?
rsjtdrjgfuzkfg
@sauntimo:
Wich OS do you use? Works fine under my XP SP3 and Ubuntu 8.10.
As you might see above, topdownjimmy has reported some problems with Ubuntu 9.04.
There is a new debug version, you can get it here.
The debug version will show MANY messages, post at least the last one here, so I can see where the problem is. Try it with a small library to get not that many messages (maybe with the last added ~20 songs in a clean profile?)
rsjtdrjgfuzkfg
@sauntimo:
Sorry, I read your comment at getsatisfaction and thought there would be the same. Ignore the OS-Question, but the debug version could help you!
sauntimo
Awesome, I'll try it out. Cheers! :)
rsjtdrjgfuzkfg
@atreiu:
The File-Hash is there ;)
topdownjimmy
@rsjtdrjgfuzkfg
UI Locked
FilePicker will be generated...
FilePicker returns OK or Replace
Got File and Stream
Wrote Header
Got LibView
Got SBProperties
Going to start with the songs; There are 19457 Elements
Done 0/19457.
Progress: 0%
Done 1/19457.
Progress: 0.0051395...%
[...]
Done 18/19457
Progress: 0.05.....%
--
At this point progress halts as usual, and I need to kill the songbird process.
Is it possible that one of the tracks in my library has wonky metadata or something that results in an error? What sort order does RatingFile use before it starts outputting data?
topdownjimmy
The file that was created won't open in a text editor, but I was able to see it in the terminal:
SB_RatingFile:
The%20OrganSinking%20HeartsSinking%20Hearts129000000
The%20OrganThere%20Is%20Nothing%20I%20Can%20DoSinking%20Hearts133000000The%20OrganWe%27ve%20Got%20to%20MeetSinking%20Hearts147000000
The%20OrganIt%27s%20Time%20to%20GoSinking%20Hearts177000000
The%20OrganI%20Am%20Not%20SurprisedSinking%20Hearts155000000
The%20OrganNo%20One%20Has%20Ever%20Looked%20So%20DeadSinking%20Hearts115000000ll14null
The%20OrganSteven%20SmithGrab%20That%20Gun126145000
The%20OrganBrotherGrab%20That%20Gun241528000
The%20OrganNo%20One%20Has%20Ever%20Looked%20So%20DeadGrab%20That%20Gun117000000ull14null
The%20OrganBasement%20Band%20SongGrab%20That%20Gun252682000
The%20OrganLove%2C%20Love%2C%20LoveGrab%20That%20Gun211748000
The%20OrganSinking%20HeartsGrab%20That%20Gun129933000
The%20OrganMemorize%20the%20CityGrab%20That%20Gun190000000
The%20OrganI%20Am%20Not%20SurprisedGrab%20That%20Gun164000000
The%20OrganThere%20Is%20Nothing%20I%20Can%20DoGrab%20That%20Gun155000000l
The%20Organ%5Buntitled%5DGrab%20That%20Gun37000000
The%20OrganA%20Sudden%20DeathGrab%20That%20Gun174628000
So apparently these are sorted by Date Added. The next file it should grab has some non-English characters in the metadata, which may be causing the problem.
Album: El Triángulo de las Bermudas
I can email you this track if you want to take a look at it.
Mozzer
Hey rsjtdrjgfuzkfg,
And thank you very much for a great plug-in. It's almost perfect now.. I have a few ideas to improve it further if you're interested...
Option for Exporting/importing Last played date, along with playcount, ratings and so on.
Option for Exporting/importing Playlists (I don't know if this is possible at all, but it would be a nice feature to have)
These are the only 2 features missing for making this the perfect back-up plugin IMHO...
Once again thank you...
Mozzer
Mozzer
Ups, I forgot to say.. I'm also having a problem when turning on the "File-hash" option.. It just stops at 25% and then locks up.. Just doing nothing... But maybe someone else is having the same problem??
rsjtdrjgfuzkfg
@topdownjimmy:
Thanks for your debug report. Yes, it gets the songlist sorted by date added, I tested it by giving a song the described album, and it worked.
Does something show up in the error console (open it before opening the dialog)?
@Mozzer:
To the file-hash-issue:
Does something show up in the error console (open it before opening the dialog)?
To the feature ideas:
Last played: We will see, added to the will come!
Playlists: How importing a playlist should work? The objects in the database are the same. So an option to export only one playlist would be possible, the normal import would change the exported objects in ALL playlists and the library.
topdownjimmy
@rsjtdrjgfuzkfg: No, nothing in the error console. Shall I send you the file? My email address is topdownjimmy@gmail.com. Thanks.
Mozzer
Thank you for your answer rsjtdrjgfuzkfg, now regarding the file-hash isse.. No, it dosn't show anything in the error console. It just stops at 25% and freezes up (I've tested it about 10 times) and I have to CTRL+ALT+DEL to stop the program....
Your idea of possibly exporting/importing one whole playlist with all the information in (Including last played date:) is absolutely genius.. Then we would have no problem going from Win to Linux to Mac and back again.. It would also help restoring the library after a crash, it would be a complete library back-up add-on... Please add this to the future will come list aswell:)
Naatan
Does this just import/export or does it also sync?
Reason I'm asking is because I would like to sync my home pc ratings with my work pc.
rsjtdrjgfuzkfg
@Mozzer:
Could you try to open the up to there created rating-file and look into your library (sort by date added) and check-back what the next song would be? And it works when you disable hashes?
Strange....
No idea. Looks like I will release a new version with more possible error messages in the next weeks ;)
@Naatan:
It does just im- and export. So the only thing you could do is importing when arrive at a pc and export when leave a pc...
Or you write the ratings in tags (about:config -> songbird.metadata.ratings.enableWriting) and use an external drive for the songs.
Mozzer
Yes, it works when I disable hashes.. It takes about 2 minutes or so for my library when hashes is off, and then there is no problem...
EEKaWILL
When i saved my ratings from my sb on my windows computer i tried to import on my Ubuntu computer and it didn't even recognize the .srf i saved to my flash drive for some reason
rsjtdrjgfuzkfg
@EEKaWILL:
What means "recognize"? Throws it an "bad header" exception?
The "bad header" might occur if you want to import a rating-file with hash-informations into a songbird with RatingFile 1.0.0.1 or older installed.
topdownjimmy
@rsjtdrjgfuzkfg: Just realized my problem...many of my files had "invalid encoding" as a result of being moved from an old Windows NTFS drive. Fixed them all and it now works!
Mozzer
@rsjtdrjgfuzkfg,
Just wanted to let you know that I got it working.. I don't know what the problem was (other than I'm using Vista). If I run Songbird as an Administrator, then it finishes perfectly, even with hashes on. Just so you know..
rsjtdrjgfuzkfg
@topdownjimmy,Mozzer:
Nice! :)
@Mozzer: Seems like your "normal" account isn't allowed to open those files?! Vista... ;)
kingsinger
I'd also like to be able to sync the Rockbox database with the songbird one. Love to see this and the foldersync add-in somehow integrated to together, so that Rockbox enable UMS devices can sync smart playlists from SB and have the metadata update in both directions.
rsjtdrjgfuzkfg
@kingsinger:
luffedelly has developed im- and export for the rockbox-db export format. But there are still bugs in the import-part of the code, so there is some debugging work to do. If you want to do this, you can send me an eMail (see FolderSyncs homepage). If not, you will have to wait...
Maybe I will work on this in the next time, maybe later...
Rune
It would also be awesome if this program backed up the "Last Played Date" for each song as well. Just some useful info to have.
Thanks!
christian81
@rsjtdrjgfuzkfg how can make manually a file to import ratings? I lost my ratings, but i have the database of library (is corrupt), and I made a list with the songs that I want import ratings, can you tell me which columns from the database I need to build a file.
I have someone...
file%20name | artist | album | duration? | year? | rating | then.. and I have NULL | NULL
I have access to library database, Can I see the source code?
Thx man this can save my ratings (more than 20,000 songs).
rsjtdrjgfuzkfg
@christian81:
There art two RatingFile (*.srf) formats, both are compartible to the current versions of RatingFile, I would recommend you the format without hashes (for files with hashes you would have to calculate the hashes of all files externally, if you have no acces to a working songbird with RatingFile, cause Songbird doesn't store file-hashes in database).
RatingFiles are splitted in lines:
The first line is a kind of header to recognize if the file is a RatingFile, wich is
SB_RatingFile:
Each other line represents one track in the library; format:
<artist><#1><title><#1><#1><album><#1><duration><#0><rating><#1><playcount><#1><skipcount>
Important is that <artist>, <title>, <album> are escaped. Escape means, that for example a space character is changed to "%20" and a ' to "%27".
So, each line is described in RatingFile as
var line= escape(artistName)+unescape("\001")+ escape(trackName)+unescape("\001")+ escape(albumName)+unescape("\001")+ duration+unescape("\000")+ rating+unescape("\001")+ playCount+unescape("\001")+ skipCount;You can find the whole source, in the Add-On file (*.xpi, download for each version of RatingFile here), for example of 1.1.0.1.
The xpi is a zip archive, browse to chrome\content to get the *.js sources. The source file with the whole file-format is dialog.js.
christian81
@ rsjtdrjgfuzkfg:
Thank you very much!!!!, I have playing with the database and I have a file with some tracks like this.
Aly%20&%20Fila|Rosaires|A%20State%20of%20Trance%202009|227343000|5
Neptune%20Project|Aztec|Dream%20Trance|258742000|5
...
...
but... is this a ascii code? -------> <#1> and <#0> between the fields?
I saw the source code but it's very diffcult to understand, I'll want to manipulate the list adding special characters with PHP or some basic programming language, thanks to the database I have the correct order (artist, title, album.....).
Is there a problem deleting the last 2 fields (playcount, skipcount)??? or I need to set NULL's ? ... to fill in the correct order.
Thx man for your help.
christian81
It's works perfectly! I had a lot of problems with the NULL & return car characters.. I export to mysql database and then to a file .txt, with a notepad & C++ script I replace characters and Voilaaaaaaa!!
It's import the ratings perfectly.... THX THX A LOT!
rsjtdrjgfuzkfg
@christian81:
You're welcome ;)
DJTeez
I seem to be having the same problem. The addon locks at 94% and renders the whole program, inactive.
I'm not a computer wiz so have downloaded your debug but dont quite know what to do with it next. It just sits there smiling at me in my downoad folder ;:-)
Am I supposed to cut and paste it somewhere??
Please advise... many thanks
rsjtdrjgfuzkfg
@DJTeez:
The debug version is a xpi-Addon like every other Songbird Add-On, so you can install it via drag'n'drop (Windows only) or via Tools|Add-Ons or the preferences, in the addon section there should be a button labeled "install...". open the xpi and use RatingFile as usual, you will get debug output (hint: the debug version bases currently on 1.0.0.1, so the file hash feature is missing)
Erikw
Would be cool if can import/export ratings to comments field. For iTunes there's a script that will do just that. So if RatingFile could do this too I can sync ratings between iPhone and Songbird - now that would be sweet!
rsjtdrjgfuzkfg
@Erikw:
You mean, RatingFile should set the comment tag to for example "5" if the Rating is 5 stars?
mulluysavage
I would like to store my library on a NAS, and access it from Songbird on my desktop and MythTV from my entertainment center. I would like the two systems to share ratings, last played, date added, and other information. Is there a way I can do this at all? Where does songbird save this information?
rsjtdrjgfuzkfg
@mulluysavage:
I don't know an easy way to do this :(
The Library informations (including Rating, Skip- and Playcount) are stored in a database file in your profile folder.
To access the data you can either access this file directly or you write a songbird addon. Take a look at the source of RatingFile to see how you can access the database. If you need help with coding such an AddOn, write a eMail, I will see if I can help you. A good start is the Mozilla Development Center.
mulluysavage
Thanks for the generous offers of help. Can you help me find the profile folder? What would it be named/ where would it be?
rsjtdrjgfuzkfg
@mulluysavage:
Your profiles are stored in
<songbirddirectory>\Profiles\
<songbirddirectory> is the path to your songbird user data folder, for example (Windows)
C:\Documents and Settings\<username>\Application Data\songbird2 C:\Users\<username>\AppData\Roaming\songbird2
Under linux look into your home folder, there should be a .songbird or .songbird2 or similar...
mulluysavage
Hmm there is no folder named Profiles in the Songbird directory on Linux, and I can't seem to find the user data folder. Strange, that my .ini file specifies Songbird2 as the profile, then a search using Catfish does not turn up a file by that name. Any penguins in the house?
rsjtdrjgfuzkfg
@Rune,Mozzer:
Version 1.2 does implement the last-Played dates/times :)
Yadonashi
Absolutely brilliant! I have been waiting for something like this for a long time. This might just make me choose to return to Songbird once again. :)
ruipenunes
Hello rsjtdrjgfuzkfg!
Thank you very much for all your work on this add-on.
If I'm not mistaken, you're just a few steps away from creating the first draft of a songbird profile rebuilder (backup).
There are some great ideas on this matter here, for example exporting/importing information about the installed add-ons:
http://getsatisfaction.com/songbird/topics/rebuild_profile_tool
But I would already be extremely thankful if you could manage to simply add an option for exporting/importing "Date added".
Please consider this. Right now I'm having to create another SB profile, since I'm having a few problems after installing the 1.4.1, so having this option would be awesome.
Thanks again for your work!
rsjtdrjgfuzkfg
ruipenunes:
If you want, I add it to the will come...
Look above ;)
The profile backup thing... I already thought about it.
What is to save:
-The library
Thought: The music could be anywhere. Auto-Importing the music files is not possible. But importing one or two folders in Songbird is a thing everybody can do without much problems.
The parts of the library that are not in the Files, these parts should save this Add-On: Ratings, Counter and Dates (Thanks for the import-date-ides).
-The Add-Ons
How to save Add-Ons? I really don't know how to do this out of an Add-On. Maybe the user can save a extension list (there is another Add-On for that), and install them.
-The preferences
This is a problem. What everybody could do is backup the prefs.js in the profile folder. This could be made automatically, of course.
Anything else?
I think that for the not in the tags saved information this AddOn is a suitable way.
For the backup of one file - If somebody want I can write such an "Preference Backup" Addon. This is a nice idea.
The problem is, how to connect both?
Maybe the Preference Backup can communicate with RatingFile if it is installed.
I think this is the best way. If I can find some time anywhere, I will write such an AddOn. Nice Idea!
rsjtdrjgfuzkfg
@ruipenunes, all:
The backup-AddOn "BackupBird" is there ;)
ruipenunes
Hello rsjtdrjgfuzkfg!
Thank you so much. I really appreciated your "christmas gift".
If only every add-on developer could be half as fast as you...
I'll try BackupBird as soon as I can, but in the mean time please update to 1.4.3.
Thanks again for all your great work!
rsjtdrjgfuzkfg
@ruipenunes:
You're welcome!
I didn't saw the update to 1.4.3... wasn't available via update...
Will release the new versions as soon as I can!
rsjtdrjgfuzkfg
@ruipenunes:
Date Added is there ;)
Log in to Post a Comment
Statistics
Downloads: 4,646
Average Rating:
based on 11 ratings
based on 11 ratingsImages: 2
Comments: 72
Last Updated: 2 months ago
Details
Share
Embed:
Share:
Other Add-ons by rsjtdrjgfuzkfg
cristian3100
Thanks, excellent add-on