TV Server Plugin: TvWishList (5 Viewers)

[D3ltoroxp]

AW: TV Server Plugin: TvWishList

Oh nice to know I had something already introduced !

So still time to my problem. I changed nothing since then last post, but i have only disable the checkbox "Skip episode" and yesterday he had then found Upps!.

So now comes Upps! also on RTL is because I simply create a new search select the same as in SRTL and hold back only RTL ? Or are the problems if I have understood here correctly?

 

[mcl]

AW: TV Server Plugin: TvWishList

ok, i think i'll try your plugin these days. the main reason for me for using this is to avaid unnecessary recordings. ie i scheduled "csi" wednesdays with "every week at this time". but for the last 2 weeks rtl decided to broadcast the german verion of "i'm a celebrity get me outta here" at this time. so not only that i don't have any new episodes of csi, i now have recordings of the worst garbage on television
in other situations i have programs that are aired every ie sunday around 22:30. sometimes at 22:25, then at 22:35 and so on. mostly mp then records the program before 22:30 and after.

i think with the time filters delivered by your plugin i should be able to avoid those things. the only problem i see really is this csi thing. because there are 3 different types of csi ("den tätern auf der spur", "ny" and "miami") on 2 different stations. and in my epg are entries like "c.s.i. ....", "c s i ....", "csi ...." and sometimes with a "-" between csi and ie miami and sometimes not. so scheduling something like partial "i - miami" wouldn't find "csi miami". but only scheduling "miami" would find too many wrong results. same for "ny" (sometimes called "new york") and "den tätern auf der spur".
that's the reason why i would actually need something like "c%s%i%den tätern auf der spur", "c%s%i%ny", "c%s%i%newyork" and "c%s%i%miami". the only workaround i can image at the moment would be to create entries for all possible combinations and i guess that's what i'm gonna try this weekend

 

[porky996t]

mcl said:

"i'm a celebrity get me outta here" ........ ... i now have recordings of the worst garbage on television

Good to see I'm not alone with my thoughts... you made my day with that one!

 

[huha]

Prerelease of version 1.2.0.6

I am doing a prerelease of 1.2.0.6, which includes now SQL queries and will open a new dimension on flexibility usage and processing speed. You can now specify any queries for title, description, genre, ..... whatever is specified in the program database and supported by your EPG. To find that out just do a simple search with partial title and look at the result in the log file or your email as it will list all program attributes which can be used. Please note that channelname or groupname cannot be used as they do not belong to the program structure in mediaportal. But they are implemented in the advanced filter section of the plugin.

You have to set "MatchType" to expression and then enter the SQL expression in "SearchFor"

Please post if you have new cool ideas how to use the expression feature

Attached a copy from the manual

Match Type
The match type can be „exact“ , „partial“ or “word” if applied to a program title. If „exact“ is
selected the program name in the EPG data must be exactly the same as the name specified in the
„Search for“ textbox. In case of partial selection the EPG data must contain the specified phrase.
Please note that for both options the Search for text is not case sensitive. This option is used only
for the program title, but never for the program description, which always implies a „partial“
setting. For “Word in Title”, “Word in text” or “Word in Title/Text” the plugin assumes that a user
has specified an exact word as a search criteria. This means the title/text must contain exactly this
word with a space before and after the matched text. Alternatively the matched text can be at the
beginning or end of the program title or description. If “expression” is chosen for match type the
user can specify a SQL query in “Search For”. This enables great flexibility as the following
examples are showing:
Example1:
(title like '%James Bond%' ) AND ( (description like '%007%') OR (description like '%geheimagent
%' ) )
This will match James Bond in the program title only if at the same time either 007 or geheimagent
is found in the text description of the program
Example 2:
(title like '%Star Wars%' ) AND ( title not like '%clone wars%' )
This will search for a partial title Star wars only if the title does not contain clone wars
Example 3:
(starrating ='***')
This will search for all programs rated with *** if your EPG data do include Starrating.
Besides title and description you can also use the following search criteria:
classification, starttime, endtime, originalairdate, episodename, episodenum, episodenumber,
episodepart, genre, parentalrating, seriesnum, starrating
Please note that sql expressions are not case sensitive.
The following operators are supported from SQL:
= Equal
<> Not equal
> Greater than
< Less than
>= Greater than or equal
<= Less than or equal
BETWEEN Between an inclusive range
LIKE Search for a pattern
NOT LIKE Search for an excluding pattern
IN If you know the exact value you want to return for at
least one of the columns
The pattern must be enclosed by ' at the begin and at the end of the pattern expression. The following
wildcard characters are supported in SQL syntax:
% A substitute for zero or more characters
_ A substitute for exactly one character
[charlist] Any single character in charlist
[^charlist] or [!charlist] Any single character not in charlist

Update for SQL experts:
I have implemented the SQL query in the form:
select * from Program where expression_from_search_for_string

Update:deleted attached file as you can find it now on the first page

 

[huha]

I have now released 1.2.0.6. There were no updates to the prerelease. I just want to mention one more item:
If you do a SQL query for dates (e.g. starttime or endtime) you must use your national date format of your SQL data base.
To find that out check "verbose debug" in settings, choose any partial title and click "Search Now" in the email settings. Then you can look in the tvserver log file tv.log for "SQL query for:" and you will find a line like
SQL query for: (EndTime >= '2011-02-12 12:48:06') AND ( title like '%test%' )
showing your actual SQL date format.

 

[vurtua1]

Hi everyone. Call me stupid, but having searched this thread for "email" I can't find any information on what to include on the email tab in TV Config>Plugins>TvWishList settings. I assume the email receiver address is where you want notifications sent to, but what needs to go in the "Account" box?



EDIT: and the SMTP section, sorry!

 

[huha]

vurtua1, click on main on the help button. it will open the .pdf manual, which should answer all your questions.

 

[mcl]

AW: TV Server Plugin: TvWishList

hi,

i have 2 questions about your plugin:

1. in your manual your say "please note that overlapping schedules in time will not be recorded independent of the number of tv cards". is this only for programs with the same title to avoid double recordings if the airtime has changed. or does that mean that i can't schedule any recordings that are overlapping in time. for example if "criminal minds" start at 20:15 till 21:15 and "dsds" starts at the same time on another chanel. will it records both programs or only one? i have 2 tv cards.

2. to avoid repeated episodes of tv series you say that your plugin compares the title and the description. i often don't habe any description in the repeated episode. couldn't you just compare title and episode title?

btw what i would really love was a webinterface to add new programs from my laptop and to display an overview of the schedules

 

[olli14]

Hi everyone. Call me stupid, but having searched this thread for "email" I can't find any information on what to include on the email tab in TV Config>Plugins>TvWishList settings. I assume the email receiver address is where you want notifications sent to, but what needs to go in the "Account" box?



EDIT: and the SMTP section, sorry!

I have the same question. What is the email address in the account box for? The PDF says nothing about this.

 

[huha]

mcl, let me first start with your questions.
1) It should record both schedules if they are on different channels if you have sufficient tv cards

2) this is something i can put on my todo list for future versions - not working right now

I am using teamviewer as a web interface to my htpc. It works great (on LAN or Internet). Check my posting under emailscheduler. Google for teamviewer

olli14,
the emailaddress is used if the account user name is different than your email address. In most cases they are the same and you can leave email address blank. There were some users, which needed a separate field as their username was different to their emailaddress. Looks like i need to update the manual here.