Seems to work. The attached file is not really a zip file, but an Excel .xls file with just the extension changed to .zip.
Another reason I didn't suggest that was that some people keep the Windows default setting of hiding the extension of known file types. So if they try to rename the file abc.xls, they would actually end up with something like abc.zip.xls (with the ".xls" part hidden the entire time).
Inventory software
Moderator: admin
- Attachments
-
[The extension zip has been deactivated and can no longer be displayed.]
Heath
Central Louisiana
-10ER - SN 13927, Born 1949, Acquired October 2008, Restored November, 2008
-10ER - SN 35630, Born 1950, Acquired April 2009, Restored May 2009, A34 Jigsaw
-Mark V - SN 212052, Born 1986, Acquired Sept 2009, Restored March 2010, Bandsaw
-10ER - SN 39722, Born 1950, Acquired March 2011, awaiting restoration
Central Louisiana
-10ER - SN 13927, Born 1949, Acquired October 2008, Restored November, 2008
-10ER - SN 35630, Born 1950, Acquired April 2009, Restored May 2009, A34 Jigsaw
-Mark V - SN 212052, Born 1986, Acquired Sept 2009, Restored March 2010, Bandsaw
-10ER - SN 39722, Born 1950, Acquired March 2011, awaiting restoration
-
kd6vpe
- Platinum Member
- Posts: 585
- Joined: Mon Jun 11, 2007 8:53 pm
- Location: Owasso, Oklahoma
- Contact:
Wow,
Had no idea this was as interesting as it seems. I was trying to think ahead as my brain contiues to forget more. I wanted something that I could pull up to see what I am getting low on to make a trip to town with a shopping list of sandpaper screws and other consumables. Tool inventory is also I nice thought. I guess I will have to build up a database and if I can get one made up that works I will let you all know. Sounds like most of you have access so I guess visual basic would work for creating the application. Dont too excited I am by no means a programmer but I can create a database and attach a form to it.
Had no idea this was as interesting as it seems. I was trying to think ahead as my brain contiues to forget more. I wanted something that I could pull up to see what I am getting low on to make a trip to town with a shopping list of sandpaper screws and other consumables. Tool inventory is also I nice thought. I guess I will have to build up a database and if I can get one made up that works I will let you all know. Sounds like most of you have access so I guess visual basic would work for creating the application. Dont too excited I am by no means a programmer but I can create a database and attach a form to it.
SS 500 upgraded to 510; SS bandsaw; SS jointer
SS Oscillating Drum Sander; Universal Lathe Rest;
lathe duplicatior, shaper fence and shapers; SS Belt
Sander
Jim
www.youtube.com/kd6vpe
SS Oscillating Drum Sander; Universal Lathe Rest;
lathe duplicatior, shaper fence and shapers; SS Belt
Sander
Jim
www.youtube.com/kd6vpe
While I can see the usefulness of such a thing, it would require manual updating and I know that I would never update it. So the file/database would be inaccurate after the first change to my "inventory."
Heath
Central Louisiana
-10ER - SN 13927, Born 1949, Acquired October 2008, Restored November, 2008
-10ER - SN 35630, Born 1950, Acquired April 2009, Restored May 2009, A34 Jigsaw
-Mark V - SN 212052, Born 1986, Acquired Sept 2009, Restored March 2010, Bandsaw
-10ER - SN 39722, Born 1950, Acquired March 2011, awaiting restoration
Central Louisiana
-10ER - SN 13927, Born 1949, Acquired October 2008, Restored November, 2008
-10ER - SN 35630, Born 1950, Acquired April 2009, Restored May 2009, A34 Jigsaw
-Mark V - SN 212052, Born 1986, Acquired Sept 2009, Restored March 2010, Bandsaw
-10ER - SN 39722, Born 1950, Acquired March 2011, awaiting restoration
-
kd6vpe
- Platinum Member
- Posts: 585
- Joined: Mon Jun 11, 2007 8:53 pm
- Location: Owasso, Oklahoma
- Contact:
So,
Something like having a project with the parts list that could be read with a scanner and auto populate the database so when you create the project it auto updates and also the next time you want to build the same project it could know in advance what you need and let you know if you are low on something before you start the project. HMMM very nice thinking there thank you that gives me some ideas now.
Something like having a project with the parts list that could be read with a scanner and auto populate the database so when you create the project it auto updates and also the next time you want to build the same project it could know in advance what you need and let you know if you are low on something before you start the project. HMMM very nice thinking there thank you that gives me some ideas now.
SS 500 upgraded to 510; SS bandsaw; SS jointer
SS Oscillating Drum Sander; Universal Lathe Rest;
lathe duplicatior, shaper fence and shapers; SS Belt
Sander
Jim
www.youtube.com/kd6vpe
SS Oscillating Drum Sander; Universal Lathe Rest;
lathe duplicatior, shaper fence and shapers; SS Belt
Sander
Jim
www.youtube.com/kd6vpe
-
robinson46176
- Platinum Member
- Posts: 4182
- Joined: Mon Mar 09, 2009 9:00 pm
- Location: Central Indiana (Shelbyville)
My inventory only has one entry. It just says "stuff". 
I spent much of my life doing stuff like inventory etc. but I am retired now. I don't have to... I don't want to... And I'm not going to...
OK, I'll leave everybody alone now.
I spent much of my life doing stuff like inventory etc. but I am retired now. I don't have to... I don't want to... And I'm not going to...
OK, I'll leave everybody alone now.
--
farmer
Francis Robinson
I did not equip with Shopsmiths in spite of the setups but because of them.
1 1988 - Mark V 510 (bought new), 4 Poly vee 1 1/8th HP Mark V's, Mark VII, 1 Mark V Mini, 1 Frankensmith, 1 10-ER, 1 Mark V Push-me-Pull-me Drillpress, SS bandsaw, belt sander, jointer, jigsaw, shaper attach, mortising attach, TS-3650 Rigid tablesaw, RAS, 6" long bed jointer, Foley/Belsaw Planer/molder/ripsaw, 1" sander, oscillating spindle/belt sander, Scroll saw, Woodmizer sawmill
farmer
Francis Robinson
I did not equip with Shopsmiths in spite of the setups but because of them.
1 1988 - Mark V 510 (bought new), 4 Poly vee 1 1/8th HP Mark V's, Mark VII, 1 Mark V Mini, 1 Frankensmith, 1 10-ER, 1 Mark V Push-me-Pull-me Drillpress, SS bandsaw, belt sander, jointer, jigsaw, shaper attach, mortising attach, TS-3650 Rigid tablesaw, RAS, 6" long bed jointer, Foley/Belsaw Planer/molder/ripsaw, 1" sander, oscillating spindle/belt sander, Scroll saw, Woodmizer sawmill
-
dusty
- Platinum Member
- Posts: 21530
- Joined: Wed Nov 22, 2006 6:52 am
- Location: Tucson (Wildcat Country), Arizona
heathicus wrote:Seems to work. The attached file is not really a zip file, but an Excel .xls file with just the extension changed to .zip.
Another reason I didn't suggest that was that some people keep the Windows default setting of hiding the extension of known file types. So if they try to rename the file abc.xls, they would actually end up with something like abc.zip.xls (with the ".xls" part hidden the entire time).
This is a nice format. I may change some of the titles but this provides a much more user friendly spread sheet than does mine. I did copy mine into it and it works. The data is in the wrong columns but that it very easily correvted. Thanks for cleaning up my listing.
"Making Sawdust Safely"
Dusty
Sent from my Dell XPS using Firefox.
Dusty
Sent from my Dell XPS using Firefox.
-
wlhayesmfs
- Platinum Member
- Posts: 667
- Joined: Fri Jul 21, 2006 10:50 am
- Location: Broken Arrow OK
one of the guys on the pen turners site has a program to track all of his pen parts and turning wood. No a bad program and could me modified to track parts or tools probably
Bill
Broken Arrow OK
MKV, 510, MKVll, 50th Anniversary 520 with Jointech saw train, Bandsaw, scroll saw, joiner, 6" Sander,Stand Alone Pin Router and Router Table, Strip Sander, Jigsaw & (4) ER's plus Jigsaw for ER. DC SS RAS
Broken Arrow OK
MKV, 510, MKVll, 50th Anniversary 520 with Jointech saw train, Bandsaw, scroll saw, joiner, 6" Sander,Stand Alone Pin Router and Router Table, Strip Sander, Jigsaw & (4) ER's plus Jigsaw for ER. DC SS RAS
-
curiousgeorge
- Platinum Member
- Posts: 880
- Joined: Tue Feb 27, 2007 1:00 am
- Location: Fort Worth, Texas
I use a program called "Everything I Own". It has provisions for any info you need for anything you own as well as the ability to attach a picture of the item. It is ideal for insurance purposes and for keeping track of where they are stored or for just keeping tabs on how much you have spent on tools, etc. I downloaded it from:
http://www.mycroftcomputing.com/eiown.html
It costs $19.95 to download or $24.95 for a CD. They also have a free trial version you can download.
http://www.mycroftcomputing.com/eiown.html
It costs $19.95 to download or $24.95 for a CD. They also have a free trial version you can download.
George
Ft. Worth, TX.
Go TCU Froggies
Ft. Worth, TX.
Go TCU Froggies
-
terrydowning
- Platinum Member
- Posts: 1678
- Joined: Mon Jul 19, 2010 3:26 pm
- Location: Windsor, CO
Here Here I totally agree!burkhome wrote:You guys are making shop time sound like going to work every day. I go there to forget inventory programs.
--
Terry
Copy and paste the URLs into your browser if you want to see the photos.
1955 Shopsmith Mark 5 S/N 296860 Workshop and Tools
https://1drv.ms/i/s!AmpX5k8IhN7ahFCo9VvTDsCpoV_g
Public Photos of Projects
http://sdrv.ms/MaXNLX
Terry
Copy and paste the URLs into your browser if you want to see the photos.
1955 Shopsmith Mark 5 S/N 296860 Workshop and Tools
https://1drv.ms/i/s!AmpX5k8IhN7ahFCo9VvTDsCpoV_g
Public Photos of Projects
http://sdrv.ms/MaXNLX