84.4.5.46 CUSTOM > CH-9 > PROGRAM GUIDE

Import scope
The custom Program Guide import is used to import a .XML file that contains the schedule of an entire day. This import adds events into the on-air schedule, it doesn't delete the ones already scheduled. 
Import parameters
This import module requires the following parameters to be set in order to be correctly used:

Import_custom_ch-9_program_guide

•File to import: Browse for the file from which data will be imported, only .XML files will be displayed since they are the only supported.
The standard file name is: "EPG-TCN GO Schedule-yyyymmdd.xml", where 'yyyy', 'mm' and 'dd' indicates respectively the year, month and day of the schedule to be imported.
The imported file must detail some key tags which are determinant for the correct retrieval of imported data, these fields are:
•<tv:desc>
Since imported data doesn't specify the code of the program to which it is related, Etere will assign each imported program data to a program present in the Etere's database which description matches with the one specified by the <tv:desc> tag (e.g.: <desc>='Mike buys a new car and...' ==> Etere_ProgramDesc='Mike buys a new car and...').
•<pbltv:genre>
The program type is retrieved from the <pbltv:genre> tag, and it is searched in the database across the program type descriptions, and in case it doesn't exists, it is created with a code generated using the first four description characters (e.g.: <genre>=animation ==> Etere_ProgramCode=anim).
• <tv:rating system>
Since the parental guidance classification is retrieved from the <tv:rating system> tag which is alphabetic, and since the Etere's parental guidance classification field is numeric, the import application will search the alphanumeric value across the first description letter of the classification  (e.g.: <rating>=H ==> Etere_ParentalDescription=H Classified material).
Sample file to import
The file to be imported using this method will have to the following structure in order to be correctly imported:
<?xml version="1.0"?>
<pbltv:tv xmlns:tv="urn:schemas-pblmedia-applications-phoenix-xmltv" date="20100507170648" generator-info-name="Phoenix" xmlns:pbltv="urn:schemas-pblmedia-applications-phoenix-pbltv">
 <tv:channel id="99.TCN.com.au">
   <tv:display-name lang="en">Nine GO</tv:display-name>
 </tv:channel>
<pbltv:programme channel="99.TCN.com.au" clumpidx="0/1" start="20100523060000" stop="20100523063000">
   <tv:title lang="en">Chowder</tv:title>
   <tv:sub-title lang="en">Grubble Gum/The Cinnamini Monster</tv:sub-title>
   <tv:desc lang="en">Chowder is forced to swallow his new gum before Truffles finds out he didn't buy enough to share. </tv:desc>
   <tv:date>2008</tv:date>
   <tv:category lang="en">Seasons</tv:category>
   <tv:length units="seconds">1305</tv:length>
   <tv:country lang="en">United States</tv:country>
   <tv:episode-num system="xmltv_ns">.2.</tv:episode-num>
   <tv:video>
     <tv:colour>yes</tv:colour>
     <tv:aspect>4:3</tv:aspect>
     <tv:quality>SD</tv:quality>
   </tv:video>
   <tv:audio>
     <tv:present>yes</tv:present>
     <tv:stereo>stereo</tv:stereo>
   </tv:audio>
   <tv:rating system="ACMA">
     <tv:value>G</tv:value>
   </tv:rating>
   <pbltv:genre lang="en">Animation</pbltv:genre>
 </pbltv:programme> 
 <pbltv:programme channel="99.TCN.com.au" clumpidx="0/1" start="20100523063000" stop="20100523070000">
   <tv:title lang="en">The Marvellous Misadventures Of Flapjack</tv:title>
   <tv:sub-title lang="en">Oh Brother / Panfake</tv:sub-title>
   <tv:desc lang="en">Getting a little brother can be hard.  Having a little brother is a whole ‘nother story.  Wait, no, its THIS story…</tv:desc>
   <tv:date>2008</tv:date>
   <tv:category lang="en">Animation</tv:category>
   <tv:length units="seconds">1307</tv:length>