Thread: PLI - Oztivo SQLITE EPG Plugin Script *NEW*

Ok here is an updated script 17/06/2008 which will satisfy the new oztivo requirements ( see here )


Previous versions of this script and discussions were here..


WHATS NEW
*********
- New oztivo web site - now (minnie.tuhs.org shuts down xmltv 30 June)
- Introduced local server for multiple dreamboxes - one dm can download from oztivo - other local boxes can get from that one
- Errors on some channels fixed - coding upgrade
- Ppanel for access to some information - info only - check out blue button/installed ppanels /oztivo
- debug messages upgraded - debug=3 is about right for me but debug=0 is silent and debug=5 talks more than vossy at the footy
**********
I have tested using CIFS on external mount for dm5620 and a dm600 to a 7000 smb server
also for internal usb or hard drive on DM7000
Other users have reported it works on NFS to linux box and CIFS to Winxp.

The prerequisites are
1. pli image (helenite or later - preferably iolite)
2. epg set to sqlite under settings
3. sqllite epg plugin downloaded

Warning ** will overwrite earlier version ***
If you have an earlier version and want to keep your channel mapping file (/var/tuxbox/config/dbepg/oztivo_au.dat)
- make sure you save a copy of yours and put it back after install because this will overwrite it.

Warning ** will overwrite earlier version ***
Install will overwrite your last configs (oztivo_au.txt and oztivo_au.cfg)
If you dont need the local server stuff then your previous config will be ok
But remember to change oztivo web address for new site

To Install
Attached file should go in your dbox /tmp directory and then manual install.

After install oztivo_au then make changes to

/var/tuxbox/config/dbepg/oztivo_au.txt - config for my script - must be unix format (dos2unix if needed)
- put your oztivo user name and password on line indicated must be

Code:

UserName:password

- if necessary change your cache directory to suit - script will create it eg /var/epgcache mine goes on my usb stick /media/usb/epgcache

****************************************
***NEW******
LOCAL SERVER FOR MULTIPLE DREAMBOXES LOCAL CLIENTS****
- if you want a local server for other dreamboxes set these in your oztivo_au.txt on local server which connects to oztivo
- set server=Y and set serverdir (eg serverdir=/media/usb/epgserver) on local server which connects to oztivo
- if you have previously installed and run oztivo_au it would pay to clean out your epgcache directory to start server immediately

Code:

protocol=http://
user=UserName:password
www=www.oztivo.net/xmltv/
server=Y
serverdir=/media/usb/epgserver

- on local clients which connect to local server you need to change a few lines in oztivo_au.xt on client
- (eg to match server example above on ip 192.168.1.1)

Code:

protocol=ftp://
user=root:dreambox
www=192.168.1.1/media/usb/epgserver/ 
server=N
serverdir=notused

***NEW******
*****************************************

/var/tuxbox/config/dbepg/oztivo_au.cfg - plugin config file
- leave offset at 0 if timezone is right on your box
- check your epg.db location directory - the plugin sets this if you go to that screen and hit DONE (blue)
- change number of days (oztivo is good for 3 - but up to 6 or 7 on some channels)

/var/tuxbox/config/dbepg/oztivo_au.dat - channel mapping file - my mappings
(if you have issues, you could copy your existing channel mapping file oztivo_au.dat)
(if you still have issues, empty the file and let the script add the channels to it again)
(once they are added you will need to map channels and run script again to download)

remember oztivo username and password are case sensitive
chmod 755 /var/bin/oztivo_au.sh (in case I forgot when I made tar.gz)

epg location can be found under webif/boxcontrol/settings down the bottom under EPG cache path (see SQLIte store)

I still recommend running this from telnet
Quote:
cd /var/bin
./oztivo_au.sh
then watch the output
first run will add a bunch of channels if you had an empty channels file

if it works there test it with using yellow button / sqlite epg plugin
if it works there - then setup to use cron - middle of the night

As mentioned I have included a channel mapping file - although I dont know how personal these are - like whether they are tied to my bouquets or not.
your mileage may vary here. If it dont work - clean out the oztivo_au.dat to an empty file - it must exist

What does the script do you ask ?
1. read my custom config /var/tuxbox/config/dbepg/oztivo_au.txt
2. read plugin config /var/tuxbox/config/dbepg/oztivo_au.cfg
3. if the epgcache directory does not exist it creates it
4. if the epgcache does exist - it cleans out old dated files so it is always current
5. if this machine is a server (server=y)and the epgserver directory does not exist it creates it
6. if server and the epgserver does exist - it cleans out old dated files so it is always current
7. it gets datalist.xml.gz from server(oztivo) and gunzips it
8. it creates a temporary file with no spaces from that data
9. it then reads that temp file line by line
10. for each channel it checks your channel file (oztivo_au.dat)
11. if the channel is not in your file it adds it to that file if learnchnls=Y and sets it to UNKNOWN (learnas value)
12. if the channel is in your file and is not mapped it ignores that channel
13. if the channel is in your file and is mapped it looks for data for that channel (still in datalist.xml.gz)
14. if it finds data is available for a date
- if that date is in the past it is ignored
- if that date is further forward than you want (days in oztivo_au.cfg) it is ignored
- if the date is between today up to $days ahead AND you dont have the data OR it has been modified it gets the data for you
15. if it gets the data it downloads the channel date file (wget) gunzips it and then db_epg adds the data to your epg
16. it then deletes the downloaded file (cleanup=Y)
17. it writes an empty file to your epgcache directory in the format datafordate_channel_modified
18. it reads through the whole temporary file and then deletes it at the end

Something like that anyway - Its http caching from the unix shell

Happy to hear feedback
New plugin is here