podcast_to_csv.rb

podcast_to_csv.rb

require 'rss'
require "csv"

rss_source = File.new('feed.xml')
rss = RSS::Parser.parse(rss_source, false)

CSV.open('test.csv','w') do |csv|
    rss.items.each do |item|
        title = item.title
        date = item.pubDate.localtime.strftime('%Y/%m/%d')
        duration = if item.itunes_duration then
            sprintf('%02d:%02d:%02d', item.itunes_duration.hour, item.itunes_duration.minute, item.itunes_duration.second)
        else
            ''
        end
        link = item.link
        summary = item.itunes_summary
        csv << [date, title, duration, link, summary]
    end
end