SchedulesDirect recorded originalairdate for movies is 0 (Implemented)
Posted: Tue Sep 12, 2017 11:32 pm
Proposal: Populate originalairdate for recorded movies from airdate or tmdb lookup.
I recently switched from OTA listings to SchedulesDirect.
Previously the mythtv recorded table contained an originalairdate for movies such as '2015-01-01' (always 1st Jan). Now I only have 0000-00-00 for all newly recorded movies. I have a script that uses the field.
For example:
The recorded table doesn't contain an "airdate" field.
The SD xmltv data for the movie contains year like this:
<date>2013</date>
<previously-shown/>
Whereas for tv episode it only contains:
<previously-shown start="20160316 +0000"/>
I think OTA used to copy 2013 in to both airdate and originalairdate.
So perhaps mythtv could do the same for SD if it is missing?
Or, it could copy it from the data returned by the tmdb lookup:
Thanks.
I recently switched from OTA listings to SchedulesDirect.
Previously the mythtv recorded table contained an originalairdate for movies such as '2015-01-01' (always 1st Jan). Now I only have 0000-00-00 for all newly recorded movies. I have a script that uses the field.
For example:
Code: Select all
select title,originalairdate,chanid,progstart from RECORDED where programid='MV005280550000' limit 1;
| 2 Guns | 0000-00-00 | 10220 | 2017-09-12 20:00:00 |
select title,airdate,originalairdate from PROGRAM where programid='MV005280550000' and chanid=10220 and starttime='2017-09-12 20:00:00';
| 2 Guns | 2013 | NULL |
The SD xmltv data for the movie contains year like this:
<date>2013</date>
<previously-shown/>
Whereas for tv episode it only contains:
<previously-shown start="20160316 +0000"/>
I think OTA used to copy 2013 in to both airdate and originalairdate.
So perhaps mythtv could do the same for SD if it is missing?
Or, it could copy it from the data returned by the tmdb lookup:
Code: Select all
/usr/share/mythtv/metadata/Movie/tmdb3.py -l en -a US -D 136400
...
<title>2 Guns</title>
<year>2013</year>