dbepg


Wiki source for dbepg


Show raw source

=====SQLite EPG Database manual entry with db_epg=====

db_epg is a add-on available on the PPanels to enable users to enter EPG into the SQLite EPG store from external sources.

First you need to enable EPG to use the SQLite EPG store via [[E1SystemEPG EPG Setup]] and change the EPG store to SQLite from Enigma EPG.

Then you will need to import a XMLTV file into the EPG.

The command line options for db_epg are:

Main db_epg commands:

-d, --database <file> :location of database
-t, --type <type> :type of reader to use (available types are listed below)

Using XMLTV you use the following extra commands:

-f, --file <file> :xmltv file to convert
-l, --lang <code> :language code (according to ISO 639-2)
-h, --hours <hours> :number of hours to store (default 0: no limit)
-o, --offset <offset> :time offset in seconds (defaults to 0)
-p, --provider <provider> :start of provider name
-m, --map <file> :file with service references for each channel
-g, --genre <file> :file with a list of genre strings (format <genre tring>,<value>[,min duration])
--matchname :if enabled, tries to match unknown channelnames with entries in database
-e, --export :append mapfile with all unknown channels
-c, --cp <num> :iso8859 codepage, defaults to 0

The format of the "-m" map file is:

PID:PROVIDER:TRANSPONDER=XMLTVChannelID

IE, from /var/tuxbox/config/enigma/services

----
services
**0065**:ffff0000:**0001**:**00b6**:1:210
TTT
p:T

Or

**SID**:**NAMESPACE**:**TSID**:**ONID**:**TYPE**:**PROGNUMBER**
**Program Name**
**Extra SIDs** for Teletext, extra audio etc
----

Plus you will need to find the channel names from your XMLTV file:

----
<programme channel="**channelname**" start="20080928070000 +1300" stop="20080928070500 +1300">
<title lang="eng">program title</title>
<desc>program desc.</desc>
<category>tvshow</category>
</programme>
----

From the above example you would create the map file as:

----
65:b6:1=channelname

or

**SID**:**ONID**:**TSID**=**XMLTV Channel**
----

The only extra thing you do is remove the leading zero's from the details in the Services file.

So an example command line would be:

db_epg -t xmltv -d /media/hdd/epg.db -f xmltvfile.xml -o 0 -m xmltvmap.dat -e -c 1

This will update the epg.db in /media/hdd which is the default location for your SQLite EPG file, then -f for the xmltvfile.xml to import, and -m to specify the map file you just created.
Valid XHTML :: Valid CSS: :: Powered by WikkaWiki