[mythtvnz] SQL Dump please

[Steve Hodge]

On Sun, Jun 20, 2010 at 6:09 PM, Tortise <tortise at paradise.net.nz> wrote:

> I presume by listings.xml you mean the file that is in my case {XMLTV
> config file is:} /home/mythtv/.mythtv/T1.xmltv
>

No, by listings.xml I mean the file that actually contains the epg data.
It'll contain a bunch of xml, mostly blocks that look like:
<programme channel="[xmltv id for some channel]" start="[timestamp]" stop
="[timestamp]">
   <title lang="eng">[Program title]</title>
   <desc lang="eng">[Program description]</desc>
   [possibly other tags such as category and rating]
</programme>

That is the datafile that mythfilldatabase operates on - it takes that xml
data and loads it into mythtv's database.


> Actually to clarify further from the log I note the "default" (using
> mythfilldatabase arguments "-v xmltv" ) command seems to be:
>
> 2010-06-20 16:30:17.508 Grabber Command: nice tv_grab_nz-py --config-file
> '/home/mythtv/.mythtv/T1.xmltv' --output /tmp/mythkthXCh
>

tv_grab_nz-py is a "grabber" - a grabber obtains the above xml files somehow
(in the case of tv_grab_nz-py I believe it downloads it from the net). The
.xmltv config file presumably belongs to tv_grab_nz-py - but I don't use
that grabber so I'm not sure. I believe that Hadley wrote that grabber so he
can probably give better assistance.


> Marrying this with Steve's argument suggestions perhaps:
>
>    mythfilldatabase --update --file 1 T1.xmltv --sourceid 1
>
> or maybe enough, as per Steve:
>
>    mythfilldatabase --update --file 1 T1.xmltv
>
> or
>
>    mythfilldatabase --update --file 1 '/home/mythtv/.mythtv/T1.xmltv'
>
> or referring to the default above possibly
>

No, none of the above. Try:
mythfilldatabase --sourceid <id>
where <id> is the video source id for the video source in question. Your
system might be setup so that mythfilldatabase knows how to call the grabber
itself.

But what are you actually trying to do? If you want to diagnose issues in
the data then you should probably run tv_grab_nz-py to actually grab the
data rather mythfilldatabase.

   mythfilldatabase --update --config-file 1 '/home/mythtv/.mythtv/T1.xmltv'
>
> http://mythtv.org/wiki/Mythfilldatabase does not refer to "--config-file"
> as an argument so I guess the system adds that one.
>

No, definitely not.

Cheers,
Steve
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.ourshack.com/pipermail/mythtvnz/attachments/20100620/a4496bf1/attachment.htm