SchedulesDirect Utilities Updated

[UncleJohnsBand]

9/22/2014 *** Schedules Direct Utilities will no longer work with the move of source data to JSON based API. I am not sure if I will remediate the utility to work with the JSON API or not. ***


SchedulesDirect Utilities has been updated.

This utility now provides extended EPG data to EWA(GBPVR) and NEWA (NPVR) users that utilize SchedulesDirect EPG data.

NPVR Users will need the attached NEWA patch & NPVR patch to re-enable the feature within NEWA until the next NPVR release.

This release has the following changes:

• Utility now supports both EWA for GBPVR and NEWA for NPVR.
  

You can download it from the wiki page or from here directly.

Source code is also available on the wiki at the bottom of the page or from here directly.

If you have any questions or problems please post in this Support Sub-Forum.

Enjoy!

[mulletback]

Gave it a try - looks like errors reading the sd.xml file.

[UncleJohnsBand]

Gave it a try - looks like errors reading the sd.xml file.

Crap...forgot about a patch sub had to do to fix that.....I added it to the original post above.....let me know how it goes.

[mulletback]

Thanks, that did it - now to see how best to use it... ;-)

[ElihuRozen]

If I don't use SchedulesDirect, would it be possible for me to use these? I use mc2xml which generates XML files that have the data, but in a different format than what you are looking for. Looking at your source code, I see the following possibilities in increasing likelihood of happening:

- convince sub to output an sd.xml when he uses an XML file for input other than SD. My hunch is he is just saving the SD file that he reads & not doing anything processing it before saving it. I don't see any reason for him to implement something like this.

- convince you (UJB) to modify your code to be able to read other XML files. Again, I really don't see any reason for you to do this.

- I create a modified version of your code that handles other XML files. Then, you are stuck supporting someone else's code & I don't know if I have access to VS 2008 to do it any way.

- I create a tool that reads my XML file and outputs one in the format you are looking for. Any enhancements either of us make in the future would be independent of the other's code.

[skreien]

When I try to run it I get errors. Here's the output:


C:\Documents and Settings\All Users\Application Data\NPVR\SchedulesDirect_Utilit
ies_20110101>c:

C:\Documents and Settings\All Users\Application Data\NPVR\SchedulesDirect_Utilit
ies_20110101>cd "C:\Documents and Settings\All Users\Application Data\NPVR\Sched
ulesDirect_Utilities_20110101"

C:\Documents and Settings\All Users\Application Data\NPVR\SchedulesDirect_Utilit
ies_20110101>schedulesdirectimport [email]username[/email] password 1>schedulesdirect
import.log

Unhandled Exception: System.IO.FileNotFoundException: Could not load file or ass
embly 'System.Data.SQLite, Version=1.0.65.0, Culture=neutral, PublicKeyToken=db9
37bc2d44ff139' or one of its dependencies. The system cannot find the file speci
fied.
File name: 'System.Data.SQLite, Version=1.0.65.0, Culture=neutral, PublicKeyToke
n=db937bc2d44ff139'
at schedulesdirectmetadata.DatabaseHelper.GetOpenSchedulesDirectDbConnection(
)
at schedulesdirectmetadata.DatabaseHelper.RemoveAllRecordings() in C:\Visual
Studio Local\SchedulesDirectUtilities\SchedulesDirectInterface\DatabaseHelper.cs
:line 475
at schedulesdirectmetadata.MainClass.Main(String[] args) in C:\Visual Studio
Local\SchedulesDirectUtilities\SchedulesDirectImport\Main.cs:line 77

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


C:\Documents and Settings\All Users\Application Data\NPVR\SchedulesDirect_Utilit
ies_20110101>rem

C:\Documents and Settings\All Users\Application Data\NPVR\SchedulesDirect_Utilit
ies_20110101>pause
Press any key to continue . . .

[UncleJohnsBand]

When I try to run it I get errors. Here's the output:


C:\Documents and Settings\All Users\Application Data\NPVR\SchedulesDirect_Utilit
ies_20110101>c:

C:\Documents and Settings\All Users\Application Data\NPVR\SchedulesDirect_Utilit
ies_20110101>cd "C:\Documents and Settings\All Users\Application Data\NPVR\Sched
ulesDirect_Utilities_20110101"

C:\Documents and Settings\All Users\Application Data\NPVR\SchedulesDirect_Utilit
ies_20110101>schedulesdirectimport [email]username[/email] password 1>schedulesdirect
import.log

Unhandled Exception: System.IO.FileNotFoundException: Could not load file or ass
embly 'System.Data.SQLite, Version=1.0.65.0, Culture=neutral, PublicKeyToken=db9
37bc2d44ff139' or one of its dependencies. The system cannot find the file speci
fied.
File name: 'System.Data.SQLite, Version=1.0.65.0, Culture=neutral, PublicKeyToke
n=db937bc2d44ff139'
at schedulesdirectmetadata.DatabaseHelper.GetOpenSchedulesDirectDbConnection(
)
at schedulesdirectmetadata.DatabaseHelper.RemoveAllRecordings() in C:\Visual
Studio Local\SchedulesDirectUtilities\SchedulesDirectInterface\DatabaseHelper.cs
:line 475
at schedulesdirectmetadata.MainClass.Main(String[] args) in C:\Visual Studio
Local\SchedulesDirectUtilities\SchedulesDirectImport\Main.cs:line 77

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


C:\Documents and Settings\All Users\Application Data\NPVR\SchedulesDirect_Utilit
ies_20110101>rem

C:\Documents and Settings\All Users\Application Data\NPVR\SchedulesDirect_Utilit
ies_20110101>pause
Press any key to continue . . .

Copy the system.data.sqlite.dll file from your npvr directory into the directory you created for SchedulesDirectUtilities to run in.

[skreien]

NEWA doesn't seem to be picking up the extendedewa.db3 information. Where does that file need to be in NPVR?

[UncleJohnsBand]

NEWA doesn't seem to be picking up the extendedewa.db3 information. Where does that file need to be in NPVR?

Same directory as your npvr.db3 file.

[skreien]

Been playing with it on and off... looks like the database is populated, but the additional info isn't appearing in NEWA.