Re: [mythtv-users] How do I add existing avi files to mythtv's recordings?
Chris Doyle wrote: 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, 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? This is a column in the SVN version of Myth related, I believe, to the file extension changes where MPEG files carry the MPG extension instead of NUV Kevin ___ mythtv-users mailing list mythtv-users@mythtv.org http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
Re: [mythtv-users] How do I add existing avi files to mythtv's recordings?
On Tuesday 03 January 2006 18:24, Chris Doyle wrote: > 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, 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 <[EMAIL PROTECTED]> 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 could be a different version. basename holds the filename of the recording, so look at your db and see what field holds this. mine references from the tv recordings folder, so once you find your field see how it works before continueing. I'll look into it further to see if I can do a db version check. as well, I can do some more intelligent name parsing if anyone has another format they'd like to use. -- Steve ___ mythtv-users mailing list mythtv-users@mythtv.org http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
Re: [mythtv-users] How do I add existing avi files to mythtv's recordings?
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, 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 <[EMAIL PROTECTED]> 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 ___ mythtv-users mailing list mythtv-users@mythtv.org http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
Re: [mythtv-users] How do I add existing avi files to mythtv's recordings?
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 tvgrabber-0.5.pl Description: Perl program ___ mythtv-users mailing list mythtv-users@mythtv.org http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
Re: [mythtv-users] How do I add existing avi files to mythtv's recordings?
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 ___ mythtv-users mailing list mythtv-users@mythtv.org http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
Re: [mythtv-users] How do I add existing avi files to mythtv's recordings?
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 -- Steve ___ mythtv-users mailing list mythtv-users@mythtv.org http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
Re: [mythtv-users] How do I add existing avi files to mythtv's recordings?
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 ___ mythtv-users mailing list mythtv-users@mythtv.org http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
Re: [mythtv-users] How do I add existing avi files to mythtv's recordings?
Thanks, thats the hint I needed! BillK On Tue, 2006-01-03 at 02:21 +0100, Johan Kihlström wrote: > tis 2006-01-03 klockan 09:02 +0800 skrev William Kenworthy: > > How do I add existing avi files to mythtv's recordings? > > > > Do I need to transcode into a particular resolution etc? > > > > BillK > > > > ___ > > mythtv-users mailing list > > mythtv-users@mythtv.org > > http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users > > > Any particular reason for not using MythVideo? > > Just drop the avi's in a designated library and tell Myth to update > video library. > > Tada! Your avi's easily accesible from within Myth through xine or > mplayer. > > Best regards > > Johan > > ___ > mythtv-users mailing list > mythtv-users@mythtv.org > http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users -- William Kenworthy <[EMAIL PROTECTED]> Home! ___ mythtv-users mailing list mythtv-users@mythtv.org http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
Re: [mythtv-users] How do I add existing avi files to mythtv's recordings?
tis 2006-01-03 klockan 09:02 +0800 skrev William Kenworthy: > How do I add existing avi files to mythtv's recordings? > > Do I need to transcode into a particular resolution etc? > > BillK > > ___ > mythtv-users mailing list > mythtv-users@mythtv.org > http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users Any particular reason for not using MythVideo? Just drop the avi's in a designated library and tell Myth to update video library. Tada! Your avi's easily accesible from within Myth through xine or mplayer. Best regards Johan ___ mythtv-users mailing list mythtv-users@mythtv.org http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
[mythtv-users] How do I add existing avi files to mythtv's recordings?
How do I add existing avi files to mythtv's recordings? Do I need to transcode into a particular resolution etc? BillK -- William Kenworthy <[EMAIL PROTECTED]> Home! ___ mythtv-users mailing list mythtv-users@mythtv.org http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users