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

2006-01-03 Thread Steve Adeff
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?

2006-01-03 Thread Kevin Kuphal

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?

2006-01-03 Thread Steve Adeff
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?

2006-01-03 Thread Chris Doyle
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 [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?

2006-01-03 Thread Steve Adeff
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, 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 [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?

2006-01-03 Thread Kevin Kuphal

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, 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?
 

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?

2006-01-02 Thread Johan Kihlström
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


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

2006-01-02 Thread William Kenworthy
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?

2006-01-02 Thread Kevin Kuphal

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