[mythtv-users] Manually inserting "recorded programs" into the DB and commercial flagging

[Iohan Reyes]

Thanks, after hunting down the missing perl modules for my FC5 install,
I tried this script and it meets my requirements.  

-----Original Message-----
From: mythtv-users-bounces at mythtv.org
[mailto:mythtv-users-bounces at mythtv.org] On Behalf Of Joel Means
Sent: Thursday, November 02, 2006 11:13 AM
To: Discussion about mythtv
Subject: Re: [mythtv-users] Manually inserting "recorded programs" into
the DB and commercial flagging

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Iohan Reyes wrote:
> I have a little bit of a background on mysql so I decided to poke
around
> in the mythconverg database.  I'm starting to understand how the
tables
> relate to one another, but am still learning.  My specific question
and
> the subject of this email is what table and which fields are
absolutely
> necessary to fill-in with information so that I can commercial flag an
> mpeg file that was recorded from outside of mythtv?
> 
> Here's the scenario, I have recorded a few programs on my Tivo and
> extracted them as mpeg files onto my MythTV box.  I have figured out
how
> to make them show up in the "Watch Recordings" list by inserting rows
in
> the 'recorded' table.  The reason I want them in "Watch Recordings"
> instead of in "Watch Videos" are purely for convenience and less
> confusion for other family members.  Now, the last step I would like
to
> accomplish is to commflag the mpeg files, but I'm not sure which other
> tables need to be populated with what info to make this possible.
> 
> 
> 
> 
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
> 
> 
If you look in the contrib folder of the sources, you will find a script
called 'myth.rebuilddatabase.pl' that is really handy for adding
external recordings to the database.  It works nicely and prompts you
for the title, subtitle, date, time, etc. fields.  It will also call
mythcommflag to build a seektable.  Then running a commflag job is
simple.
Joel
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.3 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFFShkB0tbb2uIZyCURAjC0AJ9tCU8L/iEY5h1eLOVoIqVYiMMzqACfcL9P
NvGedwd/5KTXj0m2DozjWkU=
=IsgR
-----END PGP SIGNATURE-----
_______________________________________________
mythtv-users mailing list
mythtv-users at mythtv.org
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users