{"id":3923,"date":"2008-09-28T10:29:31","date_gmt":"2008-09-28T14:29:31","guid":{"rendered":"http:\/\/scruss.com\/blog\/?p=3923"},"modified":"2008-09-28T10:29:31","modified_gmt":"2008-09-28T14:29:31","slug":"cleaning-up-your-firefly-media-server-database","status":"publish","type":"post","link":"https:\/\/scruss.com\/blog\/2008\/09\/28\/cleaning-up-your-firefly-media-server-database\/","title":{"rendered":"cleaning up your FireFly Media Server database"},"content":{"rendered":"<p>mp3 tagging is a minefield. Like all metadata, one has to balance obsession with detail against ease of acquisition.<\/p>\n<p>Some <a href=\"http:\/\/fireflymediaserver.org\/\">Firefly<\/a> clients are pickier than other about tagging. Regrettably, some of the music I get from <a href=\"http:\/\/emusic.com\/\">emusic<\/a> has bad characters in the tags, which throws the players right off. Finding the problem files is the majority of the problem &#8211; here&#8217;s a method that at least helps:<br \/>\n<code>wget -O- http:\/\/host:port\/rsp\/db\/1 | perl -pwe 's,&lt;(?![\/\\?]),\\n&lt;,g;' &gt; firefly.xml<br \/>\nxmllint --noout firefly.xml<br \/>\n<\/code><br \/>\nYou&#8217;ll likely get a few lines like:<br \/>\n<code><br \/>\nfirefly.xml:463415: parser error : PCDATA invalid Char value 65535<br \/>\n&lt;title&gt;\u00ef\u00bf\u00bdSinging in the Bathtub&lt;\/title&gt;<br \/>\n<\/code><br \/>\nIn this case, the song title tag has some junk characters in it that you&#8217;ll need to fix. After cleaning up the tags and rebuilding the database, try this process again to see if you&#8217;ve caught all the errors.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>mp3 tagging is a minefield. Like all metadata, one has to balance obsession with detail against ease of acquisition. Some Firefly clients are pickier than other about tagging. Regrettably, some of the music I get from emusic has bad characters in the tags, which throws the players right off. Finding the problem files is the [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[7],"tags":[1332,1371,45],"class_list":["post-3923","post","type-post","status-publish","format-standard","hentry","category-computers-suck","tag-daap","tag-firefly","tag-mp3"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/pQNZZ-11h","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/scruss.com\/blog\/wp-json\/wp\/v2\/posts\/3923","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/scruss.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/scruss.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/scruss.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/scruss.com\/blog\/wp-json\/wp\/v2\/comments?post=3923"}],"version-history":[{"count":2,"href":"https:\/\/scruss.com\/blog\/wp-json\/wp\/v2\/posts\/3923\/revisions"}],"predecessor-version":[{"id":3925,"href":"https:\/\/scruss.com\/blog\/wp-json\/wp\/v2\/posts\/3923\/revisions\/3925"}],"wp:attachment":[{"href":"https:\/\/scruss.com\/blog\/wp-json\/wp\/v2\/media?parent=3923"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/scruss.com\/blog\/wp-json\/wp\/v2\/categories?post=3923"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/scruss.com\/blog\/wp-json\/wp\/v2\/tags?post=3923"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}