Login | Register For Free | Help
Search for: (Advanced)

Mailing List Archive: MythTV: Users

Video Catalog

 

 

MythTV users RSS feed   Index | Next | Previous | View Threaded


cfr131 at gmail

Jul 6, 2009, 9:47 AM

Post #1 of 15 (1423 views)
Permalink
Video Catalog

My Video collection is getting quite large. The Wife does not like to
scroll through the videos looking at what there is, honestly, I don’t like
to either.



I want to make a “card catalog” of the videos. I would like to pull from
the database information and print it on a card, or piece of paper, put the
paper in a three ring binder. As I add new vides, I can print a page and
insert it in the proper place in the binder.



Two questions:

1) Has anyone done something similar or solved the problem in a
different manor?

2) What tools would you recommend to someone who knows only the
very basics of sql?



Thanks.


bderman at gmail

Jul 6, 2009, 9:56 AM

Post #2 of 15 (1371 views)
Permalink
Re: Video Catalog [In reply to]

On Jul 6, 2009, at 9:47 AM, Tony Baca wrote:

> My Video collection is getting quite large. The Wife does not like
> to scroll through the videos looking at what there is, honestly, I
> don’t like to either.
>
> I want to make a “card catalog” of the videos. I would like to pull
> from the database information and print it on a card, or piece of
> paper, put the paper in a three ring binder. As I add new vides, I
> can print a page and insert it in the proper place in the binder.
>
> Two questions:
> 1) Has anyone done something similar or solved the
> problem in a different manor?
> 2) What tools would you recommend to someone who knows
> only the very basics of sql?
>
> Thanks.

Wow! Sounds kind of backwards to me to move from a database to printed
pages. How do you normally browse your videos? I do mine by Genre.
Simply create a folder for each Genre of your choosing and move your
videos to the appropriate one. Then when you bring up the Videos page,
you are presented with a genre list.

You can get even more control with symlinks. At the top level, make
Genre folders with names that force them to the top of the list
(~Action, ~Comedy, ~Drama, etc.) Then place the original files at the
top level for those that like to scroll through long lists of movie
names and put a symlink into their appropriate genre(s).

Or the simple built-in solution: make sure all your genre metadata is
filled out appropriately for each video and filter/search for videos.

-Brad


_______________________________________________
mythtv-users mailing list
mythtv-users [at] mythtv
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users


jedi at mishnet

Jul 6, 2009, 10:20 AM

Post #3 of 15 (1376 views)
Permalink
Re: Video Catalog [In reply to]

On Mon, Jul 06, 2009 at 10:47:01AM -0600, Tony Baca wrote:
> My Video collection is getting quite large. The Wife does not like to
> scroll through the videos looking at what there is, honestly, I don’t like
> to either.

Why not just reorganize it so that you don't have to browse very far
to get to any particular video? Using the Gallery view could be helpful
too.

I'm not sure a printed catalog would really solve anything...

>
>
>
> I want to make a “card catalog” of the videos. I would like to pull from
> the database information and print it on a card, or piece of paper, put the
> paper in a three ring binder. As I add new vides, I can print a page and
> insert it in the proper place in the binder.
>
>
>
> Two questions:
>
> 1) Has anyone done something similar or solved the problem in a
> different manor?
>
> 2) What tools would you recommend to someone who knows only the
> very basics of sql?
>
>
>
> Thanks.

> _______________________________________________
> mythtv-users mailing list
> mythtv-users [at] mythtv
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users

_______________________________________________
mythtv-users mailing list
mythtv-users [at] mythtv
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users


cfr131 at gmail

Jul 6, 2009, 10:41 AM

Post #4 of 15 (1374 views)
Permalink
Re: Video Catalog [In reply to]

On Mon, Jul 6, 2009 at 10:56 AM, Brad DerManouelian <bderman [at] gmail>wrote:

> On Jul 6, 2009, at 9:47 AM, Tony Baca wrote:
>
> My Video collection is getting quite large. The Wife does not like to
>> scroll through the videos looking at what there is, honestly, I don’t like
>> to either.
>>
>> I want to make a “card catalog” of the videos. I would like to pull from
>> the database information and print it on a card, or piece of paper, put the
>> paper in a three ring binder. As I add new vides, I can print a page and
>> insert it in the proper place in the binder.
>>
>> Two questions:
>> 1) Has anyone done something similar or solved the problem in a
>> different manor?
>> 2) What tools would you recommend to someone who knows only the
>> very basics of sql?
>>
>> Thanks.
>>
>
> Wow! Sounds kind of backwards to me to move from a database to printed
> pages. How do you normally browse your videos? I do mine by Genre. Simply
> create a folder for each Genre of your choosing and move your videos to the
> appropriate one. Then when you bring up the Videos page, you are presented
> with a genre list.
>
> You can get even more control with symlinks. At the top level, make Genre
> folders with names that force them to the top of the list (~Action, ~Comedy,
> ~Drama, etc.) Then place the original files at the top level for those that
> like to scroll through long lists of movie names and put a symlink into
> their appropriate genre(s).
>
> Or the simple built-in solution: make sure all your genre metadata is
> filled out appropriately for each video and filter/search for videos.
>
> -Brad
>
thanks for the suggestion. I hear what you are sawying about going
backwards! For me it is about what increasing the WAF! Mine would rather
look at paper, then have to press buttons :)

I do need to update the metadata. I could use symlinks to put video into
multipule genre, that may help.


david at segall

Jul 6, 2009, 10:44 AM

Post #5 of 15 (1371 views)
Permalink
Re: Video Catalog [In reply to]

Tony Baca wrote:
> My Video collection is getting quite large. The Wife does not like to
> scroll through the videos looking at what there is, honestly, I don’t
> like to either.
>
>
>
> I want to make a “card catalog” of the videos. I would like to pull
> from the database information and print it on a card, or piece of paper,
> put the paper in a three ring binder. As I add new vides, I can print a
> page and insert it in the proper place in the binder.
>
>
>
> Two questions:
>
> 1) Has anyone done something similar or solved the problem
> in a different manor?
>
> 2) What tools would you recommend to someone who knows only
> the very basics of sql?

I wrote an entry in the Wiki that explains how to connect the MythTV
database to Microsoft Access
<http://www.mythtv.org/wiki/Microsoft_Access>. Once you have done that
Microsoft Access provides a simple form that generates the SQL required
to extract the data and a report generator that will print your page in
the format you specify. Open Office Base
http://www.openoffice.org/product/base.html> provides comparable
facilities and is cross platform and open source.
_______________________________________________
mythtv-users mailing list
mythtv-users [at] mythtv
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users


cfr131 at gmail

Jul 6, 2009, 10:54 AM

Post #6 of 15 (1363 views)
Permalink
Re: Video Catalog [In reply to]

On Mon, Jul 6, 2009 at 11:44 AM, David Segall <david [at] segall> wrote:

>
>
> Tony Baca wrote:
>
>> My Video collection is getting quite large. The Wife does not like to
>> scroll through the videos looking at what there is, honestly, I don’t like
>> to either.
>>
>>
>> I want to make a “card catalog” of the videos. I would like to pull from
>> the database information and print it on a card, or piece of paper, put the
>> paper in a three ring binder. As I add new vides, I can print a page and
>> insert it in the proper place in the binder.
>>
>>
>> Two questions:
>>
>> 1) Has anyone done something similar or solved the problem in a
>> different manor?
>>
>> 2) What tools would you recommend to someone who knows only the
>> very basics of sql?
>>
>
> I wrote an entry in the Wiki that explains how to connect the MythTV
> database to Microsoft Access <http://www.mythtv.org/wiki/Microsoft_Access>.
> Once you have done that Microsoft Access provides a simple form that
> generates the SQL required to extract the data and a report generator that
> will print your page in the format you specify. Open Office Base
> http://www.openoffice.org/product/base.html> provides comparable
> facilities and is cross platform and open source.
>

Thanks, this sounds like what I am looking for.


k at adamski

Jul 6, 2009, 4:09 PM

Post #7 of 15 (1350 views)
Permalink
Re: Video Catalog [In reply to]

On Mon, 2009-07-06 at 10:47 -0600, Tony Baca wrote:
> My Video collection is getting quite large. The Wife does not like to
> scroll through the videos looking at what there is, honestly, I don’t
> like to either.
>
>
>
> I want to make a “card catalog” of the videos. I would like to pull
> from the database information and print it on a card, or piece of
> paper, put the paper in a three ring binder. As I add new vides, I
> can print a page and insert it in the proper place in the binder.
>
>
>
> Two questions:
>
> 1) Has anyone done something similar or solved the problem
> in a different manor?
>
> 2) What tools would you recommend to someone who knows
> only the very basics of sql?

I organize my videos by year of release, each year in a separate folder,
this way the list does not grow to large. The only exception to this, is
multi sequels, so I have a separate entry for example for Star Wars at
the same level as the year folders.

K

_______________________________________________
mythtv-users mailing list
mythtv-users [at] mythtv
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users


jedi at mishnet

Jul 6, 2009, 5:30 PM

Post #8 of 15 (1337 views)
Permalink
Re: Video Catalog [In reply to]

On Mon, Jul 06, 2009 at 07:09:03PM -0400, Krzysztof Adamski wrote:
> On Mon, 2009-07-06 at 10:47 -0600, Tony Baca wrote:
> > My Video collection is getting quite large. The Wife does not like to
> > scroll through the videos looking at what there is, honestly, I don’t
> > like to either.
> >
> >
> >
> > I want to make a “card catalog” of the videos. I would like to pull
> > from the database information and print it on a card, or piece of
> > paper, put the paper in a three ring binder. As I add new vides, I
> > can print a page and insert it in the proper place in the binder.
> >
> >
> >
> > Two questions:
> >
> > 1) Has anyone done something similar or solved the problem
> > in a different manor?
> >
> > 2) What tools would you recommend to someone who knows
> > only the very basics of sql?
>
> I organize my videos by year of release, each year in a separate folder,

That sounds like a scheme that requires you to know too much about
what you already have. I started to split my TV shows by genre because
my top level list was starting to get pretty long and even that seemed
to be a bit awkward just to me and I was the one that sorted the list
to begin with.

> this way the list does not grow to large. The only exception to this, is
> multi sequels, so I have a separate entry for example for Star Wars at
> the same level as the year folders.
>
> K
>
> _______________________________________________
> mythtv-users mailing list
> mythtv-users [at] mythtv
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
_______________________________________________
mythtv-users mailing list
mythtv-users [at] mythtv
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users


brent at brentnorris

Jul 6, 2009, 6:51 PM

Post #9 of 15 (1335 views)
Permalink
Re: Video Catalog [In reply to]

What would be great is if there was a way to sort by the info that is
entered into the DB. I think it may have been XBMC that allowed that.
You have a DB that has Actors, Directors, Genre, Date, and probably a
lot of other stuff in there. The ability to sort by that would really
be what you guys are looking for.

"I am looking for something funny." Sort by genre, select comedy
"I am looking for something with Clint Eastwood" Sort by Actor, select
Clint Eastwood

etc...etc..

Maybe MythVideo has this and I have just forgot about it. Personally, I
sorted mine into directories: 0-9, A-C, D-F, etc..

Brent
_______________________________________________
mythtv-users mailing list
mythtv-users [at] mythtv
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users


nick.rout at gmail

Jul 6, 2009, 7:32 PM

Post #10 of 15 (1328 views)
Permalink
Re: Video Catalog [In reply to]

On Tue, Jul 7, 2009 at 1:51 PM, Brent Norris<brent [at] brentnorris> wrote:
> What would be great is if there was a way to sort by the info that is
> entered into the DB.  I think it may have been XBMC that allowed that. You
> have a DB that has Actors, Directors, Genre, Date, and probably a lot of
> other stuff in there.  The ability to sort by that would really be what you
> guys are looking for.
>
> "I am looking for something funny." Sort by genre, select comedy
> "I am looking for something with Clint Eastwood" Sort by Actor, select Clint
> Eastwood
>


you are correct that xbmc does that, as long as it has correctly
identified the movie and you are in library mode.
_______________________________________________
mythtv-users mailing list
mythtv-users [at] mythtv
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users


derliebegott at gmail

Jul 7, 2009, 12:56 AM

Post #11 of 15 (1295 views)
Permalink
Re: Video Catalog [In reply to]

2009/7/7 Nick Rout <nick.rout [at] gmail>:
> On Tue, Jul 7, 2009 at 1:51 PM, Brent Norris<brent [at] brentnorris> wrote:
>> What would be great is if there was a way to sort by the info that is
>> entered into the DB.  I think it may have been XBMC that allowed that. You
>> have a DB that has Actors, Directors, Genre, Date, and probably a lot of
>> other stuff in there.  The ability to sort by that would really be what you
>> guys are looking for.
>>
>> "I am looking for something funny." Sort by genre, select comedy
>> "I am looking for something with Clint Eastwood" Sort by Actor, select Clint
>> Eastwood
>>
>
>
> you are correct that xbmc does that, as long as it has correctly
> identified the movie and you are in library mode.

you have possibility to filter out videos by genre, year etc.you can
sort them also.
press M in mythvideo.
_______________________________________________
mythtv-users mailing list
mythtv-users [at] mythtv
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users


ebroo at healthydirections

Jul 7, 2009, 5:09 AM

Post #12 of 15 (1284 views)
Permalink
Re: Video Catalog [In reply to]

Are you wanting to add this to the mythfrontend, or just have some SQL somewhere that will spit out a nice card catalog based on whats in the DB?

-----Original Message-----
From: mythtv-users-bounces [at] mythtv [mailto:mythtv-users-bounces [at] mythtv] On Behalf Of Krzysztof Adamski
Sent: Monday, July 06, 2009 7:09 PM
To: Discussion about mythtv
Subject: Re: [mythtv-users] Video Catalog

On Mon, 2009-07-06 at 10:47 -0600, Tony Baca wrote:
> My Video collection is getting quite large. The Wife does not like to
> scroll through the videos looking at what there is, honestly, I don’t
> like to either.
>
>
>
> I want to make a “card catalog” of the videos. I would like to pull
> from the database information and print it on a card, or piece of
> paper, put the paper in a three ring binder. As I add new vides, I
> can print a page and insert it in the proper place in the binder.
>
>
>
> Two questions:
>
> 1) Has anyone done something similar or solved the problem
> in a different manor?
>
> 2) What tools would you recommend to someone who knows
> only the very basics of sql?

I organize my videos by year of release, each year in a separate folder,
this way the list does not grow to large. The only exception to this, is
multi sequels, so I have a separate entry for example for Star Wars at
the same level as the year folders.

K

_______________________________________________
mythtv-users mailing list
mythtv-users [at] mythtv
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users



_______________________________________________
mythtv-users mailing list
mythtv-users [at] mythtv
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users


jedi at mishnet

Jul 7, 2009, 8:22 AM

Post #13 of 15 (1281 views)
Permalink
Re: Video Catalog [In reply to]

On Mon, Jul 06, 2009 at 08:51:31PM -0500, Brent Norris wrote:
> What would be great is if there was a way to sort by the info that is
> entered into the DB. I think it may have been XBMC that allowed that.
> You have a DB that has Actors, Directors, Genre, Date, and probably a
> lot of other stuff in there. The ability to sort by that would really
> be what you guys are looking for.

Yes, that would be most cool.

It would be nice to sort movies by director and actor.

>
> "I am looking for something funny." Sort by genre, select comedy
> "I am looking for something with Clint Eastwood" Sort by Actor, select
> Clint Eastwood
>
> etc...etc..
>
> Maybe MythVideo has this and I have just forgot about it. Personally, I
> sorted mine into directories: 0-9, A-C, D-F, etc..
_______________________________________________
mythtv-users mailing list
mythtv-users [at] mythtv
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users


jedi at mishnet

Jul 7, 2009, 8:26 AM

Post #14 of 15 (1285 views)
Permalink
Re: Video Catalog [In reply to]

On Tue, Jul 07, 2009 at 08:09:40AM -0400, Edward Brookhouse wrote:
> Are you wanting to add this to the mythfrontend, or just have some SQL somewhere that will spit out a nice card catalog based on whats in the DB?

...actually. This sounds like something that would be easy to do in
PHP or be a nice addition to mythweb assuming there isn't already
a view in mythweb suitable for printing out and using in this manner.
_______________________________________________
mythtv-users mailing list
mythtv-users [at] mythtv
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users


cfr131 at gmail

Jul 7, 2009, 11:11 AM

Post #15 of 15 (1289 views)
Permalink
Re: Video Catalog [In reply to]

On Tue, Jul 7, 2009 at 6:09 AM, Edward Brookhouse <
ebroo [at] healthydirections> wrote:

> Are you wanting to add this to the mythfrontend, or just have some SQL
> somewhere that will spit out a nice card catalog based on whats in the DB?
>
>
>
I was thinking of the latter, some SQL somewhere that will spit out a card.

MythTV users RSS feed   Index | Next | Previous | View Threaded
 
 


Interested in having your list archived? Contact Gossamer Threads
 
  Web Applications & Managed Hosting Powered by Gossamer Threads Inc.