Thanks - and a couple of suggestions

12 views
Skip to first unread message

Oliver Maunder

unread,
Feb 9, 2011, 7:19:46 PM2/9/11
to MYTHTV goodies by marc
Hi

This is a great script - I found it this morning and it's just what I
need.

I've found a couple of issues while I've been playing around with it -
mainly caused by inconsistent program IDs in my schedule data (I'm in
the UK).

I see you're helping us out by using the date as the episode number
instead of the program ID. However, this date only includes the year,
month, day and minutes - not the hours. This is only a problem if you
have two episodes of the same show broadcast on the same day. If one
was shown at 10:30 and the other was at 11:30 they would get the same
episode number.

Also because of the lack of program IDs, my movie recordings don't
have IDs that start with "MV". However, in the database they do all
have the category "Movie", so it would be good to check for this too.

Finally, the TVDB helper script uses /myth/tmp/tvdbworkingdir as a
working directory. I haven't got a /myth directory on my system, so
this failed. Changing it to just /tmp/tvdbworkingdir should work on
all systems.

Thanks for doing all this work so I didn't have to!

Olly

Here are the changes I made to the python script:
351c351
< cursor.execute("SELECT t1.chanid, t1.starttime, t1.title,
t1.subtitle, t1.programid, t1.basename, t1.originalairdate,
t1.deletepending, t1.description, t2.dirname, t1.recgroup FROM
recorded t1,storagegroup t2 where t1.hostname=t2.hostname and
t1.storagegroup=t2.groupname order by starttime")
---
> cursor.execute("SELECT t1.chanid, t1.starttime, t1.title, t1.subtitle, t1.programid, t1.basename, t1.originalairdate, t1.deletepending, t1.description, t2.dirname, t1.recgroup, t1.category FROM recorded t1,storagegroup t2 where t1.hostname=t2.hostname and t1.storagegroup=t2.groupname order by starttime")
391a392
> category = row[11]
397c398
< if programid_type == "MV" and options.movie_subdir != "":
---
> if (programid_type == "MV" or category == "Movie") and options.movie_subdir != "":
418c419
< epinum=starttime[2:4] + starttime[5:7] + starttime[8:10] +
starttime[14:16]
---
> epinum=starttime[2:4] + starttime[5:7] + starttime[8:10] + starttime[11:13] + starttime[14:16]

Marc Aronson

unread,
Feb 12, 2011, 9:30:25 AM2/12/11
to mythtv-good...@googlegroups.com
Olly, I'm really glad you found the scripts useful and thank you very much for the donated code changes -- I will merge them in and post the updates in a few days!

Marc
Reply all
Reply to author
Forward
0 new messages