How does ... use season & episode if possible and Title match work ?

[puck64]

Hi All,

I have written a small app to update the Season and Episode columns with data gleaned from the Description column.
See http://forums.nextpvr.com/showthread.php...-EPG_EVENT

I am still getting recordings without the season and or the episode
Eg. "Top Gear (Includes Sneak Peek - The Block at 928 PM)_20150831_20012130.ts" instead of "Top Gear (Includes Sneak Peek - The Block at 928 PM).S00E01.ts"

From EPG_EVENT Table
Title = "Top Gear (Includes Sneak Peek - The Block at 9:28 PM)"
Description = "Patagonia - Part 1Clarkson, Hammond and May embark on a journey to the southernmost point of South America."
Season = "0" Episode ="1"

Has anyone got any ideas why?

Match Start Of Title and Match Exact Title ... How do these work? It could save from writing another RexX Program to "CLEAN" up the FTA Data.
... to Remove the likes of "- New Episode" , " - New (Includes Sneak Peek...." etc.

[Graham]

You might want to turn this on its head.

DVBguide will collect the EPG data from the OTA stream and create an XMLTV file. NextPVR can input EPG data from the XMLTV file ... http://myweb.tiscali.co.uk/pclare/DVBGuide/
You can manipulate the XMLTV data before NextPVR reads the file as part of updateepg.bat ... http://www.nextpvr.com/nwiki/pmwiki.php?...BatchFiles
I use this which copies the Series and Episode into the subtitle (among other transforms) but the syntax is utterly opaque ... http://forums.nextpvr.com/showthread.php...post434477

I used REXX in my mainframe days. I reckon that REXX would be good for manipulating xmltv files but I have never got around to doing anything about it.

[puck64]

Hi Graham,

I can clean up the Database easier than I could collect and edit the XML.

The data in the xml is the same as the Database (at a glance). It contains the likes of "Locked Up Abroad - New Episode" and
"Nine's Morning News (Includes Sneak Peek - House Husbands at 12:00 PM)"

I did notice that there was a single GENRE rather than composite genre as used in the db.

[johnsonx42]

Hi All,

I have written a small app to update the Season and Episode columns with data gleaned from the Description column.
See http://forums.nextpvr.com/showthread.php...-EPG_EVENT

I am still getting recordings without the season and or the episode
Eg. "Top Gear (Includes Sneak Peek - The Block at 928 PM)_20150831_20012130.ts" instead of "Top Gear (Includes Sneak Peek - The Block at 928 PM).S00E01.ts"

From EPG_EVENT Table
Title = "Top Gear (Includes Sneak Peek - The Block at 9:28 PM)"
Description = "Patagonia - Part 1Clarkson, Hammond and May embark on a journey to the southernmost point of South America."
Season = "0" Episode ="1"

Has anyone got any ideas why?

Match Start Of Title and Match Exact Title ... How do these work? It could save from writing another RexX Program to "CLEAN" up the FTA Data.
... to Remove the likes of "- New Episode" , " - New (Includes Sneak Peek...." etc.

you'd have to run nextpvr.exe -recurring after making any changes to the database, so that the scheduled recurring recordings will pick up the new epg_event details.

[puck64]

you'd have to run nextpvr.exe -recurring after making any changes to the database, so that the scheduled recurring recordings will pick up the new epg_event details.

Thanks for the hint...

As for the unwanted data in the Title, no need to write a program just use <StrippedEPGPrefixes> in the config.xml

Problem solved.

Problem NOT solved Like it says "<StrippedEPGPrefixes>" only strips off leading rubbish

[puck64]

Problem NOT solved Like it says "<StrippedEPGPrefixes>" only strips off leading rubbish

Hi All,

I have updated my script that extracts the season and episode data from the Program Description.

It will now remove "annoying" (to me anyway) extraneous data, like "New", "Encore", "Season Return" and the like.
The removed data (for the most part) is appended to the description.
Entries like "Top Gear (Includes Sneak Peek - The Block at 928 PM)" all you are left with is "Top Gear"

I have attached the new RexX script, its log file and PostUpdateEpg.bat

I think that this script will mainly be used by Australian Free To Air "viewers" but the logic is valid for all regions.

The main stations hit are SBS (Season/Episode info) Nine Sydney (read Network Nine) (delete "(Includes Sneak Peek .....")

The required software to run the script (RexX and ooSqllite3) can be found here .....
Open Object Rexx is available from --> http://www.oorexx.org/download.html
ooSQLite3 is available from --> http://sourceforge.net/projects/oorexx/files/ooSQLite/

As before ...

There is no copyright or copyleft on the code I have written, use it at your own peril

I would suggest that you copy your npvr.db3 database to a work folder and point the RexX program at that. when you are satisfied it works to your needs then point the RexX program at the Live database.

[puck64]

you'd have to run nextpvr.exe -recurring after making any changes to the database, so that the scheduled recurring recordings will pick up the new epg_event details.

Are there any other (undocumented ???????) goodies like this ?

[johnsonx42]

http://www.nextpvr.com/nwiki/pmwiki.php?...ineOptions

[puck64]

http://www.nextpvr.com/nwiki/pmwiki.php?...ineOptions

Thanks, Much appreciated. I should know by now RTFM!!!!! :o

New version of Season_Title.rex - Caters for Pt. in Description and adds to episode.