Simple parts inventory program? (free or opensource)

General suggestions or questions about the SparkFun Electronics website

Moderators: phalanx, CS Paul

Simple parts inventory program? (free or opensource)

Postby george graves » Thu Jul 02, 2009 5:56 pm

Can anyone recommend a simple to inventory program?

The reason why I ask is last night it took me 7 hours to figure out what I needed to order from mouser. It was not fun trying to figure out what I had on hand, what was needed, ect..

To give you an idea of my needs - I need to keep track of about 1500 parts, and be able to group them into 30 assembles.

My budget is $0. So, even an old dos program would be fine by me. Just as long as it works.

(BTW - I don't want to roll my own in excel or access)

Any suggestions? Advice?
george graves
 
Posts: 98
Joined: Sat Jun 07, 2008 5:23 pm

Postby macegr » Thu Jul 02, 2009 6:29 pm

Openoffice.org? It has an Excel-like program.
macegr
 
Posts: 380
Joined: Wed Feb 27, 2008 4:44 pm

Postby signal7 » Sat Jul 04, 2009 6:07 am

I haven't used it, but I recall that Google has some kind of database application out there. If I find some info on it, I'll post it here.
signal7
 
Posts: 177
Joined: Fri Nov 07, 2008 7:52 am

Postby leon_heller » Sat Jul 04, 2009 6:32 am

MySQL is free and can be used with Open Office.

Leon
Leon Heller
G1HSM
User avatar
leon_heller
Support Volunteer
 
Posts: 5734
Joined: Sun May 01, 2005 11:20 am
Location: St. Leonards-on-Sea, E. Sussex, UK.

Re: Simple parts inventory program? (free or opensource)

Postby madeinoz » Mon Aug 31, 2009 12:00 am

george graves wrote:Can anyone recommend a simple to inventory program?

The reason why I ask is last night it took me 7 hours to figure out what I needed to order from mouser. It was not fun trying to figure out what I had on hand, what was needed, ect..

To give you an idea of my needs - I need to keep track of about 1500 parts, and be able to group them into 30 assembles.

My budget is $0. So, even an old dos program would be fine by me. Just as long as it works.

(BTW - I don't want to roll my own in excel or access)

Any suggestions? Advice?


you could try openerp (www.openerp.org) may be a bit of overkill though. there is an electronics inventory module for it
Wireless Widget Project (Open Source Hardware Project) - http://code.google.com/p/strobit
madeinoz
 
Posts: 34
Joined: Sat Dec 02, 2006 9:57 pm
Location: Bunbury, Western Australia

Re: Simple parts inventory program? (free or opensource)

Postby pichenettes » Thu Mar 11, 2010 5:28 pm

What I would do if I had time to work on this:

- Web-based app (AppEngine probably).
- Wiki-like parts database with links to datasheets and references for all component distributors. Links to open hardware projects using the parts ("I want to check how people are using this").
- Each user creates an account on the site and can create their own inventory using their own parts definitions or those from the collaborative wiki. Can flag parts as "general purpose" and specify the optimal quantity for restocking.
- BOM manager to create and publish BOMs + keeping track of how many units of a particular device we have stock for.
- Function to create order csvs automatically for digikey or farnell ("order the parts I need for 10 units of this device" ; "restock the parts I have flagged as general purpose").
- Geo search. Find people around me who might have a part I'm looking for.

I don't think it's that hard... Add to the wishlist... Maybe I might end up doing it :)
pichenettes
 
Posts: 12
Joined: Wed Sep 16, 2009 4:03 am

Re: Simple parts inventory program? (free or opensource)

Postby george graves » Thu Mar 11, 2010 5:42 pm

^Wow. I think you are on to something. I didn't even think of a web based application!

I'll throw in a couple of things I would like:

- slim interface that would load fast and easy on the eyes. My eyes are tried of staring at bright white text feilds.
- bar code support that you could read your own bar codes *AND* mouse/digikey/ect bar codes. I bet on each bag I get from mouser has a lot of data that I wouldn't need to hand enter in.


gg
george graves
 
Posts: 98
Joined: Sat Jun 07, 2008 5:23 pm

Re: Simple parts inventory program? (free or opensource)

Postby follower » Mon Mar 15, 2010 12:02 am

It looks like Octopart have some tools that might be useful for this: http://octopart.com/tools/

--Philip;
follower
 
Posts: 280
Joined: Sun Mar 14, 2010 11:58 pm

Re: Simple parts inventory program? (free or opensource)

Postby madeinoz » Sat Jul 03, 2010 7:40 pm

I just came across this standalone OS inventory specifically for Electronic components.

http://sourceforge.net/projects/zparts/
Wireless Widget Project (Open Source Hardware Project) - http://code.google.com/p/strobit
madeinoz
 
Posts: 34
Joined: Sat Dec 02, 2006 9:57 pm
Location: Bunbury, Western Australia

Re: Simple parts inventory program? (free or opensource)

Postby fll-freak » Tue Sep 27, 2011 7:35 am

I found an old CueCat barcode scanner in my attic and started in on a way to inventory my parts. I took the approach of just using a flat file database using Excel. I purchased a large number of ESD bags from ULine and put my own barcodes on each bag. Not sure it will make life any easier. As blogradio mentioned, once you forget to decrement a part when you use it, you are screwed.
fll-freak
Support Volunteer
 
Posts: 1518
Joined: Tue May 12, 2009 8:23 am
Location: New Hampshire, USA

Re: Simple parts inventory program? (free or opensource)

Postby ic3man5 » Sun Jan 29, 2012 5:28 pm

This is the only program I know of that does inventory management: http://www.trilogydesign.com/
$99 bucks for the cheapest version.

I've written a program that is similar, to better suit my needs with mysql as the database engine. If I get a huge push for something I could possible make something for cheap ($40 bucks) with a free version with limitation. Does anyone know of something out there that you can actually pay for?
ic3man5
 
Posts: 4
Joined: Thu Oct 13, 2011 1:25 am

Re: Simple parts inventory program? (free or opensource)

Postby rpcelectronics » Wed Feb 01, 2012 5:13 pm

I'm kind of late to the party on this, but you mentioned you use Mouser. Mouser is my best friend when it comes to keeping BOM's straight for each product. Will it track your inventory? No, but you can keep a nice online listing of BOM's for each project/product. I have invested a minimal amount of money over the last ten years on various invoicing and tracking software and I found that the NCH products were the best option for me. Not too expensive, but I know you are looking for a free option, so it's just a suggestion if you ever get to the point where you want to spend some money.

Overall, I have found a good combination of Mouser's BOM manager, some good homegrown spreadsheet systems and my NCH software has kept me on track 99% of the time.

Good luck with your project!
Jason Rausch - Amateur Radio Callsign: KE4NYV
RPC Electronics, LLC
www.rpc-electronics.com
rpcelectronics
 
Posts: 184
Joined: Thu Oct 05, 2006 3:17 pm
Location: Greenbackville, Va.

Re: Simple parts inventory program? (free or opensource)

Postby macegr » Fri Feb 03, 2012 3:07 pm

Excel spreadsheets are very commonly used for BOM management in industry. You can specify as many parameters about a part as you like, you can do on the fly calculations for cost estimates, you can put in the sizes and pad counts for manufacturing estimates, you can insert notes, you can assign hyperlinks to datasheets and part sources.

I use spreadsheets to communicate BOMs to and from PCBA companies. If you don't give them a spreadsheet at the beginning, they'll probably put it all in a spreadsheet and send it back to you for review anyway.

OpenOffice and Libre Office are free, extremely powerful tools; the spreadsheet programs have so much more untapped ability than typing numbers in cells and adding some of them up. I use Excel to design SMPS and certain analog circuits. Once you crystallize a design down to a set of functions, it's really easy to adjust parameters to come up with something for different applications or available parts.
macegr
 
Posts: 380
Joined: Wed Feb 27, 2008 4:44 pm

Re: Simple parts inventory program? (free or opensource)

Postby static » Fri May 18, 2012 4:29 pm

Hi guys

I've just deployed a web app that i created to help me keep track of my inventory. I figured why not share it with others. So i've added the login function (so everyone who signed up has their own inventory, duh ;)

check it out: http://inventory.railified.com/

note: after you signup, click on link in email to confirm. (and don't worry, i'm not gonna spam you :)

Interface is very basic and not stellar looking yet. I plan to keep on improving it as time permits (i have a long list of improvements and features i would like to add, and im of course open for suggestions)

Cheers
Alex
static
 
Posts: 17
Joined: Fri Oct 10, 2008 7:42 am

Re: Simple parts inventory program? (free or opensource)

Postby donzi » Thu Nov 01, 2012 5:57 pm

You might take a look at the following

http://www.ecdb.net/about.php

Thinking of giving it a try. what do you think.

Don
donzi
 
Posts: 9
Joined: Wed Mar 10, 2010 7:41 pm

Next

Return to SparkFun Site Questions/Comments

Who is online

Users browsing this forum: Yahoo [Bot] and 0 guests