<br><br>
<div><span class="gmail_quote">On 9/5/07, <b class="gmail_sendername">Robert Current</b> <<a href="mailto:robert.current@gmail.com">robert.current@gmail.com</a>> wrote:</span>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">On Sep 5, 2007, at 8:02 PM, Robert Current wrote:<br>><br>> >> Kevin Kuphal kuphal at <a href="http://dls.net">
dls.net</a><br>> ><br>> >> They can assist with the proper data formatting of the grabber.<br>> >> Nothing<br>> >> about the grabber development really has anything to do with<br>> >> MythTV directly
<br>> >> since MythTV only requires that the data be XMLTV compliant. All<br>> >> the hard<br>> >> work from the import side is done already.<br>> >><br>> >> The parts that aren't done are the EXPORT from a filled database
<br>> >> to an<br>><br>> mysqldump -umythtv -pmythtv -h192.168.0.2 --extended-insert<br>> mythconverg program > program.sql<br>><br><br>Heh, that's one way! Lot's of data to parse…<br><br>
I was poking around with simple "select * from program" statements to<br>see what could be formatted into which specific XMLTV fields. Then<br>got sidetracked tying thinking I need to look at the mythfilldatabase
<br>code where this is probably already mapped out.</blockquote>
<div> </div>
<div>If you are running mysql 5.x, you can actually do this:</div>
<div> </div>
<div>mysqldump -umythtv -pmythtv --xml mythconverg program >program.xml</div>
<div> </div>
<div>Throw in an XSLT transform or two, and you could do the whole thing externally fairly simply.</div>
<div> </div>
<div>Not that I understand the value of an extract, still, particularly if the intent would be to then share via torrent/usenet/whatever, since why not just grab directly the same way the original person got it into the myth database. I'll buy the local LAN argument, but then you might as well just ship the XML file that you used to load the one myth box to the other myth box and load them both from the same source. Not an offense, I just don't get it.
</div>
<div> </div>
<div> </div><br> </div>