User Manual - Avalpa Digital Engineering Srl
Contents
1. 1 2 3 4 5 into this list of phpcalendar id cids 1 2 3 5 In the following table where Canale 4 sid are defined will be ignored and can be removed or not as you prefer Add a calendar If it is necessary to add a calendar to the database the extraction script needs to change accordingly Most of the information is actually in the header and you will need to moify two lines in the cids list is necessary to add a new cis order is not important For example to add the Canale Nuovo cid 8 you need to change this list of phpcalendar id cids 1 2 3 4 5 into this list of phpcalendar id cids 1 2 3 4 5 8 More over in the followinig table it necessary to add a new sid list syntax is sids lt cid gt lt sid1 gt lt sid2 gt lt sid3 gt following the example if the Canale Nuovo is broadcast with 2 sid 1801 and 1802 the resulting line will be sids 8 1801 1802 Final result will look like onid of mux tsid 8572 tsid of mux tsid 12345 list of phpcalendar id cids 1 2 3 4 5 8 cid ServiceName sids 1 1001 1010 1011 1 Canale 1 sids 2 1101 1201 2 Canale 2 sids 3 1301 3 Canale 3 sids 4 1401 4 Canale 4 EPG User Manual 22 31 Avalpa Digital Engineering Srl Sede A Via dell Arcoveggio 49 5 A tal ADDY P IVA e C F Registro imprese Bologna 02831521204 I 40129 Bologna vem w MONENG Tel 390514187531 Fax 390514173985 www avalpa com info avalpa com sids_5 1701 52. L Repeats Neve Read only Figure 11 Event generation form The form asks you to insert Subject title of the event like News or a Movie title Description event description usually reports about year director actors plot and so on Parentral Control the minum age require to watch an event in a chosen country Category lets you define to which Category the events belong to news movie documentary The from When is more complex and defines the occurrences of the event some events are suppose to be aired only once while others will have a period for example the event News is repeated every day at every time For an event without multiple repetitions the form to fill up is as shown on Fig 11 where it is enough to set date and time of start and end of the event If you need to broacast an event with repeated occurrences it is necessary to modify the Repeats from Never to one of the possible choices daily e weekly EPG User Manual 16 31 Avalpa Digital Engineering Srl Sede A Via dell Arcoveggio 49 5 A ital ADD P IVA e C F Registro imprese Bologna 02831521204 I 40129 Bologna nd 9 NONG Tel 390514187531 Fax 390514173985 www avalpa com info avalpa com monthly yearly This way the form is going to expand and will allow to insert repetition information For example if we choose daily the form will let you insert a numeric value showing how often the e
3. NOTE using a web browser is possible to view the script output using the following address http epg avalpa org demo phpc2epg full v3 php service cid 192 168 2 100 epgbasic phpc2epg full v3 php service Epg gateway to OpenCaster ver 0 3 30 3 2010 Copyright Avalpa digital engineering srl info avalpa com Calendar Service EPG Server local time 03 18 10 2 2011 TDT table based on UTC time tdt time date section year 111 since 1900 i e 2009 is 109 month 2 day 10 hour 0x14 they are decimals but in hex format minute 0x18 second 0x18 version number 1 Before any version update section number 0 last_section_number 0 lastid 0 Table span From 1297296000 gt 00 00 10 02 2011 To 1297641599 23 59 13 02 2011 service 1 with total events present in the current window 0 Dummy empty section 0 eit0 event information section table id EIT ACTUAL TS PRESENT FOLLOWING service id avalpal service id a sport stream id avalpa trans ort stream id original network id avalpa original transport stream id event loop The script access the DB generate a text file in python format with most of the information needed by OpenCaster to generate the EIT This information are the structs event information section just section from now on referring the calendar identified with cid Sections are build with two subtable actual present following actual schedu
4. 1610 N DTV Air 576 fies sof J ELT Tutto Boje e Franzi rispondono a una chiamata per un incidente stradale La vecchia Jaguar di Marta Wholers unpresso la famiglia De Renal una famiglia boghese di Besanson lt BR gt Nonostante le sue umili origini il ragazzo dall aspetto deciso e ribelle incomincia la sua scalata al successo La signora De Renal Carole Bouquet una donna debole sempre dedita alla famiglia estremamente religiosa si innamora perdutamente del giovane Julien lt BR gt A Besanson presto si incomincia a vociferare della presunta relazione fra i due lt BR gt Julien che ancor prima di iniziare a fare il precettore aveva deciso di prendere i voti si vede costretto ad anticipare la sua entrata in seminario Ma ancora una volta i due amanti di MEDIASET Figure 2 Example of detailed event information Nessun titolo Stereo 57614 43404 MICE T a Dettagli non disponibili E Guarda lt ZVZUCUzIONEDEL FATTO QUOTIDIANO Figure 3 Event without EPG information EPG can also send information regarding also future events not only current and following Most of the decoder and TV with digital receivers are able to parse the data and show a complete guide on the events broadcast in the next days Fig 4 shows such an example EPG User Manual 5 31 Avalpa Digital Engineering Srl Sede Via dell Arcoveggio 49 5 Dy ital ADD P IVA e C F Registro imprese Bologna 02831521204 I 40129 Bologna i MONENG Tel 390
5. Canale 5 sids 8 1801 1802 Note comments follow always the char can be added as needed and are not mandatory Database backup and restore To backup the data you can proceed as following mysqldump u calendar p calendar gt dump sql Restore process is also a single command line mysql u calendar p calendar dump sql Note restore delete ad adds tables so every changes between a backup and its restore will be lost How to verify settings and tables It is possible to check DVB stream with some simple commands and verify if generated tables and selected settings are correctly managed The first step is to record the DVB stream A simple command is tsasirecord stream ts x 20 this will allow to record 20MB of DVB stream Analysis can be accomplished using dvbsnoop tool the command is the following dvbsnoop tsraw s ts tssubdecode if stream ts 18 gt analisi txt this will analyze il PID 18 where EPG information is broadcast Note it is suggested to redirect ouput on file like in the exampl output command can be quite large and not easy to read A typical result is the following dvbsnoop V1 4 50 http dvbsnoop sourceforge net TS Packet 00000001 PID Full TS read Length 188 0x00bc from file stream ts 0010 00 01 4e 07 22 d8 5d 12 00 00 04 00 00 80 43 4d Nea CM 0020 3b 69 74 61 0d 53 68 6f 70 70 69 6e 67 20 74 69 ita Shopping ti 0030 6d 65 29 43 6f 6e 73 69 67 6c 69 20 75 74 69 6c me Consigli
6. Film del giorno Avventura od emozione Regista Titolo Interviste ospiti televisione cronaca gossip 20 00 2100 Telegiornale Notizie dal mondo per rimanere sempre aggiornati I migliori film in prima serata Titolo tttt Regia rr Trama xxxxxxxxxxxxx Figure 17 Example of html table generated by the system EPG User Manual 26 31 Avalpa Digital Engineering Srl Sede A Via dell Arcoveggio 49 5 i F A tal P IVA e C F Registro imprese Bologna 02831521204 I 40129 Bologna i NONNA Tel 390514187531 Fax 390514173985 www avalpa com info avalpa com Export to teletext Data information on the events aired by the services are automatically exported and always updated into elementary stream for DVB teletext 25 02 2011 11 46 03 GUIDA TV CANALE 1 venerd 25 febbra MATTI M INO NEWS RASSEGNA STAMPA TELEGIORNALE TELEFILM TUTTI IN CUCINA METEO SPORT NEWS FILM CARTONI ANIMATI TELEFILM QUIZ TV TELEGIORNALE ETEO M FILM N d d d d d d d d md Oo6 00 O8 0O 08 15 9 Rec o 1 00 2 00 4 00 4 30 5 00 7 00 8 00 9 00 oo 0 20 45 21 00 Figure 18 Example of EPG data inserted into teletext EPG User Manual 27 31 Avalpa Digital Engineering Srl Sede Via dell Arcoveggio 49 5 Dy tal i 1 P IVA e C F Registro imprese Bologna 02831521204 40129 Bologna ROT 9 QADUAGIWA Tel 4390514187531 Fax 390514173985 www avalpa com info avalpa com Export to MHP application Data information are a
7. define a single event News with its own field like description type image and so on and multiply the number of occurrences bound to the event All the occurrences will have the same eid referring News but will have unique oid Every occurrence will have also its own start and end time Please note that start and end are stored in UTC format i e the number of seconds elapsed sinc 00 00 00 1 of 1970 Users and rights EPG Avalpa Server allows different roles to access database data we look at them like 3 groups e public data entry e administrator Rights are increasing from public to administrator the public roles can visualize data and on some specific case is allow to add events Data entry is the role to access data to add and change information event but is now allow to change service objects and users Administrator has all the rights and can modify create and delete events services and others users EPG User Manual 8 31 Avalpa Digital Engineering Srl Sede CH jJ A Via dell Arcoveggio 49 5 C2 P IVA e C F Registro imprese Bologna 02831521204 40129 Bologna hoto nonno Tel 390514187531 Fax 390514173985 www avalpa com info avalpa com EPG Server is deployed original with a public access limited to two roles with higher privileges user dataentry password epg level data entry user epg password epg level administrator It is suggested to change the default password and to create new profile for access with pr
8. epgnew v3 sh will extract data for the three service and will query the database for only the Calendard ID 1 then will generate events starting from sids_1 service list First it will generate EIT present following and the schedule per the three services Note even if you can share audio and video among different services this is not allow by standard EIT so the EPG information will linearly growup with the repetition of the same audio video however the bitrate absolute value is still very small To modify sid references a calendar it is only necessary to modify the list relative to its CID For example to add SID 1252 among CalendarId 2 you should apply the following change from sids 2 1101 1201 2 Canale 2 to sids 2 1101 1201 1251 2 Canale 2 and the script will add the Canale 2 three versions each with its EIT and different SID Remove a calendar If it is necessary to remove a calendar from the database to stop extraction script from building EPG User Manual 21 31 Avalpa Digital Engineering Srl Sede A Via dell Arcoveggio 49 5 yh ital ADD P IVA e C F Registro imprese Bologna 02831521204 I 40129 Bologna ROT 9 NONG Tel 390514187531 Fax 390514173985 www avalpa com info avalpa com empty tables it is necessary to change the header of the script In detail you just need to modify the list defined in cids For example if you want to delete Canale 4 cid 4 you should change this list of phpcalendar id cids
9. in the choose month e G epgavalpa org cool index php action display month amp year 2011 amp month 3 amp day 1 AALP Canale 1 AALP ojo reni ojo venio Add Event Search View Control Deck View Week View date Logout Service Admin Admin View in GMT last year last month Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec next month next year March 2011 Europe Rome Figure 10 Month view In a similar way than the week view all the occurences of the events are shown in different boxes each of the them for a single day A click on the number of the day makes possible to move to the day view of the choose date it is also possible to browse among months and years using the labels just under the navigation bar EPG User Manual 15 31 Avalpa Digital Engineering Srl Sede A Via dell Arcoveggio 49 5 Ao ital ADD P IVA e C F Registro imprese Bologna 02831521204 I 40129 Bologna ROT 9 MONENG Tel 390514187531 Fax 390514173985 www avalpa com info avalpa com Generation of an event To insert a new event there is a specifi form to help filling up all the necessary information to define an event and its occurences Cia li Canale 1 jiha ii Add Event Search View Control Deck View Month View Week View date Logout Service Admin Admin Subject Age Rating Country Parental Control Categorization Category undef From Date 2011 March v 1 v To Date 2011 v Marh 1 7 ji
10. util 0040 69 20 70 65 72 20 74 75 74 74 69 20 69 20 74 75 i per tutti i tu 0050 6f 69 20 61 63 71 75 69 73 74 69 2e 55 04 69 74 oi acquisti U it EPG User Manual 23 31 Coto enoneenng ff ff ff ff ff ff ff ff ff ff Ww Wa anu ru Tn i Gru uo GP Gu 0020 00b0 Sync Byte 0x47 71 0x47 Transport error indicator 0 0x00 Sync Byte 0x47 71 0x47 Transport error indicator 0 0x00 Payload unit start indicator 1 0x01 transport priority 0 0x00 PID 18 0x0012 DVB Event Informati transport scrambling control 0 0x00 adaptation field control 1 0x01 n continuity counter 4 0x04 sequen Payload len 184 gt pointer field 0 0x00 gt Section table 78 0x4e transport stream present following Data Bytes 0000 00 4e bO 5e 03 e9 c3 00 NESTOR N N 0010 22 d8 5d 12 00 00 04 00 Rae CM ita 0020 Od 53 68 6f 70 70 69 6e time C 0030 6f 6e 73 69 67 6c 69 20 utili pe 0040 72 20 74 75 74 74 69 20 tuoi a 0050 63 71 75 69 73 74 69 2e cquisti U ita 0060 c6 d2 ff ff ff ff ff ff Dv EM 0070 ff ff ff ff ff ff ff ff f CE Ae Ren 0080 ff ff ff ff ff ff ff ff fu E 0090 ff ff ff ff ff ff ff ff ife mU cce 0020 ff ff ff ff ff ff ff ff DEEST UIDES 00b0 ff ff ff ff ff ff ff ff TS contains Section SI packet lengthz97 PID 18 0x0012 Guess table from table id EIT decoding Table ID 78 0x4e Event In EPG User Manual Avalpa Digital Engin
11. 1 52 53 nextweek next year ISO Week number 9 of 2011 Europe Rome Figure 8 Week view of the events Under the navigation bar there is another bar with all the week of the year starting from 1 to 53 ISO 8601 year 53 week is in between end of the year and next Inside the column identifying every single day there are two commands the first identified the day number moves the the daily base view check paragraph Day View the second identified by a symbol shaped like a moves to the interface to generate a new event check paragraph Generation of an event where the parameters relative to a date will be set from the choose day EPG User Manual 13 31 Avalpa Digital Engineering Srl Sede A Via dell Arcoveggio 49 5 Dy tal 1 P IVA e C F Registro imprese Bologna 02831521204 40129 Bologna ae i MONENG Tel 390514187531 Fax 390514173985 www avalpa com info avalpa com Day View This view shows all the events of a give date i e all the events starting that day The date is shown in the view right after the navigation bar Events are shown row by row ordered by increasing starting time The table has 3 coloumns e Title has a tick able box a link to access to the event modify function Modify and the title text that can be show more information on the event if clicked e Time starting time and ending time of the event always refered to the timezone of the service e Description the extended descri
12. 514187531 Fax 390514173985 www avalpa com info avalpa com DTV Air 4 Rete4 HAMBURG DISTRETTO 21 NIENT ALTRO CHE LA VERITA 15 10 16 15 m Boje e Franzi rispondono a una chiamata per un incidente stradal 16 00 17 00 17 00 18 00 Rai 2 Nessuna informazione Rai 3 TGR Emili Cose dellaltro Geo Geo Rete4 SENTIERI Nessuna informazione Canale5 U AMICI Nessuna informazione Italiat SAILOR MO MERLIN LA CHIAMATA Nessunai LA7 ATLANTIDE STORIE DI UOMINI E DIMOND M Mod vis 240re Mi Mod CH Dinformazioni Pagina Gi Figure 4 Example of guide with scheduled events Objectives The manual is meant for the operational of the Graphics User Interface of data entry of events in the server Operators working on the GUI directly are recognized in 4 roles 1 System integrator of the platform in the multiplexer 2 System administrator creating the services 3 Data entry operator each event at its scheduled time 4 Monitoring operator overlooking correct functioning The manual is meant for the last three roles using the system on daily base The typical routine regards data entry and modification of events and their schedules as the change of the services configured on the multiplexer should be considered a unique and rare event EPG User Manual 6 31 Avalpa Digital Engineering Srl Sede A Via dell Arcoveggio 49 5 Ao ital ADD P IVA e C F Registro imprese Bologna 02831521204
13. Administration Panel EPG User Manual 19 31 Avalpa Digital Engineering Srl Sede Via dell Arcoveggio 49 5 otal Aneng P IVA e C F Registro imprese Bologna 02831521204 I 40129 Bologna Tel 4390514187531 Fax 390514173985 www avalpa com info avalpa com Event search The page allow to search the database for events starting from a string and temporal markers Canale 1 Add Event View Control Deck View Month View Week Logout Service Admin Admin Search Phrase fim From January __ 2011 v To ES February Y 2011 Sort By Start Date v Order Ascending v Figure15 Form for event search Search is carried out looking for a match from the sentence inserted int the title or in the desciption fields of the event inside the time range For example looking for Film will probably give a result like Cirio li Canale 1 Add Event View Control Deck View Month View Week Logout Service Admin Admin Search Results Description PIU BEI FILM DI TUTTI TEMPI ANNO 1957 REGIA BIOGRAFICO ATTORI JAMES STEWART MURRAY HAMILTON PATRICIA SWEET MARC CONNELLY TRAMA CHARLES LINDBERGH E UN GIOVANE AVIATORE CHE SOGNA DI COMPIERE LA GRANDE IMPRESA LA TRAVERSATA DELL ATLANTICO SU UN AEREO MONOPOSTO IL 20 MAGGIO 1927 DOPO VARI FALLIMENTI DI EROICI MA SFORTUNATI PILOTI PARTE DA NEW YORK CON POCHI VIVERI E SENZA RADIO MA CON IL CARBURANTE SU
14. Avalpa Digital Engineering Srl Sede A Via dell Arcoveggio 49 5 Dy tal 1 P IVA e C F Registro imprese Bologna 02831521204 40129 Bologna vem i NONNA Tel 390514187531 Fax 390514173985 www avalpa com info avalpa com The Electronic Program Guide is one of the basic functions most useful to enrich the transmission of audio and video for a digital broadcaster 14 00 Electronic Program Guide EPG Electronic Program Guide User manual Col EPG User Manual 1 31 Avalpa Digital Engineering Srl Sede A Via dell Arcoveggio 49 5 A ital ADD P IVA e C F Registro imprese Bologna 02831521204 I 40129 Bologna ROT 9 CAD UNREAD Tel 390514187531 Fax 390514173985 www avalpa com info avalpa com Index Table of Contents EPG Electronic Pogliani 1 lil alal 2 REVISIONS ea IUE MM IM li ale lia 3 RR RR I 4 018 CV RR RR RR RI RR I IE I 6 Spresiano 7 Te UTA Gl ARRE AIA 7 Calendar eines eaebia 7 Lpd clara 8 Lele 9 System dccBss and DIS issoro eee eean e Eae e A aE A eao aa eae aaa iea 10 Object Event lalla 11 NVidia 12 VELA RR GR E EEA 12 pr ur ccceacaieaa 14 hs ranur M EEE 15 Generation Of An RUNE OO o iaei aaraa en 16 Service ManagRiieil a ashes 18 Portal AGI Strato AR RZ 19 Edi 20 Configure ONID TSID iii 21 Rem yv a calendar lilla pra 21 Adda calendar sser dun kar tet uns edv cua on esau dei dvaithcouduaweuduacsvaneyensudlsclybvadaconucauclis udsaisastuauondsdaddv
15. FFICIENTE PER ARRIVARE A DESTINAZIONE PARIGI TRAMA PIU BEI FILM DI TUTTI TEMPI Figure 16 Example of search result More options are available to define sorting of the events in the result set EPG User Manual 20 31 Avalpa Digital Engineering Srl Sede A Via dell Arcoveggio 49 5 A ital ADD P IVA e C F Registro imprese Bologna 02831521204 I 40129 Bologna ROT 9 CAD UNREAD Tel 390514187531 Fax 390514173985 www avalpa com info avalpa com Configure ONID TSID and SID Calendars are memorized in the database and are bound to aired services in a 1 to many way If a calendar presents events related to an audio video stream that stream can be shared among different services to manage service numbering without bandwidth lost a typical example is The service will start soon To allow this capability the script allows a header where Original Network ID Transport Stream ID and Service ID that are the only standard way to identify a service are specified and bound to a Calendar ID onid of mux tsid 8572 tsid of mux tsid 12345 list of phpcalendar id cids 1 2 34 5 cid ServiceName sids 1 1001 1010 1011 1 Canale 1 sids 2 1101 1201 2 Canale 2 sids 3 1301 3 Canale 3 sids 4 1401 4 Canale 4 sids 5 1701 5 Canale 5 Thie example shows 3 service aired with triplets onid tsid sid 8572 12345 1001 8572 12345 1010 8572 12345 1011 and bound to the single cid 1 The script start
16. I 40129 Bologna ROT 9 MONENG Tel 390514187531 Fax 390514173985 www avalpa com info avalpa com System features Avalpa EPG configuration system is based on a database typically on a mysql that is populated through a PHP application running on Apache server web and implementing a web interface This allows configuration on local or remote network in a totally transparent way without any need to install any software rather than a web browser on the operator s computer A software extracts data present on the database to inject them into the playout system based on OpenCaster that will take care to broadcast them in DVB format It is possible also to easily implement integration scripts with third parties platform to inject and extract data Avalpa s EPG is currently at version 1 0 and supports the following functions e event description title and synopsis e parental control e present following events e schedule events up to many days in front System usage To connect to the system you will a personal computer with web browser Firefox Explore Chrome Opera System will ask for credentials and user will have different rights this information is established at installation o later but has to be carefully secretly kept Without authentication you will be able to access the system as read only Have a look to an EPG creation tool available at this address http epg avalpa org cool Calendar definition A calendar is a mysql o
17. anale 1 that is Service 1 under the service name there is the navigation bar presenting some options like Add Event Search that will explain later on third row is where day and time is set that is currently when you open the page date and time are related to tue current date and time the main area of the screen is reserved for a table where every row is a service configure in the multiplexer with its name for every service on its row we fine the first the event related present and following e if the first service is running you should see a progress bar changing color and filling up From the main page is possible to move to other pages where a number of actions are possible like insert visualize modify and so on Most of the actions are carried out with simple graphic commands EPG User Manual 10 31 Avalpa Digital Engineering Srl Sede A Via dell Arcoveggio 49 5 Dy ital 1 P IVA e C F Registro imprese Bologna 02831521204 40129 Bologna ae i MONENG Tel 390514187531 Fax 390514173985 www avalpa com info avalpa com Object Event In any moment is possible to get information with more details on a event just passing the mouse over the event title box this will open a tool tip with the detailed informations Fig 6e 8 A single click on the box with the title event will present a page with even more details and it allows to modify the information epg avalpa org cool index php action display ev
18. base AALR ioi zd Canale 1 Add Event Search View Control Deck View Month View Week Logout Admin Options Week Start Monday non UK v Time Zone Europe Rome Service Name canale 1 Maximum Subject Length 32 Public Permissions Can read but not write events Y User Permissions User Name Read Write Can Create Read Only epg di dataentry O Figure 13 Management of service parameters EPG User Manual 18 31 Avalpa Digital Engineering Srl Sede Via dell Arcoveggio 49 5 C pin voit P IVA e C F Registro imprese Bologna 02831521204 40129 Bologna Tel 4390514187531 Fax 390514173985 www avalpa com info avalpa com Portal administration This page allows to manage generate modify delete of services and user profiles Canale 1 Add Event Search View Control Deck View Month View Week Logout Service Admin Create User User Name Password Confirm Password Make Admin e Submit Create Service Monday non UK Time Zone GMT Service Name Maximum Subject Length Public Permissions Cannot read nor write events Submit Service List a Canale 2 delete Canale 3 delete Canale 4 delete Canale 5 delete User List epg delete dataentry delete Figure 14
19. bject organized in days weeks months and so on For every calendar is possible to define the events and their occurrences when the the event goes on air Every calendar should be bound at least to a service defined by the triplet ONID TSID SID as specified by DVB however the presence of different services sharing the same audio and video make possible the these services share the same calendar so a calendar can be related to more than one service A calendar is defined by the following fields cid unique calendar id calendar_title week_start subject_max timezone EPG User Manual 7 31 Avalpa Digital Engineering Srl Sede A Via dell Arcoveggio 49 5 A ital ADD P IVA e C F Registro imprese Bologna 02831521204 I 40129 Bologna ROT 9 MONENG Tel 390514187531 Fax 390514173985 www avalpa com info avalpa com Event definition The data is memorized into the database with the following fields cid unique calendar id to which the event belongs to eid unique event id subject description category country_code rating image for every event there is at least one occurrence that is when it is going to be aired An occurrence is defined as following eid unique event id oid unique occurrence id start time stamp UTC end time stamp UTC The same event can be aired more than once with different star end time For example the event News can be aired more than once per day every day so it is possible to
20. d out the present following events of the generation of the present following EIT table the table is formed by two sections one for the present event and one for the following event Standards suggests also that if an event does not exists because of a gap a blank section should be generated Following event is generated in the same way The next step is the generation of the EIT schedule table By standard the table manages up to 256 sections divided int 32 segments Every segment has data to describe 3 hours time span so 32 segments are 96 hours i e 4 days starting from UTC midnight NOTE the 32 segment is the default value for the PHP script it is also possible to use smaller values but still 1 segment will always be 3 hours time span phpc2epg full v3 php service cid amp maxsegment n Every segment can use up to eight sections the number of section of a single section depends on how much data the event descriptors use A single section is maximum 4096 byte Section numbering by standard is as follow segment 0 sections 0 7 segment 1 sections 8 15 segment 2 sections 16 23 segment 31 sections 248 255 It can happen that events for a 3 hours time stamp don t get enough data so high to fill up all the sections so it is not necessary for all the sections number to be there still the maximum will always be 255 and minimum 0 EPG User Manual 31 31
21. eering Srl P IVA e C F Registro imprese Bologna 02831521204 Tel 390514187531 Fax 390514173985 assigned for DVB Sede Via dell Arcoveggio 49 5 1 40129 Bologna www avalpa com info avalpa com ui WAP Gru we THO Wr ff ff packet ok packet ok Packet data starts on Table EIT No scrambling of TS packet payload o adaptation field payload only ce ok Event Information Table EIT actual 01 01 00 01 00 01 4e 07 00 80 43 4d 3b 69 74 61 67 20 74 69 6d 65 29 43 Shopping 75 74 69 6c 69 20 70 65 onsigli 69 20 74 75 6f 69 20 61 r tutti i 55 04 69 74 61 00 5f f9 ff ff ff ff ff ff ff Tar WF YHP Ur YHP ar Tr ff ff ff ff ff ff ff ff iit Event Information Table EIT formation Table EIT actual transport 24 31 Avalpa Digital Engineering Srl Sede A Via dell Arcoveggio 49 5 Ao ital TA DOV P IVA e C F Registro imprese Bologna 02831521204 I 40129 Bologna Ld i MONENG Tel 390514187531 Fax 390514173985 www avalpa com info avalpa com stream present following section syntax indicator 1 0x01 reserved 1 0 0x00 reserved 2 3 0x03 Section length 94 0x005e 0x03e9 gt refers to PMT program number reserved 3 3 0x03 Version number 1 0x01 current next indicator 1 0x01 valid now Section number 0 0x00 Last Section number 1 0x01 ansport stream 256 0x0100 Original twork ID 256 0x0100 ExpressVu ExpressVu Inc Segment last Secti
22. ent amp oid 3639 AALP igal at Canale 1 Add Event Search View Control Deck View Month View Week Logout Service Admin Admin Rotocalco TV by epg in country ita Modify Delete When March 01 2011 at 17 00 to 20 00 Previous Occurrence Next Occurrence View All Occurrences Interviste ospiti televisione cronaca gossip Figure 7 Visualize details of an event EPG User Manual 11 31 Avalpa Digital Engineering Srl Sede A Via dell Arcoveggio 49 5 A ital ADD P IVA e C F Registro imprese Bologna 02831521204 I 40129 Bologna ROT 9 CAD UNREAD Tel 390514187531 Fax 390514173985 www avalpa com info avalpa com Navigation Bar Using the navigation bar in the main page is possible to access other functions of the EPG Server that allows actions on database data Please note that all the actions refers to the service shown as title in the first row In brief Add Event move to the event creation page Search move to the search event page View Month move to the month view View Week move to the week view Logout stop using the current permissions and fall back to public access rights Service Admin Service administration page Admin Portal administration page Every single time page is change the navigation bar is slightly changed currently show action is replaced by View Control Deck to move back to the main portal In the main portal page is possible to change view to a week base v
23. eotesuctes 22 Database backup and TOStOre ccsincsscesesssciesendassesasncawesaansdvepaeenccosardsecedesacasweannddeesdabaccaseedsaieebantoesaades 23 How to verify settings and bless 23 Appendix ASOpuonaledena dirai 26 EPG multiplexing of services imported from other DVB TS esee 26 A t matic insertion Of events scarto o vives saxa Vd e drm s uou do viva an Pa AE urea og Das uu 26 Export to zm i o a eaa 26 Export to teletext espe ub exert etre O EAE RE eb an ated RTRT 27 Export to NEEIP 3ppIC SEO aliena 28 Appendix B EIT Generation internals 5 rare 29 PHP cces to the p PRI C E 30 EPG User Manual 2 31 Coto enoneenng Avalpa Digital Engineering Srl P IVA e C F Registro imprese Bologna 02831521204 Tel 390514187531 Fax 390514173985 Sede Via dell Arcoveggio 49 5 40129 Bologna www avalpa com info avalpa com Revisions Author Revision Date Notes Lorenzo Pallara 1 4E 02 03 2011 English version new index Thomas Pavani 1 4 01 03 2011 Update images Thomas Pavani 1 3 21 02 2011 Update images Andrea Venturi 1 2 21 02 2011 Release Thomas Pavani 01 00 00 01 02 2011 First version EPG User Manual 3 31 Avalpa Digital Engineering Srl Sede A Via dell Arcoveggio 49 5 Ao tal ADD P IVA e C F Registro imprese Bologna 02831521204 I 40129 Bologna ROT 1 MOMO Tel 390514187531 Fax 390514173985 www avalpa com info avalpa com Introductio
24. iew of a service with a click on the service s name Please note that the choose service become the selected service so the service name in the top will be change becoming the selected service and all the actions will refer to it Week view The view shows the event of the selected service on a week base view There are seven columns one for each day of the current week every day shows row by row the event ordered by starting time Every column shows only the events started that day this means events in between two days are shown only in their starting day Note starting time and end time of an event is in the timezone of the service the timezone is visible after the week number check Fig 8 timezone is Europe Rome Some conventions worth mentioning The weeks starts on Monday this can be change on service base check Service Managment The current day has a white background past days has a grey background and future days has a light gray background The week number is defined following ISO 8601 standard where the week includes the first Thursday of the year EPG User Manual 12 31 Avalpa Digital Engineering Srl Sede A Via dell Arcoveggio 49 5 A ital i 1 P IVA e C F Registro imprese Bologna 02831521204 40129 Bologna ae i MONENG Tel 390514187531 Fax 390514173985 www avalpa com info avalpa com C epg avalpa org cool index php action display_week AALP Cirio zd Canale 1 43 44 45 46 47 48 49 50 5
25. ivileges based on your use case Log In Through this page is possible to access and log in so to gain rights over public access epg avalpa org cool index php action login amp lastaction display_deck Canale 1 Search View Control Deck View Month View Week Log in Log in You must have cookies enabled to login Username Password Figure 5 Log in EPG User Manual 9 31 Avalpa Digital Engineering Srl Sede A Via dell Arcoveggio 49 5 A ital 1 P IVA e C F Registro imprese Bologna 02831521204 40129 Bologna ae i MULINO Tel 390514187531 Fax 390514173985 www avalpa com info avalpa com System access and browsing To access the system you need only to open the browser at the address http epg avalpa org cool You should find an image looking like the following one epg avalpa org cool index php action display_deck AALP Fight li Canale 1 Search View Month View Week Login View in GMT 16 44 1 March 2011 Europe Rome N Film del giorno March 01 2011 at 15 00 to 17 00 Avventura od emozione Regista Titolo Canale 2 A ifanslo 4 Figure 6 Entrance page Web interface is the synthesis of EPG status clean and without decorations to express maximum information at first glance We can quickly identify different information e on top there is the title of the service currently selected default is the first service In thie case we have just C
26. le The PHP script finds out all the events with occurrences starting from midnight UTC NOTE the script allows to pass an UTC timestamp to choose a different stating time in this case the syntax call will be hpc2epg full v3 php service cid amp timestamp 1297072111 EPG User Manual 30 31 Avalpa Digital Engineering Srl Sede A Via dell Arcoveggio 49 5 A ital ADD P IVA e C F Registro imprese Bologna 02831521204 I 40129 Bologna ROT 9 CAD UNREAD Tel 390514187531 Fax 390514173985 www avalpa com info avalpa com C 192 168 2 100 epgbasic Present event running eit0 event information section table id EIT ACTUAL TS PRESENT FOLLOWING dr id vice id transport stream id avalpa transport stream id original network id avalpa original transport stream id event loop z i T Event 7121 SID SHOPPING TIME Desc TANTE UTILI IDEE PER I TUOI ACQUISTI DEBUG 1293890520 1293892320 len 0 30 0 1 1 2011 event_loop_item event_id 8805 this is the occurrence id from the database start yea 111 since 1900 i e 2009 is 109 start_month start_day start_hours start_second duration_hours running_status free CA mode 0 0 means service is 5 ambled nea at least a stream is scrambled event_de riptor loop short event de 150639 langua event name a text TANTE UTILI IDEE PER I TUOI ACQUISTI parental rating descriptor country code ita rating 0x00 The script will then fin
27. logna 02831521204 40129 Bologna vem i QADUAGIWAD Tel 390514187531 Fax 390514173985 www avalpa com info avalpa com Appendix A Optional extensions More options are availables to the basic platform described so far EPG multiplexing of services imported from other DVB TS Digital tv operators often needs to broadcast content coming from others platform like satellite or iptv If incoming services already have EIT information it is necessary to reschedule them in the Avalpa Server For this purpose a scheduler extension is available The advanced scheduler collects and re insert also the tables of re multiplexed service and can also modify TSID ONID SID accordingly to the new multiplex Automatic insertion of events Most of the scheduled events are describe with file formats like XML CSV XLS TXT agreed upon user request and they are automatically inserted into the database and are available later on the web interface as if the were data inserted manually Export to HTML pages Data information of the events aired by the services are automatically exported and always updated to tables and pages in HTML format useful to insert in the broadcaster web site A typical example will look like epg avalpa org demo phpc2html v2 php Canale 1 21 febbraio 2011 3 00 Telegiornale Notizie dal mondo per rimanere sempre aggiornati Fine Programma tao 13 00 Cartoni animati Svaghi per grandi e piccini 13 153 15 00 1700
28. n The Electronic Program Guide is one the basic function most useful over audio and video for a digital television operator EPG sends to the decoders information on the events currently on air and on the following one already scheduled information not only about the currently showing service but also about all the others present in the multiplex In the following image it is shown how the information sent through EPG are a valid hint to support choice to watch an event or another The firsts images show how information relative to the event present following help the watcher to understand what is on air and how to get more information about the event On the other side Fig 3 shows how the missing of such information leaves the watcher puzzled about what is on air a 16 09 Lun 21 Feb HAMBURG DISTRETTO 21 NI 15 10 16 15 TM rois EN Boje e Franzi rispondono a una chiamata per un incidente stradale La Guarda 4 vecchia Jaguar di Marta Wholers unpresso la famiglia De Renal una A Informazioni v SU RETEQUATTRO Figure 1 Example of an event with EPG information present following EPG User Manual 4 31 Sede Via dell Arcoveggio 49 5 P IVA e C F Registro imprese Bologna 02831521204 40129 Bologna Drigtalenoinaning ae i MONENG Tel 390514187531 Fax 390514173985 www avalpa com info avalpa com Avalpa Digital Engineering Srl A __ ____ 16 09 Lun 21 Feb HAMBURG DISTRETTO 21 NI 1510
29. on number 1 0x01 Last table id 78 0x4e Event Information Table EIT actual transport stream present following Event ID 1826 0x0722 Start time 0xd85d120000 2010 07 12 12 00 00 UTC Duration 0x0040000 04 00 00 UTC Running status 4 0x04 running Free CA mode 0 0x00 unscrambled Descriptors loop length 67 0x43 DVB DescriptorTag 77 0x4d short event descriptor descriptor length 59 0x3b IS0639 2 language code ita event name length 13 0x0d event name Shopping time Charset Latin alphabet text length 41 0x29 text char Consigli utili per tutti i tuoi acquisti Charset Latin alphabet DVB DescriptorTag 85 0x55 parental rating descriptor descriptor length 4 0x04 Country code ita Rating 0 0x00 undefined It is possible to verify among other things that PID is actually 18 and ONID TSID and SID are correctly reported It is also possible to verify every single data regarding a single event Event ID 1826 0x0722 Start time 0xd85d120000 2010 07 12 12 00 00 UTC Duration 0x0040000 04 00 00 UTC Di event name Shopping time Charset Latin alphabet text char Consigli utili per tutti i tuoi acquisti Charset Latin alphabet Country code ita Rating 0 0x00 undefined EPG User Manual 25 31 Avalpa Digital Engineering Srl Sede A Via dell Arcoveggio 49 5 A ital 1 P IVA e C F Registro imprese Bo
30. ption field of the event epg avalpa org cool index php action display day amp year 2011 amp month 3 amp day 1 amp we w AALP z noia zd Canale 1 Q ioil Bi February 28 Add Event Search View Control Deck View Month View Week Logout Service Admin Admin March2 View in GMT 1 March 2011 Europe Rome Time Description 12 00 to 13 00 Notizie dal mondo per rimanere sempre aggiornati Title Telegiornale Modify J Cartoni animati Modify 13 00 to 15 00 Svaghi per grandi e piccini J Film del giorno Modify 15 00 to 17 00 Avventura od emozione Regista Titolo J Rotocalco TV Modify 17 00 to 20 00 Interviste ospiti televisione cronaca gossip J Telegiornale Modify 20 00 to 21 00 Notizie dal mondo per rimanere sempre aggiornati O Film Prima Serata Modify 21 00 to 23 30 migliori film in prima serata Titolo ttt Regia rrrr Trama XXXXXXXXXXXXX Batt sei Figure 9 Day View In the last row of the table is present an option that allows with a single click to delete all the occurrences selected with the boxes on the left most column EPG User Manual 14 31 Avalpa Digital Engineering Srl Sede A Via dell Arcoveggio 49 5 Dy ital i 1 P IVA e C F Registro imprese Bologna 02831521204 40129 Bologna ae i MONENG Tel 390514187531 Fax 390514173985 www avalpa com info avalpa com Month view This view shows all the occurences of the events relative to the selected service present
31. utomatically exported and always updated into an MHP Java application MHP decoders will be able to present not only text but also graphics related to the event like event logos or movies posters into elementary stream for DVB teletext ITALIA JA ON m MEAS ann Figure 19 Example of MHP EPG EPG User Manual 28 31 Avalpa Digital Engineering Srl Sede A Via dell Arcoveggio 49 5 A ital f E P IVA e C F Registro imprese Bologna 02831521204 l 40129 Bologna s i MULINO Tel 390514187531 Fax 390514173985 www avalpa com info avalpa com Appendix B EIT Generation internals PHP scripts take care to extract event data from the DB and EIT table structure is generated for present following and scheduled events Basic schema is the following Data Entry TIMED SCRIPT DVB TRANSPORT STREAM Data entry on the DB is through web browser and Server Web interface A timed script periodically read the DB from a PHP interface and read the necessary information to generate OpenCaster input for the single EITs OpenCaster will then generate the output transport stream EPG User Manual 29 31 Avalpa Digital Engineering Srl Sede Via dell Arcoveggio 49 5 iota Aneng P IVA e C F Registro imprese Bologna 02831521204 I 40129 Bologna Tel 4390514187531 Fax 390514173985 www avalpa com info avalpa com PHP access to the DB The PHP script access the DB with the following call phpc2epg full v2 php service cid
32. vent is repeated 1 every day 2 every two days and up to which date the repetion will occur Parental Control Country Categorization Category Date 2011 v March Date 2011 Y March 1 2 Repeats Een Repeat every how many days SABA Until 2011 March v 1 Figure 12 Add repetition occurrences for an event After the event data entry is completed it can be submit for storage clicking on Submit Event the event and all the occurrences are saved in the database and will be shown in the different views Note 1 all the time and date information refers to the selected service timezone Note 2 EPG Server gives big freedom to the user to insert information and doesn t prevent events with times overlap it is up to the user a correct data entry EPG User Manual 17 31 Avalpa Digital Engineering Srl Sede A Via dell Arcoveggio 49 5 Ao tal ADD P IVA e C F Registro imprese Bologna 02831521204 I 40129 Bologna ROT 1 MOMO Tel 390514187531 Fax 390514173985 www avalpa com info avalpa com Service management From this page is possible to change the service features available fields are First day of the week Reference timezone e Name of the service e Maximum length for events titless User grants for public access e User Permissions allows to change grants and rights for every user accessing the data
Download Pdf Manuals
Related Search