importing Season/Episode numbers into DB from XML
Posted: Sun Mar 03, 2013 7:13 am
Alright,
So I figured out that the TV listings importer uses the following XML tag to fill in the episodeNumber field of the GuideProgram table.
<episode-num system="onscreen">
unfortunately, the program I use to download TV listings (MC2XML.exe) does not provide a XML tag for the season number. Instead puts season AND episode number together in the episode tag. So I want to write a script that will parse it, and insert a season tag into the XML before feeding it to the importer.
what tag does the importer look for the season number? Is it just <series-num system="onscreen"> ?
That didn't seem to work for me.
So I figured out that the TV listings importer uses the following XML tag to fill in the episodeNumber field of the GuideProgram table.
<episode-num system="onscreen">
unfortunately, the program I use to download TV listings (MC2XML.exe) does not provide a XML tag for the season number. Instead puts season AND episode number together in the episode tag. So I want to write a script that will parse it, and insert a season tag into the XML before feeding it to the importer.
what tag does the importer look for the season number? Is it just <series-num system="onscreen"> ?
That didn't seem to work for me.