Is there any way to retain series when switching to EPG123?

An evolving, supported alternative to Rovi
Forum rules
★ Download the latest EPG123 here: https://garyan2.github.io/ <> Setup guide here: https://garyan2.github.io/install.html
User avatar
garyan2

Posts: 7438
Joined: Fri Nov 27, 2015 7:23 pm
Location:

HTPC Specs: Show details

#41

Post by garyan2 » Thu Aug 03, 2017 3:25 am

Okay, this probably should be part of the v1.1.11 release thread as well, but figure this one is more appropriate.

dave669 asked me a question concerning user provided input to help build the conversion database, listing tvdb as a source for determining the zap2it (TMS/Gracenote) id along with the Rovi id in the backup recording file. Well, this got the gray matter working on possibilities, so I will float this out there.

Since I already have a tvdb api key, and have some experience in the past with their xml server, I thought up some expanded capabilities for the conversion tool...

For the series that do not have a value in the conversion database (pink rows), I could set it up so that a right-click on the series will bring up another window. In that window would be 3 panes. The left would be the Rovi series title and description (stored in the recordings file), the middle will be a tvdb title search results which the user will select the matching series, and the right pane will be the Gracenote series that the tvdb title result identifies. If they all match, then the user can accept the Gracenote ID and it will be available to import into the guide. No need to wait for the database to be updated.

As a bonus, I'm thinking that these matches could be emailed to the epg123 server for me to review and manually add to the database ... don't know if I'm willing to invest that much time though. I would imagine there are a lot of different series out there folks are recording that aren't active and/or in the conversion database.

Now, everyone throw rocks at the idea and see if it breaks.
- Gary
Keeping WMC alive beyond January 2020. https://garyan2.github.io

Sammy2

Posts: 1708
Joined: Fri Aug 24, 2012 7:35 pm
Location:

HTPC Specs: Show details

#42

Post by Sammy2 » Thu Aug 03, 2017 6:18 pm

I'm wondering if there's anything you need from us to enhance and improve the series transition database?

User avatar
garyan2

Posts: 7438
Joined: Fri Nov 27, 2015 7:23 pm
Location:

HTPC Specs: Show details

#43

Post by garyan2 » Sat Aug 05, 2017 5:35 am

I'm getting there. This is what the expanded tool will look like to convert the MS/Rovi series id to a Gracenote/SD id. theTVDB is the middle man that may provide the Gracenote id. You'll be able to read the description from MS/Rovi, theTVDB, and SD to compare as well as verify theTVDB and SD are the same based on artwork.
2017-08-04.png
2017-07-28 (1).png
I'm still going to be keeping the database updated as much as I can, but MS/Rovi is making that extremely difficult since it has been 5 days since their last update to WMC.
- Gary
Keeping WMC alive beyond January 2020. https://garyan2.github.io

User avatar
garyan2

Posts: 7438
Joined: Fri Nov 27, 2015 7:23 pm
Location:

HTPC Specs: Show details

#44

Post by garyan2 » Sat Aug 05, 2017 10:04 pm

Keep an eye out for the next release. Updated tool has great success in converting Rovi to Gracenote using thetvdb. Probably put it out late tonight. I have a feeling a lot of the holdouts would greatly appreciate it.
- Gary
Keeping WMC alive beyond January 2020. https://garyan2.github.io

User avatar
TheOsburnFamil

Posts: 322
Joined: Sat Jun 11, 2011 10:52 pm
Location:

HTPC Specs: Show details

#45

Post by TheOsburnFamil » Sun Aug 06, 2017 3:12 am

garyan2 wrote:Keep an eye out for the next release. Updated tool has great success in converting Rovi to Gracenote using thetvdb. Probably put it out late tonight. I have a feeling a lot of the holdouts would greatly appreciate it.
Looking forward to this for sure. Fortunately summer has been slow but I'm looking forward to fixing all my series.
Matt O. ...tivo what? ...dish dvr--uh... huh? ...cable dvr fees--you're kidding, right?

User avatar
garyan2

Posts: 7438
Joined: Fri Nov 27, 2015 7:23 pm
Location:

HTPC Specs: Show details

#46

Post by garyan2 » Sun Aug 06, 2017 3:31 am

TheOsburnFamil wrote:
garyan2 wrote:Keep an eye out for the next release. Updated tool has great success in converting Rovi to Gracenote using thetvdb. Probably put it out late tonight. I have a feeling a lot of the holdouts would greatly appreciate it.
Looking forward to this for sure. Fortunately summer has been slow but I'm looking forward to fixing all my series.
Just release v1.1.12 with the improvements.
- Gary
Keeping WMC alive beyond January 2020. https://garyan2.github.io

User avatar
TheOsburnFamil

Posts: 322
Joined: Sat Jun 11, 2011 10:52 pm
Location:

HTPC Specs: Show details

#47

Post by TheOsburnFamil » Sun Aug 06, 2017 3:35 am

garyan2 wrote:Just release v1.1.12 with the improvements.
Nice! I'll load it up first thing in the morning. Excellent work.
Matt O. ...tivo what? ...dish dvr--uh... huh? ...cable dvr fees--you're kidding, right?

User avatar
12noon

Posts: 127
Joined: Mon Oct 06, 2014 4:23 pm
Location:

HTPC Specs: Show details

#48

Post by 12noon » Sun Aug 06, 2017 1:32 pm

The 1.1.12 version of the transfer tool is throwing a .NET exception saying the Newtonsoft package is the wrong version. Did you update the NuGet package but forget to ship the new DLL? :)

It occurs when selecting the Match command.

Code: Select all

See the end of this message for details on invoking 
just-in-time (JIT) debugging instead of this dialog box.

************** Exception Text **************
System.BadImageFormatException: Could not load file or assembly 'Newtonsoft.Json, Version=8.0.0.0, Culture=neutral, PublicKeyToken=30ad4fe6b2a6aeed' or one of its dependencies. This assembly is built by a runtime newer than the currently loaded runtime and cannot be loaded.
File name: 'Newtonsoft.Json, Version=8.0.0.0, Culture=neutral, PublicKeyToken=30ad4fe6b2a6aeed'
   at epg123Transfer.tvdbApi.tvdbSearchSeriesTitle(String title)
   at epg123Transfer.frmManualMatch.frmManualMatch_Shown(Object sender, EventArgs e)
   at System.Windows.Forms.Form.OnShown(EventArgs e)
   at System.Windows.Forms.Form.CallShownEvent()
   at System.Windows.Forms.Control.InvokeMarshaledCallbackDo(ThreadMethodEntry tme)
   at System.Windows.Forms.Control.InvokeMarshaledCallbackHelper(Object obj)
   at System.Threading.ExecutionContext.runTryCode(Object userData)
   at System.Runtime.CompilerServices.RuntimeHelpers.ExecuteCodeWithGuaranteedCleanup(TryCode code, CleanupCode backoutCode, Object userData)
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Windows.Forms.Control.InvokeMarshaledCallback(ThreadMethodEntry tme)
   at System.Windows.Forms.Control.InvokeMarshaledCallbacks()

WRN: Assembly binding logging is turned OFF.
To enable assembly bind failure logging, set the registry value [HKLM\Software\Microsoft\Fusion!EnableLog] (DWORD) to 1.
Note: There is some performance penalty associated with assembly bind failure logging.
To turn this feature off, remove the registry value [HKLM\Software\Microsoft\Fusion!EnableLog].



************** Loaded Assemblies **************
mscorlib
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.8762 (QFE.050727-8700)
    CodeBase: file:///C:/Windows/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll
----------------------------------------
epg123Transfer
    Assembly Version: 1.1.0.0
    Win32 Version: 1.1.0.0
    CodeBase: file:///D:/EPG123/epg123Transfer.exe
----------------------------------------
System.Windows.Forms
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.5491 (Win7SP1GDR.050727-5400)
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
----------------------------------------
System
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.8759 (QFE.050727-8700)
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
System.Drawing
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.5495 (Win7SP1GDR.050727-5400)
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
----------------------------------------
System.Core
    Assembly Version: 3.5.0.0
    Win32 Version: 3.5.30729.5420 built by: Win7SP1
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Core/3.5.0.0__b77a5c561934e089/System.Core.dll
----------------------------------------
System.Configuration
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.5483 (Win7SP1GDR.050727-5400)
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Configuration/2.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
----------------------------------------
System.Xml
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.5494 (Win7SP1GDR.050727-5400)
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll
----------------------------------------
mcepg
    Assembly Version: 6.1.0.0
    Win32 Version: 6.1.7601.17514
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/mcepg/6.1.0.0__31bf3856ad364e35/mcepg.dll
----------------------------------------
mcstore
    Assembly Version: 6.1.0.0
    Win32 Version: 6.1.7601.17514 (win7sp1_rtm.101119-1850)
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/mcstore/6.1.0.0__31bf3856ad364e35/mcstore.dll
----------------------------------------
mcstoredb
    Assembly Version: 6.1.0.0
    Win32 Version: 6.1.7601.17514 (win7sp1_rtm.101119-1850)
    CodeBase: file:///C:/Windows/assembly/GAC_32/mcstoredb/6.1.0.0__31bf3856ad364e35/mcstoredb.dll
----------------------------------------
Microsoft.MediaCenter.UI
    Assembly Version: 6.1.0.0
    Win32 Version: 6.1.7601.17514 (win7sp1_rtm.101119-1850)
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Microsoft.MediaCenter.UI/6.1.0.0__31bf3856ad364e35/Microsoft.MediaCenter.UI.dll
----------------------------------------
ehiProxy
    Assembly Version: 6.1.0.0
    Win32 Version: 6.1.7601.17514 (win7sp1_rtm.101119-1850)
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/ehiProxy/6.1.0.0__31bf3856ad364e35/ehiProxy.dll
----------------------------------------
BDATunePIA
    Assembly Version: 6.1.0.0
    Win32 Version: 6.1.7601.17514 (win7sp1_rtm.101119-1850)
    CodeBase: file:///C:/Windows/assembly/GAC_32/BDATunePIA/6.1.0.0__31bf3856ad364e35/BDATunePIA.dll
----------------------------------------
pvwsill3
    Assembly Version: 1.1.0.0
    Win32 Version: 2.0.50727.8759 (QFE.050727-8700)
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
----------------------------------------

************** JIT Debugging **************
To enable just-in-time (JIT) debugging, the .config file for this
application or computer (machine.config) must have the
jitDebugging value set in the system.windows.forms section.
The application must also be compiled with debugging
enabled.

For example:

<configuration>
    <system.windows.forms jitDebugging="true" />
</configuration>

When JIT debugging is enabled, any unhandled exception
will be sent to the JIT debugger registered on the computer
rather than be handled by this dialog box.
USA 60005
WOW Chicago Suburbs - Digital
USA-IL58819-X

User avatar
garyan2

Posts: 7438
Joined: Fri Nov 27, 2015 7:23 pm
Location:

HTPC Specs: Show details

#49

Post by garyan2 » Sun Aug 06, 2017 3:01 pm

No changes to the json dll... the Newtonsoft.Json.dll file needs to be in the same folder as the tool to run since it has to query theTVDB and Schedules Direct which both use JSON.

BUT... I just recreated this problem which will only be in Windows 7 that I have to figure out. The Win7 version of the tool needs to target .NET 3.5 to interact with the WMC database, so in Visual Studio is uses the 3.5 version of the json dll. The dll version that is shipped with epg123 is 4.0 for the main epg123 program.

A stop gap right now would be to put the tool in its own folder with the 3.5 version you can download from http://epg123.garyan2.net/downloads/New ... son3.5.zip .

Hopefully I'll find a proper resolution soon. Sorry everybody! :oops:
- Gary
Keeping WMC alive beyond January 2020. https://garyan2.github.io

User avatar
12noon

Posts: 127
Joined: Mon Oct 06, 2014 4:23 pm
Location:

HTPC Specs: Show details

#50

Post by 12noon » Sun Aug 06, 2017 3:42 pm

Since WMC targets .NET 2 and .NET 4 changed how it loads legacy frameworks, my solution for my own apps is to add this to the app.config file:

Code: Select all

  <startup useLegacyV2RuntimeActivationPolicy="true">
    <supportedRuntime version="v4.0" sku=".NETFramework,Version=v4.5" />
  </startup>
USA 60005
WOW Chicago Suburbs - Digital
USA-IL58819-X

User avatar
garyan2

Posts: 7438
Joined: Fri Nov 27, 2015 7:23 pm
Location:

HTPC Specs: Show details

#51

Post by garyan2 » Sun Aug 06, 2017 3:46 pm

12noon wrote:Since WMC targets .NET 2 and .NET 4 changed how it loads legacy frameworks, my solution for my own apps is to add this to the app.config file:

Code: Select all

  <startup useLegacyV2RuntimeActivationPolicy="true">
    <supportedRuntime version="v4.0" sku=".NETFramework,Version=v4.5" />
  </startup>
I had tried that before with the client software with little success (different scenario). I'll give that a shot. Right now I'm looking at NuGet package Costura.Fody to embed the 3.5 dll in the Win7 tool. What you suggest, if it works, will be much cleaner though.

Thanks.
- Gary
Keeping WMC alive beyond January 2020. https://garyan2.github.io

User avatar
garyan2

Posts: 7438
Joined: Fri Nov 27, 2015 7:23 pm
Location:

HTPC Specs: Show details

#52

Post by garyan2 » Sun Aug 06, 2017 6:45 pm

Ended up embedding the dll into both the epg123Transfer.exe and the epg123.exe files. The Win7 version of the transfer tool will get the .NET 3.5 version of the json dll while all the others will get the .NET 4.0 version.

New version 1.1.13 released.
- Gary
Keeping WMC alive beyond January 2020. https://garyan2.github.io

User avatar
12noon

Posts: 127
Joined: Mon Oct 06, 2014 4:23 pm
Location:

HTPC Specs: Show details

#53

Post by 12noon » Sun Aug 06, 2017 9:02 pm

Cool. Thanks for fixing that so quickly.
USA 60005
WOW Chicago Suburbs - Digital
USA-IL58819-X

Post Reply