New Pornstar Interviews - [more]
Chloe Temple Interview

"I’ve hooked up with multiple people in one day, just bounced from one to the other."
All Forums > The Porn Pool > The Porn Pool Forum Page 560 > Indexing My Library
AuthorPost
ipop
Senior Member


1115 Posts
1/06
Posted - Jul 28 2006 : 4:26AM
As my DVD collection keeps growing, I've been wishing I had a list of all my DVD's, but never sem to have the time.

I came up with an easy way to make a cool list. I started a spreadsheet in Excel that I will eventually enter all my movies in. Now, whenever I'm looking up movies at IAFD, I can just copy the title from a star's listing, then paste it on the spreadsheet, and it creates a hyperlink to the listing in IAFD. Next to that, I can copy/paste any of my favorite stars from the movie, and it will create a hyperlink showing the star's name and linking to their page at IAFD. I have a column for DVD or VHS, and I can even add a number column later. Even ssomebody with little experience in Excel could do this.

I was looking up Teagan tonight, so then I created entries for every one of her movies that I knew I had (almost every damn one). I can just gradually add to it whenever I'm browsing, then sort it (alphabetize by Column A). If I create a double entry, it will be easy to spot after sorting it.

I'm sure I'm not the first one to do it this way, but I thought I would share my idea.

Edited by - ipop on Jul 28 2006

Edited by - ipop on Jul 28 2006

cubesnake
Senior Member

3858 Posts
10/02
Posted - Jul 28 2006 : 8:42AM
Hi,

even worse than finding the right way of indexing your stuff is to keep track of what your star has done. IAFD doesn´t know everything

Cube

willywilly
Member

Activated Member
662 Posts
2/05
Posted - Jul 28 2006 : 12:15PM
Before you get into it too deep, would it be a better idea to use a database instead of a spreadsheet? ..just something to think about.

There have been a few threads on this subject, if you want to see what methods others use. Not sure without searching, but those threads might have been in the Tech Talk forum. Maybe searching for 'database' would find them.

Ramsey
Senior Member

Trina Michaels fan
10332 Posts
10/02
Posted - Jul 28 2006 : 12:55PM
I want to keep it simple so I also use Excel. It's perfect if you want to do a quick search when you buy a movie like if you already have it. I scanned all my boxcovers and I'm using those scans as hyperlinks.
willywilly
Member

Activated Member
662 Posts
2/05
Posted - Jul 28 2006 : 2:05PM
I'm curious if you feel that a spreadsheet is more simple than a database. Can you expand on that a bit?
Interesting idea.
 
Endless Loop
Senior Member

Tomatometer
1129 Posts
8/04
Posted - Jul 28 2006 : 4:11PM

I too like this idea, and have my old MS Office,

but never became very familiar with Excel and spreadsheets. :(

ipop
Senior Member

1115 Posts
1/06
Posted - Jul 28 2006 : 10:16PM
I don't think I have any software to create a database. I guess I'll just stick to Excel for now.

I entered about 50 titles last night. My mouse hand was sore from all the copying and pasting. (and yes, I was using Ctrl + C & Ctrl + V when possible)

d_knife
Member

Brisbane, Australia
13 Posts
10/05
Posted - Jul 29 2006 : 5:34AM
I use Movie Collector from collectorz.com
It's can search and add movies by title or entered manually. It has support for covers and can enter star details in.
For instance I know within 2 seconds that out of the 285 titles I have (for example) 17 Tiana Lynn titles
and 25 Evil Angel discs
king of rappers
Member

225 Posts
6/06
Posted - Jul 29 2006 : 5:35AM
holy shit, bro. how much porn do you have?
Ramsey
Senior Member

Trina Michaels fan
10332 Posts
10/02
Posted - Jul 29 2006 : 8:33AM
Because I have no idea how to set up a database like the IAFD for example so Excel works for me.
willywilly
Member

Activated Member
662 Posts
2/05
Posted - Jul 29 2006 : 2:31PM
That would prevent the use of a database. :)


willywilly
Member

Activated Member
662 Posts
2/05
Posted - Jul 29 2006 : 2:45PM
A database like IAFD?
I wasn't talking about anything like that. :)

Just something simple, on a home PC. I wouldn't have any idea how to set it up for online use either. Nor do I have the motivation to make it pleasing to the eye. Since it is just for manipulating data for my own personal use, I don't mind if it is rather ugly.

I'm not a wizard with either spreadsheets or databases. Have made and used them at work though. Spreadsheets were great for numbers manipulation, i.e. accounting. Learned that databases were much better for storing and sorting information.

The bottom line is: since we are talking about personal use, whatever works and is liked is the way to go. :)


By the way, I was searching for something else here on ADT and found a couple posts by you. Back then you said you used a database. Did you switch from a database to a spreadsheet? or was it just a general statement?

Here
and
here


willywilly
Member

Activated Member
662 Posts
2/05
Posted - Jul 29 2006 : 2:52PM



Jump To: