TV Database

Help each other out

TV Database

Postby a06lp on Mon Apr 10, 2006 12:30 am

Hi,

I'm new, but I did a TON of searching on this, but couldn't find any useful info on this topic...

I am trying to set up a database for my TV shows, which are stored on my HDD.

My layout is like this:
D:\TV\Lost\Season2\218 - Dave.avi
D:\TV\Scrubs\Season 5\517 - My Chopped Liver.avi


In other words:
C:\TV\Series\Season\EpNum - EpTitle.(extension)

What I want to do is make the screens go like this:
Click TV (main screen) --> List of all Series --> List of all Seasons --> List of eps (selecting one, plays the ep, obviously)
[TV>Series>Season>(list)>play]?

Could someone help me and post a step-by-step guide describing how I can accomplish this?

Thanks!
a06lp
 
Posts: 119
Joined: Thu Apr 06, 2006 2:17 am

Postby m_masta on Mon Apr 10, 2006 4:55 am

Assuming you have files as you describe, and you import d:\tv
1)create a new import template and accept extension types avi,mpg, etc...
2)in metamasks add:


\\(?<Name>.*)\\[S|s]eason\s(?<Season>\d*)\\.(?<EpNum>\d*)\s-\s(?<EpTitle>.*)\..*
\\(?<Name>.*)\\[S|s]eason(?<Season>\d*)\\.(?<EpNum>\d*)\s-\s(?<EpTitle>.*)\..*

3)choose custom and Folder->ignore (try different settings to see what's best for you)
4)import

This assumes that you have the spaces and the "-" as you show in your example. It allows for either "Season" or "season" (Capital S or lowercase s) as well as "Season #" or "Season#"
I assumed the episode numbers were the last two digits of "517" for the example. If you need it to be all three digits, remove the "." in ".(?<EpNum..."

Note: It's crucial for file structure/name be accurate for the metamasks to work. You should learn a little bit about regex to customize your stuff.
m_masta
 
Posts: 125
Joined: Fri Mar 11, 2005 5:41 am
Location: Houston, TX

Postby a06lp on Mon Apr 10, 2006 9:18 pm

@m_masta:

Thanks for your help so far.

Using your metatags, everything imports almost perfectly:

When I set custom, and folder>ignore:
I just get one long list of all the episodes (each with name, season, epnum, & eptitle are database fields.)

When I set custom, and folder>container:
It's ALMOST perfect -
I get series, season, but then instead of eptitle, i get just the seriesname.
name, season, epnum, & eptitle are database fields.

What am I doing wrong?
a06lp
 
Posts: 119
Joined: Thu Apr 06, 2006 2:17 am

Postby jmb295 on Sat Apr 15, 2006 4:10 am

i am trying to set this up now myself. i discovered that the name field is displayed in the main display box. if you change the meta tags from name to something like title, and then change eptitle to name you should be ok. i did this and it is working for me. you can then display seperately on the screen the episode number, series name, ect.
jmb295
 
Posts: 69
Joined: Tue May 04, 2004 11:56 pm
Location: Sterling, Va

Postby a06lp on Sun Apr 16, 2006 4:51 pm

jmb295 wrote:i discovered that the name field is displayed in the main display box. if you change the meta tags from name to something like title, and then change eptitle to name you should be ok. i did this and it is working for me.


It didn't work for me.
I entered this for my Metatags:
Code: Select all
\\(?<Series>.*)\\[S|s]eason\s(?<Season>\d*)\\.(?<EpNum>\d*)\s-\s(?<Name>.*)\..*
\\(?<Series>.*)\\[S|s]eason(?<Season>\d*)\\.(?<EpNum>\d*)\s-\s(?<Name>.*)\..*

But what I get is:
series>season> but then instead of the name of the ep, i just a blank space for most.
But here's the really weird part: even though most are blank, some have like a letter or something.
Some db entries have part of the titlename - i figured out these are the titles with a period in their name, like "303 - Mr. Griffin Goes To Washington.rm" becomes "Mr"; and "218 - E. Peterbus Unum.rmvb" becomes "E"; and "402 - Fast Times At Buddy Cianci Jr. High.rmvb" becomes "Fast Times At Buddy Cianci Jr"
Any titles without a period all come up blank.

This leads me to think there must be something wrong with the db code. So then I tried this metatags code for the import:
Code: Select all
\\(?<Series>.*)\\Season\s(?<Season>\d*)\\.(?<EpNum>\d*)\s-\s(?<Name>.*)\.*
\\(?<Series>.*)\\Season(?<Season>\d*)\\.(?<EpNum>\d*)\s-\s(?<Name>.*)\.*

This is the closest I've gotten. Now all the titles show up as they should, except each title is missing the last word of the title.
For example, "408 - 8 Simple Rules For Buying My Teenage Daughter.rmvb" shows up as "8 Simple Rules For Buying My Teenage".
Interestingly, "402 - Fast Times At Buddy Cianci Jr. High.rmvb" still shows up as "Fast Times At Buddy Cianci Jr" (but probably for a different reason this time)

The periods seem to be the problem here - but I don't know how to fix it! :( Can anyone help?
Last edited by a06lp on Mon Apr 17, 2006 10:56 pm, edited 2 times in total.
a06lp
 
Posts: 119
Joined: Thu Apr 06, 2006 2:17 am

Postby a06lp on Mon Apr 17, 2006 10:55 pm

Ok, some more trial and error, and a bit of intuition led me to this solution:

Code: Select all
\\(?<Series>.*)\\Season\s(?<Season>\d*)\\.(?<EpNum>\d*)\s-\s(?<Name>.*)\. *
\\(?<Series>.*)\\Season(?<Season>\d*)\\.(?<EpNum>\d*)\s-\s(?<Name>.*)\. *
\\(?<Series>.*)\\(?<Season>.*)\\(?<Name>.*)\. *


This sorts the files as I want them in the database.

Yay!
SOLVED!
a06lp
 
Posts: 119
Joined: Thu Apr 06, 2006 2:17 am

Re: TV Database

Postby Myth on Wed May 03, 2006 10:39 am

a06lp wrote:What I want to do is make the screens go like this:
Click TV (main screen) --> List of all Series --> List of all Seasons --> List of eps (selecting one, plays the ep, obviously)
[TV>Series>Season>(list)>play]?


I took a slightly different track...
The existing movie database suit me, already , using sub-items etc

My TV-Series layout ( both directory and database structure ) is

Code: Select all
Friends - Series
Lost - Series
The Simpsons - Series
|->The Simpsons - Series 01
|->The Simpsons - Series 02
     |-> S2e01 - Episode 1 Title
     |-> S2e02 - Episode 2 Title
             |->Title
             |->Date
             |->Plot etc
 


The only problem is I have to manually paste in the Plot, The Actors, Date etc.
If the spider could handle a site Like TV.com with at least 3 selection points ( TV Series / Series No / Episode No ) then I could update it as easily as I do with Movies using IMDB and Amazon

A couple of feature requests (see links) would make it a bit better :lol:

http://www.xlobby.com/forum/viewtopic.php?t=4327&highlight=myth

http://www.xlobby.com/forum/viewtopic.php?t=3614&highlight=myth

Myth
Myth
 
Posts: 83
Joined: Sun May 09, 2004 9:48 am

Postby abobader on Tue May 09, 2006 1:12 pm

m_masta wrote:Assuming you have files as you describe, and you import d:\tv
1)create a new import template and accept extension types avi,mpg, etc...
2)in metamasks add:


\\(?<Name>.*)\\[S|s]eason\s(?<Season>\d*)\\.(?<EpNum>\d*)\s-\s(?<EpTitle>.*)\..*
\\(?<Name>.*)\\[S|s]eason(?<Season>\d*)\\.(?<EpNum>\d*)\s-\s(?<EpTitle>.*)\..*

3)choose custom and Folder->ignore (try different settings to see what's best for you)
4)import

This assumes that you have the spaces and the "-" as you show in your example. It allows for either "Season" or "season" (Capital S or lowercase s) as well as "Season #" or "Season#"
I assumed the episode numbers were the last two digits of "517" for the example. If you need it to be all three digits, remove the "." in ".(?<EpNum..."

Note: It's crucial for file structure/name be accurate for the metamasks to work. You should learn a little bit about regex to customize your stuff.


Hi masta,

I have some tv show as:

\\TV\TV1\
\\TV\TV1\ShoGun\
\\TV\TV1\ShoGun\Volume 1\
\\TV\TV1\ShoGun\Volume 1\ShowGun.mpg

\\TV\TV1\
\\TV\TV1\ShoGun\
\\TV\TV1\ShoGun\Volume 2\
\\TV\TV1\ShoGun\Volume 2\ShowGun.mpg

Any help in the metamask issue, thanks in advanced for any input.

My best.
abobader
 
Posts: 142
Joined: Fri Apr 21, 2006 5:08 pm

Postby abobader on Tue May 09, 2006 4:58 pm

Please ignore my above post, I found out using the movie database solve the issue.

My best.
abobader
 
Posts: 142
Joined: Fri Apr 21, 2006 5:08 pm