.properties file specs for tv series

[jptheripper]

background - I use mymovies for file management

I have recently engaged with the mymovies folks, and I will be updating the dll that does sage .properties file exports for movies and tv series.

Movies are easy

Tv Series - does anyone have a .properties file that shows what should be included on an archived tv show so it shows properly in sage when included in an import directory?

My guess is for the minimum is:

Title - Show name?
Description - Episode Description
EpisodeName - self explanatory
Duration
RunningTime - different from duration?
SeasonNumber
EpisodeNumber
Year
OriginalAirDate

Any info or a fully populated example file would be AWESOME! thank you in advance

[nyplayer]

Originally Posted by jptheripper

background - I use mymovies for file management

I have recently engaged with the mymovies folks, and I will be updating the dll that does sage .properties file exports for movies and tv series.

Movies are easy

Tv Series - does anyone have a .properties file that shows what should be included on an archived tv show so it shows properly in sage when included in an import directory?

My guess is for the minimum is:

Title - Show name?
Description - Episode Description
EpisodeName - self explanatory
Duration
RunningTime - different from duration?
SeasonNumber
EpisodeNumber
Year
OriginalAirDate

Any info or a fully populated example file would be AWESOME! thank you in advance

#Generator: CMT Metadata, written on Sunday, August 23, 2015 2:04 PM
Subtitled=false
Genre=Drama
Contestant=
ChannelPremiere=false
RunningTime=0
Widescreen=false
Guest=
Choreographer=
ExtendedRatings=
Dolby=false
Composer=
Writer=
Stereo=false
ParentalRating=TVG
EpisodeNumber=9
Description=Mary accepts Adam's proposal, but doubts they can raise children.
ExternalID=EP0026330104
SAP=false
HDTV=false
Title=Little House on the Prairie
SeasonNumber=5
CC=false
SeriesFinale=false
TotalParts=0
Live=false
Voice=
Surround=false
Judge=
EpisodeName=The Wedding
Director=Michael Landon
SeriesPremiere=false
Anchor=
PartNumber=0
Guest\ Voice=
3D=false
DD5.1=false
Executive\ Producer=
Guest\ Star=
SeasonPremiere=false
Musical\ Guest=
New=false
Letterbox=false
Taped=false
Producer=
Misc=
Language=English
Dubbed=false
Narrator=
SeasonFinale=false
Rated=
Correspondent=
OriginalAirDate=279244800000
Host=
Team=
Year=
Premiere=false
Actor=Michael Landon;Karen Grassle;Melissa Gilbert;Melissa Sue Anderson;Richard Bull;Katherine MacGregor;Alison Arngrim;Jonathan Gilbert;Kevin Hagen;Dabbs Greer;Merlin Olsen;Patrick Laborteaux;Hersha Parady;Matthew Laborteaux;Linwood Boomer;Don "Red" Baker;Lindsay Greenbush;Sidney Greenbush;Brenda Turnbaugh;Wendi Turnbaugh

[jptheripper]

awesome I really appreciate it

Any idea what the source of

ExternalID

is? (edit - its the zap2it id, is this necessary?)

Any good lord, is OriginalAirDate unixtime in milliseconds? Tue, 07 Nov 1978 00:00:00 GMT Does seem right for that episode

[Monedeath]

Originally Posted by jptheripper

RunningTime - different from duration?

Yes, this comes from Sage being a recorder. If a program is scheduled to be on air for one hour, it will have a 1 hour duration. If at some point that recording were to say, become 42 minutes and 30 seconds in length, and be reimported into SageTV. It would then have a runtime that reflected the shorter recording time, but still report a 60 minute duration.

This is where people will start to see a red bar to go with their green and white bars during playback. SageTV uses the red bar to indicate incomplete recordings and which section it thinks is missing.

[jptheripper]

Originally Posted by Monedeath

Yes, this comes from Sage being a recorder. If a program is scheduled to be on air for one hour, it will have a 1 hour duration. If at some point that recording were to say, become 42 minutes and 30 seconds in length, and be reimported into SageTV. It would then have a runtime that reflected the shorter recording time, but still report a 60 minute duration.

This is where people will start to see a red bar to go with their green and white bars during playback. SageTV uses the red bar to indicate incomplete recordings and which section it thinks is missing.

perfect thank you

[Fuzzy]

Originally Posted by jptheripper

ExternalID

is? (edit - its the zap2it id, is this necessary?)

I don't think any of the properties are 'necessary'. It just makes sense to populate any you can source info for.

[stuckless]

Here's a few other OPTIONAL things to consider...

1. If I recall, ExternalID is used internally by SageTV to denote actual recordings vs imported media. For example ExternalID sthat starts with "EP" will show up as an actual SageTV recording instead of an imported media file. The numbers folloing EP is not relevant so in BMT, I'll do something like EP[IMDBID][SEASON][EPISODE], so might be EP39725740101.

2. Consider populating some of NON core fields that will help Phoenix and Gemstore better organize our media.

These include...

# These are core SageTV fields
Title=Ray Donovan
EpisodeName=The Kalamazoo
EpisodeNumber=1
SeasonNumber=3
OriginalAirDate=1436673600000
ParentalRating=TVM
Genre=Crime/Drama
RunningTime=3600000

# These are NON CORE OPTIONAL
IMDBID=tt3972574

# Separate fields for storing the "provider" and "id"
# So, you an use this for something like, "mymovies" for the ProviderID
# the MyMovies ID for the ProviderDataID.
# You might use this information, later, in SageTV, etc.
MediaProviderDataID=259866
MediaProviderID=tvdb

# Media TItle is usually same as Title
MediaTitle=Ray Donovan
# Media Types are "TV", "Movie", "Music"
MediaType=TV

# Setting this to MyMovies will prevent BMT/Phoenix from re-scraping the files when they are added/updated in sagetv. 
# The ScrapedBy can be anything, except for Phoenix :)
ScrapedBy=Phoenix
ScrapedDate=1437744051015

Dates are Java Date long values.
RunningTime is Milliseconds

And as Fuzzy said... populate whatever you have... the more the better.

[Opus4]

In case it wasn't seen, there was an old sticky that talked about .properties and had some links to lists of valid entries. (I'm not sure how much has changed since then.)

Andy

[Narflex]

Originally Posted by Monedeath

Yes, this comes from Sage being a recorder. If a program is scheduled to be on air for one hour, it will have a 1 hour duration. If at some point that recording were to say, become 42 minutes and 30 seconds in length, and be reimported into SageTV. It would then have a runtime that reflected the shorter recording time, but still report a 60 minute duration.

This is where people will start to see a red bar to go with their green and white bars during playback. SageTV uses the red bar to indicate incomplete recordings and which section it thinks is missing.

Actually, that's not correct. The reason there's a 'Running Time' parameter is for movies. For example you have a 2 hour Airing on HBO of a movie; so that 2 hours is the duration. BUT the movie itself is only 1 hour and 50 minutes long....so that would then be the 'RunningTime' of the movie. The 'duration' is stored in the Airing object and the RunningTime is stored in the Show object (both use a field called 'duration'). SageTV has logic in the code for determining when you've watched something completely to take this into account. So when you stop playing that movie at the credits; and there's still another 15 minutes left in the actual program...it'll know you actually watched the whole movie.

[Monedeath]

Originally Posted by Narflex

Actually, that's not correct. The reason there's a 'Running Time' parameter is for movies. For example you have a 2 hour Airing on HBO of a movie; so that 2 hours is the duration. BUT the movie itself is only 1 hour and 50 minutes long....so that would then be the 'RunningTime' of the movie. The 'duration' is stored in the Airing object and the RunningTime is stored in the Show object (both use a field called 'duration'). SageTV has logic in the code for determining when you've watched something completely to take this into account. So when you stop playing that movie at the credits; and there's still another 15 minutes left in the actual program...it'll know you actually watched the whole movie.

Interesting, although it has been the observed behavior I've seen when reimporting edited versions of episodes that have lost their commercials. May have been an unintended outcome, but it is there.

[Tiki]

Originally Posted by Monedeath

Interesting, although it has been the observed behavior I've seen when reimporting edited versions of episodes that have lost their commercials. May have been an unintended outcome, but it is there.

I don't think this is because of the Running Time parameter though.
I think Sage also keeps track of the airing start time and looks at the time/date stamp of the file (which should be when it stopped recording). If that timestamp minus the start time doesn't match the "duration" that Sage has stored, you will see the red bar indicating that something is missing (or the bar may be screwed up in other ways of the time stamp is really wrong).

[Fuzzy]

The Airing has a duration, as does the MediaFile. The MediaFile duration is taken from the file itself when it is imported (I think it passes the file through ffmpeg - SageTVTranscoder - to get that info). The Airing duration would come from the actual EPG data if it was a recording, or from another metadata provider.

You can set an Airing's duration to whatever you want... you cannot alter or change the duration of the mediafile, as it is directly representative of the file itself.

[Monedeath]

Originally Posted by Fuzzy

The Airing has a duration, as does the MediaFile. The MediaFile duration is taken from the file itself when it is imported (I think it passes the file through ffmpeg - SageTVTranscoder - to get that info). The Airing duration would come from the actual EPG data if it was a recording, or from another metadata provider.

That's what I get for posting from memory rather than checking at the server, of course, it would help to not be 1,000 miles away from the thing when posting.

This does sound more like what I'm remembering seeing, so I stand corrected on this.

Originally Posted by Tiki

I think Sage also keeps track of the airing start time and looks at the time/date stamp of the file (which should be when it stopped recording). If that timestamp minus the start time doesn't match the "duration" that Sage has stored, you will see the red bar indicating that something is missing (or the bar may be screwed up in other ways of the time stamp is really wrong).

The web-interface has options for altering recording data to specify how many seconds(IIRC) before and/or after a recording was set to run, so SageTV does have a data field for that kind of information and does track it. The red bar indicates what Sage believes to be missing data based on reported start/stop times and file duration.

What I haven't seen exposed to an end-user (via plugin) is how Sage tracks the multi-part recordings that sometimes occur when there are tuner problems or other things going on(person watching live TV and tuning in and out of a channel without actually setting to record continuously), as I've seen the progress bar fill up with alternating bands of red and green, at least until the watched flag comes rolling along, which will overwrite everything to the left of it. So SageTV itself evidently has some way of knowing and tracking when each individual part of a multi-part recording of a single program was made. Although those are very much edge-cases for the more crazed video-archivists among us, as that would normally be grounds to re-record or find other means of obtaining a continuous recording of the show in question, if not simply deleting it. So the need to import or export metadata for such an event is quite small I'd imagine.

[Fuzzy]

Originally Posted by Monedeath

What I haven't seen exposed to an end-user (via plugin) is how Sage tracks the multi-part recordings that sometimes occur when there are tuner problems or other things going on(person watching live TV and tuning in and out of a channel without actually setting to record continuously), as I've seen the progress bar fill up with alternating bands of red and green, at least until the watched flag comes rolling along, which will overwrite everything to the left of it. So SageTV itself evidently has some way of knowing and tracking when each individual part of a multi-part recording of a single program was made. Although those are very much edge-cases for the more crazed video-archivists among us, as that would normally be grounds to re-record or find other means of obtaining a continuous recording of the show in question, if not simply deleting it. So the need to import or export metadata for such an event is quite small I'd imagine.

That is handled by a given MediaFile object containing a number of segments. Each of those segments has it's own duration, and start time. Multiple MediaFile Segments are attached to the same Airing object.