Inventorying Miscellaneous Computer Junk?

drewhearle writes "I'm sure lots of Slashdot readers act as technical support to friends and family. I do a lot of this myself and have collected all sorts of miscellaneous computer hardware over the years, such as cases, power supplies, older memory, hard drives, cables and the like. If you're like me, you have to dig through everything and look in various closets, drawers and boxes whenever you need something. What do you use for keeping track of your inventory? Is there a full-featured open-source or freeware package out there that actually works?" Read more for what he's looking for -- sounds like a useful niche.

drewhearle continues "Ideally I'd like an open-source solution with the following features:

A web-browser-based system (or something else with LAN connectivity) that would allow me to access the inventory from multiple computers

Something to indicate where each part is, i.e. "under bed" or "behind bookshelf" :)

A way to attach one or more photos to each item

Category organization, like "hard drives," "memory," or "cables". Subcategories would be nice too.

A "notes" field for each item, to save misc. information

Search functionality, so I could search by category or text-search any field.

I'm probably asking too much, but if there isn't [widely available] software out there like this, maybe somebody has developed something similar for themselves and would be willing to share."

Comments

hardware solution

[yarbo]

I use filing cabinets. Each drawer has a label on the front (drives, cables, fans, etc...). Each item goes in the designated drawer when I receive it. Cases go somewhere else.

Why spreadsheets?

[Dibblah]

Why oh why is everyone's first reaction a spreadsheet?

Spreadsheets == handling of numbers
Databases == handling of data

Spreadsheets are not originally designed for searching or indexing. Spreadsheets have no good concept of interrelations.

Use the right tool for the job, for a change.

Re:Why spreadsheets?

[adolf]

Databases are cool, but they're almost useless by themselves. Are we supposed to grok SQL statements every day just to locate a SCSI adapter?

What front-end software would you suggest be used for a home-oriented inventory control system?

Or is learning Perl, Tcl, PHP, HTML, and/or C, along with SQL and the different various features of available engines a prerequisite for organizing one's computer cruft? What a weighty project to undertake.

I maintain a good bit of inventory/stuff at home. Here's how I do it:

A cheap medium-size (~4 foot) rollaway toolbox. Individual components (resistors, caps, LEDs), in one drawer. Fasteners get their own drawer. Bundled cables in one. Small PC-card based items like RAM and CPUs get their own drawer. Add-on cards in another. Large items (fans, odd case hardware) get their own drawer. Power supplies and the like end up in the cabinet in the bottom of the box.

When I run out of space in one of these compartments, I start throwing things away, in order of age. An interesting side effect of this is that other things tend to disappear at the same time - a 12" amber monochrome monitor is a lot less useful after you toss the 15-year-old full-length ISA control card for it.