Rockbox Technical Forums

Third Party => Other Utilities => Topic started by: adamgolding on April 12, 2009, 06:52:46 AM

Title: Library Management -- database syncing between desktop & Rockbox?
Post by: adamgolding on April 12, 2009, 06:52:46 AM
I am switching back to rockbox, but am having trouble finding a suitable desktop program to use in conjunction with it.  I'm hoping to find a windows program such that I can do the following with rockbox:

   - synchronize playcounts
   - synchronize track ratings
   - synchronize album ratings
   - synchronize playlists

I have looked long and hard but am generally unable to tell, for a given program, if some combination of plugins and scripts and so on would allow me to do this or not.  Has anyone successfully done the above with Rockbox and a Windows program?  How!?
Title: Re: Choice of Desktop Software for use with Rockbox?
Post by: LambdaCalculus on April 12, 2009, 11:48:37 AM
This is not an easy topic to discuss, nor is it really Rockbox-related. Whatever program you want to use to sync music to your player is entirely up to you. Most people have their own opinions as to what works for them and what doesn't, and one man's app is probably not meant for the next guy.

Just experiment with different apps until you find the one that works for you.
Title: Re: Choice of Desktop Software for use with Rockbox?
Post by: Chronon on April 12, 2009, 02:04:41 PM
I am not aware of any applications that do these tasks out of the box.  Rockbox can export its database changes to a text file (provided you told it to track these things).  If you can figure out how a given desktop application stores this information then it shouldn't be too great a task to do this synchronization in each direction.

As LambdaCalculus379 pointed out, this is more of a question about 3rd party applications than about Rockbox, so I moved it to the Other Utilities forum.
Title: Re: Library Management -- database syncing between desktop & Rockbox?
Post by: adamgolding on April 13, 2009, 05:55:16 AM
Well, since interoperability depends on the behavior of both programs, and also is a factor in determining the quality of both programs, it's as much a rockbox question as it is a foobar/winamp/songbird/amarok/etc. question.

As came up on the mailing list, this might be much more feasible if rockbox wrote ratings and playcounts to the files--I've been told before that this would wear out the flash, but as the owner of a HDD player I certainly desire the option, if no other solution is available..

That being said, my hope is that at least one windows user has encountered this problem before and has found or created a solution to it--surely there is a rockbox user out there who syncs ratings to a windows machine?  This is also a basic usability issue and is probably a barrier to adoption of rockbox--I'll gladly write a guide for users if there's a way to do this with *any* program on windows..

Anyway, this issue does bear on rockbox behavior, and also on how it is marketed and documented for users.
Title: Re: Library Management -- database syncing between desktop & Rockbox?
Post by: Llorean on April 13, 2009, 06:37:08 AM
Well, since interoperability depends on the behavior of both programs

Depends on the behaviour, but doesn't actually require any action from our side. For example, take the fact that there are many tools that sync to iPods quite comfortably despite no cooperation from Apple.

Our database code is open source, the tools are available entirely for any project to interpret and use our database format for keeping playcounts in line. At this point, the ball is in their court. So it really is a question for third-parties.

It's hardly a "basic" usability issue, since a large number of users don't feel the need to keep two separate libraries in sync. This is an advanced usability issue, and one the requires the actions of third parties to be solved. Pick your favorite open-source library management tool, and write a patch for them or a feature request.
Title: Re: Library Management -- database syncing between desktop & Rockbox?
Post by: Hillshum on April 13, 2009, 12:41:49 PM
There's a tool written to read the database of a Sansa and write that to MediaMonkey called SansaMonkey. It will read the Rockbox database on Sansas and other DAPs with Rockbox on them
Title: Re: Library Management -- database syncing between desktop & Rockbox?
Post by: BruceHP on April 14, 2009, 08:03:27 PM
I also use MediaMonkey.
Title: Re: Library Management -- database syncing between desktop & Rockbox?
Post by: rkdowner on May 26, 2009, 01:40:44 PM
I guess what I'd really like to see is RockBox for Windows :-)

So, should I make a feature request for this, or what?
Title: Re: Library Management -- database syncing between desktop & Rockbox?
Post by: GodEater on May 26, 2009, 03:08:59 PM
There already is Rockbox for Windows - it's called "The Simulator".

Check here for builds for windows (kindly provided by forum member rasher) :

http://www.rasher.dk/rockbox/simulator/
Title: Re: Library Management -- database syncing between desktop & Rockbox?
Post by: rkdowner on May 26, 2009, 04:15:05 PM
Thanks, but that's not quite what I meant...

Which of the many simulators simulates a PC? :-)
Title: Re: Library Management -- database syncing between desktop & Rockbox?
Post by: froggyman on May 26, 2009, 04:45:02 PM
Which of the many simulators simulates a PC? :-)
Those simulators are for simulating a rockbox device on a PC, not the other way around...
Title: Re: Library Management -- database syncing between desktop & Rockbox?
Post by: rkdowner on May 26, 2009, 07:32:35 PM
I was trying to be funny. As in, which one simulates the RockBox device "PC," as opposed to simulating "iPod Mini."
Title: Re: Library Management -- database syncing between desktop & Rockbox?
Post by: GodEater on May 27, 2009, 03:53:01 AM
I was trying to be funny. As in, which one simulates the RockBox device "PC," as opposed to simulating "iPod Mini."

I don't understand the question. The Rockbox simulator on windows plays music located on your PC, and creates a database of that music. What does it not do that you're after ?
Title: Re: Library Management -- database syncing between desktop & Rockbox?
Post by: kingsinger on November 27, 2009, 01:11:06 AM
Being able to sync play lists, play counts, etc. between the simulator data base and the data base on a copy of rockbox running on a portable device would be helpful.

For people who like to just drag and drop static play lists or directories of their music onto the player and manage it from there, rockbox works great. It's super powerful compared to pretty much any other player firmware, because it is was designed to be self-contained and untied to any particular desktop client.

Along the same lines, if I had my entire music library on my player, RB seems great for that scenario too. All I'd really need is to add new music to the player. Then I could just manage everything from there. The RB Database tools are complicated and basically have a command line interface that's not particularly accessible to people who aren't super technically inclined, but they do seem powerful in terms of building smart filters, etc. If that was my situation, I could learn how to use those tools, and get the functionality I need from them.

But for someone with a limited capacity player who likes to have an algorithmically generated, dynamically changing body of content on the player, it's a definite limitation that there doesn't seem to be any straightforward way for average non-techies (or maybe anyone) to sync their player DB info with a DB on their computer that relates to their entire music library, so that things like smart play lists based on things like play count, date added, ratings etc. can be updated, and you can easily put this new stuff on the player.

This, I think, is the crux of the comments above about these needs being basic usability issues. This may not be important to everyone, but it's definitely something that every ipod/itunes user takes for granted. I know I do with my ipod touch, and it's one of the things that makes a smaller capacity player a workable thing for me.

It's very convenient to have a smart play list for content added in say the last 4 weeks and to be able to have that go on the player automatically as it changes on the computer. The same goes for a rather intricate play list I built based on play counts, last played, etc. It gives me a nice balance of new music and old favorites. But it also shifts and changes over time as play counts change, get synced, and a song ascends from the 10-12 plays list to the 13-15 plays list, etc.

I find Rockbox to be so amazingly great in many respects on my Sansa E250. It makes the player so much more useful. But this particular limitation is something I'd love find a solution for.

The folder sync add-in for Songbird provides one piece of the puzzle. If I change songs in a playlist/directory on my computer, it will then make the same changes to that playlist/directory on my player.

What the add-in lacks is the feedback loop from the player, where the songbird library is updated first with run time data from the player, so the play list on the computer can be dynamically updated and then synced back to the player.

I think the developer of this add-on  actually started incorporating the Rockbox meta-data syncing aspect. Unfortunately, he said he didn't have time to work on this any further.

Part of this reluctance seems to be that he doesn't have time to get up to speed on how the RB database side would interrelate with his existing code. He also doesn't have Rboxed player to debug on. So if there is anyone else out there reading this, who has the technical skill/understanding of this stuff, it might make sense to reach out to this guy. Maybe with some collaboration with someone on this side of the fence, these features could be brought over the finish line.

To me, the combination of a ums directory sync (including relevant metadata) that works natively in Rockbox would be a huge win for both Songbird and Rockbox, because it would make Songbird so much more useful for so many people using so many different kinds of players.

It would also completely bypass proprietary stuff like MTP, etc., which seems to be at least a sub-text of both the Mozilla and rockbox projects. It would also be relatively easy to implement across platforms, which would be a big win too.

Anyway, I'm just a humble user of this cool firmware. I don't have the skills to act on any of the ideas above. Just being expansive and hopeful that maybe someone with the skills has an interest in seeing if some of this stuff could be made to work.

Happy thanksgiving.

Best,

KS
Title: Re: Library Management -- database syncing between desktop & Rockbox?
Post by: AlexP on November 27, 2009, 03:09:29 AM
Part of the problem here is that very very few of the developers use the database, and therefore don't feel inclined to work on it adding features they wouldn't use to an existing feature they already don't use, as Rockbox is after all a spare time volunteer project.

It needs someone who both wants these features and is willing to work on implementing them to do the work.
Title: Re: Library Management -- database syncing between desktop & Rockbox?
Post by: Llorean on November 27, 2009, 10:51:39 AM
It sounds like a large portion of what is wanted requires work on a PC side app anyway, outside the scope of the Rockbox project.

Basically, you need to be asking developers of PC-side tools (whichever's your favorite) to be adding in support to sync with Rockbox and its database, including modifying tagnavi, rather than feature requests to Rockbox itself. We can't do any syncing from our side.

Your argument that this is "basic usability" still ignores the fact that it doesn't really require action from Rockbox's side.
Title: Re: Library Management -- database syncing between desktop & Rockbox?
Post by: froggyman on November 27, 2009, 11:28:36 AM
couldnt it be built into RbutilQT manager?
Title: Re: Library Management -- database syncing between desktop & Rockbox?
Post by: AlexP on November 27, 2009, 01:31:52 PM
It is not the job of Rockbox Utility to be a media manager.
Title: Re: Library Management -- database syncing between desktop & Rockbox?
Post by: Llorean on November 27, 2009, 02:26:00 PM
Music management is covered by hundreds of programs tailored toward millions of individual preferences. RBUtil is for installation and management of rockbox itself, something they are unlikely to be able to stay up to date on. Meanwhile rbutil is unlikely to be able to meet the full range of syncing needs without a lot more people and time behind it, and then it becomes too large and bloated to be a primary installer. Basically bloatware - "to install Rockbox please download this giant program with thousands of other functions unrelated."
Title: Re: Library Management -- database syncing between desktop & Rockbox?
Post by: froggyman on November 27, 2009, 02:44:27 PM
It is not the job of Rockbox Utility to be a media manager.

I meant for the sole purpose of the database building. You know like by having another button added that builds the database for the music on the device, not to actually manage any music.
Title: Re: Library Management -- database syncing between desktop & Rockbox?
Post by: csavery on May 21, 2010, 08:30:30 AM
I use both Rockbox and Songbird with FolderSync. I've even provided patches for FolderSync in the past and been in contact with the developer. He was nice enough to add me as a contributor too. I have the ability to develop some sync->back feature for play counts. I'd need to know exactly what was the desired result and could attack it on a simplest solution basis.

I don't personally keep track of play counts so it wouldn't be of much use to me. Isn't that the only data item you would want to send back to Songbird?

Probably a small bit of code could read the playcount stats on rockbox and add them into Songbird during the sync, and then clear the stats so they don't get later added in again.