An Effective Way of Organising Your JAV Collection ?

[Kumi3]

Does anyone have an effective method of organizing their JAV collection ?

In an attempt to avoid acquiring the same title twice (a couple of instances), I began keeping a list in a Word document. As the collection grew, I added cover thumbnails, and some cross-reference hyper-links.

Titles are listed in sequence of code-number. These are hyper-linked to an Idol list, sequenced alphabetically by name.


I'm interested to hear of alternative methods, or are most just happy to do it from memory ?

 

[SecretPal]

You're doing better than any of us. I used a spreadsheet, then I finally put all my vids on a 3 terrabyte drive. This way they are automatically sorted by the usual explorer functions.

 

[Kumi3]

Until recently, I didn't have that flexibility in storage.

I regularly drop them out to 8Gb DVDisk. I average 6 titles per platter - The (my) sequential disk number goes back into my index listing next to the original titles code-number.


There is a third list in my document I didn't mention earlier. A list of platter contents listed numerically. I haven't hyper-linked this list tho', it hasn't yet been required - I usually get what I need from the first two lists.

 

[WillEater]

An easy way to determine what you have at any point, use the old DOS command line:
run cmd type in: dir c:\files *.* > filelist.txt

The command creates a text file with all of the titles listed in the directory c:\files.
:study:

 

[Kumi3]

That's only good for what's still on the drive. Once your collection spans multiple drives, and dozens of disks, it's not so easy.

There's a windows utility that does the same as the old DOS pipe method. It covers sub-directories as well. I don't remember if it spans volumes - it has been a couple of years since I've had need to use it.

 

[shinigamie]

I used memory, I can pretty much remember if I have the film by seeing the cover.

But if I doubt myself, I just do a usual sku search of the film in the folder my JAV is in.

Sometimes I download different versions of the same movie to compare quality and keep the better one.

Back when I started, I didnt keep the Cover, but it was a terrible mistake. So in 2011 I began to collect the covers along with the film. Its easier to organize and u dont have to click open the video to see what its about.

 

[Desu]

i kept an excel sheet for a couple years, until it went corrupted somehow :notagain:
right now i'm trying to reorganize things with Collectorz Movie Collector;
it's a superb software with tons of features, but 99% of them are useless for a porn collection

 

[BudEWiser]

Although I rarely collect JAV stuff, my idol collection has grown a lot. I'm currently working on a relational database that will be able to be used to find all videos by a particular model, from a producer, a certian age, tags, and most importantly DVD codes.
This is proving to be a very difficult task, and I'm thinking about starting a project to have others help in filling in the most difficult parts, and being able to share the database with them. Sort of an open source project like thing.

 

[iori11]

:study: i searched for a long time, for now i am using jriver media center 18 as long as the cover has the same as the video file everything goes smoothly as for the tags well by hands my friends by hands :notagain:

 

[Kumi3]

Does jriver media center 18 operate across multiple drives (networked), and removable disks (CD, DVD, et al) ?

Ah - Got the answer for the first part of that whilst I was typing. (Yes). It looks like a souped up version of iTunes (not that I've used that either...).

http://www.jriver.com/index.html

I'm currently working on a relational database

That's a reasonably hardcore grouping and sorting option.

What are you looking at there, BudEWiser, prime data files for Title (DVD), and for Idol, maybe Publisher, and whatever indices you need for your sorting options.

I'm interested to know how you're approaching the Japanese names. What your 'conventions' are ?

For myself, I went Given name first, Family name second. With variations in spelling, it's been pretty much a 'first come' sort of thing. But where it's become very apparent the initial version is incorrect, I've gone back and amended all occurrences (except on the physical CD, of course). In regard to 'alias' names, I've not yet addressed that one (too few instances so far - fingers crossed).

 

[BudEWiser]

That's a reasonably hardcore grouping and sorting option.

What are you looking at there, BudEWiser, prime data files for Title (DVD), and for Idol, maybe Publisher, and whatever indices you need for your sorting options.

I'm interested to know how you're approaching the Japanese names. What your 'conventions' are ?

For myself, I went Given name first, Family name second. With variations in spelling, it's been pretty much a 'first come' sort of thing. But where it's become very apparent the initial version is incorrect, I've gone back and amended all occurrences (except on the physical CD, of course). In regard to 'alias' names, I've not yet addressed that one (too few instances so far - fingers crossed).

It is very "hard core" and so far I'm in the planning stages. This database will have several different tables so that it's easier to do drop down boxes for things like "Production Company" with an "Add new entry" available if it's not in the database. Names will be handled by how they are most commonly written, except the English translation will always be given name, family name, as they would most commonly be informally written in English.
I've gone through about 40 different iterations of it so far, and am almost settled on a format. The next stage will be writing the php code (since I will have it running on one of my home servers) for it all. Eventually if I could come up with a front end, I would like to have it on a web server that just about any one can access to look up the information, and trusted individuals be able to make additions and corrections to. The only part that would be missing from the web version's interface would be the "Have" column. Those would be reserved for those who want to download the most current version of the database and use it on their own, to manage their collection.

As you said, a very hardcore option. Because I haven't been happy with anything I've developed on my own, I have been looking into open source collection software, but it's all geared towards Hollywood and little room for modification, because of their complex PHP schemes.
If any one has any suggestions regarding open source options let me know. It would be much easier to modify someone elses work than to make it all completely from scratch. Especially the PHP, at least for me.

 

[Kumi3]

I would like to have it on a web server that just about any one can access to look up the information

And here I was, just worried about which movie is on what disk...


Your talk of a web server has my interest. I'm (at this point only vaguely) toying with the idea of establishing a server to host very small files, including images.

Can you point me to some reference points at which I can figure out my hardware and software requirements ?

I envisage setting aside a dedicated PC, having a disk containing the hosted files. Running some sort of web server software, tweaked to allow access only to those IP's / individuals that I wish to share with.

For example, if I were post a link to a document on Akiba-Online, it can only be pulled by an Akiba visitor, not from elsewhere if someone copied / reposted the link. In theory, I think this is possible, but it's a nicety, not absolutely essential.

Something I have no idea about, is whether it'll run seamlessly through my regular ISP connection. Although I don't see why not - after all uTorrent, and eMule operate on these principles.

In any case, I've some research to do - just need to know where to start.

 

[Nick_Wells]

I'm working on a slightly similar concept myself. My ultimate goal is to create an online archive/review site. I'm thinking something along the lines of IAFD crossed w/ Roger T Pipes, except exclusively for Japanese AV.

I've got a spreadsheet right now that has roughly 2500 entries in it. I don't actually have that many titles in my own collection - only about 700, but as I implied, the idea is to be a centralized reference point. Of course, that's what most people use DMM for and that's cool. I'd just like to create something a little more user friendly for non-Japanese users... even if it is far less complete.

Right now, for the VIDEO sheet I've got fields for title (in the original Japanese), id (sku), release date, label, studio, run time, censored (or not), review (whether I've done one) and performer(s) (up to 21). For the GIRLS sheet I have fields for id, name-e, name-j, b-date, bplace-e, bplace-j, tall-e (ht), tall-j (ht in metric), bwh-e (measurements)and bwh-j (measurements in metric). I'm also working sheets for STUDIO and LABEL.

The plan is to eventually export each sheet from Calc into a separate table in mySQL. I don't have a lot of experience w/ databases but I understand the basics and have messed around a bit. Fortunately, a buddy of mine is a DBM who specializes in php, too. He should be able to give me enough assistance/guidance to get at least something tangible from all this.

-Nick

BTW I handle the issues of names like this: personal->family in English and using the appropriate Kanji/Hiragana/Katakana in Japanese.