Update Season and Episode from EPG_EVENT

[puck64]

Hi All,

I have written a small RexX Program that Queries the description column of EPG_EVENT and updates the season and episode columns.

I think that this would only be of use to people who use the FreeToAir Program Guide.

I find that not all Channels (in Australia) include the season and or episode number with their description :mad:

The required software (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/

The Program will run on the Latest and Previous versions of NextPVR

The code (epg_series_episode_update.rex and PostUpdateEpg.bat) along with 2 Log files are attached.

If your NextPVR database is not located in C:\Users\Public\NPVR\npvr.db3 then change the line (6 lines from the top) from dbName = 'C:\Users\Public\NPVR\npvr.db3' to dbName = 'where ever it is'

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.