Parts Libraries and Vendor parts list to simplify odering parts

Here is the closest I have found to a cross-reference:

http://www.blakerobertson.com/files/guides/pcb/eagle/lbr/partlist-5-7-05.xls

Since we all are having to cross-reference and make parts lists for our

circuits, if each of us contributed that information, we could grow a

cross-reference list with little extra effort.  If all the users will email

me theirs, I will put them together in similar format to the spreadsheet I

referenced above.

If you wish to do so, email to eagle@teccsv.biz

To email to this address, remove the letter v.

Tim

"Tim" <tec112@hotmail.com> wrote in message

news:gcgqis$plh$1@cheetah.cadsoft.de...

I am looking for a means to make ordering parts that I use in designing

PCBs easier.  It seems to me that an addition to the library of

manufacturer and part number would be useful.  Or possibly a spreadsheet

showing the library and part number with manufacturer and part number.

 

I would be happy to colaborate on making a comprehensive list of this

nature with others who use Eagle CAD.  This would save us all a ton of

time in the long run.  Maybe Mouser and Digi-key as well as other vendors

could be specified.

 

Any ideas?  Anybody want to work on this with me?  Has this already been

done?  If so, where can I get ahold of the results?

 

Please feel free to email me at

 

Tim

 

Does anyone know how to manipulate the library files directly.  Putting in

new attributes for each part would be painfully slow using the GUI.

"Tim" <tec112@hotmail.com> wrote in message

news:gcgqis$plh$1@cheetah.cadsoft.de...

I am looking for a means to make ordering parts that I use in designing

PCBs easier.  It seems to me that an addition to the library of

manufacturer and part number would be useful.  Or possibly a spreadsheet

showing the library and part number with manufacturer and part number.

 

I would be happy to colaborate on making a comprehensive list of this

nature with others who use Eagle CAD.  This would save us all a ton of

time in the long run.  Maybe Mouser and Digi-key as well as other vendors

could be specified.

 

Any ideas?  Anybody want to work on this with me?  Has this already been

done?  If so, where can I get ahold of the results?

 

Please feel free to email me at

 

Tim

 

Joerg wrote:

David Pollum wrote:

 

Joerg wrote:

 

Eldon Hiebert wrote:

 

"Wouter Mense" <woutermense@gmail.com> wrote in message

news:op.uiq3t5ee5mc67z@compwouter.pm12.nl...

 

On Wed, 08 Oct 2008 22:22:01 +0200, Joerg

<notthisjoergsch@removethispacbell.net> wrote:

 

Tim wrote:

 

Would anyone like to divide up the libraries between us and start

putting in part numbers once we figure out the use of the extra

fields in the library that Joerg mentioned?

 

Anyhow, be careful. For example, there are literally dozens of

part numbers for, say, the ubiquitous 0.1uF 0805 cap. Some folks

need a higher voltage and can live with Z5U ceramic, others don't

need high voltage but almost get a heart attack if the ceramic

material isn't at least X7R.

 

And also resistors. It would be nice if there was a way to also

take into account the value in order to generate a part number.

Like just put in the required specifications and suitable parts are

loaded from the ordercode database or something.

 

 

The current BOM ulp allows for the loading of a parts database.

However, I was confused as to how the parts database gets XREF'd to

the part numbers in the libs.

 

Really, the parts vendors should provide some assistance in this

matter. If digikey wants us to buy their supply lines then shouldn't

THEY supply a XREF database from manufacturer part number to their

catalogue numbering scheme???

 

This gets complicated by susbstitutions of the same parts made by

more than one manufacturer. For example, here are many manufacturers

of a simple 1206 SMD resistor. But some of them vary widely in

price. I know we would all like to minimize cost of manufacture.

 

Its not really possible to create a global parts database. The parts

I select may not be the ones someone in Europe would choose, due to

cost of locality (shipping, duty, taxes, etc).

 

Does Digikey have a database of their inventory?

 

 

Something similar already exists but I am afraid they may have signed

an exclusive deal:

 

http://eepn.com/Locator/Products/ArticleID/16321/Action/Issue/16321.html

 

 

I saw a demo of this at PCB West last month.  It was pretty cool -

realtime check of Digikey's inventory.  The vendor is EMA Design

Automation.

 

 

Probably they offered you a seat before telling you the price

 

They were the only vendor there with a demo and they were encouraging

people to have a seat and watch the demo.  So "why not".  I don't recall

if they mentioned the price or not.  They scanned my badge and later

sent me an email, which I didn't answer.  Their product only worked with

OrCAD.

And speaking of OrCAD, the Cadence web site actually had prices!  I

can't remember if the price was $4K or $5K, but I do remember that the

price included a $1,000 maintenance fee.  That's fee is almost the price

of EAGLE!

-Dave Pollum

David Pollum wrote:

Joerg wrote:

 

Eldon Hiebert wrote:

 

"Wouter Mense" <woutermense@gmail.com> wrote in message

news:op.uiq3t5ee5mc67z@compwouter.pm12.nl...

 

On Wed, 08 Oct 2008 22:22:01 +0200, Joerg

<notthisjoergsch@removethispacbell.net> wrote:

 

Tim wrote:

 

Would anyone like to divide up the libraries between us and start

putting in part numbers once we figure out the use of the extra

fields in the library that Joerg mentioned?

 

Anyhow, be careful. For example, there are literally dozens of part

numbers for, say, the ubiquitous 0.1uF 0805 cap. Some folks need a

higher voltage and can live with Z5U ceramic, others don't need

high voltage but almost get a heart attack if the ceramic material

isn't at least X7R.

 

And also resistors. It would be nice if there was a way to also take

into account the value in order to generate a part number. Like just

put in the required specifications and suitable parts are loaded

from the ordercode database or something.

 

The current BOM ulp allows for the loading of a parts database.

However, I was confused as to how the parts database gets XREF'd to

the part numbers in the libs.

 

Really, the parts vendors should provide some assistance in this

matter. If digikey wants us to buy their supply lines then shouldn't

THEY supply a XREF database from manufacturer part number to their

catalogue numbering scheme???

 

This gets complicated by susbstitutions of the same parts made by

more than one manufacturer. For example, here are many manufacturers

of a simple 1206 SMD resistor. But some of them vary widely in price.

I know we would all like to minimize cost of manufacture.

 

Its not really possible to create a global parts database. The parts

I select may not be the ones someone in Europe would choose, due to

cost of locality (shipping, duty, taxes, etc).

 

Does Digikey have a database of their inventory?

 

 

Something similar already exists but I am afraid they may have signed

an exclusive deal:

 

http://eepn.com/Locator/Products/ArticleID/16321/Action/Issue/16321.html

 

I saw a demo of this at PCB West last month.  It was pretty cool -

realtime check of Digikey's inventory.  The vendor is EMA Design

Automation.

 

Probably they offered you a seat before telling you the price

--

Regards, Joerg

http://www.analogconsultants.com/

"gmail" domain blocked because of excessive spam.

Use another domain or send PM.

On Tue, 7 Oct 2008 19:15:44 -0400, Tim wrote

(in article <gcgqis$plh$1@cheetah.cadsoft.de>):

I am looking for a means to make ordering parts that I use in designing PCBs

easier.  It seems to me that an addition to the library of manufacturer and

part number would be useful.  Or possibly a spreadsheet showing the library

and part number with manufacturer and part number.

 

I would be happy to colaborate on making a comprehensive list of this nature

with others who use Eagle CAD.  This would save us all a ton of time in the

long run.  Maybe Mouser and Digi-key as well as other vendors could be

specified.

 

Any ideas?  Anybody want to work on this with me?  Has this already been

done?  If so, where can I get ahold of the results?

Hello Tim,

We are currently working on an EAGLE tool that is related.  We are working

with a major distributor (can't say who yet but you all know who it is) to

tap into their database of parts and extract real-time pricing and

confirmation of part numbers and ROHS status.

It does make use of the attributes that are now available in EAGLE 5 and the

ability to make system calls.  With those two items we can do a lot!

It's not quite as real-time as the EMA Design tool as there just aren't the

hooks in EAGLE to do that--it would have to be done in the actual program. 

But at any time you can run this tool and it will create a BOM and then

cross-reference that BOM against the disty database and extract the data. 

You'll know right away if there are shortages or errors in your part numbers

The core of it is just a JAVA app (runs on all platforms) that takes a .csv

file with minimum requirements and then adds the info into an output .csv

file.  So it will actually work with any EDA tool that can create the BOM in

the right format (very simple, most can).

Expect to see more in a month or two as we are just entering beta right now. 

I know how much time this is going to save me and I'm sure everyone else will

benefit as well.

The price hasn't been set but will be somewhere from $100-150 range.

Cheers,

James.

-

 James Morrison  ~~~  Stratford Digital

 email:  sales@eagletoolkit.com

 fax:    888.701.8097

 web:    http://www.eagletoolkit.com

 Online EAGLE Dealer for US and Canada

 EAGLE Design Experts

 EAGLE Enterprise Toolkit

-

Joerg wrote:

Eldon Hiebert wrote:

 

"Wouter Mense" <woutermense@gmail.com> wrote in message

news:op.uiq3t5ee5mc67z@compwouter.pm12.nl...

 

On Wed, 08 Oct 2008 22:22:01 +0200, Joerg

<notthisjoergsch@removethispacbell.net> wrote:

 

Tim wrote:

 

Would anyone like to divide up the libraries between us and start

putting in part numbers once we figure out the use of the extra

fields in the library that Joerg mentioned?

 

Anyhow, be careful. For example, there are literally dozens of part

numbers for, say, the ubiquitous 0.1uF 0805 cap. Some folks need a

higher voltage and can live with Z5U ceramic, others don't need high

voltage but almost get a heart attack if the ceramic material isn't

at least X7R.

 

And also resistors. It would be nice if there was a way to also take

into account the value in order to generate a part number. Like just

put in the required specifications and suitable parts are loaded from

the ordercode database or something.

 

The current BOM ulp allows for the loading of a parts database.

However, I was confused as to how the parts database gets XREF'd to

the part numbers in the libs.

 

Really, the parts vendors should provide some assistance in this

matter. If digikey wants us to buy their supply lines then shouldn't

THEY supply a XREF database from manufacturer part number to their

catalogue numbering scheme???

 

This gets complicated by susbstitutions of the same parts made by more

than one manufacturer. For example, here are many manufacturers of a

simple 1206 SMD resistor. But some of them vary widely in price. I

know we would all like to minimize cost of manufacture.

 

Its not really possible to create a global parts database. The parts I

select may not be the ones someone in Europe would choose, due to cost

of locality (shipping, duty, taxes, etc).

 

Does Digikey have a database of their inventory?

 

 

Something similar already exists but I am afraid they may have signed an

exclusive deal:

 

http://eepn.com/Locator/Products/ArticleID/16321/Action/Issue/16321.html

I saw a demo of this at PCB West last month.  It was pretty cool -

realtime check of Digikey's inventory.  The vendor is EMA Design

Automation.

-Dave Pollum

Eldon Hiebert wrote:

"Wouter Mense" <woutermense@gmail.com> wrote in message

news:op.uiq3t5ee5mc67z@compwouter.pm12.nl...

On Wed, 08 Oct 2008 22:22:01 +0200, Joerg

<notthisjoergsch@removethispacbell.net> wrote:

 

Tim wrote:

Would anyone like to divide up the libraries between us and start

putting in part numbers once we figure out the use of the extra fields

in the library that Joerg mentioned?

Anyhow, be careful. For example, there are literally dozens of part

numbers for, say, the ubiquitous 0.1uF 0805 cap. Some folks need a

higher voltage and can live with Z5U ceramic, others don't need high

voltage but almost get a heart attack if the ceramic material isn't at

least X7R.

And also resistors. It would be nice if there was a way to also take into

account the value in order to generate a part number. Like just put in the

required specifications and suitable parts are loaded from the ordercode

database or something.

 

The current BOM ulp allows for the loading of a parts database. However, I

was confused as to how the parts database gets XREF'd to the part numbers in

the libs.

 

Really, the parts vendors should provide some assistance in this matter. If

digikey wants us to buy their supply lines then shouldn't THEY supply a XREF

database from manufacturer part number to their catalogue numbering

scheme???

 

This gets complicated by susbstitutions of the same parts made by more than

one manufacturer. For example, here are many manufacturers of a simple 1206

SMD resistor. But some of them vary widely in price. I know we would all

like to minimize cost of manufacture.

 

Its not really possible to create a global parts database. The parts I

select may not be the ones someone in Europe would choose, due to cost of

locality (shipping, duty, taxes, etc).

 

Does Digikey have a database of their inventory?

 

Something similar already exists but I am afraid they may have signed an

exclusive deal:

http://eepn.com/Locator/Products/ArticleID/16321/Action/Issue/16321.html

Except for the "in-stock" hickup Digikey has the best search engine

since sliced bread but they still do not allow sorting by price. Some

manufacturers do, for example ON Semi. Probably some kind of bot could

do that I guess.

--

Regards, Joerg

http://www.analogconsultants.com/

"gmail" domain blocked because of excessive spam.

Use another domain or send PM.

"Wouter Mense" <woutermense@gmail.com> wrote in message

news:op.uiq3t5ee5mc67z@compwouter.pm12.nl...

On Wed, 08 Oct 2008 22:22:01 +0200, Joerg

<notthisjoergsch@removethispacbell.net> wrote:

 

Tim wrote:

Would anyone like to divide up the libraries between us and start

putting in part numbers once we figure out the use of the extra fields

in the library that Joerg mentioned?

Anyhow, be careful. For example, there are literally dozens of part

numbers for, say, the ubiquitous 0.1uF 0805 cap. Some folks need a

higher voltage and can live with Z5U ceramic, others don't need high

voltage but almost get a heart attack if the ceramic material isn't at

least X7R.

And also resistors. It would be nice if there was a way to also take into

account the value in order to generate a part number. Like just put in the

required specifications and suitable parts are loaded from the ordercode

database or something.

The current BOM ulp allows for the loading of a parts database. However, I

was confused as to how the parts database gets XREF'd to the part numbers in

the libs.

Really, the parts vendors should provide some assistance in this matter. If

digikey wants us to buy their supply lines then shouldn't THEY supply a XREF

database from manufacturer part number to their catalogue numbering

scheme???

This gets complicated by susbstitutions of the same parts made by more than

one manufacturer. For example, here are many manufacturers of a simple 1206

SMD resistor. But some of them vary widely in price. I know we would all

like to minimize cost of manufacture.

Its not really possible to create a global parts database. The parts I

select may not be the ones someone in Europe would choose, due to cost of

locality (shipping, duty, taxes, etc).

Does Digikey have a database of their inventory?

Thanks,

Eldon.

Wouter Mense wrote:

On Wed, 08 Oct 2008 22:22:01 +0200, Joerg

<notthisjoergsch@removethispacbell.net> wrote:

 

Tim wrote:

Would anyone like to divide up the libraries between us and start

putting in part numbers once we figure out the use of the extra

fields in the library that Joerg mentioned?

IMHO for R and C values this would not be the best way to go about it as you

then need a separate R , C value for each defined value tolerance, material

combination, etc.

Anyhow, be careful. For example, there are literally dozens of part

numbers for, say, the ubiquitous 0.1uF 0805 cap. Some folks need a

higher voltage and can live with Z5U ceramic, others don't need high

voltage but almost get a heart attack if the ceramic material isn't at

least X7R.

And also resistors. It would be nice if there was a way to also take

into account the value in order to generate a part number. Like just put

in the required specifications and suitable parts are loaded from the

ordercode database or something.

Have a look at the BOM-am series of ULPs- available from the cadsoft

download area I believe

What I'd suggest is that you develop external databases to use with the

BOM-Am series of ULP's.  You then need to define a standard format for

adding the fields to the parts in the sch/brd,and then these keys are used

to look up the BOM-am database via the ULP.  Not sure how this works with v5

The data base is also much easier to maintain as it is essentially in  a

format that can be edited in excel or a.n. other spreadsheet.

cheers

David

On Wed, 08 Oct 2008 22:22:01 +0200, Joerg 

<notthisjoergsch@removethispacbell.net> wrote:

Tim wrote:

Would anyone like to divide up the libraries between us and start 

putting in part numbers once we figure out the use of the extra fields 

in the library that Joerg mentioned?

Anyhow, be careful. For example, there are literally dozens of part 

numbers for, say, the ubiquitous 0.1uF 0805 cap. Some folks need a 

higher voltage and can live with Z5U ceramic, others don't need high 

voltage but almost get a heart attack if the ceramic material isn't at 

least X7R.

And also resistors. It would be nice if there was a way to also take into 

account the value in order to generate a part number. Like just put in the 

required specifications and suitable parts are loaded from the ordercode 

database or something.