[mythtv-users] Problems filling EPG data in database with --file option

[Johannes Niess]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Am Mittwoch, 28. Januar 2004 13:06 schrieb Tom Grant:
> Hi guys
>
> New to this list, new to MythTV and a few problems getting everything to
> work :)
>
> I like to use german EPG information. I use nxtvepg for this, because
> tv_grab_de is offline for months. So i have to use the --file option if i
> fill the database.
>
> Getting the the EPG-information and exporting it to a file works without
> any problem. But filling the database will not work correctly, or I just
> don't get it ;)
>
> - sourceid: Does it start from 0 or from 1? If i have just one card, is it
> then 1? I tried both, and still have problems. Or is this a setting which I
> didn't see?

It's supposed to start at 1. But mythtv has no control over the autoindex 
values of mysql. So with every  "mythsetup" with clear capture card=yes it 
goes up. You can reset it to 1 by mysql's optimize table. But now it is out 
of sync with other mysql tables. On recording it leads to a "unknown card id 
- -1" and the backend goes down.

>
> - if i use -1 for the days, it should clear everything and just use the new
> data from the xml-file, right?. It looks like it still tries to add the
> data, which brings up an SQL error message "Duplicate entry "blablah" for
> key1". What i am doing wrong here?
>
> - "Program guide": I don't see any informations here. But i am sure, this
> is because i am doing something wrong with the data-import. Strange is that
> i see the infos in the "Program Finder". So channel-mapping or so is wrong
> i guess.

I've not managed to have mythfilldatabase merge channel entries from the xmltv 
source (i.e. nxtvepg) and the --xawchannels option. Even --manual did not 
work. You get records from xmltv without a mapping to frequencies and records 
from --xawtvchannels with other programid and no xmltvid.

I ended up with "zap"ping the complete database, mythsetup, "mythfilldatabase 
- --file 1 -1 nxtvepg.xml" and editing the channel table by hand. You have to 
fill in the missing values for channum, freqid and callsign. My channels 
table is in the attachment.

> That's it for the beginning. More to come probably :) Thanks for any
> replies in advance.
>
> Cheers Tom
>
> btw. sorry, if something as been asked already. I tried to search
> everything in the archives here
> http://www.gossamer-threads.com/perl/mailarc/gforum.cgi
>

HTH,

Johannes Nieß
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.3 (GNU/Linux)

iD8DBQFAF7pxZ86b9aw2E+0RAqQ/AJ9JA59LlhE+VXNQ0O6oCCaS+WkqNwCgr9cX
ZMJfE6AD1zMUauroqRpBFqQ=
=ZKyA
-----END PGP SIGNATURE-----
-------------- next part --------------
1000,14,SE13,1,Pro7,Pro7,,0,,CNI0D94,0,32768,32768,32768,32768,
1001,1,E2,1,ARD,ARD,,0,,CNI0DC1,0,32768,32768,32768,32768,
1002,2,E4,1,ZDF,ZDF,,0,,CNI0DC2,0,32768,32768,32768,32768,
1003,10,E5,1,RTL,RTL,,0,,CNI0DAB,0,32768,32768,32768,32768,
1004,13,E10,1,SAT.1,SAT.1,,0,,CNI0DB9,0,32768,32768,32768,32768,
1005,22,SE14,1,BR3,BR3,,0,,CNI0DCB,0,32768,32768,32768,32768,
1006,,,1,,HR3,,0,,CNI0DCF,0,32768,32768,32768,32768,
1007,21,SE10,1,NDR,NDR,,0,,CNI0DD4,0,32768,32768,32768,32768,
1008,20,E7,1,SWR,SW BW,,0,,CNI0DE0,0,32768,32768,32768,32768,
1009,23,E8,1,WDR,WDR,,0,,CNI0DE6,0,32768,32768,32768,32768,
1010,7,E3,1,MDR/KiKa,MDR,,0,,CNI0DFE,0,32768,32768,32768,32768,
1011,,,1,,RBB Br,,0,,CNI0D82,0,32768,32768,32768,32768,
1012,4,E9,1,3sat,3sat,,0,,CNI0DC7,0,32768,32768,32768,32768,
1013,42,E12,1,VIVA,VIVA,,0,,CNI0D88,0,32768,32768,32768,32768,
1014,15,SE6,1,Kabel 1,Kabel 1,,0,,CNI0D92,0,32768,32768,32768,32768,
1015,12,S24,1,Super RTL,Super RTL,,0,,CNI0D8A,0,32768,32768,32768,32768,
1016,16,E11,1,VOX,VOX,,0,,CNI0D8E,0,32768,32768,32768,32768,
1017,11,SE17,1,RTL2,RTL2,,0,,CNI0D8F,0,32768,32768,32768,32768,
1018,30,S8,1,9Live,9Live,,0,,CNI0DBA,0,32768,32768,32768,32768,
1019,31,SE11,1,DSF,DSF,,0,,CNI0D8D,0,32768,32768,32768,32768,
1020,32,SE16,1,Eurosport,Eurosport,,0,,CNI0D91,0,32768,32768,32768,32768,
1021,6,E3,1,KiKa/mdr,KiKa,,0,,CNI0DC9,0,32768,32768,32768,32768,
1022,5,S21,1,Arte,Arte,,0,,CNI0D85,0,32768,32768,32768,32768,
1023,40,S7,1,n-tv,n-tv,,0,,CNI0D8C,0,32768,32768,32768,32768,
1024,,,1,,tvtv,,0,,CNIFFF1,0,32768,32768,32768,32768,
1025,,,1,,ORF2,,0,,CNI0AC2,0,32768,32768,32768,32768,
1026,,,1,,RBB Be,,0,,CNI0DDC,0,32768,32768,32768,32768,
1027,40,SE18,1,MTV,MTV,,0,,CNIFFEF,0,32768,32768,32768,32768,
1028,,,1,,BR A,,0,,CNI0D44,0,32768,32768,32768,32768,
1029,,,1,,TRT,,0,,CNI9001,0,32768,32768,32768,32768,
1030,51,S25,1,N24,N24,,0,,CNI0D7A,0,32768,32768,32768,32768,
1031,7,SE5,1,Phoenix,Phoenix,,0,,CNI0DC8,0,32768,32768,32768,32768,
1032,31,S4,1,Tele5,Tele5,,0,,CNI0D78,0,32768,32768,32768,32768,
1033,40,SE18,1,MTV,MTV,,0,,CNI4D54,0,32768,32768,32768,32768,
1034,,,1,,MTV2,,0,,CNI4D59,0,32768,32768,32768,32768,
1035,,,1,,EURONEWS,,0,,CNIFE01,0,32768,32768,32768,32768,
1036,,,1,,SF1,,0,,CNI04C1,0,32768,32768,32768,32768,
1037,,,1,,ORF1,,0,,CNI0AC1,0,32768,32768,32768,32768,
1038,,,1,,TSR,,0,,CNI04C2,0,32768,32768,32768,32768,
1039,,,1,,France 2,,0,,CNI2F02,0,32768,32768,32768,32768,
1040,,,1,,France 3,,0,,CNI2F03,0,32768,32768,32768,32768,
1041,,,1,,TF 1,,0,,CNI2F01,0,32768,32768,32768,32768,
1042,60,SE12,1,TV5,TV5,,0,,CNIF500,0,32768,32768,32768,32768,
1043,,,1,,TSI,,0,,CNI04C3,0,32768,32768,32768,32768,
1044,,,1,,RAI 1,,0,,CNIFFF2,0,32768,32768,32768,32768,
1045,,,1,,RAI 2,,0,,CNIFFF3,0,32768,32768,32768,32768,
1046,,,1,,BBC Prime,,0,,CNI2C7F,0,32768,32768,32768,32768,