<html><head><meta http-equiv="Content-Type" content="text/html; charset=utf-8"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;" class=""><br class=""><div><br class=""><blockquote type="cite" class=""><div class="">On Aug 7, 2019, at 2:21 PM, Mike Bibbings <<a href="mailto:mike.bibbings@gmail.com" class="">mike.bibbings@gmail.com</a>> wrote:</div><br class="Apple-interchange-newline"><div class="">
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" class="">
<div bgcolor="#FFFFFF" text="#000000" class="">
<div class="moz-cite-prefix">On 07/08/2019 18:43, Jay Harbeston
wrote:<br class="">
</div>
<blockquote type="cite" cite="mid:191CDFB2-7B93-449B-A3B9-A0195C37B171@gmail.com" class="">
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" class="">
<br class="">
<div class=""><br class="">
<blockquote type="cite" class="">
<div class="">On Aug 7, 2019, at 1:33 PM, Klaas de Waal <<a href="mailto:klaas.de.waal@gmail.com" class="" moz-do-not-send="true">klaas.de.waal@gmail.com</a>>
wrote:</div>
<br class="Apple-interchange-newline">
<div class=""><span style="caret-color: rgb(0, 0, 0);
font-family: Palatino-Roman; font-size: 13px; font-style:
normal; font-variant-caps: normal; font-weight: normal;
letter-spacing: normal; text-align: start; text-indent:
0px; text-transform: none; white-space: normal;
word-spacing: 0px; -webkit-text-stroke-width: 0px;
text-decoration: none; float: none; display: inline
!important;" class="">On Wed, 7 Aug 2019 at 16:16, Don
Brett <</span><a href="mailto:dlbrett@zoominternet.net" style="font-family: Palatino-Roman; font-size: 13px;
font-style: normal; font-variant-caps: normal;
font-weight: normal; letter-spacing: normal; orphans:
auto; text-align: start; text-indent: 0px; text-transform:
none; white-space: normal; widows: auto; word-spacing:
0px; -webkit-text-size-adjust: auto;
-webkit-text-stroke-width: 0px;" class="" moz-do-not-send="true">dlbrett@zoominternet.net</a><span style="caret-color: rgb(0, 0, 0); font-family:
Palatino-Roman; font-size: 13px; font-style: normal;
font-variant-caps: normal; font-weight: normal;
letter-spacing: normal; text-align: start; text-indent:
0px; text-transform: none; white-space: normal;
word-spacing: 0px; -webkit-text-stroke-width: 0px;
text-decoration: none; float: none; display: inline
!important;" class="">> wrote:</span><br style="caret-color: rgb(0, 0, 0); font-family:
Palatino-Roman; font-size: 13px; font-style: normal;
font-variant-caps: normal; font-weight: normal;
letter-spacing: normal; text-align: start; text-indent:
0px; text-transform: none; white-space: normal;
word-spacing: 0px; -webkit-text-stroke-width: 0px;
text-decoration: none;" class="">
<blockquote type="cite" style="font-family: Palatino-Roman;
font-size: 13px; font-style: normal; font-variant-caps:
normal; font-weight: normal; letter-spacing: normal;
orphans: auto; text-align: start; text-indent: 0px;
text-transform: none; white-space: normal; widows: auto;
word-spacing: 0px; -webkit-text-size-adjust: auto;
-webkit-text-stroke-width: 0px; text-decoration: none;" class=""><br class="">
I missed the announcements when my local broadcasters
decided to change<br class="">
frequencies and required everyone to re-scan. I thought
my HDHR-Connect<br class="">
box stopped working, so I bought a new HDHR-Quatro (four
tuners).<br class="">
<br class="">
The installation went pretty well. I deleted the existing
tuners and<br class="">
created four new ones for the Quatro box (thanks Klaas for
the<br class="">
instructions). The channel scan worked fine and all four
tuners are<br class="">
working better than expected; some of the hard to get
channels are<br class="">
working really well.<br class="">
<br class="">
However, the program guide is unpopulated
("Unknown(Unknown)" for all<br class="">
the new tuner channels. I also have an Hauppauge HD-PVR
for the cable<br class="">
box and those channels are fine. I've run
mythfilldatabase several<br class="">
times; do I have a myth-setup issue, or maybe something
with<br class="">
Schedules-Direct?<br class=""></blockquote></div></blockquote><br class="">
</div>
<div class="">I will need to do this at the beginning of September, and my
only concern is getting the xml ids set up. If rather than doing
a wipe and rescan, will just doing a scan, will the scan update
the channels?</div>
<div class=""><br class="">
</div>
<div class="">I don’t want to do the OTA method above as I don’t want to
lose the xml id values currently in the db for the 18 + Over the
Air channels.</div>
<div class=""><br class="">
</div>
<div class=""><span style="caret-color: rgb(0, 0, 0); font-family: Palatino-Roman;" class="">I am currently using
the tv_grab_zz_sdjson script for my xml guide data in the
USA. </span></div>
<div class=""><span style="caret-color: rgb(0, 0, 0); font-family: Palatino-Roman;" class="">Currently all the
channels are mapped correctly in the form </span><a href="http://i43730.json.schedulesdirect.org/" class="" style="font-family: Palatino-Roman;" moz-do-not-send="true">I43730.json.schedulesdirect.org</a><span style="caret-color: rgb(0, 0, 0); font-family: Palatino-Roman;" class="">.</span></div>
<div class=""><span style="caret-color: rgb(0, 0, 0); font-family: Palatino-Roman;" class=""><br class="">
</span></div>
<div class=""><span style="caret-color: rgb(0, 0, 0); font-family: Palatino-Roman;" class="">Will I need to go back
in once the channels are rescanned and update the db / edit
the channels to make sure they get mapped correctly?</span></div>
<div class=""><span style="caret-color: rgb(0, 0, 0); font-family: Palatino-Roman;" class=""><br class="">
</span></div>
Thanks!
<div class=""><br class="">
</div>
</blockquote><p class=""><br class="">
</p><p class="">mythconverg_backup has a option to save xmltvid data to a file in
the same backup directory as a normal database backup, do this
before a full channel scan.<br class="">
</p>
<pre style="background-color: rgb(249, 249, 249); border: 1px solid rgb(221, 221, 221); padding: 1em; white-space: pre-wrap; line-height: 1.3em; font-size: 14px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; word-spacing: 0px; -webkit-text-stroke-width: 0px;" class=""><path_to>/mythconverg_backup.pl --backup_xmltvids
The created file contains two different formats, the first being a series of update statements using only callsign:
e.g.
UPDATE channel SET xmltvid = '<a href="http://I17155.json.schedulesdirect.org" class="">I17155.json.schedulesdirect.org</a>' WHERE callsign = 'Channel 4';
</pre><p class="">There is an "Alternative" format in the same file (this
Alternative format is commented out in the file /*....*/ style)
uses both channel number and callsign and is probably only useful
where channel numbers do not change.<br class="">
</p><p class="">e.g. <br class="">
</p><p class="">UPDATE channel SET xmltvid = '<a href="http://I17155.json.schedulesdirect.org" class="">I17155.json.schedulesdirect.org</a>'
WHERE channum = '4' AND name = 'Channel 4';</p><p class="">Once you have done the full channel scan you can just use
mythconverg_restore to get back all your xmltvid's <br class="">
</p><p class="">e.g. <br class="">
</p>
<pre style="font-family: monospace, Courier; background-color: rgb(249, 249, 249); border: 1px solid rgb(221, 221, 221); padding: 1em; white-space: pre-wrap; line-height: 1.3em; font-size: 14px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px;" class=""><path_to>/mythconverg_restore.pl --restore_xmltvids
or if you have more than one backup xmltvid file
<path_to>/mythconverg_restore.pl --restore_xmltvids --filename mythtv_xmltvid_backup-20080626211808.sql
The wiki has details see <a href="https://www.mythtv.org/wiki/Database_Backup_and_Restore#Backup_xmltvid_data_.28before_doing_a_full_channel_scan.29" class="">https://www.mythtv.org/wiki/Database_Backup_and_Restore#Backup_xmltvid_data_.28before_doing_a_full_channel_scan.29</a>
Mike
</pre><p class=""><br class=""></p></div></div></blockquote>EXCELLENT INFORMATION!</div><div><br class=""></div><div>Thank you!</div><div><br class=""></div><div>Jay</div><div><br class=""><blockquote type="cite" class=""><div class=""><div bgcolor="#FFFFFF" text="#000000" class=""><p class="">
</p>
</div>
_______________________________________________<br class="">mythtv-users mailing list<br class=""><a href="mailto:mythtv-users@mythtv.org" class="">mythtv-users@mythtv.org</a><br class="">http://lists.mythtv.org/mailman/listinfo/mythtv-users<br class="">http://wiki.mythtv.org/Mailing_List_etiquette<br class="">MythTV Forums: https://forum.mythtv.org<br class=""></div></blockquote></div><br class=""></body></html>