MyTVSeries - Plugin that organizes TV Video Files (2 Viewers)

[strontium]

Not much in the log so I have put it below:

01/02/2006 08:00:51 - *******************************************************
01/02/2006 08:12:08 - Sucessfully opened database 'C:\Program Files\Team MediaPortal\MediaPortal\Database\SeriesDatabase.db3'.
01/02/2006 08:12:14 - Sucessfully opened database 'C:\Program Files\Team MediaPortal\MediaPortal\Database\SeriesDatabase.db3'.
01/02/2006 08:12:14 - ******************************************************

anything else that might be helpful?
I have also added the error log below:

01/02/2006 08:12:08 SQLeriesDatabase.db3 cmd:sqlite3_prepare16vm=null err:ERROR detailed:table path already exists query:CREATE TABLE path (path_id integer primary key, path text);

01/02/2006 08:12:08 SQLeriesDatabase.db3 cmd:sqlite3_prepare16vm=null err:ERROR detailed:table series already exists query:CREATE TABLE series (series_id integer primary key, name text, premiered text, airs text, status text, duration text, network text, description text, image_url text, summary_url text);

01/02/2006 08:12:08 SQLeriesDatabase.db3 cmd:sqlite3_prepare16vm=null err:ERROR detailed:table episode already exists query:CREATE TABLE episode (episode_id integer primary key, season_id int, title text, aired text, episode_number integer, filename text, description text, image_url text, summary_url text);

01/02/2006 08:12:08 SQLeriesDatabase.db3 cmd:sqlite3_prepare16vm=null err:ERROR detailed:table season already exists query:CREATE TABLE season (season_id integer primary key, series_id int, name text, season_number integer, description text, image_url text);

01/02/2006 08:12:08 SQLeriesDatabase.db3 cmd:sqlite3_prepare16vm=null err:ERROR detailed:table genre already exists query:CREATE TABLE genre (genre_id integer primary key, name text);

01/02/2006 08:12:08 SQLeriesDatabase.db3 cmd:sqlite3_prepare16vm=null err:ERROR detailed:table genre_series_link already exists query:CREATE TABLE genre_series_link (link_id integer primary key, genre_id int, series_id int);

01/02/2006 08:12:08 SQLeriesDatabase.db3 cmd:sqlite3_prepare16vm=null err:ERROR detailed:table actor already exists query:CREATE TABLE actor (actor_id integer primary key, name text, character text);

01/02/2006 08:12:08 SQLeriesDatabase.db3 cmd:sqlite3_prepare16vm=null err:ERROR detailed:table actor_episode_link already exists query:CREATE TABLE actor_episode_link (link_id integer primary key, actor_id int, episode_id integer);

01/02/2006 08:12:08 SQLeriesDatabase.db3 cmd:sqlite3_prepare16vm=null err:ERROR detailed:table replacementstring already exists query:CREATE TABLE replacementstring (replacementstring_id integer primary key, search text, replace text);

01/02/2006 08:12:08 SQLeriesDatabase.db3 cmd:sqlite3_prepare16vm=null err:ERROR detailed:table pattern already exists query:CREATE TABLE pattern (pattern_id integer primary key, pattern text);

01/02/2006 08:12:13 SQLeriesDatabase.db3 cmd:sqlite3_prepare16vm=null err:ERROR detailed:table path already exists query:CREATE TABLE path (path_id integer primary key, path text);

01/02/2006 08:12:13 SQLeriesDatabase.db3 cmd:sqlite3_prepare16vm=null err:ERROR detailed:table series already exists query:CREATE TABLE series (series_id integer primary key, name text, premiered text, airs text, status text, duration text, network text, description text, image_url text, summary_url text);

01/02/2006 08:12:13 SQLeriesDatabase.db3 cmd:sqlite3_prepare16vm=null err:ERROR detailed:table episode already exists query:CREATE TABLE episode (episode_id integer primary key, season_id int, title text, aired text, episode_number integer, filename text, description text, image_url text, summary_url text);

01/02/2006 08:12:14 SQLeriesDatabase.db3 cmd:sqlite3_prepare16vm=null err:ERROR detailed:table season already exists query:CREATE TABLE season (season_id integer primary key, series_id int, name text, season_number integer, description text, image_url text);

01/02/2006 08:12:14 SQLeriesDatabase.db3 cmd:sqlite3_prepare16vm=null err:ERROR detailed:table genre already exists query:CREATE TABLE genre (genre_id integer primary key, name text);

01/02/2006 08:12:14 SQLeriesDatabase.db3 cmd:sqlite3_prepare16vm=null err:ERROR detailed:table genre_series_link already exists query:CREATE TABLE genre_series_link (link_id integer primary key, genre_id int, series_id int);

01/02/2006 08:12:14 SQLeriesDatabase.db3 cmd:sqlite3_prepare16vm=null err:ERROR detailed:table actor already exists query:CREATE TABLE actor (actor_id integer primary key, name text, character text);

01/02/2006 08:12:14 SQLeriesDatabase.db3 cmd:sqlite3_prepare16vm=null err:ERROR detailed:table actor_episode_link already exists query:CREATE TABLE actor_episode_link (link_id integer primary key, actor_id int, episode_id integer);

01/02/2006 08:12:14 SQLeriesDatabase.db3 cmd:sqlite3_prepare16vm=null err:ERROR detailed:table replacementstring already exists query:CREATE TABLE replacementstring (replacementstring_id integer primary key, search text, replace text);

01/02/2006 08:12:14 SQLeriesDatabase.db3 cmd:sqlite3_prepare16vm=null err:ERROR detailed:table pattern already exists query:CREATE TABLE pattern (pattern_id integer primary key, pattern text);

 

[strontium]

I do not know what happened.
I added a folder and went to test and it failed again.
Went back into setup and it imported the folder correctly. I have now been able to add the folders without any more problems.

 

[WeeToddDid]

I do not know what happened.
I added a folder and went to test and it failed again.
Went back into setup and it imported the folder correctly. I have now been able to add the folders without any more problems.

I think i might know what the issue is. Try open media portal, keep it open, and then go into the setup. I bet it will fail. I never took into consideration that both would be open. Let me know

 

[strontium]

It still worked ok when I had mediaportal minimised. Oh well it appears to be working fine now. So I don't know what the problem could be :?

 

[WeeToddDid]

It still worked ok when I had mediaportal minimised. Oh well it appears to be working fine now. So I don't know what the problem could be :?

I did change the database in version 0.14a. Maybe there was an issue with the table structure. In any case, please let me know if it re-occurs.

Thanks for letting me know.... :wink:

 

[WeeToddDid]

I have posted new source codes and binary files here

The plugin can now lookup images from the internet (amazon & google). Although, I find this feature clumsy, its still better than a kick in the ass.

I left a bug in the code in this version. It will occur when trying to download an image from the Internet using a specific URL. The error will state that their is not enough space. if anyone gets this error, please send me the URL of the image. I will get rid of this issue in the next release.


I have finally started working on the Media Portal side of this plugin. I am playing around with the layout and I need your input :idea: :idea: :idea:

Here are your options:

1. Use the standard menu system with a list of series/seasons/episodes (like the last version). I would enhance it by implementing the info screen - activated when pressing the info button on the remote.

2. Combining the menu and info screens together. Here is a screenshot of the prototype.

In any case, i would enable each item in the list view to have its own menu - activated when pressing the menu button on the remote. this will contains things like (re-download info, play, delete, etc)


Let me know[/url]

 

[Inker]

Weetod,

One thing about images. Did you take into consideration my suggestion for allowing the use of url's with placeholders such as www.myurl.com/[seriesname]/images/[season][episodenumber].jpg

I know if a couple of websites for some shows (mostly small fansites) that serve episode specific images in such a way. Although we certainly dont wanna bring them down with all that traffic, so I suggest supporting this function but not including url's by default.

Inker

 

[LordMessi]

I have posted new source codes and binary files here

The plugin can now lookup images from the internet (amazon & google). Although, I find this feature clumsy, its still better than a kick in the ass.

I left a bug in the code in this version. It will occur when trying to download an image from the Internet using a specific URL. The error will state that their is not enough space. if anyone gets this error, please send me the URL of the image. I will get rid of this issue in the next release.


I have finally started working on the Media Portal side of this plugin. I am playing around with the layout and I need your input :idea: :idea: :idea:

Here are your options:

1. Use the standard menu system with a list of series/seasons/episodes (like the last version). I would enhance it by implementing the info screen - activated when pressing the info button on the remote.

2. Combining the menu and info screens together. Here is a screenshot of the prototype.

In any case, i would enable each item in the list view to have its own menu - activated when pressing the menu button on the remote. this will contains things like (re-download info, play, delete, etc)


Let me know[/url]

Well....I like number 2. - but I think there might be a problem if got 10+ series...or what? If this could be taken into consideration...I mean not to lose the overview, when having a lot of series...then i'll vote for number 2.

 

[Inker]

In regards to visualizing the info, how about doing something like this:

Don't laugh, its just a very rough sketch and I'm at work and all I have is pbrush.exe.......seriously

I'll do a better sketch when I'm home.

Basically it lists all the series/shows displaying their header Image from tv.com. Those shows (old/less popular ones) without such an image could simply write the name as before.

Problem is this might not be possible as of yet with MP. If so, and you wish to display information in such a way, I'll try to enable such an element for you.

Let me know what you think.

Inker

 

[wishywashy]

I like option 2 for the series, but something like Inker suggested for individual episodes