Hi, new member here.
I've had a Plenue 1 for a few motnhs now, and I decided to start to try and address some of the knonw shortfalls of this great sounding player. I've come up with a few things other members might appreciate.
I now listen to all my music on this great machine, so one of the things that concerned me was getting Favorite lists stranded on the player. I did some rumamging around, and found the obvious storage location that the player uses. Its a SQLite3 database. You can find it at:
/Plenue1/System/.TAGDB/tag.db
I backup this database to my PC on every connection, and currently work with the PC copy. Using
SQLiteStudio, I now have full offline access to the favorite lists I have created on the Plenue. This SQL query will extract all tracks, for all favorite lists:
select e.group_name As Favorite, a.audio_title as Track, d.album_name as Album, a.file_name as File, c.artist_name as Artist from audio a, favorite_song b, artist c, album d, favorite_group e where b.audio_id=a.audio_id and a.artist_id=c.artist_id and a.album_id=d.album_id and b.group_id = e.group_id order by e.group_name, d.album_name
To use this query, you start SQLiteStudio, and open an offline copy database file. From the Tools menu, select Open SQL Editor. Then, paste the above query into the top right hand pane (it should be the SQL tab), and then hit F9. Voila. You can export the lsiting to CSV, or text of whatever. I haven't opimised this query - it just works, and that should be good enough for most people's purposes. This sort of offline querying is perfectly safe, and will not break anything.
Now, in theory (and I emphasise in theory), it may be possible to update the tables using this tool - which obviously gives rise to the possibility of importing playlists. I'll try and give it a bash over the coming weeks, and see if it is possible to update the database directly whilst connected in USB mode. Unoftunately, I'm heavily into exams mode at the moment, so I don't have a lot of time to play with this but I'll see if I can squeeze it in.