4 replies to this topic

[kleinlappies]

hi, i am looking for some help or a bump in the right direction, pls
i have been reading around but just can't seem to get the nack of it.

im from south africa and on dstv. i have my dreambox 500s x4 / 600pvr x1 setup with jade pli
i have the the fllowing plugins installed
mv plugin
sqlite epg import plugin
xmltv epgimport rytec plugin
e1 multiview 2.5.3
e1 rytec package
e1 rytec package dat files

i have the sqllite selected under the epg setting under the main settings.

I am not looking for a hand out and i am quite willing the read more but i would just like to know what i should do eg.

i have the site / link for our dstv xml tv channels guide
(http://zaxmltv.flash.za.org/)

I just need to find out how to and where to onto the boxes the file should go and or script to wget of something from the site.
my /var and /hdd are network shares so no worries there.

please, anyone with a litte help would be much appreciated

[Janeway]

I have created a shell script to import the DStv EPG into the SQLite EPG database. It's quite crude but it does the job. Let me know if you're interested and I'll post it here.

[doglover]

Pls. Post it or send it to me via PM.

Thanks in advance.

Willy

[Janeway]

I was able to import the EPG using db_epg and the XMLTV files downloaded from ZAXMLTV. The website has the files for 14 days only. Downloading files for all the channels would make the database too big so I wrote the script to download files for the channels that we frequently watch. You can change these channels to your liking. I've also broken the downloading into channel groups to make it easier to understand when downloading and editing.

There are two files that are required. One is the script file and the other is the map file. I copied the script file to /usr/bin/ and I copied the map file to the sqlite database directory, /media/server1/. You must change the directories in the script to suit your setup. This is my second shell script in linux (my first script was only 1 line) so it is not very good but it does work :-). I hope it helps you.

The script file, zaxmltv.sh:

#/bin/sh														

clear
rm zaxmltv.xml
echo
echo DStv Channel 101, 103, 104, 105, 106, 108, 109, 110
echo ---------------------------------------------------
cd /media/server1/
wget -O zaxmltv.xml.gz "http://zaxmltv.flash.za.org/schedule/zaxmltv_get.php?download=on&chanlist[]=101&chanlist[]=103&chanlist[]=104&chanlist[]=105&chanlist[]=106&chanlist[]=108&chanlist[]=109&chanlist[]=110"
gzip -d zaxmltv.xml.gz
db_epg -t xmltv -d epg.db -f zaxmltv.xml -m zaxmltv.map
rm zaxmltv.xml

echo
echo DStv Channel 113, 120
echo ---------------------
wget -O zaxmltv.xml.gz "http://zaxmltv.flash.za.org/schedule/zaxmltv_get.php?download=on&chanlist[]=113&chanlist[]=120"
gzip -d zaxmltv.xml.gz
db_epg -t xmltv -d epg.db -f zaxmltv.xml -m zaxmltv.map
rm zaxmltv.xml

echo
echo DStv Channel 121, 125, 126
echo --------------------------
wget -O zaxmltv.xml.gz "http://zaxmltv.flash.za.org/schedule/zaxmltv_get.php?download=on&chanlist[]=121&chanlist[]=125&chanlist[]=126"
gzip -d zaxmltv.xml.gz
db_epg -t xmltv -d epg.db -f zaxmltv.xml -m zaxmltv.map
rm zaxmltv.xml

echo
echo DStv Channel 131, 132, 133, 134
echo -------------------------------
wget -O zaxmltv.xml.gz "http://zaxmltv.flash.za.org/schedule/zaxmltv_get.php?download=on&chanlist[]=131&chanlist[]=132&chanlist[]=133&chanlist[]=134"
gzip -d zaxmltv.xml.gz
db_epg -t xmltv -d epg.db -f zaxmltv.xml -m zaxmltv.map
rm zaxmltv.xml

echo
echo DStv Channel 180, 181, 182, 183
echo -------------------------------
wget -O zaxmltv.xml.gz "http://zaxmltv.flash.za.org/schedule/zaxmltv_get.php?download=on&chanlist[]=180&chanlist[]=181&chanlist[]=182&chanlist[]=183"
gzip -d zaxmltv.xml.gz
db_epg -t xmltv -d epg.db -f zaxmltv.xml -m zaxmltv.map
rm zaxmltv.xml

echo
echo DStv Channel 250, 251, 253, 255, 260, 261, 264
echo ----------------------------------------------
wget -O zaxmltv.xml.gz "http://zaxmltv.flash.za.org/schedule/zaxmltv_get.php?download=on&chanlist[]=250&chanlist[]=251&chanlist[]=254&chanlist[]=255&chanlist[]=260&chanlist[]=261&chanlist[]=264"
gzip -d zaxmltv.xml.gz
db_epg -t xmltv -d epg.db -f zaxmltv.xml -m zaxmltv.map
rm zaxmltv.xml

echo
echo DStv Channel 301, 302, 303, 305
echo -------------------------------
wget -O zaxmltv.xml.gz "http://zaxmltv.flash.za.org/schedule/zaxmltv_get.php?download=on&chanlist[]=301&chanlist[]=302&chanlist[]=303&chanlist[]=305"
gzip -d zaxmltv.xml.gz
db_epg -t xmltv -d epg.db -f zaxmltv.xml -m zaxmltv.map
rm zaxmltv.xml

echo
echo DStv Channel 306, 308, 323
echo --------------------------
wget -O zaxmltv.xml.gz "http://zaxmltv.flash.za.org/schedule/zaxmltv_get.php?download=on&chanlist[]=306&chanlist[]=307&chanlist[]=308&chanlist[]=319&chanlist[]=323"
gzip -d zaxmltv.xml.gz
db_epg -t xmltv -d epg.db -f zaxmltv.xml -m zaxmltv.map
rm zaxmltv.xml

The map file, zaxmltv.map:

6e:1800:14=101.dstv.com
78:1800:14=103.dstv.com
136:1800:3=104.dstv.com
15e:1800:3=105.dstv.com
17c:1800:3=106.dstv.com
9b:1800:14=107.dstv.com
a0:1800:14=108.dstv.com
1af:1800:4=109.dstv.com
96:1800:14=110.dstv.com
fb:1800:2=111.dstv.com
3fc:1800:a=112.dstv.com
1c2:1800:4=113.dstv.com
12b:1800:2=114.dstv.com
38a:1800:88=115.dstv.com
46a:1800:b=120.dstv.com
b4:1800:14=121.dstv.com
24e:1800:5=123.dstv.com
870:1800:15=124.dstv.com
226:1800:5=125.dstv.com
7c1:1800:13=126.dstv.com
654:1800:10=131.dstv.com
65e:1800:10=132.dstv.com
668:1800:10=133.dstv.com
183:1800:3=134.dstv.com
460:1800:b=180.dstv.com
1ed:1800:4=181.dstv.com
12a:1800:2=182.dstv.com
84d:1800:15=183.dstv.com
82:1800:14=201.dstv.com
8c:1800:14=202.dstv.com
148:1800:3=203.dstv.com
42e:1800:a=204.dstv.com
be:1800:14=205.dstv.com
118:1800:2=206.dstv.com
11e:1800:2=207.dstv.com
91:1800:14=208.dstv.com
1a4:1800:4=230.dstv.com
456:1800:b=231.dstv.com
4a6:1800:b=250.dstv.com
474:1800:b=251.dstv.com
24f:1800:5=254.dstv.com
83e:1800:15=255.dstv.com
208:1800:5=260.dstv.com
442:1800:a=261.dstv.com
384:1800:88=264.dstv.com
1e0:1800:4=301.dstv.com
244:1800:5=302.dstv.com
1a9:1800:4=303.dstv.com
47e:1800:b=305.dstv.com
488:1800:b=306.dstv.com
21c:1800:5=307.dstv.com
780:1800:13=308.dstv.com
cb:0049:1=319.dstv.com
c3:1800:14=320.dstv.com
1ae:1800:4=321.dstv.com
1f1:1800:4=322.dstv.com
1d1:1800:4=323.dstv.com
69a:1800:10=324.dstv.com
186:1800:3=325.dstv.com
2f12:1800:c=326.dstv.com
406:1800:a=331.dstv.com
70:1800:88=341.dstv.com
125:1800:2=342.dstv.com
1b8:1800:4=400.dstv.com
104:1800:2=401.dstv.com
128:1800:2=402.dstv.com
438:1800:a=403.dstv.com
127:1800:2=404.dstv.com
410:1800:a=406.dstv.com
149:1800:3=408.dstv.com
848:1800:15=410.dstv.com
1d6:1800:4=411.dstv.com
230:1800:5=412.dstv.com
7b7:1800:13=431.dstv.com
b8:1800:88=447.dstv.com
b9:1800:88=448.dstv.com
245:1800:5=607.dstv.com

[kleinlappies]

thanks!