Podcast with existing episodes

Need help? Post your questions here.

Moderator: moderators

Podcast with existing episodes

Postby sjthespian » Sun Jan 06, 2013 10:39 pm

I would like to use Subsonic for managing my podcasts since I don't always have iTunes or gPodder running. I have quite a few podcasts where I already have existing episodes, but if I add them to Subsonic it downloads these episodes all over again and puts a "0" at the end of the filenames. Is there a way to convince Subsonic to not download episodes that already exist in the podcast directory?
sjthespian
 
Posts: 1
Joined: Sat Jan 05, 2013 4:27 am

Re: Podcast with existing episodes

Postby jowtron » Tue Jan 22, 2013 1:21 pm

Yes, I also have this problem which arises if a new install is needed, when you restore the files the podcast settings are lost and they no longer display in the podcast tab of minisub unless you download them all again. It would also be nice if there was an option to back up all subsonic settings to a file.
jowtron
 
Posts: 11
Joined: Thu Dec 20, 2012 11:37 pm

Re: Podcast with existing episodes

Postby tsull360 » Sun Feb 02, 2014 6:51 am

I'm sure its wildly unsupported, but I've taken to manually inserting podcast files into the database. This enables me to reference existing files in the podcast section (I have some files for podcasts which no longer exist).

The first step involves creating the podcast channel:
insert into podcast_channel (ID,URL,TITLE,DESCRIPTION,STATUS) Values (6,'http://www.foo.com','Test Insert','Testing Manual Insertion','COMPLETED')

The second step involves inserting the actual podcast episodes. To do this you first need to retrieve the channel ID assigned from the step above:
select podcast_channel where TITLE='Title From Above'

Then use the value returned in the command below.
insert into podcast_episode (ID,CHANNEL_ID,URL,PATH,TITLE,DESCRIPTION,PUBLISH_DATE,DURATION,BYTES_TOTAL,BYTES_DOWNLOADED,STATUS,ERROR_MESSAGE) Values (371,6,'http://www.foo.com/stuff.mp3','c:\foo\stuff.mp3','Test Title','Description','2014-01-27 06:00:00.0','1:00:00','200','200','COMPLETED','')

Not user friendly (and not meant to be), but is doing what I need.

Tim
tsull360
 
Posts: 8
Joined: Thu Mar 29, 2012 8:33 pm


Return to Help

Who is online

Users browsing this forum: No registered users and 95 guests