Matrix10
Administrator
Direct download EPG for some providers/channels from satellite
with Mhw2epgdownloader for CrossEPG
Once again thank @sergiotas for coming to our forum
and the new version.
More about that in the Spanish section.
http://www.vuplus-community.net/boa...hw2epgdownloader-en-crossepg.4811/#post-40155
Mhw2epgdownloader
This tool allows EPG download and format for several Sat providers based on mhw1 and mhw2 protocol. It works on Linux DVBAPI systems such as the most popular Enigma1, Enigma2, MythTV… It can work like standalone binary on MythTV, Plugin for mv on E1, Plugin for E2 or embedded inside crossepg.
Internals: How it works
Mhw2epgdownloader formats the EPG using an SQLite3 data base. This database is loaded inside memory, but for analysis or study it can also be loaded to a file. To enable use of output to a file you need to activate the following variables inside the conf file (e.g. mhw2epgdownloader.conf):
After these changes and mhw2epgdownloader execution in any binary format you can access the database using any management tool for SQLite3 (e.g. SQLiteStudio).
The Data Base includes several tables:
The main tables are channels, events and summaries. A query example could be the following:
Summary of all channels downloaded, events total, first event date and last event date.
Sample query result for csdfrance:
http://team.tododream.com/mhw2epgdownloader/france_resume.txt
Embedded crossepg internals
Inside the crossepg extension you can find the mhw2epgdownloader inside /usr/crossepg/scripts/mhw2epgdownloader or /var/crossepg/scripts/mhw2epgdownloader it all depends on the image used.
The configuration files are the following: mhw1_csdfrance.conf, mhw1_csdnl.conf, mhw1_cyfra.conf and mhw2_dplus.conf.
Each channel is defined by service:transponder:net. Inside any Enigma2 image you can find the information for each channel selecting:
Menu -> Info -> Channel -> PIDS
Sometimes the EPG info does not download in the correct format. There are three different cases this downloaded info:
1) The EPG info for one channel downloads Ok.
2) The EPG info for one channels does not exist but there is that information inside another clon channel.
e.g. France channel TF1 HD there is no EPG but regular TF1 channel does include the EPG info.
As this channel is from csdfrance we need to add one line inside the configuration file mhw1_csdfrance.conf
3) The EPG info for one channels comes incorrectly inside the service:transponder:net format.
e.g. Spain channel C+ LIGA HD comes with the incorrect information as it is joined inside a promotional channel so we need to add the following line to the config file mhw2_dplus.conf
We can verify that one channels comes with the incorrect format if the parameters service, transponder and network inside the downloaded database does not match the correct channel.
expecial thanks to tinos for translation
with Mhw2epgdownloader for CrossEPG
Once again thank @sergiotas for coming to our forum
and the new version.
More about that in the Spanish section.
http://www.vuplus-community.net/boa...hw2epgdownloader-en-crossepg.4811/#post-40155
Mhw2epgdownloader
This tool allows EPG download and format for several Sat providers based on mhw1 and mhw2 protocol. It works on Linux DVBAPI systems such as the most popular Enigma1, Enigma2, MythTV… It can work like standalone binary on MythTV, Plugin for mv on E1, Plugin for E2 or embedded inside crossepg.
Internals: How it works
Mhw2epgdownloader formats the EPG using an SQLite3 data base. This database is loaded inside memory, but for analysis or study it can also be loaded to a file. To enable use of output to a file you need to activate the following variables inside the conf file (e.g. mhw2epgdownloader.conf):
Code:
dbinmemory = 0
dbfile = /tmp/mhw2epg.db
The Data Base includes several tables:
Code:
Channels
Channels_copy
Events
Settings
Summaries
Themes
Summary of all channels downloaded, events total, first event date and last event date.
Code:
SELECT c.channel_id, c.channel, c.network, c.transponder, c.service,
(SELECT count(event_id) FROM events e WHERE e.channel_id=c.channel_id) as totalevents,
(SELECT dateev FROM events e WHERE e.channel_id=c.channel_id ORDER BY dateev ASC LIMIT 1) as first_event,
(SELECT dateev FROM events e WHERE e.channel_id=c.channel_id ORDER BY dateev DESC LIMIT 1) as last_event
FROM channels AS c;
Sample query result for csdfrance:
http://team.tododream.com/mhw2epgdownloader/france_resume.txt
Embedded crossepg internals
Inside the crossepg extension you can find the mhw2epgdownloader inside /usr/crossepg/scripts/mhw2epgdownloader or /var/crossepg/scripts/mhw2epgdownloader it all depends on the image used.
The configuration files are the following: mhw1_csdfrance.conf, mhw1_csdnl.conf, mhw1_cyfra.conf and mhw2_dplus.conf.
Each channel is defined by service:transponder:net. Inside any Enigma2 image you can find the information for each channel selecting:
Menu -> Info -> Channel -> PIDS
Code:
SID: Service
TSID: Transponder
ONID: Net
1) The EPG info for one channel downloads Ok.
2) The EPG info for one channels does not exist but there is that information inside another clon channel.
e.g. France channel TF1 HD there is no EPG but regular TF1 channel does include the EPG info.
As this channel is from csdfrance we need to add one line inside the configuration file mhw1_csdfrance.conf
Code:
channel copy = 20AE:432:1:TF1 -> 2329:0442:1:TF1 HD
3) The EPG info for one channels comes incorrectly inside the service:transponder:net format.
e.g. Spain channel C+ LIGA HD comes with the incorrect information as it is joined inside a promotional channel so we need to add the following line to the config file mhw2_dplus.conf
Code:
channel replace = 7611:408:1:C+LIGA HD -> 7852:0:0:C+LIGA HD
expecial thanks to tinos for translation