XMLTV import skips some channels but not all

Mercbac · 2008-04-20, 23:04

After reading the other related XMLTV import problem threads it seems no-one has seen my scenario yet, so I hope I can describe it in enough detail that someone can spot the obvious silly detail I haven't found yet...
Running MP 1.0.0.0 RC1 with single seat server installation on Vista Ultimate 32-bit and MySQL as dbms, I have created a WebEPG.xml file by using Web-config.exe. The xml file is in C:\Program Files\Team MediaPortal\MediaPortal\WebEPG.
Next, I ran WebEPG.exe in order to create the tv-guide.xml file, which was created in C:\Program Files\Team MediaPortal\MediaPortal\XMLTV (Yes the dtd file is also there). Last step I manually press "import" on the Server Config -> Plugins -> XMLTV screen and wait for it to finish. On the Mappings-tab, the mappings look fine and also seem to match what I see in the WebEPG.xml file.
It tells me 6035 programs imported. However, running a count on the string "<programme " in my tv-guide.xml file gives 10685 lines, so obviously 4650 lines were not imported. For example, all of the programs on channel "Nickelodeon" are not imported.

I thought I would trick the import and copy / paste the entire block of Nickelodeon programs higher up in the tv-guide.xml file (inbetween two other channels), but it gives me the same result of 6035 programs imported...

In the logfile it says at the bottom that 40 channels were imported. Now I do indeed have 40 channels defined in my WebEPG.xml file, but if you look at the details of imported programs per channel, there are obviously a number of channels skipped and not imported.

Attached are my WebEPG.xml, tv-guide.xml and tv.log files.

And now I hope that someone can tell me which obvious detail I have missed....

Thanks in advance!!

robyf · 2008-04-21, 10:43

The attached log file seems to be corrupt. I think I have the same problem but I was not able to retrieve logs of it. How do you enable logging of import events?

Roby

Mercbac · 2008-04-21, 11:07

The .zip file was compressed with high compression in Winzip 11 (took an extra 200KB off the filesize) so you'll need that one to unpack it. Just did it on my work-PC where I don't have a local copy of that attachment and all 3 included files look fine.
On my HTPC, the tv.log automatically logs import events. I did read in another thread though that it could help to delete the entire log directory under the TV server if it only logs one line.

EDIT: The behaviour does seem consistent with newer downloaded tvguide.xml files, but it did not happen on my previous MP install with 0.2.3.0 + SVN 2008-03-14

Mercbac · 2008-04-22, 21:29

Well, I caused it myself, so no blame on the importer... What happened was that I uninstalled my previous MP 0.2.3.0 install, but exported all TV channels from my TV server database before uninstalling. After installing 1.0.0.0 RC1 I imported that list and somehow the column 'externalId' in the table 'channels' was left blank for exactly those channels that were being skipped by the importer. After fixing them in MySQL Query Browser the importer now picks up these channels too.
So lesson learned is that it's always best to start from scratch and get rid of the old stuff. Nothing beats a clean install!

Paranoid Delusion · 2008-04-22, 22:33

Yep, been there done it, end up chasing your own tail.

2008-04-20, 23:04	#1 (permalink)
Mercbac Portal Member Join Date: Mar 2007 Posts: 73 Thanks: 5 Thanked 1 Time in 1 Post Country: My System	XMLTV import skips some channels but not all After reading the other related XMLTV import problem threads it seems no-one has seen my scenario yet, so I hope I can describe it in enough detail that someone can spot the obvious silly detail I haven't found yet... Running MP 1.0.0.0 RC1 with single seat server installation on Vista Ultimate 32-bit and MySQL as dbms, I have created a WebEPG.xml file by using Web-config.exe. The xml file is in C:\Program Files\Team MediaPortal\MediaPortal\WebEPG. Next, I ran WebEPG.exe in order to create the tv-guide.xml file, which was created in C:\Program Files\Team MediaPortal\MediaPortal\XMLTV (Yes the dtd file is also there). Last step I manually press "import" on the Server Config -> Plugins -> XMLTV screen and wait for it to finish. On the Mappings-tab, the mappings look fine and also seem to match what I see in the WebEPG.xml file. It tells me 6035 programs imported. However, running a count on the string "<programme " in my tv-guide.xml file gives 10685 lines, so obviously 4650 lines were not imported. For example, all of the programs on channel "Nickelodeon" are not imported. I thought I would trick the import and copy / paste the entire block of Nickelodeon programs higher up in the tv-guide.xml file (inbetween two other channels), but it gives me the same result of 6035 programs imported... In the logfile it says at the bottom that 40 channels were imported. Now I do indeed have 40 channels defined in my WebEPG.xml file, but if you look at the details of imported programs per channel, there are obviously a number of channels skipped and not imported. Attached are my WebEPG.xml, tv-guide.xml and tv.log files. And now I hope that someone can tell me which obvious detail I have missed.... Thanks in advance!! Last edited by Mercbac; 2008-04-24 at 17:53.

2008-04-21, 10:43	#2 (permalink)
robyf Portal Member Join Date: Jun 2005 Location: Bolzano Age: 37 Posts: 214 Thanks: 28 Thanked 4 Times in 4 Posts Country: My System	The attached log file seems to be corrupt. I think I have the same problem but I was not able to retrieve logs of it. How do you enable logging of import events? Roby __________________ Roby Download italian myvideos IMDB script yahoo.it Download italian myvideos IMDB script mymovies.it Visit my iPod Italian site: http://www.ipoditalia.it

2008-04-21, 11:07	#3 (permalink)
Mercbac Portal Member Join Date: Mar 2007 Posts: 73 Thanks: 5 Thanked 1 Time in 1 Post Country: My System	The .zip file was compressed with high compression in Winzip 11 (took an extra 200KB off the filesize) so you'll need that one to unpack it. Just did it on my work-PC where I don't have a local copy of that attachment and all 3 included files look fine. On my HTPC, the tv.log automatically logs import events. I did read in another thread though that it could help to delete the entire log directory under the TV server if it only logs one line. EDIT: The behaviour does seem consistent with newer downloaded tvguide.xml files, but it did not happen on my previous MP install with 0.2.3.0 + SVN 2008-03-14 Last edited by Mercbac; 2008-04-21 at 21:27.

2008-04-22, 22:33	#5 (permalink)
Paranoid Delusion Super Moderator Join Date: Jun 2005 Location: Cheshire UK Posts: 5,932 Thanks: 106 Thanked 179 Times in 161 Posts Country: My System	Yep, been there done it, end up chasing your own tail. __________________ Ray\PD Check your codecs are fine with Filmerit. XP\Vista known issues FOR FULL SUPPORT PLEASE GIVE USER SPECIFICATIONS AND RELEVANT LOG's as per HERE

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

2008-04-22, 21:29	#4 (permalink)
Mercbac Portal Member Join Date: Mar 2007 Posts: 73 Thanks: 5 Thanked 1 Time in 1 Post Country: My System	Well, I caused it myself, so no blame on the importer... What happened was that I uninstalled my previous MP 0.2.3.0 install, but exported all TV channels from my TV server database before uninstalling. After installing 1.0.0.0 RC1 I imported that list and somehow the column 'externalId' in the table 'channels' was left blank for exactly those channels that were being skipped by the importer. After fixing them in MySQL Query Browser the importer now picks up these channels too. So lesson learned is that it's always best to start from scratch and get rid of the old stuff. Nothing beats a clean install!