id	summary	reporter	owner	description	type	status	priority	milestone	component	version	severity	resolution	keywords	cc	mlocked
2686	[work in progress] program to manage channel table for sky digital users	Simon Kenyon	danielk	"i've been working on this for a few days and i wanted to get it out there for feedback/suggestions.
with multiple sources/backends/channels/cards it can be quite hard to manage it all.
why sky changed their lineup earlier in the year i didn't have the time/energy to fix it all up and lived with missing channels etc.

anyway, the itch got too much and i scratched it.

please find attached what i've been working on so far.
the core of it is an XML file which describes channels and providers and various routines to load and store from that xml file.

there are a set of classes and a test program to drive them (test.pm)
it is non-destructive in that it doesn't overwrite anything that it didn't create.

right now i can load it, add additional content (from the xmltv uk_rt/channel_ids file) and the store again, as well as the ability to generate the sql to reload the channels table. as i said it is a work in progress and i intend to continue working on it. things to add include:

loading more data from additional sources (wikipedia)
generating additional output files (the various xmltv files for .mythtv and channel_ids springs to mind)
a DTD for the xml
documentation
a proper program other that test.pm

i've tried to write it in the best way that i know how. it is all rather oo, which meant learning how to do that in perl and the number of classes vs. the functionality is a bit out of whack.

if it helps anybody, then i'm happy. it has made my mythtv installation useful again.

as i said, comments are welcome "	enhancement	closed	minor	unknown	mythtv	head	low	invalid	xmltv db channels sky		0