Re: [mythtv-users] Mass channel deletes
Bruce Markey wrote: Robert Johnston wrote: On 21/09/05, Bruce Markey <[EMAIL PROTECTED]> wrote: Michael T. Dean wrote: ... Good to know, but you're making me feel like I'm slacking on my own Adrian Monk-ishness. I spend way too much time cleaning my computer There are two spaces. ^^ There should only be one. systems, and now that you've mentioned another thing to clean, I'm sure I'll be much better about my channel deletes. I'll also have to check out MythWeb's delete channel code to see how much it cleans up for me--that might be an easier way to get it all clean. Is your Space key sticking? You could make a script with the TRUNCATE commands but maybe you should check your keyboard first. Have you cleaned your keyboard with rubbing alcohol yet this week? This is way OT, but some people do prefer to use 2 spaces after a full-stop (Period to you Americans), rather than one. It used to be the tradition (on Typewriters) to use two spaces after the end of a sentence to break them up a little. I See! Well, maybe this is something you'd like to discuss with Dr. Kroger =). Yep. Robert's right. I use the old-school two spaces after a period. I've scheduled an appointment with Dr. Kroger. Mike ___ mythtv-users mailing list mythtv-users@mythtv.org http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
Re: [mythtv-users] Mass channel deletes
Brian Puccio wrote: ... Two spaces after a period (or exclamation or question mark) was a Oh my goddness. For anyone else who's never heard of "Adrian Monk" and don't want to cause giggles for those who have, see: http://www.usanetwork.com/series/monk/index.html . If you are not in North America, it is quite possible that this award winning series about an obsessive compulsive detective will be syndicated in other countries. I highly recommend this if it is ever shown in your area. You can set a custom rule to catch this title if it ever shows up in your listings: program.title = "Monk" See: http://www.mythtv.org/docs/mythtv-HOWTO-11.html#ss11.8 -- bjm ___ mythtv-users mailing list mythtv-users@mythtv.org http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
Re: [mythtv-users] Mass channel deletes
On Wed, 2005-09-21 at 14:58 -0700, Bruce Markey wrote: > Michael T. Dean wrote: > ... > > Good to know, but you're making me feel like I'm slacking on my own > > Adrian Monk-ishness. I spend way too much time cleaning my computer > There are two spaces. ^^ There should only be one. > > systems, and now that you've mentioned another thing to clean, I'm sure > > I'll be much better about my channel deletes. I'll also have to check > > out MythWeb's delete channel code to see how much it cleans up for > > me--that might be an easier way to get it all clean. > > Is your Space key sticking? You could make a script with the TRUNCATE > commands but maybe you should check your keyboard first. Have you > cleaned your keyboard with rubbing alcohol yet this week? Two spaces after a period (or exclamation or question mark) was a practice that was started with typewriters to make it easier on the eye to see breaks in sentences which were hard to pick out given their monospaced font. With the advent of computers and proportional fonts like Times New Roman, the practice has since shifted to one space. However, one could argue that since this list is plain text and most likely read on a machine in a monospaced font, that one should put two spaces after a period. http://www.webword.com/reports/period.html for more information. signature.asc Description: This is a digitally signed message part ___ mythtv-users mailing list mythtv-users@mythtv.org http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
Re: [mythtv-users] Mass channel deletes
Robert Johnston wrote: On 21/09/05, Bruce Markey <[EMAIL PROTECTED]> wrote: Michael T. Dean wrote: ... Good to know, but you're making me feel like I'm slacking on my own Adrian Monk-ishness. I spend way too much time cleaning my computer There are two spaces. ^^ There should only be one. systems, and now that you've mentioned another thing to clean, I'm sure I'll be much better about my channel deletes. I'll also have to check out MythWeb's delete channel code to see how much it cleans up for me--that might be an easier way to get it all clean. Is your Space key sticking? You could make a script with the TRUNCATE commands but maybe you should check your keyboard first. Have you cleaned your keyboard with rubbing alcohol yet this week? This is way OT, but some people do prefer to use 2 spaces after a full-stop (Period to you Americans), rather than one. It used to be the tradition (on Typewriters) to use two spaces after the end of a sentence to break them up a little. I See! Well, maybe this is something you'd like to discuss with Dr. Kroger =). -- bjm ___ mythtv-users mailing list mythtv-users@mythtv.org http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
Re: [mythtv-users] Mass channel deletes
On 21/09/05, Bruce Markey <[EMAIL PROTECTED]> wrote: > Michael T. Dean wrote: > ... > > Good to know, but you're making me feel like I'm slacking on my own > > Adrian Monk-ishness. I spend way too much time cleaning my computer > There are two spaces. ^^ There should only be one. > > systems, and now that you've mentioned another thing to clean, I'm sure > > I'll be much better about my channel deletes. I'll also have to check > > out MythWeb's delete channel code to see how much it cleans up for > > me--that might be an easier way to get it all clean. > > Is your Space key sticking? You could make a script with the TRUNCATE > commands but maybe you should check your keyboard first. Have you > cleaned your keyboard with rubbing alcohol yet this week? This is way OT, but some people do prefer to use 2 spaces after a full-stop (Period to you Americans), rather than one. It used to be the tradition (on Typewriters) to use two spaces after the end of a sentence to break them up a little. Just a FYI. -- Robert "Anaerin" Johnston ___ mythtv-users mailing list mythtv-users@mythtv.org http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
Re: [mythtv-users] Mass channel deletes
Michael T. Dean wrote: ... Good to know, but you're making me feel like I'm slacking on my own Adrian Monk-ishness. I spend way too much time cleaning my computer I fixed your message. There is only one space now. -- bjm ___ mythtv-users mailing list mythtv-users@mythtv.org http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
Re: [mythtv-users] Mass channel deletes
Michael T. Dean wrote: ... Good to know, but you're making me feel like I'm slacking on my own Adrian Monk-ishness. I spend way too much time cleaning my computer There are two spaces. ^^ There should only be one. systems, and now that you've mentioned another thing to clean, I'm sure I'll be much better about my channel deletes. I'll also have to check out MythWeb's delete channel code to see how much it cleans up for me--that might be an easier way to get it all clean. Is your Space key sticking? You could make a script with the TRUNCATE commands but maybe you should check your keyboard first. Have you cleaned your keyboard with rubbing alcohol yet this week? -- bjm ___ mythtv-users mailing list mythtv-users@mythtv.org http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
Re: [mythtv-users] Mass channel deletes
Bruce Markey wrote: Michael T. Dean wrote: Since TMS currently adds "new" channels to all lineups (instead of allowing you to choose to lock in a lineup), and since I have DISH network (which is adding all the local stations around the country), I get new channels at least once a week (sometimes several channels per day). On one of their surveys, TMS asked if there should be an option to not automatically add channels. Appearently nothing has come of that. I'm sure in your situation I'd rather go in and check new channels periodically or when I fould out that my provider added a channel I want to receive. Yeah. I remember voting for that option. :) Glad to hear that it's not just some setting they've added since then that I haven't yet found. To keep the 13 channels to which I've subscribed, I've been deleting the channel and program information after updating my lineup at zap2it. However, I've never deleted any info from programrating, programgenres, credits, or people. It looks like it's been getting deleted after "expiring," but I wanted to verify that my (lazy) approach should not cause any problems. Mine was the Adrian Monk approach. Most of these have dates and will expire. "people" doesn't but it's a finite set and the same names come up again. If the program table is emptied so that you can't match a bogus show then the auxiliary info doesn't matter. AFAIK, this isn't a problem right now, however, there have been times in the past that mfdb may have leaked data by not cleaning up properly and I used to dump out all of these tables every so often just to be sure that I wasn't building up cruft. One thing you could do is "select count(*) from tablename;" to find what the normal sizes are and if any table is growing over time. Good to know, but you're making me feel like I'm slacking on my own Adrian Monk-ishness. I spend way too much time cleaning my computer systems, and now that you've mentioned another thing to clean, I'm sure I'll be much better about my channel deletes. I'll also have to check out MythWeb's delete channel code to see how much it cleans up for me--that might be an easier way to get it all clean. Mike ___ mythtv-users mailing list mythtv-users@mythtv.org http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
Re: [mythtv-users] Mass channel deletes
Michael T. Dean wrote: Bruce Markey wrote: Dave Sherohman wrote: Would I break my existing recordings or upcoming recording schedule if I just deleted all records from the channel table, then ran mythfilldatabase manually to reconstruct it? That would work but would leave behind program information that might be found in searches so you may want to remove all the program information also. $ mysql -u mythtv -pmythtv mythconverg mysql> truncate table channel; mysql> truncate table program; mysql> truncate table programrating; mysql> truncate table programgenres; mysql> truncate table credits; mysql> truncate table people; then run "mythfilldatabase" again. Since TMS currently adds "new" channels to all lineups (instead of allowing you to choose to lock in a lineup), and since I have DISH network (which is adding all the local stations around the country), I get new channels at least once a week (sometimes several channels per day). On one of their surveys, TMS asked if there should be an option to not automatically add channels. Appearently nothing has come of that. I'm sure in your situation I'd rather go in and check new channels periodically or when I fould out that my provider added a channel I want to receive. To keep the 13 channels to which I've subscribed, I've been deleting the channel and program information after updating my lineup at zap2it. However, I've never deleted any info from programrating, programgenres, credits, or people. It looks like it's been getting deleted after "expiring," but I wanted to verify that my (lazy) approach should not cause any problems. Mine was the Adrian Monk approach. Most of these have dates and will expire. "people" doesn't but it's a finite set and the same names come up again. If the program table is emptied so that you can't match a bogus show then the auxiliary info doesn't matter. AFAIK, this isn't a problem right now, however, there have been times in the past that mfdb may have leaked data by not cleaning up properly and I used to dump out all of these tables every so often just to be sure that I wasn't building up cruft. One thing you could do is "select count(*) from tablename;" to find what the normal sizes are and if any table is growing over time. -- bjm ___ mythtv-users mailing list mythtv-users@mythtv.org http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
Re: [mythtv-users] Mass channel deletes
Bruce Markey wrote: Dave Sherohman wrote: Would I break my existing recordings or upcoming recording schedule if I just deleted all records from the channel table, then ran mythfilldatabase manually to reconstruct it? That would work but would leave behind program information that might be found in searches so you may want to remove all the program information also. $ mysql -u mythtv -pmythtv mythconverg mysql> truncate table channel; mysql> truncate table program; mysql> truncate table programrating; mysql> truncate table programgenres; mysql> truncate table credits; mysql> truncate table people; then run "mythfilldatabase" again. Since TMS currently adds "new" channels to all lineups (instead of allowing you to choose to lock in a lineup), and since I have DISH network (which is adding all the local stations around the country), I get new channels at least once a week (sometimes several channels per day). To keep the 13 channels to which I've subscribed, I've been deleting the channel and program information after updating my lineup at zap2it. However, I've never deleted any info from programrating, programgenres, credits, or people. It looks like it's been getting deleted after "expiring," but I wanted to verify that my (lazy) approach should not cause any problems. Thanks, Mike Why I have to watch this closely: With the DISH network receiver, if you tune to a channel for which you do not have a subscription, the receiver displays a message, "You are not currently subscribed to channel " and asking you to call to add a channel to your subscription. Unfortunately, the only way to get out of this screen is to use channel up/down and then type in the channel number you want (i.e. you have to be on a subscribed channel to request a channel by number). I learned this could be a problem when I came back from a week-long business trip and found that I had 6 hours of "You are not currently subscribed..." DISH had added some local channels, which TMS added to my lineup (even though the FCC /forbids/ me from receiving "local" channels that are not broadcast from within my designated market area), which mythfilldatabase added to my Myth database. Then, when Myth noticed "King of the Hill" showing on one of them, it tried to record it. Since the DISH receiver wouldn't tune to another channel afterward, I ended up with 6 hours of annoying DISH messages instead of programs I wanted. Fortunately, it happened on my second capture card, so I only got 6 hours of junk instead of 10+ (and, Myth's using the preferred tuner was a very welcome behavior--I was very glad it didn't use tuner 2 to allow it to record the global pre-/post-roll). ___ mythtv-users mailing list mythtv-users@mythtv.org http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
Re: [mythtv-users] Mass channel deletes
Easiest way I've found to delete a bunch of arbitrary channels is to get MythWeb working, and do it through the web interface. I do this regularly when Zap2It adds new satellite channels. --- Dave Sherohman <[EMAIL PROTECTED]> wrote: > Since I didn't recognize all the abbreviated channel IDs, I just set > myself up initially for all channels that I receive when I signed up > with zap2it. I've now gone through and identified about two dozen > channels that don't interest me and have removed them from my zap2it > lineup. > > Section 22.9 of the howto states that I now should go into the > database directly and run a couple SQL statements to get rid of "the" > channel I deleted... but that seems a bit labor-intensive when you're > doing more than a couple channels all at once. Is there a quicker > way to do a bulk channel removal? Would I break my existing > recordings or upcoming recording schedule if I just deleted all > records from the channel table, then ran mythfilldatabase manually to > reconstruct it? > ___ mythtv-users mailing list mythtv-users@mythtv.org http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
Re: [mythtv-users] Mass channel deletes
Dave Sherohman wrote:
On Mon, Sep 19, 2005 at 10:27:13AM -0700, Bruce Markey wrote:
Dave Sherohman wrote:
Section 22.9 of the howto states that I now should go into the
database directly and run a couple SQL statements to get rid of "the"
channel I deleted... but that seems a bit labor-intensive when you're
doing more than a couple channels all at once. Is there a quicker
way to do a bulk channel removal? Would I break my existing
recordings or upcoming recording schedule if I just deleted all
records from the channel table, then ran mythfilldatabase manually to
reconstruct it?
That would work but would leave behind program information that
might be found in searches so you may want to remove all the
program information also.
My impression from the howto is that the program information, etc.
would still be deleted as it expires, even though the channels may
have been removed. ("Old program data will be removed over the
course of a week. However, you may want to immediately delete any
current program listings for the channel that has been removed...")
Is this no longer accurate?
Notice that I wrote "may want to" both in the docs and in the
replay to you =). I would. Mfdb will refill all the program data
for the channels you now receive with no cruft. IOW, if you removed
the channel entries for QVC and CSPAN the program table will still
have all of their shows through a week from Saturday. Mfdb won't
grab any new data for those channels from now on but you might as
well get rid of the useless data now while you're cleaning up.
Thanks for the confirmation that my recording schedule would survive
such a housecleaning. I'd hate to have to go back through the lists
of shows to find all the stuff that looks worthwhile...
The rules are stored in the 'record' table and will still apply
after you've repopulated the program information. There is one
caveat that I don't expect will be a problem in your case but
is more likely if the channel numbers or video source changed.
That is, for rules that are associated with a channel (Single,
Timeslot, Weekslot and Channel) and the "chanid" has changed, the
the rule may not match the new chanid. I don't think this will
be a problem for you because you're using the same video source
and the channel numbers are the same, there are just fewer channels.
Go to the Set Priorities page and look for things that are white
and say "(Recording 0 of 0)" where you would expect it should have
something to record. Press "O" to see the upcoming showings. If
the channel info has changed you can create a new rule and remove
the old one. Even if you have to fix some things, at least the Set
Priorities page shows all of your rules so you don't have to remember
each of the titles you wanted to record.
-- bjm
___
mythtv-users mailing list
mythtv-users@mythtv.org
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
Re: [mythtv-users] Mass channel deletes
On Mon, Sep 19, 2005 at 10:27:13AM -0700, Bruce Markey wrote:
> Dave Sherohman wrote:
> >Section 22.9 of the howto states that I now should go into the
> >database directly and run a couple SQL statements to get rid of "the"
> >channel I deleted... but that seems a bit labor-intensive when you're
> >doing more than a couple channels all at once. Is there a quicker
> >way to do a bulk channel removal? Would I break my existing
> >recordings or upcoming recording schedule if I just deleted all
> >records from the channel table, then ran mythfilldatabase manually to
> >reconstruct it?
>
> That would work but would leave behind program information that
> might be found in searches so you may want to remove all the
> program information also.
My impression from the howto is that the program information, etc.
would still be deleted as it expires, even though the channels may
have been removed. ("Old program data will be removed over the
course of a week. However, you may want to immediately delete any
current program listings for the channel that has been removed...")
Is this no longer accurate?
Thanks for the confirmation that my recording schedule would survive
such a housecleaning. I'd hate to have to go back through the lists
of shows to find all the stuff that looks worthwhile...
--
The freedoms that we enjoy presently are the most important victories of the
White Hats over the past several millennia, and it is vitally important that
we don't give them up now, only because we are frightened.
- Eolake Stobblehouse (http://stobblehouse.com/text/battle.html)
___
mythtv-users mailing list
mythtv-users@mythtv.org
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
Re: [mythtv-users] Mass channel deletes
Dave Sherohman wrote: Since I didn't recognize all the abbreviated channel IDs, I just set myself up initially for all channels that I receive when I signed up with zap2it. I've now gone through and identified about two dozen channels that don't interest me and have removed them from my zap2it lineup. Section 22.9 of the howto states that I now should go into the database directly and run a couple SQL statements to get rid of "the" channel I deleted... but that seems a bit labor-intensive when you're doing more than a couple channels all at once. Is there a quicker way to do a bulk channel removal? Would I break my existing recordings or upcoming recording schedule if I just deleted all records from the channel table, then ran mythfilldatabase manually to reconstruct it? That would work but would leave behind program information that might be found in searches so you may want to remove all the program information also. $ mysql -u mythtv -pmythtv mythconverg mysql> truncate table channel; mysql> truncate table program; mysql> truncate table programrating; mysql> truncate table programgenres; mysql> truncate table credits; mysql> truncate table people; then run "mythfilldatabase" again. -- bjm ___ mythtv-users mailing list mythtv-users@mythtv.org http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
[mythtv-users] Mass channel deletes
Since I didn't recognize all the abbreviated channel IDs, I just set myself up initially for all channels that I receive when I signed up with zap2it. I've now gone through and identified about two dozen channels that don't interest me and have removed them from my zap2it lineup. Section 22.9 of the howto states that I now should go into the database directly and run a couple SQL statements to get rid of "the" channel I deleted... but that seems a bit labor-intensive when you're doing more than a couple channels all at once. Is there a quicker way to do a bulk channel removal? Would I break my existing recordings or upcoming recording schedule if I just deleted all records from the channel table, then ran mythfilldatabase manually to reconstruct it? -- The freedoms that we enjoy presently are the most important victories of the White Hats over the past several millennia, and it is vitally important that we don't give them up now, only because we are frightened. - Eolake Stobblehouse (http://stobblehouse.com/text/battle.html) ___ mythtv-users mailing list mythtv-users@mythtv.org http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
