Listing Movies

vbimport

#1

I have about 600 movies that I purchased and copied. I have them all listed by the date I bought them. I would like to list them alphabetically. Can I imput them into the computer by date and than some how re-arrange them into aplhabetical order? I am sure this can be done, hope I am not asking a dumb question. T.I A.
Jim:confused:


#2

Hi,

that’s rather simple.
I’d suggest using a spreadsheet software like OpenOffice Calc or Excel for that job. If you have the date of purchase in the first column, and the title of the movies in the second one, then you can easily sort them alphabetically or however you want that.

Michael


#3

[QUOTE=mciahel;2570691]Hi,

that’s rather simple.
I’d suggest using a spreadsheet software like OpenOffice Calc or Excel for that job. If you have the date of purchase in the first column, and the title of the movies in the second one, then you can easily sort them alphabetically or however you want that.

Michael[/QUOTE]
Thats pretty much as I thought, I’ll try with excel. Thanks for the reply, just needed a little confirmation before I jumped in.


#4

[QUOTE=durkinjt;2570794]Thats pretty much as I thought, I’ll try with excel. Thanks for the reply, just needed a little confirmation before I jumped in.[/QUOTE]

That’s what I did but I have to now go back and make sure I got them all listed with the right names and correct cd/dvd storage sleeves so I can locate which cases hold which movies. Otherwise I would have to dig through so many cases it would be more work just to watch the movies. I have them on a Excel spreadsheet but have to revised and correct the names to match up correctly.


#5

I use a customized MS Works database to keep track of my 38,000 home-recorded titles. The advantage of such a database is that it may be searched by any data or sorted on any field. MS Works is already found on many computers.

Here are entries for two recent DVDs:

101229H THE LADYKILLERS 1955 TCM 12/29/2010 5008
101229H KIND HEARTS AND CORONETS 1949 TCM 12/29/2010
101229I THE LAVENDER HILL MOB 1951 TCM 12/29/2010 5008
101229I FDOC FOREVER EALING 2002 TCM 12/29/2010
101229I THE MAN IN THE WHITE SUIT 1951 TCM 12/29/2010

Serialized material is listed so:

101126C STOOGE THREE STOOGES: MERRY MAVERICKS 3ST-133 1951 AMC 11/22/2010 T280
101126C STOOGE THREE STOOGES: BACK TO THE WOODS 3ST-023 1937 AMC 11/22/2010
101126C STOOGE THREE STOOGES: GYPPED IN THE PENTHOUSE 3ST-161 1955 AMC 11/22/2010
101126C STOOGE THREE STOOGES: WOMEN HATERS (MINI) 3ST-001 1934 AMC 11/22/2010
101126C STOOGE THREE STOOGES: SELF MADE MAIDS 3ST-124 1950 AMC 11/23/2010
101126C STOOGE THREE STOOGES: GYPPED IN THE PENTHOUSE 3ST-161 1955 AMC 11/23/2010
101126C STOOGE THREE STOOGES: WOMEN HATERS (MINI) 3ST-001 1934 AMC 11/23/2010
101126C STOOGE THREE STOOGES: MEN IN BLACK (MINI) 3ST-003 1934 AMC 11/23/2010
101126C STOOGE THREE STOOGES: INCOME TAX SAPPY 3ST-153 1954 AMC 11/23/2010
101126C STOOGE THREE STOOGES: SELF MADE MAIDS 3ST-124 1950 AMC 11/25/2010
101126C STOOGE THREE STOOGES: VIOLENT IS THE WORD FOR CURLY (MINI) 3ST-033 1938 AMC
11/25/2010
101126C STOOGE THREE STOOGES: SLAP HAPPY SLEUTHS 3ST-127 1950 AMC 1/25/2010
101126C STOOGE THREE STOOGES: THREE MISSING LINKS 3ST-034 1938 AMC 11/25/2010
101126C STOOGE THREE STOOGES: LOOSE LOOT 3ST-146 1953 AMC 11/26/2010
101126C STOOGE THREE STOOGES: BOOBS IN ARMS (MINI) 3ST-052 1940 AMC 11/26/2010
101126C STOOGE THREE STOOGES: THE TOOTH WILL OUT 3ST-134 1951 AMC 11/26/2010
101126C STOOGE THREE STOOGES: FOR CRIMIN’ OUT LOUD 3ST-170 1956 AMC 11/26/2010
101126C STOOGE THREE STOOGES: PARDON MY SCOTCH (MINI) 3ST-009 1935 AMC 11/26/2010


#6

Why re-invent the wheel? Just use a good movie cataloging software like Ant Movie Catalog.


#7

[QUOTE=VoxHumana;2570886]I use a customized MS Works database to keep track of my 38,000 home-recorded titles. The advantage of such a database is that it may be searched by any data or sorted on any field. MS Works is already found on many computers.

Here are entries for two recent DVDs:

101229H THE LADYKILLERS 1955 TCM 12/29/2010 5008
101229H KIND HEARTS AND CORONETS 1949 TCM 12/29/2010
101229I THE LAVENDER HILL MOB 1951 TCM 12/29/2010 5008
101229I FDOC FOREVER EALING 2002 TCM 12/29/2010
101229I THE MAN IN THE WHITE SUIT 1951 TCM 12/29/2010

Serialized material is listed so:

101126C STOOGE THREE STOOGES: MERRY MAVERICKS 3ST-133 1951 AMC 11/22/2010 T280
101126C STOOGE THREE STOOGES: BACK TO THE WOODS 3ST-023 1937 AMC 11/22/2010
101126C STOOGE THREE STOOGES: GYPPED IN THE PENTHOUSE 3ST-161 1955 AMC 11/22/2010
101126C STOOGE THREE STOOGES: WOMEN HATERS (MINI) 3ST-001 1934 AMC 11/22/2010
101126C STOOGE THREE STOOGES: SELF MADE MAIDS 3ST-124 1950 AMC 11/23/2010
101126C STOOGE THREE STOOGES: GYPPED IN THE PENTHOUSE 3ST-161 1955 AMC 11/23/2010
101126C STOOGE THREE STOOGES: WOMEN HATERS (MINI) 3ST-001 1934 AMC 11/23/2010
101126C STOOGE THREE STOOGES: MEN IN BLACK (MINI) 3ST-003 1934 AMC 11/23/2010
101126C STOOGE THREE STOOGES: INCOME TAX SAPPY 3ST-153 1954 AMC 11/23/2010
101126C STOOGE THREE STOOGES: SELF MADE MAIDS 3ST-124 1950 AMC 11/25/2010
101126C STOOGE THREE STOOGES: VIOLENT IS THE WORD FOR CURLY (MINI) 3ST-033 1938 AMC
11/25/2010
101126C STOOGE THREE STOOGES: SLAP HAPPY SLEUTHS 3ST-127 1950 AMC 1/25/2010
101126C STOOGE THREE STOOGES: THREE MISSING LINKS 3ST-034 1938 AMC 11/25/2010
101126C STOOGE THREE STOOGES: LOOSE LOOT 3ST-146 1953 AMC 11/26/2010
101126C STOOGE THREE STOOGES: BOOBS IN ARMS (MINI) 3ST-052 1940 AMC 11/26/2010
101126C STOOGE THREE STOOGES: THE TOOTH WILL OUT 3ST-134 1951 AMC 11/26/2010
101126C STOOGE THREE STOOGES: FOR CRIMIN’ OUT LOUD 3ST-170 1956 AMC 11/26/2010
101126C STOOGE THREE STOOGES: PARDON MY SCOTCH (MINI) 3ST-009 1935 AMC 11/26/2010[/QUOTE]

That is an awesome program, I don,t think I am in your league yet, need a simpler way to just get an aplhabetical thing going at this point, then maybe down the road upgrade. Again thanks for the reply, any help woud be grateful.


#8

No need to throw money into the greediness aka m$.

Get OpenOffice. :wink: