[mythtv-users] How do I add existing avi files to mythtv's recordings?

Chris Doyle umaro at comcast.net
Tue Jan 3 23:24:50 UTC 2006


Steve,

This is great! just one small problem.

Upon execution, it grabs the show info just fine from TV.com, but the query fails with a message of

DBD::mysql::st execute failed: Unknown column 'basename' in 'field list' at /root/tvgrabber-0.5.pl line 571, <STDIN> line 1.

apparently basename is a column in your mythconverg.recorded table, but not mine (latest knoppmyth)

Did you add the basename column to your db, or am I just using a different version than you?

Thanks!
Chris Doyle

On Tue, 3 Jan 2006 09:52:54 -0500
Steve Adeff <adeffs at gmail.com> wrote:

> On Tuesday 03 January 2006 09:28, Kevin Kuphal wrote:
> > Steve Adeff wrote:
> > >On Monday 02 January 2006 20:57, Kevin Kuphal wrote:
> > >>William Kenworthy wrote:
> > >>>How do I add existing avi files to mythtv's recordings?
> > >>>
> > >>>Do I need to transcode into a particular resolution etc?
> > >>
> > >>In the contrib folder of the mythtv source is a script named
> > >>myth.rebuilddatabase.pl that will take an "--ext avi" command-line
> > >>option to import AVI files into Watch Recordings.
> > >>
> > >>Kevin
> > >
> > >I made a modified version of this that scrapes tv.com for show information
> > > and then adds it to the Watch Recordings list. If this is something that
> > > people might want to play with let me know and I'll post it to the list.
> > > I've used it for adding a few shows so far and its great, the g/f asked
> > > about this cause I refuse to manage MythVideo for episodic stuff....
> >
> > I'd love to see this.  I have the skeleton of an "Import Recordings"
> > screen for the frontend but I'm lacking the script that will automate
> > this to the point of making it useful.
> >
> > Kevin
> 
> Here's my script, I wrote it first as a tv.com scraper, then added the calls 
> needed for MythTV. I'm new at PERL and coding in general, I'm sure it could 
> use some cleaning up, etc. So if anyone has any changes/etc drop me an email 
> and I'll add them. One thing I'd like to have is a way to add the more 
> detailed show information and better db error checking.
> 
> I do have it set to use the filename as the show name/seasoninfo input since I 
> have a specific naming scheme I use, This could easily be taken in as 
> arguements if needed for some other purpose.
> 
> -- 
> Steve



More information about the mythtv-users mailing list