• Mac OS X Server

    Scrubbing Assets from Podcast Producer

    At some point, you may find that you would like to remove all episodes from Podcast Producer that were brought in using a specific workflow, or based on a specific keyword, a string in the title, a date, or the user that created the episodes. All of these attributes are trapped in the db.sqlite3 database for Podcast Producer. This database is stored in the Server directory of your shared library. Within this database there is a table called episodes. Using that table you can locate all episodes that match the given pattern. To query, you will use the sqlite3 command and identify the database path. A very basic incantation of…

  • Mac OS X

    Adding and Removing Bundle Flags

    The Mac OS X Developer Tools come with an application called SetFile, which can be leveraged to change the bundle flag attribute. For example to add a bundle flag to a sparse bundle that is missing one you could use the following (assuming the name is FILENAME): SetFile -a B ~/Desktop/FILENAME.sparsebundle To then remove the bundle flag: SetFile -a b ~/Desktop/FILENAME.sparsebundle