Keeping track of my toys

kiev4a

Well-known
Local time
5:46 AM
Joined
Feb 25, 2005
Messages
999
Just finished putting together an Access database listing all of my equipment, along with photos. Still have some small stuff to enter but it contains all the major equipment and some notes on where, when and how I acquired each piece, I keep a seond copy at another location for insurance purposes. It's interesting as I sell and acquire equipment because even after a camera or lens has gone I have information on where it went. It's only 218 Megs! Of course a lot of that is the photos.
 
kiev4a said:
Just finished putting together an Access database listing all of my equipment, along with photos. Still have some small stuff to enter but it contains all the major equipment and some notes on where, when and how I acquired each piece, I keep a seond copy at another location for insurance purposes. It's interesting as I sell and acquire equipment because even after a camera or lens has gone I have information on where it went. It's only 218 Megs! Of course a lot of that is the photos.

I've been thinking of something like that for a long time. I saw this on eBoy:

Collection Software - Click Here

I don't know if this stuff is any good - I never ordered it because I'm no longer running Windows/Mac - only Linux. I might see if I can duplicate some of the functionality at some point in Perl/TK - presuming I ever get any free time.

Congrats on getting organized!

Best Regards,

Bill Mattocks
 
kiev4a said:
Just finished putting together an Access database listing all of my equipment, along with photos.
Cool! Good for including notes about CLA and other repair/service too. I did this too (with FileMaker rather than Access), and it's been incredibly useful. I'd like to see how you laid out your form.

Let's see if I can find a typical record and attach a snap of it... Most of the info is in a big scrolling notes field, but some specs have their own fields for purposes of different sorting and such... I even include photo gear other than cameras and lenses... filters, for instance -- who can otherwise remember what filters in what sizes and where they are currently located? 😀
 
Keep this in mind also, folks. For those of us living in the USA, your homeowner's insurance may not cover an extensive collection of anything small and expensive, such as jewelry, cameras, and firearms. Such things require additional named coverage and a (usually) small fee to be added to the policy. A record such as the ones you're talking about is invaluable in establishing that the lenses, cameras, even filters exist, what you paid, when you bought them, and in what condition they were in.

Insurance companies are used to people having fires or burglaries and then suddenly remembering that they had six Rolex watches and a Van Gogh in the living room. Without documentation, many will refuse to cover such 'losses'.

If you use a program like the ones described, consider making a hard copy or CD-ROM and putting it in a safe deposit box or sending it to your insurance agent, and letting them know so that they can discuss how you can protect your investment by insuring it against risks just like you do your house.

FYI - I'm not an insurance guy, and I have no interest in any such thing. I work for a bank that also owns insurance companies, though. I'm just a computer guy who has suffered a burglary in the past.

Best Regards,

Bill Mattocks
 
Just a thought on Bill's excellent advice above. If you remember me saying this before, actually I don't apologize. It is important.

When we bought our first home about 15 years ago, I bought home owner's insurance. 'Sposed to, right? I had never done it before. When the agent asked how much I wanted in personal property coverage, I gave it some thought. We had a lot of possessions; furniture, appliances, clothing. I sure had some camera equipment. Little of it was new. Still, when I let him talk me into $50K for the value I was sort of uncomfortable. After all, none of it was new, right?

Well, first make sure your policy is for replacement value. Most are, but be sure. Figure out what you think is the repacement value and at least double it. Sound like an invitation to an insurance fraud investigation? Here's what happened to me.

We went to church one morning and were going to another that afternoon. We decided to stop by our house for some warmer clothing as there was to be an outdoor cookout (wintertime). We found a lot of fire equipment in front of our house. Although the house was deemed repairable, we were luckily allowed to tear it down to the foundation and rebuild, since it would cost a little bit less than to repair.

Now to our personal property. Ever try to replace mother of pearl Korean furniture in the US? No fun. Over how many years have you been buying clothing and furniture that is still quite serviceale and you in fact use? Try coming home one day and finding it all has to be replaced. My personal experience is that the burned smoke smell doesn't come out of clothing easily, even if it wasn't burned too badly to be saved as most of ours was. How about your home furnisings; photos, rugs, etc.

Point being, all of a sudden, all that which had been collected over the years sudenly all had to be replaced at one time. Inflation will change the replacement cost! New fashions will cause increases. Don't be like me. Be sure you are covered. If you are too high in your estimate, you just won't use it all. No fraud there.

I lost camera equipment and books. Oh, I forgot about those. Very difficult and expensive to replace. Fortunately some of my camera gear was in my car.

As to eletronic gear, insureance companies don't even try to clean it up. The acids in smoke cause problems over time. They would rather just replace up front. My experience is the it is a toss up. Some will survive, some won't. Some will clean up on the outside, some won't.

Sorry for the long post. But it can happen. Insureance is a gamble. We are betting something will go wrong, they are betting it won't. We need to win if it goes wrong.
 
It doesn't have to be fancy, or even include photos. A spreadsheet works -- Excel, 123, or OpenOffice. Print it out every so often and put a hard copy in your safe deposit box at the bank or keep a copy in your desk at work.

Gene
 
Bill brings up a good point about insurance. My home was burglarized a while back and all my wife's jewelry was stolen. They also took cash and a pistol, but left the pistol in the yard-I think the thought of a stolen firearm was too much. Anyway, I got 0 reimbursement-It seems you need a rider on jewelry. I'll have to check with my broker about camera equipment. Stu
 
Ask your insurance agent about a Personal Articles Policy. It 's "all risk" (some exclusions apply) coverage for your gear. There are no deductibles and no adjustments for depreciation. If you drop your $2,000 lens and it breaks, you get a check to repair it or if repairs aren't possible, the value specified on the policy. If your kid spills soda on your Leica M, it's covered. If someone steals your gear, it's covered.

Most insurance companies either want a receipt for the gear if it's less than 2 years old or an appraisal before they will bind coverage. Overall, it's a great deal. This type of coverage on $20,000 worth of cameras will cost you about $264 per year. You can also insure leather jackets, laptop computers, jewelry, guns and golf clubs on the same policy.

Here are the rates I pay per $100:

Cameras.........................................$1.32
Musical Instruments ........................ $0.52
Jewelry.......................................... $1.70
Sporting Goods................................ $1.60
Computers...................................... $1.25
Cell Phones..................................... $3.50

R.J.
 
Last edited:
I keep track of my toys on my Palm PDA using a database program called JFile (although I don't use them, there are ways to convert JFile databases to Access & Filemaker format). Since I carry my PDA w/me everywhere, I always have ready access to my database, which can be useful when browsing in stores, etc. Also, the database is backed up whenever I sync the Palm w/my Mac & I also routinely back up to a SD card in the Palm itself.
 
Back
Top Bottom