RE: [Project] Home Inventory System

["Graham Howe" <graham@xxxxxxx>]

This is also on my list of things to do. I intend to make it web based
(easy
to call up stuff from ePODs) with a database on the back end (probably SQL7
as I have it installed already, but access would be just as easy). I would
not actually hold photos in the database, just the links to them so that
they appear on the screen when required.

I would probably have serial number as a field on all items (for groceries
it could hold bar code number) but make it optional, likewise with
photograph link. Location would be a mandatory field (the system would have
an admin mode for creating and deleting locations etc), as would
description. Purchase date might be on there too for tracking expiry of
food
and expiry of warranties.

Stock levels would really only count for consumables, but it wouldn't do
any
harm to have a figure against other items. A flag could indicate those
items
that needed to be stock managed and combined with an optional re-order
point
quantity, shopping list could be created quite easily. Of course it is
essential to have stock correctly updated when items are purchased and
consumed (this is where I like the idea of bar code tracking though it
would
take a while to populate the list).

The next stage would be for my kitchen mounted ePOD to scour the internet
for recipes that can be made with the contents of my cupboards, fridge and
freezer! The it's just a question of getting robots to do the cooking and
I'm sorted!

Graham

-----Original Message-----
From: Stuart Grimshaw [mailto:stuart@xxxxxxx]
Sent: 21 May 2001 14:14
To: ukha_d@xxxxxxx
Subject: [ukha_d] [Project] Home Inventory System


I've wanted to write a home inventory system for a long while. I have the
same problem as most people, I forget who I lend stuff to. So I'd like a
system to keep track of that.

But also I'd like a system to keep a complete home inventory, with
electrical
item serial numbers, descriptions & photo's of valuable objects and
other
things to aid police identify anythig stolen from my home.

Another cool feature I'd like to implement would be stock tracking, what I
have available to eat in the kitchen, how many bog rolls are left in the
toilet. These levels could then be used to create shopping lists, and maybe
even at some stage do the ordering.

--
,,,
(o o)
===========================oOO==(_)==OOo==============================
Stuart Grimshaw         www.schoolsnet.com          sg@xxxxxxx
Special Projects Developer                            t: 07976 625221
Schoolsnet LTD             .oooO  Oooo.               f: 0870 7060260
===========================(   )==(   )===============================
\ (    ) /
\_)  (_/



Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/







Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/