(original thread) US/Canadian/Mexico EPG Zap2it Plugin Released (1 Viewer)

[patrick]

I think I am missing simple, but it is going right past me.

My bad, I was not thinking.

Try this SQL using the above instructions:
update channel set frequency=1111000

Just tested and all went ok.

HTH,
patrick

 

[mzemina]

I think I am missing simple, but it is going right past me.

My bad, I was not thinking.

Try this SQL using the above instructions:
update channel set frequency=1111000

Just tested and all went ok.

HTH,
patrick

BINGO - That was it! Many, many

 

[natrlhy]

The bug is actually in the TVDatabase.cs file in the MP source about line 3258-3260 in the MapATSCChannel method.

the String.Format SQL for "update tblATSCMapping"
has ..., majorChannel={22}, minorChannel={23}
but the replaced values have minorChannel then majorChannel

I will try to post something in the development forum.

HTH,
patrick

Just wanted to post an update regarding this. I was talking with the devs on IRC and micheloe made the changes. The latest SVN as of 04/10/2006 (thats October 4th ) should have this fix. I will test this out tonight.

MediaPortal TVDatabase
04/10/2006 [21:49h] micheloe added: Fixed major/minor ATSC channel numbers were mixed up when editing a channel

 

[patrick]

Just wanted to post an update regarding this. I was talking with the devs on IRC and micheloe made the changes. The latest SVN as of 04/10/2006 (thats October 4th ) should have this fix. I will test this out tonight.

MediaPortal TVDatabase
04/10/2006 [21:49h] micheloe added: Fixed major/minor ATSC channel numbers were mixed up when editing a channel

Thanks for the update!

patrick

 

[cowpie]

Hi,
Can someone add this plugin to this wiki entry? I don't know how to do that:

http://wiki.team-mediaportal.com/UserGuides/Country_based_EPG

I had ot search the forum for days (not exaggerating ) to find this plugin because, if you search for "Canada" on that wiki entry, nothing comes up!

 

[cowpie]

OK, so I got to the the autotune step. But when I restart MediaPortal, it doesn't download the guides...what can I do now? I don't have firewall (use NAT) and my username and password are correct, and I have a lineup configure at labs.zap2it.com . i use analog cable. I tried setting the "force update on next restart" option, didn't help.

Most oddly, it seems the plugin never even starts. Logs\epg.log is not there! I'm using the October 8th svn, before that october 7.. And yes it is installed in \Team MediaPortal\MediaPortal\Plugins\Process\Zap2itPlugin.dll

So my entire tv guide is still empty and just says "no data available"

EDIT:
I did find a zap2it mention in error.log though: http://pastebin.com/802463

2006-10-08 07:57:25.281250 [ERROR][MPMain]: SQL:TVDatabaseV21.db3 cmd:sqlite3_prepare16:pvm=null err:ERROR detailed:duplicate column name: idCard query:ALTER TABLE recorded ADD COLUMN idCard integer
2006-10-08 07:57:25.296875 [ERROR][MPMain]: TVDatabase exception err:SQL:TVDatabaseV21.db3 cmd:sqlite3_prepare16:pvm=null err:ERROR detailed:duplicate column name: idCard query:ALTER TABLE recorded ADD COLUMN idCard integer stack:   at SQLite.NET.SQLiteClient.ThrowError(String statement, String sqlQuery, SqliteError err)
   at SQLite.NET.SQLiteClient.Execute(String query)
   at MediaPortal.TV.Database.TVDatabase.UpdateFromPreviousVersion()
   at MediaPortal.TV.Database.TVDatabase.Open()
2006-10-08 07:57:29.328125 [ERROR][MPMain]: Unable to start plugin:ProcessPlugins.EpgGrabber.Zap2itPlugin exception:System.MissingMethodException: Method not found: 'Void MediaPortal.GUI.Library.Log.WriteFile(LogType, System.String, System.Object[])'.
   at ProcessPlugins.EpgGrabber.Zap2itPlugin.MediaPortal.GUI.Library.IPlugin.Start()
   at MediaPortal.GUI.Library.PluginManager.Start()

Mediaportal.log (excerpt): http://pastebin.com/802465

2006-10-08 07:57:29.156250 [Info.][MPMain]:   Load plugins from :C:\Program Files\Team MediaPortal\MediaPortal\plugins\process\XBMCServer.dll
2006-10-08 07:57:29.171875 [Info.][MPMain]:   Load plugins from :C:\Program Files\Team MediaPortal\MediaPortal\plugins\process\Zap2itPlugin.dll
2006-10-08 07:57:29.171875 [Info.][MPMain]:   PlugInManager.Start()
2006-10-08 07:57:29.187500 [Info.][MPMain]: PowerScheduler: version 0.3
2006-10-08 07:57:29.187500 [Info.][MPMain]: PowerScheduler: Settings loaded - wakeup 1, shutdown 0, mode Suspend
2006-10-08 07:57:29.187500 [Info.][MPMain]: PowerScheduler: Shutdown on idle - disabled
2006-10-08 07:57:29.203125 [Info.][MPMain]: XBMCServer Starting
2006-10-08 07:57:29.203125 [Info.][8]: XBMCServer binding to adress: 192.168.2.31 on port 13000
2006-10-08 07:57:29.218750 [Info.][8]: XBMCServer: Waiting for a connection... 
2006-10-08 07:57:29.218750 [Info.][MPMain]: XBMCServer: Found recoding path C:\Documents and Settings\username\My Documents\My Recordings
2006-10-08 07:57:29.328125 [Info.][MPMain]: Unable to start plugin:ProcessPlugins.EpgGrabber.Zap2itPlugin exception:System.MissingMethodException: Method not found: 'Void MediaPortal.GUI.Library.Log.WriteFile(LogType, System.String, System.Object[])'.
   at ProcessPlugins.EpgGrabber.Zap2itPlugin.MediaPortal.GUI.Library.IPlugin.Start()
   at MediaPortal.GUI.Library.PluginManager.Start()
2006-10-08 07:57:31.640625 [Info.][6]: mpeg2:MPEG2 demuxer map MPG stream 0xe0->video output pin
2006-10-08 07:57:31.640625 [Info.][6]: mpeg2:mapped MPEG2 demuxer stream 0xe0->video output 
2006-10-08 07:57:31.640625 [Info.][6]: mpeg2:MPEG2 demuxer map MPG stream 0xc0->audio output pin
2006-10-08 07:57:31.640625 [Info.][6]: mpeg2:mapped MPEG2 demuxer stream 0xc0->audio output
2006-10-08 07:57:31.671875 [Info.][6]: mpeg2:MPEG2 demuxer map LPCM stream 0xbd->audio output pin
2006-10-08 07:57:31.671875 [Info.][6]: mpeg2:mapped MPEG2 demuxer stream 0xbd->audio output
2006-10-08 07:57:31.703125 [Info.][6]: SinkGraphEx: VideoProcAmp setting defaults
2006-10-08 07:57:31.718750 [Info.][6]: SinkGraphEx:CreateGraph() OUT

EDIT: Never mind! SVN users, go to post 193 https://forum.team-mediaportal.com/showpost.php?p=80151&postcount=193

Could you edit your first post to include these (or could a mod?) for any others? Thanks, and great plugin

 

[patrick]

I am testing a change to the zap2it plugin.

Part of the initial matching of channels the plugin
does two checks by by channel number, first comparing the
MediaPortal channel number to the zap2it broadcast channel number
then if no match is found it compares MediaPortal channel number
to the zap2it majorchannel number.
I have switched the order of these in this test.

The reason is that the broadcast channel number is often the OTA channel
number and the Major Channel number the Cable/Sat channel number this
can result in incorrect mapping depending on the order the channels are
processed and if there are overlaps between the OTA channels and the
cable/sat channels.

This change could cause problems with initial mapping of OTA channels.

Maybe this should be an option?

Anyway, if you are interested in testing it the files are attached.
(only attached the dll files since this is a test)

Thanks to fod for pointing this out.

patrick

 

[natrlhy]

I'm game! I'll try this out tonight or tomorrow and post the results.

EDIT: Here is my epg.log file. Seems to have updated what I expected regarding my OTA channels. I did an autotune for my OTA HD channels and the rest was created by the plugin and my zap2it account settings.

 

[patrick]

I'm game! I'll try this out tonight or tomorrow and post the results.

EDIT: Here is my epg.log file. Seems to have updated what I expected regarding my OTA channels. I did an autotune for my OTA HD channels and the rest was created by the plugin and my zap2it account settings.

Wow that was fast. Thanks!

patrick

 

[opusnut]

we need a new build of this plugin for 0.2.1

thanx