Mail Archives: geda-user/2016/02/28/16:00:25
--Apple-Mail=_EA514860-A126-48DF-B63E-2A78ABFA40F3
Content-Transfer-Encoding: quoted-printable
Content-Type: text/plain;
charset=windows-1252
On Feb 28, 2016, at 1:12 PM, Nicklas Karlsson =
(nicklas DOT karlsson17 AT gmail DOT com) [via geda-user AT delorie DOT com] =
<geda-user AT delorie DOT com> wrote:
>>> A BOM generator which automatically heavify symbols with ordering
>>> information is what I ultimately want to write. Of course there have
>>> to be a database with values to pick from.
>>=20
>> Keith and I recently put something like this together for Altus =
Metrum.
>>=20
>> We now, by default, only set three attributes on a part: 'device',
>> 'footprint', and 'value'. We have a "preferred parts" database =
that's
>> just a tab-separated-values flat file, and a couple awk scripts that
>> take the attributes for each part in a csv file, use the triplet =
above
>> to index into the database, and fill in any missing attributes.
>>=20
>> This means that for almost all parts, we only have one place to =
update
>> when we change manufacturer part data or vendor info for our =
'preferred
>> parts', yet we can override any attribute we need to on a per-design
>> basis. ...
>=20
> In particular there will be no need to update schematic then there are =
no changes to schematic.
>=20
> This is particularly useful if there is a need for distributor part =
number.
>=20
>=20
> Nicklas Karlsson
>=20
What I do is to make a key from four attributes: device, value, spec, =
and footprint. Spec is something like =9350WVDC X7R=94 or =931% 1/10W=94. =
Together, these form a sufficiently unique key to identify a part.
But it gets tricky then, because there are generally separate =
organizations involved with their own approaches. The folks who order =
parts will have a =93database=94 (really a spreadsheet) of approved =
parts. The board assembly house will have their own form they want. So, =
I have to customize the scripts frequently. One project has used three =
different layout shops and four different assembly shops for different =
phases.
John Doty Noqsi Aerospace, Ltd.
http://www.noqsi.com/
jpd AT noqsi DOT com
--Apple-Mail=_EA514860-A126-48DF-B63E-2A78ABFA40F3
Content-Transfer-Encoding: 7bit
Content-Disposition: attachment;
filename=signature.asc
Content-Type: application/pgp-signature;
name=signature.asc
Content-Description: Message signed with OpenPGP using GPGMail
-----BEGIN PGP SIGNATURE-----
Comment: GPGTools - https://gpgtools.org
iQIcBAEBCgAGBQJW01/WAAoJEF1Aj/0UKykRH4UP/jgW10r6+sZYEeiRtsISpvwX
LRvh74ZnMPJ1XMrTwK5etnq6M+eybpUVYhghbYqBv1XGKwqGNRxgnAVJSwrH7O1p
3ftZsLCTHmR4nNr1sKOPKzvEGsUxedyQgdjMWedl/GI9w+q4hfQOWg24b+w8sLSw
Q0uNJP97oALByp/lzszveq8N0PALX6r1By2Glm8Rmp46kKawj7LDFvKjRT3B8jC3
VGlGa6/oKvwbzSkIW9/SJi41+o87biH5EO2z8SSR8Bm23L3pMIbdzK9X8dAYxQwI
udi02oQICd6wSADzq4Kj6g8Iur5LyHjNz1jTLuVLNc5NOmhmcmHkupisNGhSpTz+
1xJys4GkU2+WzzfdgS4NC76OJDIbK4xNvafYRLVNMbg23xOG9pou2eUU654SQ1ru
dQP2MZSRNfTu5A7FJNCzO8zk3ECnle0QIHRAnpPWJuwFkgb4BcTxbYWHReTi7vyz
sGtN8LagVXbRdk69YCdy9lnrCE3IIog2cux4AHiMVH/7h0uN58RIVKwgrzFnWu4K
WllPUhLG4josX59I6ta2zeT43yC5LT2J767kUM31mN6S2C2/UJyhrPPWOmOrFL2w
FlIUBa6SYDkyAWzDWFdFKuzY5ugY/SRTFO71TyXPSAyTvz6tqD/0PJryixmlY8yV
y4BCsgKpq3j3GQB5UVOr
=BIv+
-----END PGP SIGNATURE-----
--Apple-Mail=_EA514860-A126-48DF-B63E-2A78ABFA40F3--
- Raw text -