#Have not have movie collector database movie
#Have not have movie collector database code
#Have not have movie collector database tv

#Have not have movie collector database movie

Sometimes, the file name may not reveal enough about the movie so that it can't be identified automatically. This works extremely well if the movies are named accordingly, the program has for instance no issue identifying the movie gladiator.avi as the movie Gladiator.

#Have not have movie collector database tv

While it takes a couple of clicks to configure the program to do so, it not only adds the files to the database, but also uses movie databases such as IMDB to scrape movie information to add them to each movie or TV show found automatically. One of the best features as far as I'm concerned is the ability to point it to any folder on a connected drive to have it scanned for movie or TV show files. Once you get used to the program though, you will certainly like what it has to offer. Media Companion's interface may look confusing at first as it is making available many different tabs and settings in its interface. Programs like Media Companion not only help you keep an overview of your entire collection, but also act as a launcher to watch movies and TV shows right from the application in the default media player. The file contains macros, so you’ll have to enable those to make the file work.If you have a large movie or TV show collection at home, either on hard drives or in form of CDs, DVDs and Blu-Ray discs, you may be interested in a management program for the collection. It’s in Excel 2003 format (xls), and the file is zipped.

#Have not have movie collector database code

To see the code and test the sample file, you can download the Excel movies database file. The criteria sheet and Lists sheet are automatically updated, so no changes need to be made to those sheets. Then, select a category or actor, and a report is created on Select Movies sheet, with all the movies that meet the selected criteria. To use the database, enter movie information on the Movies List sheet. The pivot tables are automatically refreshed when the workbook opens, and when you deactivate the data entry sheet. These are pivot tables, based on the MovieList database. The final sheet in the workbook stores the lists that are used in the yellow drop down cells. If you select an actor, the Actor criteria range is used. If you select a Category from the drop down list, the Category criteria range is used for the Advanced Filter. There’s a criteria area for each type of filter, stored on the CriteriaSel sheet. The code runs an Advanced Filter, just as you could do manually. To see the code, right-click the Select Movies sheet tab, and click View Code. The yellow cells are named (SelCat and SelActor), and the block of green cells is a range named ExtractMovies. Select from either of those, and code automatically runs, to filter a list of movies that match your selection. On the report sheet, named Select Movies, there are two drop down lists – one for Category and one for Actor. In Excel 2007 you could use an Excel Table instead, and in Excel 2003 you could use an Excel List. The database was named MovieList, using a dynamic range. On the data entry sheet, named Movies List, there’s a table with seven columns.Ī unique ID number is entered for each movie, then the title, and other information about the movie. In this database you can store movie data, then create a list of movies for a specific category or actor. This example shows a movie collection database in Excel, but you could set up something similar to keep track of books, sales orders, or almost anything else. For a simple database, Excel can do a pretty good job of organizing and reporting your data.