Been talking with jjeff at SXSW about improving the iTunes support in the audio module. We did some brainstorming about how to integrate the channel data with views.

Comments

drewish’s picture

drewish commented

Seems like the best way to do it is add an audio_image table with fields for:

The code duplicate views_rss's rss argument. Adding a new local task to the edit view menu for configuring each channel.

zirafa’s picture

zirafa commented

why call it {audio_image} - wouldn't an audio_itunes or audio_podcast table make more sense?

I'm into this approach though.

drewish’s picture

drewish commented

whoops, totally a typo, audio_itunes is what it should have read.

jjeff’s picture

jjeff commented

following

drewish’s picture

drewish commented
Status: Active » Needs work

humm, well i was going to upload what i've gotten working but it's not allowing .module .info or .install files. this short of it is i've added hook_form_alter and hook_nodeapi implementations to add fields to audio nodes to specify per item itunes information. now i've got to get the views plugin stuff working to return the per channel information.

zirafa’s picture

zirafa commented

Here is the way the 4.7 playlist module stored iTunes/podcast data. The way it did channel categories was to simply use the taxonomy terms associated with the node - but since we aren't using nodes we'll need a table for it. Otherwise looks pretty similar to what is proposed.

// $Id: audio_playlist.install,v 1.3 2006/06/27 00:03:38 zirafa Exp $

function audio_playlist_install() {
  switch ($GLOBALS['db_type']) {
    case 'mysql':
    case 'mysqli':
      db_query(
<<<MYSQL_UPDATE
        CREATE TABLE {audio_playlist_metadata} (
          pid int(10) unsigned NOT NULL default '0',
          image_url varchar(128) default '',
          subtitle varchar(128) default '',
          author varchar(128) default '',
          copyright varchar(128) default '',
          owner varchar(128) default '',
          owner_email varchar(128) default '',
          explicit tinyint(1) NOT NULL DEFAULT '0',
          PRIMARY KEY  (`pid`)
        ) /*!40100 DEFAULT CHARACTER SET utf8 */;
MYSQL_UPDATE
      );
      break;
  }
}
drewish’s picture

drewish commented
Status: Needs work » Active

cool, that's pretty much what i came up with. i committed a beta version so if you could check it out and give me a little feedback i'd appreciate it. it attaches to the view and if you select the itunes rss feed view argument you'll get a little tab on the view to edit the itunes info.

stuff still to do:
- remove the record from audio_itunes_channel when the view is deleted.
- add some help text explaining what the module is and how it works.
- support for category and owner tags.
- other stuff flagged FIXME

steveparks’s picture

steveparks commented

subscribing

webservant’s picture

webservant commented

This will be cool if it can integrate with the existing views. I've succeeded in making a views list work for podcasts, but it is missing some of the itunes features. If this can integrate with the views modules so that we don't have to change the podcast link I'll be real happy.
Keep up the good work. The sooner you can give us this the better. I've got another podcast site starting up next week.

drewish’s picture

drewish commented

webservant, what's working is already in there. you'll need to change the view's RSS argument to the iTunes argument.

drewish’s picture

drewish commented
Component: Code » audio_itunes
Status: Active » Closed (fixed)

I'm going to close this and move the remaining TODO items into new issues:
http://drupal.org/node/175057
http://drupal.org/node/175058