AW: [mythtv-users] mythfilldatabase in Germany

[Steffen Becker]

Hi,

Felix H. Hoßfeld asked me to post his answer for him because of troubles
with his account. So here we go:

When setting up MythTV in Germany you are facing a problem: The
xmltv-grabber (tv_grab_de) for Germany is currently offline. Luckily, Ben
Buksch has developed a little python script to download an xml-TV guide for
German (and Austrian) channels from TV Movie and convert it to xmltv's data
format.
(http://www.bucksch.com/1/projects/various/xmltv/)

I assume you know how to get the program going and how to edit the
config.py. (I also downloaded and installe the qtxmlchacker though I don't
know if that is strictly necessry. Make sure that the sh-bang (#!) is set to
an python 2.1 or 2.2 binary (on Debian it's #!/usr/bin/python2.2) and make
sure make it executable. Now create a softlink from
/usr/local/bin/tv_grav_de to the fetchdata.py script. If you have the
xmltv-packet installed make sure tv_grab_de calls Ben's script NOT the one
of the xmltv-package.

If you have that working, you must setup everything properly by running
MythTV's setup program. It will tell you that you will have to run
"mythfilldatabase --manual". Once finished wih the setup do that.

mythfilldatabse should start Ben's script and attempt to put it into your
database. Everytime it finds a station in the xmltv-file that is not in your
db it will ask you for the channel identifier and station name.
I suggest that you enter dummies during this stage of the setup. The easiest
way to do this, is to sit next
to your tv and enter the channel number of your tv setup as the channel id
and number (DO NOT USE ANY CHANNEL ID TWICE!!!). Leave the other values
blank or use the default values! You just make too many mistakes in the
console program so it's not worth even trying to get it right. It is much
easier to fill in the missing information using mythweb or phpmyadmin. If
you can't receive a channel leave it to channel id 0 and it will be
ommitted.

I suggest you try mythweb unless you have phpmyadmin already running as you
will be using mythweb in the future anyway. Go to setting and choose
channels. There you can edit the values much more easily. Most of the values
should be self-explaining. The only problem is freqid. This is the channel
frequency. You can either use xawtv to get the channel names or look them up
on the Web. Just search for kabel +kanalbelegung + <your town>. Alternativly
you could call the Telekom, I think.
It is fairly easy to translate them to mythtv's format. A normal channel
with just a number gets an extra E. "Sonderkanäle" get an SE. So it is:

1 -> E1
2 -> E2
S1 -> SE1

This all assumes you are using pal/west. I couldn't get all channels because
some were not defined properly in libs/libmythtv/frequencies.c. I have
wirtten a patch for that but you might try to solve that problem by
switching to europe/east. I haven't checked. With my patch I can get all but
three station on SE7, SE8, SE9. In Hamburg that's RTL2, MTV2 and arte. I
think they must be on slightly different frequencies but I haven't found any
information.

MfG

Felix H. Hoßfeld

------------------------------------------------------------------------
Dipl. Wirtsch. Inform. Steffen Becker, DFG Junior Research Group "Palladio",
Fk 2, Department of Computing Science, Software Engineering Group
CvO Universität Oldenburg / OFFIS, Escherweg 2, D-26121 Oldenburg
Email: becker at informatik.uni-oldenburg.de
URL: http://se.informatik.uni-oldenburg.de
Voice: +49 441 9722-582  (-501, secr.)       Fax:   +49 441 9722-502
------------------------------------------------------------------------


> -----Ursprüngliche Nachricht-----
> Von: mythtv-users-bounces at mythtv.org
> [mailto:mythtv-users-bounces at mythtv.org]Im Auftrag von Steffen Becker
> Gesendet: Dienstag, 16. Dezember 2003 11:13
> An: mythtv-users at mythtv.org
> Betreff: [mythtv-users] mythfilldatabase in Germany
>
>
> Hi List,
>
> i'm new to the mythtv community trying to get my system up and
> running with
> a Hauppauge PVR 350 in Germany (a PAL contry). Besides the
> problems the ivtv
> driver has with PAL i don't know how to set up the mythtv channel
> database.
> I tried it on mythtv 0.13 with
> mythfilldatabase --file GrabTV -1 TVGuide.xml --manual --preset
> But this didn't work. It queried the channel infos from me but on
> trying to
> store it in the db it said UPDATE .... Database reported error (or the
> like - i'm writing from memory). In mythtv 0.12 that worked.
>
> Can sb. help me? Is mythfilldatabase broken in 0.13. Do i have to try CVS?
> Or better 0.12?
>
> Nevertheless i was unable to set up the database correctly for
> 0.12 either.
> Is it right to use as channel no. any int from 0 up to n? And to use as
> preset the PAL channel, eg. SE11, E12, etc.??
>
> Thanks in advance
> Steffen
>
> ------------------------------------------------------------------------
> Dipl. Wirtsch. Inform. Steffen Becker, DFG Junior Research Group
> "Palladio",
> Fk 2, Department of Computing Science, Software Engineering Group
> CvO Universität Oldenburg / OFFIS, Escherweg 2, D-26121 Oldenburg
> Email: becker at informatik.uni-oldenburg.de
> URL: http://se.informatik.uni-oldenburg.de
> Voice: +49 441 9722-582  (-501, secr.)       Fax:   +49 441 9722-502
> ------------------------------------------------------------------------
>
>
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users