[mythtv-users] Mythfilldatabase, new HdHr Quatro box, and EPG

[Jay Harbeston]

> On Aug 7, 2019, at 2:21 PM, Mike Bibbings <mike.bibbings at gmail.com> wrote:
> 
> On 07/08/2019 18:43, Jay Harbeston wrote:
>> 
>> 
>>> On Aug 7, 2019, at 1:33 PM, Klaas de Waal <klaas.de.waal at gmail.com <mailto:klaas.de.waal at gmail.com>> wrote:
>>> 
>>> On Wed, 7 Aug 2019 at 16:16, Don Brett <dlbrett at zoominternet.net <mailto:dlbrett at zoominternet.net>> wrote:
>>>> 
>>>> I missed the announcements when my local broadcasters decided to change
>>>> frequencies and required everyone to re-scan.  I thought my HDHR-Connect
>>>> box stopped working, so I bought a new HDHR-Quatro (four tuners).
>>>> 
>>>> The installation went pretty well.  I deleted the existing tuners and
>>>> created four new ones for the Quatro box (thanks Klaas for the
>>>> instructions). The channel scan worked fine and all four tuners are
>>>> working better than expected; some of the hard to get channels are
>>>> working really well.
>>>> 
>>>> However, the program guide is unpopulated ("Unknown(Unknown)" for all
>>>> the new tuner channels.  I also have an Hauppauge HD-PVR for the cable
>>>> box and those channels are fine.  I've run mythfilldatabase several
>>>> times; do I have a myth-setup issue, or maybe something with
>>>> Schedules-Direct?
>> 
>> 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?
>> 
>> 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.
>> 
>> I am currently using the  tv_grab_zz_sdjson script for my xml guide data in the USA. 
>> Currently all the channels are mapped correctly in the form I43730.json.schedulesdirect.org <http://i43730.json.schedulesdirect.org/>.
>> 
>> 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?
>> 
>> Thanks!
>> 
> 
> 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.
> 
> <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 = 'I17155.json.schedulesdirect.org' WHERE callsign = 'Channel 4';
> 
> 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.
> 
> e.g. 
> 
> UPDATE channel SET xmltvid = 'I17155.json.schedulesdirect.org' WHERE channum = '4' AND name = 'Channel 4';
> 
> Once you have done the full channel scan you can just use mythconverg_restore to get back all your xmltvid's 
> 
> e.g. 
> 
> <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 https://www.mythtv.org/wiki/Database_Backup_and_Restore#Backup_xmltvid_data_.28before_doing_a_full_channel_scan.29 <https://www.mythtv.org/wiki/Database_Backup_and_Restore#Backup_xmltvid_data_.28before_doing_a_full_channel_scan.29>
> 
> Mike
> 
> 
EXCELLENT INFORMATION!

Thank you!

Jay

> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://lists.mythtv.org/mailman/listinfo/mythtv-users
> http://wiki.mythtv.org/Mailing_List_etiquette
> MythTV Forums: https://forum.mythtv.org

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20190807/a3c591e0/attachment-0001.html>