General > General Technical Chat
Home asset/inventory tracking software/database
(1/2) > >>
Halcyon:
I'm in the process of completing an inventory of my household contents (mostly for insurance purposes) as if I had to make a claim today, I wouldn't be able to compile a complete list of my things.

I'm looking for suggestions on what you guys use. I started a spreadsheet, but I can see how it would becoming messy very quickly.

At the very least, I need to track:
- Item make/model/serial
- Item value
- Purchase information (invoice number, date, supplier)
- Item location (some small items are "assigned" to storage boxes)
- Write-off/disposal information
Ground_Loop:
I use Microsoft Access database. A database, in my opinion is far less susceptible to accidental corruption than a spreadsheet. And the data can be ordered/presented/updated much more intuitively.
Rick Law:
A video of the house content in-place is what I use.  Not only can it serve as inventory, it can also serve as proof of ownership of such item and that such item was in the house when fire/flood/thief occurred.
Halcyon:

--- Quote from: Ground_Loop on February 23, 2021, 02:58:14 am ---I use Microsoft Access database. A database, in my opinion is far less susceptible to accidental corruption than a spreadsheet. And the data can be ordered/presented/updated much more intuitively.

--- End quote ---

I should also point out, I don't use Windows. All Linux here.


--- Quote from: Rick Law on February 23, 2021, 03:39:27 am ---A video of the house content in-place is what I use.  Not only can it serve as inventory, it can also serve as proof of ownership of such item and that such item was in the house when fire/flood/thief occurred.

--- End quote ---

Good idea. Ideally the system should allow for photos/videos to be added as part of the item.
Foxxz:
For simple database projects like this I like using SQLite. Its a well known format and has libraries for every programming language. The database is simply a file you point the library to and whatever can read the file (write access requires write access to the file and directory) can access it. Pictures could be stored in the database but I'd rename them to a hash and store that in the database. Then use python, java, or whatever to build the database.

I'd probably use libreoffice calc if you're not looking to program anything. While you can put images in the spreadsheet I'm not sure that would be the best idea.
Navigation
Message Index
Next page
There was an error while thanking
Thanking...

Go to full version
Powered by SMFPacks Advanced Attachments Uploader Mod