Parts Libraries and Vendor parts list to simplify odering parts

Tim wrote:

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

 

AFAIK Eagle version 5 has additional attribute fields. I don't own that

version but it should be possible to add i.e. a Digikey P/N, a

manufacturer P/N and the manufacturer. Plus probably more if needed.

Then it should be fairly simple to generate a BOM that spits all this

out in a format your purchasing folks can use. However, automatic

sprinkling into a Digikey order form would be a tall order I guess. I've

heard the new OrCad might be able to do that but not sure.

Anyhow, that's how I did it in the days of OrCad SDT. It has 8 part

fields of which only two were occupied. So I used a third for the

internal part numbers clients had assigned, those 4+4 digit sequences we

all know. Ah, the good old days when everything was DOS-based and you

could still repair your car ...

--

Regards, Joerg

http://www.analogconsultants.com/

"gmail" domain blocked because of excessive spam.

Use another domain or send PM.

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?

Tim

"Joerg" <notthisjoergsch@removethispacbell.net> wrote in message

news:gch225$d9s$1@cheetah.cadsoft.de...

Tim wrote:

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

 

 

AFAIK Eagle version 5 has additional attribute fields. I don't own that

version but it should be possible to add i.e. a Digikey P/N, a

manufacturer P/N and the manufacturer. Plus probably more if needed. Then

it should be fairly simple to generate a BOM that spits all this out in a

format your purchasing folks can use. However, automatic sprinkling into a

Digikey order form would be a tall order I guess. I've heard the new OrCad

might be able to do that but not sure.

 

Anyhow, that's how I did it in the days of OrCad SDT. It has 8 part fields

of which only two were occupied. So I used a third for the internal part

numbers clients had assigned, those 4+4 digit sequences we all know. Ah,

the good old days when everything was DOS-based and you could still repair

your car ...

 

--

Regards, Joerg

 

http://www.analogconsultants.com/

 

"gmail" domain blocked because of excessive spam.

Use another domain or send PM.

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?

 

I'd love to but I am probably just about to switch to gschem because I

need hierarchical sheet structures.

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.

Tim

"Joerg" <notthisjoergsch@removethispacbell.net> wrote in message

news:gch225$d9s$1@cheetah.cadsoft.de...

Tim wrote:

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

 

AFAIK Eagle version 5 has additional attribute fields. I don't own that

version but it should be possible to add i.e. a Digikey P/N, a

manufacturer P/N and the manufacturer. Plus probably more if needed. Then

it should be fairly simple to generate a BOM that spits all this out in a

format your purchasing folks can use. However, automatic sprinkling into a

Digikey order form would be a tall order I guess. I've heard the new OrCad

might be able to do that but not sure.

 

Anyhow, that's how I did it in the days of OrCad SDT. It has 8 part fields

of which only two were occupied. So I used a third for the internal part

numbers clients had assigned, those 4+4 digit sequences we all know. Ah,

the good old days when everything was DOS-based and you could still repair

your car ...

 

--

Regards, Joerg

 

http://www.analogconsultants.com/

 

"gmail" domain blocked because of excessive spam.

Use another domain or send PM.

--

Regards, Joerg

http://www.analogconsultants.com/

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.

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

"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.

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.

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

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

-

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.