TV Database

[a06lp]

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!

[m_masta]

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.

[a06lp]

@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?

[jmb295]

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.

[a06lp]

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?

[a06lp]

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!

[Myth]

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

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

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

Myth

[abobader]

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]

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

My best.