Tuesday, August 17, 2010

new designs are on the way......

I recently discovered the iWebKit library. It's basically CSS styles to simulate a native iPhone app with a web-app. I must says it is very useful and so i'm preparing a new version of my web-interface. Here is a first preview to the start-page !

Wednesday, August 11, 2010

BongParser Download

You can download BongParser.exe here.

First of all the MySQL-Database must exist. Therefore i would recommend to create and configure the database first. The SQL script can be downloaded here:
For database installations instructions please look here and the Synology website downloads.
BongParser.exe is configured with the settings-file BongParser.exe.config which is located in the same directory than BongParser.exe. The following settings can be adjusted to your personal requirements.

this is the url, where bong.tv publishes existing recordings. This should not be changed, except bong.tv changes there API.
example: http://www.bong.tv/ajax2/api/recordings.xml
please enter you login. This must be configured correctly, otherwise BongParser will fail !
example: user4711
please enter you password. This must be configured right, otherwise BongParser will fail !
example: password4711
this will be the path, where the video files are downloaded. please keep in mind, that this must be a local linux path, which has not drive-letters etc. Synology puts user created directories always under /volume1, so if you create a folder 'video' with the disk station manager, the path would be '/volume1/video/'. 
example: volume1/Video/bong/
either NQ or HQ (i always use HQ)
example: HQ
this is the connection string for the mysql-database.please make sure to create a user with sufficient rights for the table.
example: server=localhost;user=remote;database=bong.tv;port=3306;password=bong2010;
with that variable, you can control the filename of the downloaded video-file. the original names are unusable and have your name included. In the moment title, ID, Channel and Date can be inserted. you can change the order or leave out one of the fields, but {fieldname} must be complete and exactly written.
example:  {Title} - ({ID}) - {Channel} - {Date}
not every character in the title or other fields is a valid windows or unix char. this string must consist of all chars, which must be removed from the filename. as this settings file is an xml not all chars are allowed and must be exchanged by the xml-value. my tip: do not change if possible.
example: \/*?"<>|:
this is the path, where the applications writes a logfile. again it is a local linux path and should not have a driveletter etc. if you use this app on windows you can use driveletters.
example: /volume1/Video/bong/parser.log

You can edit the config-file with an editor that is able to write unix compatible text files (LF only). I can recommend EditPad Lite, which is free and is able to convert between windows and unix formats.
Note: To run the exe under linux, the execute flag must be set with chmod.

Friday, August 6, 2010

iPhone/ Browser Interface

This article decribes the browser based interface for the bong.tv download automation. Each video on my DS209 storage, has a corresponding entry in the MySQL database and so it is easy to display the contents of my DS209-box from any connected webbrowser. The interface is written in PHP and consists of several views/pages. I have designed them for using it on my iPhone, so the width is limited to the width of the iPhone.

1. The Status View

when called directly it shows the whole content of the database. By default it sorts for the 'broadcast-date' , newest first. The columns show Title, Duration, Channel, BroadcastDate and the Status. In this picture you can see, that all videos are allready downloaded, except 'Die dreisten Drei', which is waiting to be downloaded. With a click on the video's title the app shows the 'Details View'. 

2. The Details View

The Details View shows all relevant information about a single entry. For about 30% of all videos Bong.TV delivers a picture from the movie. The rest has a default picture with a TV-Logo.  A click
onto the picture opens up the default-player and the video is streamed via http from the DS209. To enable this, i have mounted the bong directly under the 'web'-directory as only the web directory (and subdirectories) is accessible via http (by default apache configuration).

3. The Search View

The Search window allows a search on Title, Description and can select for Time-Ranges, Categories and TV-channels. It simply calls the status-page,and than the search expression via http-post) generates a filtered search in the status view.

The Status Page


The Details View

The Search View