[mythtv-users] EPG data not loading from xml file

Sim simon.hampton at freebel.net
Sun Mar 13 20:56:48 UTC 2005


Hi,
I'm trying fill the daatbase from an XML file downloaded from a Belgian
website, but it is not working.

My channels file reads:

drop table channel;

CREATE TABLE channel (
  chanid int(10) unsigned NOT NULL default '0',
  channum varchar(5) NOT NULL default '',
  freqid varchar(5) NOT NULL default '',
  sourceid int(10) unsigned default NULL,
  callsign varchar(20) default NULL,
  name varchar(20) default NULL,
  icon varchar(255) default NULL,
  finetune int(11) default NULL,
  videofilters varchar(255) default NULL,
  xmltvid varchar(64) default NULL,
  recpriority int(10) NOT NULL default '0',
  contrast int(11) default '32768',
  brightness int(11) default '32768',
  colour int(11) default '32768',
  hue int(11) default '32768',
  tvformat varchar(10) NOT NULL default 'Default',
  commfree tinyint(4) NOT NULL default '0',
  visible tinyint(1) NOT NULL default '1',
  PRIMARY KEY  (chanid)
) TYPE=MyISAM;

INSERT INTO channel VALUES
(1002,'2','SE14',1,'BBC2','bbc2','/home/mythtv/.mythtv/channels/BBC2.gif',0,'','bbc2',0,28000,30000,31000,30500,'Default',0,1);
INSERT INTO channel VALUES
(1003,'3','SE8',1,'MTV','mtv','/home/mythtv/.mythtv/channels/MTV.gif',0,'','mtv',0,28000,30000,31000,30500,'Default',0,1);
INSERT INTO channel VALUES
(1004,'4','E10',1,'TV1','tv1','/home/mythtv/.mythtv/channels/TV1.gif',0,'','tv1',0,28000,30000,31000,30500,'Default',0,1);
INSERT INTO channel VALUES
(1005,'5','SE10',1,'CANVAS','canvas','/home/mythtv/.mythtv/channels/canvas.gif',0,'','canvas',0,28000,30000,31000,30500,'Default',0,1);
[...]

I do
mysql -u root -p mythconverg < channels.sql

And my program info comes in the form:
  <channel id="raiuno">
    <icon src="http://www.teveblad.be/gfx/logos/RAIUNO.gif">
    </icon>
    <display-name>raiuno</display-name>
  </channel>
  <programme start="200503110900 +0100" stop="200503111530 +0100"
channel="canvas">
    <title>Lentebeelden</title>
  </programme>

Then I do 
$ mythfilldatabase --file 1 -1 nerdhero/guide.xml 2> /dev/null
### bypassing grabbers, reading directly from file
Updating icons for sourceid: 1
Adjusting program database end times...
0 replacements made.
Marking repeats...found 0
Unmarking repeats from grabber that fall within our new episode window...found 
0
2005-03-13 21:55:09.655 Connecting to backend server: 127.0.0.1:6543 (try 1 of 
5)
2005-03-13 21:55:09.663 Using protocol version 14

I wonder about the reference to channel="canvas" but simply know nothing
about sql

Hoping someone can help

Sim


More information about the mythtv-users mailing list