MS Excel

Introduction

It is possible to use Microsoft Excel as a tool for managing the EPG data.

The process for that is:

Manage EPG with the Excel tool and the excel format given by Icareus
Save the Excel (.xls) files as CSV (*.csv) files
Use the manual uploading the CSV file to the Playout/http/ftp server
Refresh the system

Format

For managing the EPG data with Excel use the format shown in the image below:

Mapping format to Icareus Playout

Column	Description	Format	Mandatory
Event id	Unique identifier of an event	text/number	No
Service id	Service identifier of an event	number	Yes
Date	Event's start date in UTC	dd/mm/yyyy	Yes
Time	Event's start time in UTC	hh:mm:ss	Yes
Duration	Event's duration	hh:mm:ss	Yes
Language	Language definition for the event's Name/Short description/Long descriptions. It is possible to define more than one language for each event. Separate lines should be used for different languages.	text (see attachment)	Yes
Name	Event's name	text (New lines are not allowed)	Yes
Short description	Event's short description	text (New lines are not allowed)	No
Long description	Event's long description	text (New lines are not allowed)	No
Genre	Event's genre	number (see attachment)	No
PG rating	Parental guide rating	number (age limit: 4-18)	No

Configurable field mapping

Icareus Playout version 6.0.2.4 added a configurable field mapping for the CSV Data source. This allows the user to specify the mapping of CSV or Excel columns to the Playout database fields.

Playout 6.0.2.4 and newer can now ingest EPG data directly from Excel sheets (file format xls, xlsm or xlsx). These are converted to CSV before they are read into the EPG database.

The configurable field mapping is optional and enabled in a Service's EIT source tab using the checkbox Use field mapping. If Use field mapping is not checked, the Mapping format to Icareus Playout, described above, is used. We will refer to this as the default mapping.

The field mapping parameters

Delimiter: the default delimiter is a comma sign , . Using the field mapping feature, any character can be the delimiter, except the quotation mark ". You can specify some special characters by entering one of the following: comma, colon, equals, semicolon, space or tab.

Number of header rows: How many rows there are in the input file that are not EPG events. If the header takes 1 row, like in the example above, use the value 1. If there's e.g. 8 header rows before the EPG data starts on row 9, use the value 8.

Number of columns: How many columns there are for each row in the spreadsheet. For example if the Excel sheet has columns A - Z, AA - AF, this parameter should have the value 31.

Field mapping: This is a JSON array of objects which specify each field. Below the default mapping format described above is specified as a JSON. This is the default mapping that is used if the Field mapping is left empty.

            [
                {
                    "column":"A",
                    "field":"Event id"
                },
                {
                    "column":"B",
                    "field":"Service id"
                },
                {
                    "column":"C",
                    "field":"Date",
                    "format":"dd/MM/yyyy"
                },
                {
                    "column":"D",
                    "field":"Time",
                    "format":"hh:mm:ss",
                    "timezone":"UTC"
                },
                {
                    "column":"E",
                    "field":"Duration",
                    "format":"hh:mm:ss"
                },
                {
                    "column":"F",
                    "field":"Language"
                },
                {
                    "column":"G",
                    "field":"Name",
                    "language":"eng"
                },
                {
                    "column":"H",
                    "field":"Short description",
                    "language":"eng"
                },
                {
                    "column":"I",
                    "field":"Long description",
                    "language":"eng"
                },
                {
                    "column":"J",
                    "field":"Genre"
                },
                {
                    "column":"K",
                    "field":"Parental rating",
                    "country":"902",
                    "format":"minimum age"
                }
            ]

For each column, it is necessary to specify the column and the field. The other keys are necessary for some fields to specify e.g. the format of data in the field.

Here's an explanation of the keys used in the JSON:

column: This tells in which column in the spreadsheet a specific field is located. The columns are named like in Microsoft Excel, the first 26 columns are "A" - "Z", the 2th is "AA" and so on. In the example above the Date field is located in column C.

field: This value tells what information is present in the current column. For a table of available fields, see below.

format: The format lets us specify how to interpret the contents of a field. For example the Date (event start date) might be specified in the CSV file as "25/01/2024" for 25th of January, 2024. In this case the format string should be specified as "dd/MM/yyyy".

timezone: For event start and stop times, a timezone can be specified. This can be for example "UTC+2". This allows the CSV data source to calculate the event start and stop times for the UTC timezone, which is the value used in the Playout EPG database. If the time values in the input CSV file are already in the UTC time zone, one doesn't have to specify the timezone as UTC is assumed.

language: For texts appearing in the EPG data, such as event Name, Short Description and so on, the language should be specified, e.g. "eng" for English language text. See below for the ISO 639-2 language codes available.

country: This is used for the Parental rating. These are 3-letter country codes defined in ISO 3166-1, for example "ZAF" means South Africa. A value of "902" means that the rating is valid for all countries.

Table of available fields

The field names in the JSON mapping are case insensitive, so e.g. Event id and event id specify the same field. Some fields have aliases, e.g. Date and Start Date specify the same thing. Only the field names in the table below are supported.

Field	Comments	Available formats
Event id	Optional. Can be any string. Playout uses this to identify the event in it's EPG database, incase an existing event is updated.
Service id	Optional. Used with the default mapping to validate that the CSV file being ingested has data for the same service id that is in Playout.
Date	Start date of the event, this field is mandatory. Note that year values between 0 and 99 are interpreted as 2000 - 2099. I.e. year 24 is assumed to mean 2024.	dd/MM/yyyy, dd/MM/yy, M/d/y, MM/dd/yy, MM/dd/yyyy, yyyy/MM/dd, yyyyMMdd
Time	Start time of the event, this field is mandatory. A timezone can be specified, telling the system in which timezone the time is specified. If no timezone is specified, UTC is assumed. For example if the time 12:00 in the CSV refers to 12:00 in the UTC+2 timezone, the EPG updater can calculate that the UTC time of the event is 10:00.	time, hh:mm, h:mm, hh:mm:ss, hh:mm:ss:??
Duration	The duration in seconds. This field is optional. If it's not present the event duration is calculated using stop date and time, if available. If only the Date and Time are available, but no duration or stop date/time, then the duration is found by assuming the event stops when the next event starts.	hh:mm:ss, hh:mm:ss:??
Stop date	Stop date of the event, this field is optional.	M/d/y, MM/dd/yyyy,
Stop time	Stop time of the event, this field is optional. A timezone can be specified, see above for field Time.	time, h:mm
Language	Optional ISO 639-2 language code. If this field is present, the Name, Short Description and Long Description fields should be in this language.
Name	Event name. The language can be specified in the field mapping if present, otherwise will use the value in the Language field, or "eng" (English) if not known.
Short description	Event short description. The language can be specified in the field mapping if present, otherwise will use the value in the Language field, or "eng" (English) if not known.
Long description	Event long description. The language can be specified in the field mapping if present, otherwise will use the value in the Language field, or "eng" (English) if not known.
Genre	The genre is assumed to be a number. Values from 0 to 255 are possible. See below for Supported Genres.
Genre nibble 1	The genre can optionally be specified giving the 2 genre nibbles that together form the value from 0-255. See ETSI EN 300 468 V1.15.1 (2016-03) Table 28: Content nibble level 1 and 2 assignments
Genre nibble 2	See above
Parental rating	The parental rating maps to a rating value in EPG output. A country should be specified, otherwise the rating is assumed to be valid for all countries. See ETSI EN 300 468 V1.15.1 (2016-03) Table 81: Parental rating descriptor, rating	PG, DVB, or minimum age. See table below.

Table of formats

These are the formats supported by Playout 6.0.2.4.

Format	Description	Example value(s)
dd/MM/yyyy	day specified with 2 digits, slash, month specified with 2 digits, slash and then year specified with 4 digits, all with leading zeros	25/01/2024
dd/MM/yy	same as above, but year has only 2 digits	25/01/24
M/d/y	month / day / year, any number of digits in each is allowed	1/25/2024
MM/dd/yy	month, day and year each specified with exactly 2 digits, separated by slash	01/25/24
MM/dd/yyyy	as above, but year is specified with 4 digits	01/25/2024
yyyy/MM/dd	as above, but order is year, month, day	2024/01/25
yyyyMMdd	same as above, but without the slashes	20240125
time	a time with hours and minutes or hours, minutes and seconds, separated by colon	18:00 or 18:00:00
hh:mm	a time with hours and minutes, both with leading zeros	09:10
h:mm	a time with hours and minutes, the hour not having leading zeros	1:35
hh:mm:ss	a time with hours, minutes and seconds, separated by colon	01:35:00
hh:mm:ss:??	a time with hours, minutes, seconds and 2 more digits (100ths of second) separated by colon	01:35:00:00
PG	A Parental Guidance (PG) format with codes such as PG-13 etc. which are country specific.	PG-13
DVB	A Parental rating that is directly the DVB rating value as a number (minimum age = rating + 3 years)	15
Minimum age	A Parental rating that is given as the minimum age. The DVB rating is then rating = minimum age - 3	18

Additional fields used in EPG API

These are treated as strings, so they don't have any specific format.

Field	Comments
Censorship codes
Website synopsis
EPG synopsis
Mobile synopsis
Episode title
Episode number
Season number
Episodes in season
Start of season
End of season
Logline
Theme
Live
Year of release
Actors	Can be a comma separated list, e.g. Peter Sellers, Herbert Lom, Burt Kwouk
Directors
Awards
Subtitles
HI Subtitles
Premiere
Highlight
Change alert
Widescreen
High definition
Dolby digital
Stereo
Surround sound

Language Codes

Character language codes are defined in ISO 639-2:

    <languages>

   

        <language id="abk" name="Abkhazian"/>

   

        <language id="ace" name="Achinese"/>

   

        <language id="ach" name="Acoli"/>

   

        <language id="ada" name="Adangme"/>

   

        <language id="aar" name="Afar"/>

   

        <language id="afh" name="Afrihili"/>

   

        <language id="afr" name="Afrikaans"/>

   

        <language id="afa" name="Afro-Asiatic (Other)"/>

   

        <language id="aka" name="Akan"/>

   

        <language id="akk" name="Akkadian"/>

   

        <language id="alb" name="Albanian" secondary="sqi"/>

   

        <language id="ale" name="Aleut"/>

   

        <language id="alg" name="Algonquian languages"/>

   

        <language id="tut" name="Altaic (Other)"/>

   

        <language id="amh" name="Amharic"/>

   

        <language id="apa" name="Apache languages"/>

   

        <language id="ara" name="Arabic"/>

   

        <language id="arc" name="Aramaic"/>

   

        <language id="arp" name="Arapaho"/>

   

        <language id="arn" name="Araucanian"/>

   

        <language id="arw" name="Arawak"/>

   

        <language id="arm" name="Armenian" secondary="hye"/>

   

        <language id="art" name="Artificial (Other)"/>

   

        <language id="asm" name="Assamese"/>

   

        <language id="ath" name="Athapascan languages"/>

   

        <language id="map" name="Austronesian (Other)"/>

   

        <language id="ava" name="Avaric"/>

   

        <language id="ave" name="Avestan"/>

   

        <language id="awa" name="Awadhi"/>

   

        <language id="aym" name="Aymara"/>

   

        <language id="aze" name="Azerbaijani"/>

   

        <language id="nah" name="Aztec"/>

   

        <language id="ban" name="Balinese"/>

   

        <language id="bat" name="Baltic (Other)"/>

   

        <language id="bal" name="Baluchi"/>

   

        <language id="bam" name="Bambara"/>

   

        <language id="bai" name="Bamileke languages"/>

   

        <language id="bad" name="Banda"/>

   

        <language id="bnt" name="Bantu (Other)"/>

   

        <language id="bas" name="Basa"/>

   

        <language id="bak" name="Bashkir"/>

   

        <language id="baq" name="Basque" secondary="eus"/>

   

        <language id="bej" name="Beja"/>

   

        <language id="bem" name="Bemba"/>

   

        <language id="ben" name="Bengali"/>

   

        <language id="ber" name="Berber (Other)"/>

   

        <language id="bho" name="Bhojpuri"/>

   

        <language id="bih" name="Bihari"/>

   

        <language id="bik" name="Bikol"/>

   

        <language id="bin" name="Bini"/>

   

        <language id="bis" name="Bislama"/>

   

        <language id="bra" name="Braj"/>

   

        <language id="bre" name="Breton"/>

   

        <language id="bug" name="Buginese"/>

   

        <language id="bul" name="Bulgarian"/>

   

        <language id="bua" name="Buriat"/>

   

        <language id="bur" name="Burmese" secondary="mya"/>

   

        <language id="bel" name="Byelorussian"/>

   

        <language id="cad" name="Caddo"/>

   

        <language id="car" name="Carib"/>

   

        <language id="cat" name="Catalan"/>

   

        <language id="cau" name="Caucasian (Other)"/>

   

        <language id="ceb" name="Cebuano"/>

   

        <language id="cel" name="Celtic (Other)"/>

   

        <language id="cai" name="Central American Indian (Other)"/>

   

        <language id="chg" name="Chagatai"/>

   

        <language id="cha" name="Chamorro"/>

   

        <language id="che" name="Chechen"/>

   

        <language id="chr" name="Cherokee"/>

   

        <language id="chy" name="Cheyenne"/>

   

        <language id="chb" name="Chibcha"/>

   

        <language id="chi" name="Chinese" secondary="zho"/>

   

        <language id="chn" name="Chinook jargon"/>

   

        <language id="cho" name="Choctaw"/>

   

        <language id="chu" name="Church Slavic"/>

   

        <language id="chv" name="Chuvash"/>

   

        <language id="cop" name="Coptic"/>

   

        <language id="cor" name="Cornish"/>

   

        <language id="cos" name="Corsican"/>

   

        <language id="cre" name="Cree"/>

   

        <language id="mus" name="Creek"/>

   

        <language id="crp" name="Creoles and Pidgins (Other)"/>

   

        <language id="cpe" name="Creoles and Pidgins, English-based (Other)"/>

   

        <language id="cpf" name="Creoles and Pidgins, French-based (Other)"/>

   

        <language id="cpp" name="Creoles and Pidgins, Portuguese-based (Other)"/>

   

        <language id="hrv" name="Croatian"/>

   

        <language id="cus" name="Cushitic (Other)"/>

   

        <language id="ces" name="Czech" secondary="cze"/>

   

        <language id="dak" name="Dakota"/>

   

        <language id="dan" name="Danish"/>

   

        <language id="del" name="Delaware"/>

   

        <language id="din" name="Dinka"/>

   

        <language id="div" name="Divehi"/>

   

        <language id="doi" name="Dogri"/>

   

        <language id="dra" name="Dravidian (Other)"/>

   

        <language id="dua" name="Duala"/>

   

        <language id="dut" name="Dutch" secondary="nla"/>

   

        <language id="dum" name="Dutch, Middle (ca. 1050-1350)"/>

   

        <language id="dyu" name="Dyula"/>

   

        <language id="dzo" name="Dzongkha"/>

   

        <language id="efi" name="Efik"/>

   

        <language id="egy" name="Egyptian (Ancient)"/>

   

        <language id="eka" name="Ekajuk"/>

   

        <language id="elx" name="Elamite"/>

   

        <language id="eng" name="English"/>

   

        <language id="enm" name="English, Middle (ca. 1100-1500)"/>

   

        <language id="ang" name="English, Old (ca. 450-1100)"/>

   

        <language id="esk" name="Eskimo (Other)"/>

   

        <language id="epo" name="Esperanto"/>

   

        <language id="est" name="Estonian"/>

   

        <language id="ewe" name="Ewe"/>

   

        <language id="ewo" name="Ewondo"/>

   

        <language id="fan" name="Fang"/>

   

        <language id="fat" name="Fanti"/>

   

        <language id="fao" name="Faroese"/>

   

        <language id="fij" name="Fijian"/>

   

        <language id="fin" name="Finnish"/>

   

        <language id="fiu" name="Finno-Ugrian (Other)"/>

   

        <language id="fon" name="Fon"/>

   

        <language id="fra" name="French" secondary="fre"/>

   

        <language id="frm" name="French, Middle (ca. 1400-1600)"/>

   

        <language id="fro" name="French, Old (842- ca. 1400)"/>

   

        <language id="fry" name="Frisian"/>

   

        <language id="ful" name="Fulah"/>

   

        <language id="gaa" name="Ga"/>

   

        <language id="gae" name="(Scots)" secondary="gdh"/>

   

        <language id="glg" name="Gallegan"/>

   

        <language id="lug" name="Ganda"/>

   

        <language id="gay" name="Gayo"/>

   

        <language id="gez" name="Geez"/>

   

        <language id="geo" name="Georgian" secondary="kat"/>

   

        <language id="deu" name="German" secondary="ger"/>

   

        <language id="gmh" name="German, Middle High (ca. 1050-1500)"/>

   

        <language id="goh" name="German, Old High (ca. 750-1050)"/>

   

        <language id="gem" name="Germanic (Other)"/>

   

        <language id="gil" name="Gilbertese"/>

   

        <language id="gon" name="Gondi"/>

   

        <language id="got" name="Gothic"/>

   

        <language id="grb" name="Grebo"/>

   

        <language id="grc" name="Greek, Ancient (to 1453)"/>

   

        <language id="ell" name="Greek, Modern (1453-)" secondary="gre"/>

   

        <language id="kal" name="Greenlandic"/>

   

        <language id="grn" name="Guarani"/>

   

        <language id="guj" name="Gujarati"/>

   

        <language id="hai" name="Haida"/>

   

        <language id="hau" name="Hausa"/>

   

        <language id="haw" name="Hawaiian"/>

   

        <language id="heb" name="Hebrew"/>

   

        <language id="her" name="Herero"/>

   

        <language id="hil" name="Hiligaynon"/>

   

        <language id="him" name="Himachali"/>

   

        <language id="hin" name="Hindi"/>

   

        <language id="hmo" name="Hiri Motu"/>

   

        <language id="hun" name="Hungarian"/>

   

        <language id="hup" name="Hupa"/>

   

        <language id="iba" name="Iban"/>

   

        <language id="ice" name="Icelandic" secondary="isl"/>

   

        <language id="ibo" name="Igbo"/>

   

        <language id="ijo" name="Ijo"/>

   

        <language id="ilo" name="Iloko"/>

   

        <language id="inc" name="Indic (Other)"/>

   

        <language id="ine" name="Indo-European (Other)"/>

   

        <language id="ind" name="Indonesian"/>

   

        <language id="ina" name="Interlingua (International Auxiliary language Association)"/>

   

        <language id="ine" name="Interlingue"/>

   

        <language id="iku" name="Inuktitut"/>

   

        <language id="ipk" name="Inupiak"/>

   

        <language id="ira" name="Iranian (Other)"/>

   

        <language id="gai" name="Irish" secondary="iri"/>

   

        <language id="sga" name="Irish, Old (to 900)"/>

   

        <language id="mga" name="Irish, Middle (900 - 1200)"/>

   

        <language id="iro" name="Iroquoian languages"/>

   

        <language id="ita" name="Italian"/>

   

        <language id="jpn" name="Japanese"/>

   

        <language id="jav" name="Javanese" secondary="jaw"/>

   

        <language id="jrb" name="Judeo-Arabic"/>

   

        <language id="jpr" name="Judeo-Persian"/>

   

        <language id="kab" name="Kabyle"/>

   

        <language id="kac" name="Kachin"/>

   

        <language id="kam" name="Kamba"/>

   

        <language id="kan" name="Kannada"/>

   

        <language id="kau" name="Kanuri"/>

   

        <language id="kaa" name="Kara-Kalpak"/>

   

        <language id="kar" name="Karen"/>

   

        <language id="kas" name="Kashmiri"/>

   

        <language id="kaw" name="Kawi"/>

   

        <language id="kaz" name="Kazakh"/>

   

        <language id="kha" name="Khasi"/>

   

        <language id="khm" name="Khmer"/>

   

        <language id="khi" name="Khoisan (Other)"/>

   

        <language id="kho" name="Khotanese"/>

   

        <language id="kik" name="Kikuyu"/>

   

        <language id="kin" name="Kinyarwanda"/>

   

        <language id="kir" name="Kirghiz"/>

   

        <language id="kom" name="Komi"/>

   

        <language id="kon" name="Kongo"/>

   

        <language id="kok" name="Konkani"/>

   

        <language id="kor" name="Korean"/>

   

        <language id="kpe" name="Kpelle"/>

   

        <language id="kro" name="Kru"/>

   

        <language id="kua" name="Kuanyama"/>

   

        <language id="kum" name="Kumyk"/>

   

        <language id="kur" name="Kurdish"/>

   

        <language id="kru" name="Kurukh"/>

   

        <language id="kus" name="Kusaie"/>

   

        <language id="kut" name="Kutenai"/>

   

        <language id="lad" name="Ladino"/>

   

        <language id="lah" name="Lahnda"/>

   

        <language id="lam" name="Lamba"/>

   

        <language id="oci" name="Langue d'Oc (post 1500)"/>

   

        <language id="lao" name="Lao"/>

   

        <language id="lat" name="Latin"/>

   

        <language id="lav" name="Latvian"/>

   

        <language id="ltz" name="Letzeburgesch"/>

   

        <language id="lez" name="Lezghian"/>

   

        <language id="lin" name="Lingala"/>

   

        <language id="lit" name="Lithuanian"/>

   

        <language id="loz" name="Lozi"/>

   

        <language id="lub" name="Luba-Katanga"/>

   

        <language id="lui" name="Luiseno"/>

   

        <language id="lun" name="Lunda"/>

   

        <language id="luo" name="Luo (Kenya and Tanzania)"/>

   

        <language id="mac" name="Macedonian" secondary="mak"/>

   

        <language id="mad" name="Madurese"/>

   

        <language id="mag" name="Magahi"/>

   

        <language id="mai" name="Maithili"/>

   

        <language id="mak" name="Makasar"/>

   

        <language id="mlg" name="Malagasy"/>

   

        <language id="may" name="Malay" secondary="msa"/>

   

        <language id="mal" name="Malayalam"/>

   

        <language id="mlt" name="Maltese"/>

   

        <language id="man" name="Mandingo"/>

   

        <language id="mni" name="Manipuri"/>

   

        <language id="mno" name="Manobo languages"/>

   

        <language id="max" name="Manx"/>

   

        <language id="mao" name="Maori" secondary="mri"/>

   

        <language id="mar" name="Marathi"/>

   

        <language id="chm" name="Mari"/>

   

        <language id="mah" name="Marshall"/>

   

        <language id="mwr" name="Marwari"/>

   

        <language id="mas" name="Masai"/>

   

        <language id="myn" name="Mayan languages"/>

   

        <language id="men" name="Mende"/>

   

        <language id="mic" name="Micmac"/>

   

        <language id="min" name="Minangkabau"/>

   

        <language id="mis" name="Miscellaneous (Other)"/>

   

        <language id="moh" name="Mohawk"/>

   

        <language id="mol" name="Moldavian"/>

   

        <language id="mkh" name="Mon-Kmer (Other)"/>

   

        <language id="lol" name="Mongo"/>

   

        <language id="mon" name="Mongolian"/>

   

        <language id="mos" name="Mossi"/>

   

        <language id="mul" name="Multiple languages"/>

   

        <language id="mun" name="Munda languages"/>

   

        <language id="nau" name="Nauru"/>

   

        <language id="nav" name="Navajo"/>

   

        <language id="nde" name="Ndebele, North"/>

   

        <language id="nbl" name="Ndebele, South"/>

   

        <language id="ndo" name="Ndongo"/>

   

        <language id="nep" name="Nepali"/>

   

        <language id="new" name="Newari"/>

   

        <language id="nic" name="Niger-Kordofanian (Other)"/>

   

        <language id="ssa" name="Nilo-Saharan (Other)"/>

   

        <language id="niu" name="Niuean"/>

   

        <language id="non" name="Norse, Old"/>

   

        <language id="nai" name="North American Indian (Other)"/>

   

        <language id="nor" name="Norwegian"/>

   

        <language id="nno" name="Norwegian (Nynorsk)"/>

   

        <language id="nub" name="Nubian languages"/>

   

        <language id="nym" name="Nyamwezi"/>

   

        <language id="nya" name="Nyanja"/>

   

        <language id="nyn" name="Nyankole"/>

   

        <language id="nyo" name="Nyoro"/>

   

        <language id="nzi" name="Nzima"/>

   

        <language id="oji" name="Ojibwa"/>

   

        <language id="ori" name="Oriya"/>

   

        <language id="orm" name="Oromo"/>

   

        <language id="osa" name="Osage"/>

   

        <language id="oss" name="Ossetic"/>

   

        <language id="oto" name="Otomian languages"/>

   

        <language id="pal" name="Pahlavi"/>

   

        <language id="pau" name="Palauan"/>

   

        <language id="pli" name="Pali"/>

   

        <language id="pam" name="Pampanga"/>

   

        <language id="pag" name="Pangasinan"/>

   

        <language id="pan" name="Panjabi"/>

   

        <language id="pap" name="Papiamento"/>

   

        <language id="paa" name="Papuan-Australian (Other)"/>

   

        <language id="fas" name="Persian" secondary="per"/>

   

        <language id="peo" name="Persian, Old (ca 600 - 400 B.C.)"/>

   

        <language id="phn" name="Phoenician"/>

   

        <language id="pol" name="Polish"/>

   

        <language id="pon" name="Ponape"/>

   

        <language id="por" name="Portuguese"/>

   

        <language id="pra" name="Prakrit languages"/>

   

        <language id="pro" name="Provencal, Old (to 1500)"/>

   

        <language id="pus" name="Pushto"/>

   

        <language id="que" name="Quechua"/>

   

        <language id="roh" name="Rhaeto-Romance"/>

   

        <language id="raj" name="Rajasthani"/>

   

        <language id="rar" name="Rarotongan"/>

   

        <language id="roa" name="Romance (Other)"/>

   

        <language id="ron" name="Romanian" secondary="rum"/>

   

        <language id="rom" name="Romany"/>

   

        <language id="run" name="Rundi"/>

   

        <language id="rus" name="Russian"/>

   

        <language id="sal" name="Salishan languages"/>

   

        <language id="sam" name="Samaritan Aramaic"/>

   

        <language id="smi" name="Sami languages"/>

   

        <language id="smo" name="Samoan"/>

   

        <language id="sad" name="Sandawe"/>

   

        <language id="sag" name="Sango"/>

   

        <language id="san" name="Sanskrit"/>

   

        <language id="srd" name="Sardinian"/>

   

        <language id="sco" name="Scots"/>

   

        <language id="sel" name="Selkup"/>

   

        <language id="sem" name="Semitic (Other)"/>

   

        <language id="scr" name="Serbo-Croatian"/>

   

        <language id="srr" name="Serer"/>

   

        <language id="shn" name="Shan"/>

   

        <language id="sna" name="Shona"/>

   

        <language id="sid" name="Sidamo"/>

   

        <language id="bla" name="Siksika"/>

   

        <language id="snd" name="Sindhi"/>

   

        <language id="sin" name="Singhalese"/>

   

        <language id="sit" name="Sino-Tibetan (Other)"/>

   

        <language id="sio" name="Siouan languages"/>

   

        <language id="sla" name="Slavic (Other)"/>

   

        <language id="ssw" name="Siswant"/>

   

        <language id="slk" name="Slovak" secondary="slo"/>

   

        <language id="slv" name="Slovenian"/>

   

        <language id="sog" name="Sogdian"/>

   

        <language id="som" name="Somali"/>

   

        <language id="son" name="Songhai"/>

   

        <language id="wen" name="Sorbian languages"/>

   

        <language id="nso" name="Sotho, Northern"/>

   

        <language id="sot" name="Sotho, Southern"/>

   

        <language id="sai" name="South American Indian (Other)"/>

   

        <language id="esl" name="Spanish" secondary="spa"/>

   

        <language id="suk" name="Sukuma"/>

   

        <language id="sux" name="Sumerian"/>

   

        <language id="sun" name="Sudanese"/>

   

        <language id="sus" name="Susu"/>

   

        <language id="swa" name="Swahili"/>

   

        <language id="ssw" name="Swazi"/>

   

        <language id="sve" name="Swedish" secondary="swe"/>

   

        <language id="syr" name="Syriac"/>

   

        <language id="tgl" name="Tagalog"/>

   

        <language id="tah" name="Tahitian"/>

   

        <language id="tgk" name="Tajik"/>

   

        <language id="tmh" name="Tamashek"/>

   

        <language id="tam" name="Tamil"/>

   

        <language id="tat" name="Tatar"/>

   

        <language id="tel" name="Telugu"/>

   

        <language id="ter" name="Tereno"/>

   

        <language id="tha" name="Thai"/>

   

        <language id="bod" name="Tibetan" secondary="tib"/>

   

        <language id="tig" name="Tigre"/>

   

        <language id="tir" name="Tigrinya"/>

   

        <language id="tem" name="Timne"/>

   

        <language id="tiv" name="Tivi"/>

   

        <language id="tli" name="Tlingit"/>

   

        <language id="tog" name="Tonga (Nyasa)"/>

   

        <language id="ton" name="Tonga (Tonga Islands)"/>

   

        <language id="tru" name="Truk"/>

   

        <language id="tsi" name="Tsimshian"/>

   

        <language id="tso" name="Tsonga"/>

   

        <language id="tsn" name="Tswana"/>

   

        <language id="tum" name="Tumbuka"/>

   

        <language id="tur" name="Turkish"/>

   

        <language id="ota" name="Turkish, Ottoman (1500 - 1928)"/>

   

        <language id="tuk" name="Turkmen"/>

   

        <language id="tyv" name="Tuvinian"/>

   

        <language id="twi" name="Twi"/>

   

        <language id="uga" name="Ugaritic"/>

   

        <language id="uig" name="Uighur"/>

   

        <language id="ukr" name="Ukrainian"/>

   

        <language id="umb" name="Umbundu"/>

   

        <language id="und" name="Undetermined"/>

   

        <language id="urd" name="Urdu"/>

   

        <language id="uzb" name="Uzbek"/>

   

        <language id="vai" name="Vai"/>

   

        <language id="ven" name="Venda"/>

   

        <language id="vie" name="Vietnamese"/>

   

        <language id="vol" name="Volap&#252;k"/>

   

        <language id="vot" name="Votic"/>

   

        <language id="wak" name="Wakashan languages"/>

   

        <language id="wal" name="Walamo"/>

   

        <language id="war" name="Waray"/>

   

        <language id="was" name="Washo"/>

   

        <language id="cym" name="Welsh" secondary="wel"/>

   

        <language id="wol" name="Wolof"/>

   

        <language id="xho" name="Xhosa"/>

   

        <language id="sah" name="Yakut"/>

   

        <language id="yao" name="Yao"/>

   

        <language id="yap" name="Yap"/>

   

        <language id="yid" name="Yiddish"/>

   

        <language id="yor" name="Yoruba"/>

   

        <language id="zap" name="Zapotec"/>

   

        <language id="zen" name="Zenaga"/>

   

        <language id="zha" name="Zhuang"/>

   

        <language id="zul" name="Zulu"/>

   

        <language id="zun" name="Zuni"/>

   

    </languages>
   

Genres

  The supported Genre codes are defined below
 

    Genres

   

    <group name="">

   

            <type value="0" name=""/>

   

        </group>

   

        <group name="Movie/Drama">

   

            <type value="16" name="general"/>

   

            <type value="17" name="detective/thriller"/>

   

            <type value="18" name="adventure/western/war"/>

   

            <type value="19" name="science/fiction"/>

   

            <type value="20" name="comedy"/>

   

            <type value="21" name="soap/melodrama/folkloric"/>

   

            <type value="22" name="romance"/>

   

            <type value="23" name="serious/classical/religious/historical movie/drama"/>

   

            <type value="24" name="adult/movie"/>

   

        </group>

   

        <group name="News/Current affairs">

   

            <type value="32" name="general"/>

   

            <type value="33" name="news/weather report"/>

   

            <type value="34" name="news magazine"/>

   

            <type value="35" name="documentary"/>

   

            <type value="36" name="discussion/interview/debate"/>

   

        </group>

   

        <group name="Show/Game show">

   

            <type value="48" name="general"/>

   

            <type value="49" name="game show/quiz/contest"/>

   

            <type value="50" name="variety show"/>

   

            <type value="51" name="talk show"/>

   

        </group>

   

        <group name="Sports">

   

            <type value="64" name="general"/>

   

            <type value="65" name="special events (Olympic Games, World Cup etc.)"/>

   

            <type value="66" name="sports magazines"/>

   

            <type value="67" name="football/soccer"/>

   

            <type value="68" name="tennis/squash"/>

   

            <type value="69" name="team sports (excluding football)"/>

   

            <type value="70" name="athletics"/>

   

            <type value="71" name="motor sport"/>

   

            <type value="72" name="water sport"/>

   

            <type value="73" name="winter sports"/>

   

            <type value="74" name="equestrian"/>

   

            <type value="75" name="martial sports"/>

   

        </group>

   

        <group name="Children's/Youth programmes">

   

            <type value="80" name="general"/>

   

            <type value="81" name="pre-school children's programmes"/>

   

            <type value="82" name="entertainment programmes from 6 to 14"/>

   

            <type value="83" name="entertainment programmes from 10 to 16"/>

   

            <type value="84" name="informational/educational/school programmes"/>

   

            <type value="85" name="cartoons/puppets"/>

   

        </group>

   

        <group name="Music/Ballet/Dance">

   

            <type value="96" name="general"/>

   

            <type value="97" name="rock/pop"/>

   

            <type value="98" name="serious music/classical music"/>

   

            <type value="99" name="folk/traditional music"/>

   

            <type value="100" name="jazz"/>

   

            <type value="101" name="musical/opera"/>

   

            <type value="102" name="ballet"/>

   

        </group>

   

        <group name="Arts/Culture (without music)">

   

            <type value="112" name="general"/>

   

            <type value="113" name="performing arts"/>

   

            <type value="114" name="fine arts"/>

   

            <type value="115" name="religion"/>

   

            <type value="116" name="popular culture/traditional arts"/>

   

            <type value="117" name="literature"/>

   

            <type value="118" name="film/cinema"/>

   

            <type value="119" name="experimantal film/video"/>

   

            <type value="120" name="broadcasting/press"/>

   

            <type value="121" name="new media"/>

   

            <type value="122" name="arts/culture magazines"/>

   

            <type value="123" name="fashion"/>

   

        </group>

   

        <group name="Social/Political issues/Economics">

   

            <type value="128" name="general"/>

   

            <type value="129" name="magazines/reports/documentary"/>

   

            <type value="130" name="economics/social advisory"/>

   

            <type value="131" name="remarkable people"/>

   

        </group>

   

        <group name="Educational/Science/Factual topics">

   

            <type value="144" name="general"/>

   

            <type value="145" name="nature/animals/environment"/>

   

            <type value="146" name="technology/natural sciences"/>

   

            <type value="147" name="medicine/physiology/psychology"/>

   

            <type value="148" name="foreign countries/expeditions"/>

   

            <type value="149" name="social/spiritual sciences"/>

   

            <type value="150" name="further education"/>

   

            <type value="151" name="languages"/>

   

        </group>

   

        <group name="Leisure hobbies">

   

            <type value="160" name="general"/>

   

            <type value="161" name="tourism/travel"/>

   

            <type value="162" name="handicraft"/>

   

            <type value="163" name="motoring"/>

   

            <type value="164" name="fitness &amp; health"/>

   

            <type value="165" name="cooking"/>

   

            <type value="166" name="advertisement/shopping"/>

   

            <type value="167" name="gardening"/>

   

        </group>

   

        <group name="Special characteristics">

   

            <type value="176" name="original language"/>

   

            <type value="177" name="black &amp; white"/>

   

            <type value="178" name="unpublished"/>

   

            <type value="179" name="live broadcast"/>

   

        </group>

   

Related Articles
Introduction to EPG Management
General Icareus Playout EPG Server is used to broadcast the TV program information and to generate the necessary service information. It provides many different ways to ingest the EPG/EIT data. Each EPG source can be managed based on the settings ...
EPG Sources
Introduction Usually, in TV / OTT services, the EPG data is received from the 3rd party EPG sources, which are either commercial EPG data providers or then technical solutions like Icareus EPG Playout server extracting the EPG data from DVB ...
Epgs.com
Introduction More information can be found at http://www.epgs.com/ Supported Datasources Local drop folder Http(s) EPGS.com DTD EPGS DTD: http://epgs.com/feeds/xml/epg.dtd Example of EPGs.com format <?xml version="1.0" encoding="UTF-8" ?> <!DOCTYPE ...
Thomson Jade
Introduction Jade EPG format specifies an XML file which contains the EPG events for multiple services. Format Example of Jade Format <PSI lang="chi"> <BOUQUET id="65520" version_number="31"> <NAME_BOUQUET encoding="05">RTHK</NAME_BOUQUET> ...
TV-Anytime
Introduction TV-Anytime EPG format specifies an XML file which contains first a program information table which identifies the programs using crid ids and after this a schedule of events that refer back to the program information table. Note that ...

MS Excel

MS Excel

Introduction

Format

Mapping format to Icareus Playout

Configurable field mapping

The field mapping parameters

Table of available fields

Table of formats

Additional fields used in EPG API

Language Codes

Genres

Related Articles

Introduction to EPG Management

EPG Sources

Epgs.com

Thomson Jade

TV-Anytime