GuidePlus for NPVR

[toricred]

guideplus xmlin=c:\xmltvgrab\dtv.xml xmout=c:\xmltvgrab\npvr.xml

Also, should the data appear in the guide? I'm not seeing it.

[toricred]

And after changing a few more stations to point to the XMLTV file modified by GuidePlus, I'm getting the following error:

2012-11-06 17:44:10.016 [ERROR][6] Unexpected error in UpdateRecurringRecording(): System.NullReferenceException: Object reference not set to an instance of an object.
at NShared.RecordingServiceProxy.UpdateRecurringRecording(RecurringRecording recurringRecording)

Changing them back to look at SchedulesDirect in the GUI doesn't fix this.

[carpeVideo]

I recommend removing the trigger then and seeing if that fixes everything. Can you attach the logfile for guideplus for its last run

[toricred]

How do I remove the trigger? It also appears that all my Advanced Rules for my recurring recordings (almost all the recordings I have set up) are gone. Finally, where is the log file?

I was able to recover my advanced rules by re-using Martin's program to import from FTR.

[carpeVideo]

The syntax is drop trigger recordingInserted. I assume you can execute an SQL statement since you changed the null issue. I apologize for the mess up, everything runs well on both my dev machine and NPVR machine. It will be best in the end to get rid of the extra non standard table so give me a few days, shorter if I am lucky. The log file does not exist as it wasn't in your parms so never mind on that one.

I don't know why you would lose any recording rules, guidePlus does not touch that.

[toricred]

It's just the advanced rule portion that was lost. I agree that the extra table is not optimal. I have dropped the trigger now so I should be good on that account. Thanks for the help on this.

[carpeVideo]

Give this version a try - since all you want is to alter the guide - open the new xml file with notepad++ or something and look at an entry for a movie and a series that you have/are recording. If the subtitle has s01e01 or something similar you know it is doing the correct thing. If you like it later you can add rename=on and all recordings that are a series that it can figure out the season string for will be renamed to add the season episode and subtitle to the filename.

If the original guide entry does not have a unique id starting with ep or a season episode number already it won't work unless you manually create a starting showfile with the list of title that you want altered. (since looking up every show would take too long it only adds the guide data to series you are or have recorded or is explicitly in the showfile)

CV

[toricred]

That looks like it builds the xml right, but now I'm getting a new error. Also attached is the log file:

2012-11-06 21:31:00.511 [ERROR][7] Unexpected error parsing EPGEvent xml: System.Xml.XmlException: An error occurred while parsing EntityName. Line 3, position 14.
at System.Xml.XmlTextReaderImpl.Throw(Exception e)
at System.Xml.XmlTextReaderImpl.Throw(String res, String arg)
at System.Xml.XmlTextReaderImpl.Throw(String res)
at System.Xml.XmlTextReaderImpl.ParseEntityName()
at System.Xml.XmlTextReaderImpl.ParseEntityReference()
at System.Xml.XmlTextReaderImpl.Read()
at System.Xml.XmlLoader.LoadNode(Boolean skipOverWhitespace)
at System.Xml.XmlLoader.LoadDocSequence(XmlDocument parentDoc)
at System.Xml.XmlLoader.Load(XmlDocument doc, XmlReader reader, Boolean preserveWhitespace)
at System.Xml.XmlDocument.Load(XmlReader reader)
at System.Xml.XmlDocument.LoadXml(String xml)
at NUtility.EPGEvent.Parse(String xml)
2012-11-06 21:31:00.511 [ERROR][7] xml:
<Event>
<OID>18715</OID>
<Title>Lois & Clark: The New Adventures of Superman</Title>
<SubTitle>s04e01: Lord of the Flys</SubTitle>
<Description>1996-09-22: Lois and Clark&apos;s relationship hangs in the balance as Clark is forced to adhere to kryptonian law and marry the woman he was pledged to at birth.</Description>
<ChannelOID>7301</ChannelOID>
<StartTime>11/5/2012 12:59:09 AM</StartTime>
<EndTime>11/5/2012 2:02:00 AM</EndTime>
</Event>
2012-11-06 21:31:00.513 [ERROR][7] Unexpected error in UpdateRecurringRecording(): System.NullReferenceException: Object reference not set to an instance of an object.
at NShared.RecordingServiceProxy.UpdateRecurringRecording(RecurringRecording recurringRecording)
2012-11-06 21:31:00.513 [INFO][7] UpdateRecurringRecording(72, 'The Mindy Project'):
<Rules><ChannelOID>0</ChannelOID><ChannelName>All Channels</ChannelName><StartTime>2012-09-01T06:00:00.0000000Z</StartTime><EndTime>2012-09-02T05:59:59.0000000Z</EndTime><PrePadding>1</PrePadding><PostPadding>2</PostPadding><Quality>QUALITY_DEFAULT</Quality><Keep>0</Keep></Rules>

[mvallevand]

For the first error this is bad xml

<Title>Lois & Clark: The New Adventures of Superman</Title>

For the second error it looks like the advanced rules got wiped out of your Rules again. Here is how the FTR import created it for me.

Code:

<Rules>
  <ChannelOID>0</ChannelOID>
  <ChannelName>All Channels</ChannelName>
  <StartTime>2012-09-01T04:00:00.0000000</StartTime>
  <EndTime>2012-09-02T03:59:59.0000000</EndTime>
  <PrePadding>1</PrePadding>
  <PostPadding>2</PostPadding>
  <Quality>0</Quality>
  <Keep>0</Keep>
  <AdvancedRules>title like &apos;The Mindy Project&apos; and subtitle != &apos;&apos; and subtitle not in (select XmlLookup(event_details,&apos;/Event/SubTitle&apos;) as subtitle from scheduled_recording where name like &apos;The Mindy Project&apos;) </AdvancedRules>
</Rules>

Another thing in that error report is <Quality>QUALITY_DEFAULT</Quality> I am not sure where that is coming from.

Martin

[carpeVideo]

The bad xml should be fixed with the attached version. I don't have Lois & Clark in the guide so the error never occurred for me.

GuidePlus does not touch <AdvancedRules> or <Quality> so unless the first error is causing the second I don't know what is happening there.


Let me know if it works so I don't post a broken version.

CV