I have two lineups; OTA and Comcast cable. The OTA is no big deal, but
the Comcast lineup sucks. It has almost 600 channels, many of which are
wrong (don't come in at all or channels we DO get aren't listed), but
for the most part, the ones we watch are ok. The problem lies in that
fact that we had to go through all 500+ channels and manually disable
the On-Demand, and premium channels and low def channels and FM radio
channels, etc, etc. The way we did that was suggested in the Wiki where
you take the SD.xml file with the channel!<ID> (ones you don't want) vs
channel=<ID> (ones you do want) and edit that with a text editor
(similar procedure for the sqlite DB) changing the "=" to a "!" on ones
you don't want and vise verse on one you do want.
That SD.xml file is used when you run mythfilldatabase to determine
which channels it gets listing data for. Unfortunately, it still
creates all the channels from the lineup in the mythconverg channel
table, it just doesn't pull any data for the "deselected" channels.
Since the channels table has a default "visible" value of 1, I ended up
with all these "No Data" channels in my listings. YUCK!
What I wound up doing was grep for all the "channel!" in the .xml file
and output that to a file which I edited into an SQL query to set
visible=0 where xmltvid=xxxx and ORed the hundreds of channels I didn't
want. I ended up with two files; one to set visible=1 on the channels
with "=" and one to set visible=0 on the channels with "!". All the
useless channels are still there, happily created by mithfilldatabase,
they just have no data. After running my queries, at least the unused
ones don't show up in the listings (except where the lineup has errors).
Don't know if any of this helps, but it's what I've done and figured I'd
share FWIW.
Dave D.
_______________________________________________
mythtv-users mailing list
mythtv-users@mythtv.org
http://lists.mythtv.org/mailman/listinfo/mythtv-users
http://wiki.mythtv.org/Mailing_List_etiquette
MythTV Forums: https://forum.mythtv.org
the Comcast lineup sucks. It has almost 600 channels, many of which are
wrong (don't come in at all or channels we DO get aren't listed), but
for the most part, the ones we watch are ok. The problem lies in that
fact that we had to go through all 500+ channels and manually disable
the On-Demand, and premium channels and low def channels and FM radio
channels, etc, etc. The way we did that was suggested in the Wiki where
you take the SD.xml file with the channel!<ID> (ones you don't want) vs
channel=<ID> (ones you do want) and edit that with a text editor
(similar procedure for the sqlite DB) changing the "=" to a "!" on ones
you don't want and vise verse on one you do want.
That SD.xml file is used when you run mythfilldatabase to determine
which channels it gets listing data for. Unfortunately, it still
creates all the channels from the lineup in the mythconverg channel
table, it just doesn't pull any data for the "deselected" channels.
Since the channels table has a default "visible" value of 1, I ended up
with all these "No Data" channels in my listings. YUCK!
What I wound up doing was grep for all the "channel!" in the .xml file
and output that to a file which I edited into an SQL query to set
visible=0 where xmltvid=xxxx and ORed the hundreds of channels I didn't
want. I ended up with two files; one to set visible=1 on the channels
with "=" and one to set visible=0 on the channels with "!". All the
useless channels are still there, happily created by mithfilldatabase,
they just have no data. After running my queries, at least the unused
ones don't show up in the listings (except where the lineup has errors).
Don't know if any of this helps, but it's what I've done and figured I'd
share FWIW.
Dave D.
_______________________________________________
mythtv-users mailing list
mythtv-users@mythtv.org
http://lists.mythtv.org/mailman/listinfo/mythtv-users
http://wiki.mythtv.org/Mailing_List_etiquette
MythTV Forums: https://forum.mythtv.org