X-Authentication-Warning: delorie.com: mail set sender to geda-user-bounces using -f
X-Recipient: geda-user AT delorie DOT com
X-TCPREMOTEIP: 207.224.51.38
X-Authenticated-UID: jpd AT noqsi DOT com
Content-Type: text/plain; charset=windows-1252
Mime-Version: 1.0 (Mac OS X Mail 7.3 \(1878.6\))
Subject: Re: [geda-user] Desired changes (was:"New experimental netlist features")
From: John Doty <jpd AT noqsi DOT com>
In-Reply-To: <20150909093102.bad96542a878c8bce15eb5f8@gmail.com>
Date: Wed, 9 Sep 2015 10:43:44 -0600
Message-Id: <5B80DA3E-C67B-4595-9503-37B3FCC17D9A@noqsi.com>
References: <alpine DOT DEB DOT 2 DOT 11 DOT 1509031356150 DOT 13201 AT nimbus> <201509032030 DOT t83KU1Yq017045 AT envy DOT delorie DOT com> <55E97A3E DOT 2070402 AT jump-ing DOT de> <69B8B3F4-A6E4-43E9-9055-C63A5D6A3707 AT noqsi DOT com> <msfjma$340$1 AT ger DOT gmane DOT org> <alpine DOT DEB DOT 2 DOT 00 DOT 1509060518220 DOT 6924 AT igor2priv> <msidqe$66h$1 AT ger DOT gmane DOT org> <D2219618-B906-432B-B11A-C108DA9FCBF9 AT noqsi DOT com> <CAOP4iL3JkWC4Nuw8vDOBDR4Zk4OD2xwrMwHXp-ZihPom5Wmfwg AT mail DOT gmail DOT com> <43CA04C5-47B7-4DA4-8005-3A2D4E9D0E47 AT noqsi DOT com> <20150908162514 DOT 43142577ec15e48c50950a18 AT gmail DOT com> <CD93E147-F22E-4CA2-9793-FAAA5558486D AT noqsi DOT com> <20150908182504 DOT 196a11571c68bc63ef8e4c27 AT gmail DOT com> <11875D68-7D82-48AB-8850-C5C3BCCF64EC AT noqsi DOT com> <20150908193308 DOT 9668c04bfb9b5a501f9c11a2 AT gmail DOT com> <E0A54A3A-F1AC-47F4-9718-912C70B3B2F5 AT noqsi DOT com> <20150908211310.2a3de7efe3e37! 61fcab458d5 AT gmail DOT com> <E12B2B08-085A-4263-9B4C-C293A0275746 AT noqsi DOT com> <20150908231242.75cc796752f53d329! 8631084 AT gmail DOT com> <2F1C1D79-3C24-4513-BDD8-1C57E0617113 AT noqsi DOT com> <20150909093102.bad96542!
 a878c8bce15eb5f8 AT gmail DOT com>
To: geda-user AT delorie DOT com
X-Mailer: Apple Mail (2.1878.6)
Content-Transfer-Encoding: 8bit
X-MIME-Autoconverted: from quoted-printable to 8bit by delorie.com id t89GhrTO028237
Reply-To: geda-user AT delorie DOT com
Errors-To: nobody AT delorie DOT com
X-Mailing-List: geda-user AT delorie DOT com
X-Unsubscribes-To: listserv AT delorie DOT com
Precedence: bulk


On Sep 9, 2015, at 1:31 AM, Nicklas Karlsson (nicklas DOT karlsson17 AT gmail DOT com) [via geda-user AT delorie DOT com] <geda-user AT delorie DOT com> wrote:

>> For manufacturer part numbers, in big projects, I do a join of the BOM to a database that relates part specs to part numbers. There are sometimes two such databases, as prototype and production parts are different.
> 
> This one of the things I have been thinking about for a long time, it seems really great!

It’s really pretty trivial. The script changes a bit from project to project, but a published example is at:

https://github.com/TESScience/FPE/blob/master/FPE/Schematic/CirrexxBOM.awk

Unfortunately, for that project, parts procurement has moved to a separate office that uses its own time-consuming error-prone spreadsheet-based methods :(

> 
> There I worked before manufacturer part number had to be known then adding the component. As soon as a number changed all documents had to be updated and this was horrible.
> 

John Doty              Noqsi Aerospace, Ltd.
http://www.noqsi.com/
jpd AT noqsi DOT com