|
SageTV Studio Discussion related to the SageTV Studio application produced by SageTV. Questions, issues, problems, suggestions, etc. relating to the Studio software application should be posted here. |
|
Thread Tools | Search this Thread | Display Modes |
#1
|
||||
|
||||
Show ExternalIDs not Unique for sports?
I'm writing a plugin that needs to keep information about specific Shows and I've discovered that some Airings that assumed have the same Show ExternalIDs do not. College Football is an example. I thought, incorrectly it seems, that all college football games have the same Show ExternalID but they don't.
Is this common or are sports the only Shows that may have the same title but different Show ExternalIDs? I was hoping to use the Show ExternalID as a key into the database because that will be a lot cleaner than using the Show Title.
__________________
Sage Server: 8th gen Intel based system w/32GB RAM running Ubuntu Linux, HDHomeRun Prime with cable card for recording. Runs headless. Accessed via RD when necessary. Four HD-300 Extenders. |
#2
|
|||
|
|||
Most sports events have an EID of SP*, which is never the same (for different events). It does repeat itself for different repeat airings of the same event. Definitely SP* EIDs cannot be used to try and group together sports events of the same "type". Title is your best bet as Tribune usually does a pretty good job of normalizing the titles for sports events. There are exceptions to that though, for example:
The title for all MLB games will be "MLB Baseball" during the regular season and playoffs, but during the World Series they use "yyyy World Series" (i.e. "2012 World Series"). Same with NBA and NFL and NCAA football. All good until the championship then the titles change. Also, some events use EP* EIDs, usually if additional description is added (like Sunday/Monday night football will usually be an EP* id, but not always).
__________________
Twitter: @ddb_db Server: Intel i5-4570 Quad Core, 16GB RAM, 1 x 128GB OS SSD (Win7 Pro x64 SP1), 1 x 2TB media drive Capture: 2 x Colossus STB Controller: 1 x USB-UIRT Software:Java 1.7.0_71; SageTV 7.1.9 Clients: 1 x HD300, 2 x HD200, 1 x SageClient, 1 x PlaceShifter Plugins: Too many to list now... |
#3
|
||||
|
||||
Thanks Slugger. I bit the bullet and changed the database key to the ShowTitle.
__________________
Sage Server: 8th gen Intel based system w/32GB RAM running Ubuntu Linux, HDHomeRun Prime with cable card for recording. Runs headless. Accessed via RD when necessary. Four HD-300 Extenders. |
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Help! - Unique Menus, Guides & MC Folders | JimmyBalboa | SageTV Customizations | 5 | 01-10-2009 03:48 PM |
Unique IR for MVPs? | BFisher | SageTV Media Extender | 6 | 09-10-2007 04:54 AM |
Unique Media file ID is zero? | beelzerob | SageTV Studio | 18 | 04-12-2007 05:35 AM |
Unique Issues | jp207 | SageTV Customizations | 21 | 05-30-2006 09:39 PM |
Assigning Unique Feature Commands | meekell | SageTV Customizations | 0 | 05-23-2004 11:45 AM |