An Olive on top

The Olive music server has been a hit among hi-fi folks, and I have to admit, it's pretty cool. It does touchless CD ripping in uncompressed WAV or FLAC, and exists on the network as a UPNP server. It's interface makes it perfect for people who dont like computers, but want a media server. The O4HD does 192kHz/24bit music, and has won awards and accolades among those who take their music seriously.

And I'm going to tear one apart.

I have gotten a hold of an Olive 04HD hard drive. The files are stored in folders by album under a folder called AudioLibrary, though their names are obfuscated so that each folder looks like "CD_8b08ad0a". This makes it difficult to directly browse the music library.

The file zDB holds the key to these obscure file names. It is an SQL3 Database containing the following tables:

• t_album
• t_albumrel
• t_artist
• t_artistrel
• t_composer
• t_composerrel
• t_container
• t_genre
• t_genrerel
• t_object
• t_playlist
• t_track
• t_version
• t_work
• t_workrel
• zapprofile

t_track contains the path information, but only contains ID elements for the rest (of course). It doesn't seem to be as stright forward as I had hoped to string the bits from the different tables together into a coherent META tag. I am working on it, though, and hope to be able to produce at least a shell script to name all of the tracks in the database, freeing them from the grip of the Olive.