Results 1 to 8 of 8

Thread: Shop Inventory

  1. #1
    Join Date
    May 2007
    Location
    Kansas City, Missouri
    Posts
    13,452

    Shop Inventory

    I decided it was time to get a better snapshot of what I've got in my shop, so been trying out some different inventory apps.

    The one I've chosen is an open source web based program called Home Inventory. To be honest, it doesn't work well out of the "box" but was able to determine the issues and get it working for my needs. Of the apps I looked at, I was mostly looking to track my tools, of when I bought them, models, serial numbers, and what was paid. The one I chose does this, it also allows for image uploads, and even tracks borrowed tools (not that I do this often). It also allow for different locations, so looking to use this for hardware inventory. I've got boxes of hardware I've purchase and forget that I've got them, so hopefully it will allow me to do some design around what hardware I've got on hand too.

    A bonus is that I was able to open the app from my smart phone, update records, and attach pictures of each machine on the fly.

    Click image for larger version. 

Name:	inventory.jpg 
Views:	24 
Size:	25.0 KB 
ID:	73005

    A detail view:
    Click image for larger version. 

Name:	inventory_detail.jpg 
Views:	26 
Size:	37.9 KB 
ID:	73006

    Adding a new item, there is an option to add a main picture, then an option to add additional pictures (unlimited) after you've saved the record.
    Click image for larger version. 

Name:	inventory_add.jpg 
Views:	21 
Size:	34.8 KB 
ID:	73007
    Last edited by Darren Wright; 01-07-2013 at 03:00 AM.
    Darren

    To a small child, the perfect granddad is unafraid of big dogs and fierce storms but absolutely terrified of the word “boo.” – Robert Brault

  2. #2
    Join Date
    Aug 2007
    Location
    Reno NV
    Posts
    13,361
    Not a bad idea. If you think about it, A lot of us probably have a significant investment tied up in our tools and wood and other assorted items.

    It'd be a good idea to do this, and make sure it was all covered on our insurance records...

    I know I need to do this.
    Programmer - An organism that turns coffee into software.
    If all your friends are exactly like you, What an un-interesting life it must be.
    "A door is what a dog is perpetually on the wrong side of" Ogden Nash


  3. #3
    Join Date
    Jan 2011
    Location
    Spitting distance north of Detroit Michigan
    Posts
    3,798
    Pretty cool, I like the maintenance section, be good to keep track of how many sharpening's a blade has been thru, top waxing's etc...stinkin sox to get old
    I could of used the 'lent to' more times than I care to admit, I've probably got a whole tool box full of hand tools{ie: brake tools, rivet guns, automotive specialty tools etc} floating around our tri-county area and danged if I can recall who or where has what...
    The perception of perfection is perfectly clear to everyone else

  4. #4
    Join Date
    May 2007
    Location
    Kansas City, Missouri
    Posts
    13,452
    I'm thinking of expanding the maintenance section to be a little more detailed, right now it's just a text box. Thinking about adding a category field as well to query by.
    Darren

    To a small child, the perfect granddad is unafraid of big dogs and fierce storms but absolutely terrified of the word “boo.” – Robert Brault

  5. #5
    Join Date
    Nov 2006
    Location
    Between Aledo and Fort Worth, TX
    Posts
    2,784
    I just recently took a video of the shop and all the big tools. An inventory system would be good. Not sure I'm up to the time involved to do it...but I do have plenty of time right now. Hmmm.... You said you made some refinements to the program. Is that something a normal person could do? I'm not a programmer. Since it is open source, can you share the adjustments you made? Jim.
    Coolmeadow Setters...
    Exclusively Irish!
    Home of Irish Setter Rescue of North Texas
    When Irish Eyes are smiling, they're usually up to something!!
    At a minimum, I'm Pentatoxic...but most likely, I'm a Pentaholic. There seems to be no known cure. Pentatonix, winners of The Sing Off, season 3


  6. #6
    Join Date
    May 2007
    Location
    Kansas City, Missouri
    Posts
    13,452
    Quote Originally Posted by Jim O'Dell View Post
    Is that something a normal person could do? I'm not a programmer. Since it is open source, can you share the adjustments you made? Jim.
    I'm guessing it may be beyond most folks skills, but will put together a list and maybe a release for anyone that wants to set one up on their own once I get some modifications done.

    I was just looking at the NAIC (National Association of Insurance Commisioners) site and they've got a PDF that can be printed out as well as some free mobile phone apps that can be installed on iPhone and Android. Once you add items there are options to export them for safe keeping.

    http://www.insureuonline.org/home_inventory_page.htm

    I've done the same in the past with the video camera and it is solid proof, but having actual model numbers and serial numbers will make a difference in how much the insurance company will pay out.

    To be quite honest it's not the loss factor that got me interested in doing inventory. We have a good friend that was diagnosed with a very bad form of brain cancer and his outlook isn't good, months to a couple of years at best. I know my wife wouldn't have a clue what my tools were worth and I'm thinking it would be beneficial to her in dealing with them if something were to happen to me. One field I'm looking at adding is to disclose the final destination of tool if such should happen. Some of the tools belong to my dad and feel they should go to my other family members when I'm done with them.
    Darren

    To a small child, the perfect granddad is unafraid of big dogs and fierce storms but absolutely terrified of the word “boo.” – Robert Brault

  7. #7
    Join Date
    Jun 2007
    Location
    Oceanside, So. Calif. 5 mi. to the ocean
    Posts
    4,944
    My home and shop inventories are in Excel. They are designed by a "gee nuts." Having a photo for each item is something I did not even consider. I guess I'm living up to my "gee nuts" I.Q.

    I do have photos of all (well almost all) of my tools and stuff inside of the home.

    I would have to live to age 999 years to do all of the stuff I should do...

    Sorry to be so abrupt. I have to go buy a bunch of vitamins and organic vegies.

    Enjoy,

    JimB
    First of all you have to be smarter than the machine.
    VOTING MEMBER

  8. #8
    Join Date
    Oct 2006
    Location
    Tokyo Japan
    Posts
    15,807
    That is a good idea.
    I should look into this kind of thing for an app for my iPhone for taking inventory for the L shop, the system we have now is very old and clunky, and in Japanese, I cannot read most of it, and even though my wife can read it, it might as well be in Greek, as she cannot understand it Maybe there is a simple easy app that I could use to take inventory..... got me thinking, always a dangerous thing
    The pessimist complains about the wind; the optimist expects it to change; the realist adjusts the sails.
    William Arthur Ward

Similar Threads

  1. a couple of humorous additions to the shop tool inventory
    By Dan Noren in forum Flatwork Project Showcase
    Replies: 8
    Last Post: 08-23-2012, 12:28 PM
  2. Shop inventory idea
    By Jeff Horton in forum General Woodworking Q&A
    Replies: 9
    Last Post: 08-08-2011, 02:08 AM
  3. Trying to fill my pen inventory
    By Mack Cameron in forum Lathe Project Showcase
    Replies: 8
    Last Post: 03-12-2011, 01:56 AM
  4. Do you have an inventory list of your shop contents?
    By Rob Keeble in forum General Woodworking Q&A
    Replies: 10
    Last Post: 07-04-2010, 06:18 PM
  5. Inventory for 8/15 art show
    By Bruce Shiverdecker in forum Lathe Project Showcase
    Replies: 5
    Last Post: 07-29-2009, 02:06 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •