From: Keith Packard Date: Sat, 5 Jan 2013 14:54:46 +0000 (-0800) Subject: Generate partslist.dk and partslist.mouser X-Git-Tag: fab-v0.3~3 X-Git-Url: https://git.gag.com/?p=hw%2Fteleterra;a=commitdiff_plain;h=580d4dfab81916afb1965aa67d0e6a675f429eca Generate partslist.dk and partslist.mouser These are in CSV format, suitable for direct import into DK Signed-off-by: Keith Packard --- diff --git a/Makefile b/Makefile index 8faefb9..ae393bf 100644 --- a/Makefile +++ b/Makefile @@ -1,7 +1,9 @@ +PROJECT=teleterra + # intentionally want to rebuild drc and bom on every invocation all: hw -hw: drc partslist partslist.csv +hw: drc partslist partslist.csv partslist.dk partslist.mouser CC= sdcc CFLAGS= -mpic14 -p16f886 @@ -23,6 +25,12 @@ partslist.csv: teleterra.sch Makefile tail -n+2 teleterra.unsorted | sort -t \, -k 8 >> partslist.csv rm -f teleterra.unsorted +partslist.dk: $(PROJECT).sch Makefile scheme/gnet-partslist-bom.scm + gnetlist -m scheme/gnet-partslist-bom.scm -g partslist-bom -Ovendor=digikey -o $@ $(PROJECT).sch + +partslist.mouser: $(PROJECT).sch Makefile scheme/gnet-partslist-bom.scm + gnetlist -m scheme/gnet-partslist-bom.scm -g partslist-bom -Ovendor=mouser -o $@ $(PROJECT).sch + pcb: teleterra.sch project gsch2pcb project diff --git a/scheme/gnet-partslist-bom.scm b/scheme/gnet-partslist-bom.scm new file mode 100644 index 0000000..dd90ea0 --- /dev/null +++ b/scheme/gnet-partslist-bom.scm @@ -0,0 +1,118 @@ +; Copyright © 2012 Keith Packard +; gnet-partslist-bom.scm +; +; This program is free software; you can redistribute it and/or modify +; it under the terms of the GNU General Public License as published by +; the Free Software Foundation; either version 2 of the License, or +; (at your option) any later version. +; +; This program is distributed in the hope that it will be useful, +; but WITHOUT ANY WARRANTY; without even the implied warranty of +; MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the +; GNU General Public License for more details. +; +; You should have received a copy of the GNU General Public License +; along with this program; if not, write to the Free Software +; Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA + +; The /'s may not work on win32 +(load (string-append gedadata "/scheme/gnet-partslist-common.scm")) + +(define (caddddddr s) + (car (cdr (cdr (cdr (cdr (cdr (cdr s)))))))) + +(define (cadddddr s) + (car (cdr (cdr (cdr (cdr (cdr s))))))) + +(define (caddddr s) + (car (cdr (cdr (cdr (cdr s)))))) + +(define multiplier 1) + +(define (partslist-bom:write-part s port) + (let ((quantity (caddddddr s)) + (part (cadddddr s)) + (device (cadr s)) + (value (caddr s))) + (display (* multiplier quantity) port) + (display "," port) + (display part port) + (display "," port) + (display device port) + (display " " port) + (display value port) + (display "\n" port))) + +(define (partslist-bom:write-partslist ls port) + (if (null? ls) + '() + (begin (partslist-bom:write-part (car ls) port) + (partslist-bom:write-partslist (cdr ls) port)))) + +(define (count-same-parts ls) + (if (null? ls) + (append ls) + (let* ((parts-table-no-uref (let ((result '())) + (for-each (lambda (l) (set! result (cons (cdr l) result))) (reverse ls)) + (append result))) + (first-ls (car parts-table-no-uref)) + (match-length (length (member first-ls (reverse parts-table-no-uref)))) + (rest-ls (list-tail ls match-length)) + (match-ls (list-tail (reverse ls) (- (length ls) match-length))) + (uref-ls (let ((result '())) + (for-each (lambda (l) (set! result (cons (car l) result))) match-ls) + (append result)))) + (cons (cons uref-ls (append first-ls (list match-length))) (count-same-parts rest-ls))))) + +(define get-vendor + (lambda (package) + (gnetlist:get-package-attribute package "vendor"))) + +(define get-vendor-part-number + (lambda (package) + (gnetlist:get-package-attribute package "vendor_part_number"))) + +(define get-footprint + (lambda (package) + (gnetlist:get-package-attribute package "footprint"))) + +(define (get-parts-table-bom packages vendor) + (if (null? packages) + '() + (let ((package (car packages))) + (if (string=? (get-vendor package) vendor) + (if (string=? (get-device package) "include") + (get-parts-table-bom (cdr packages) vendor) + (cons (list package + (get-device package) + (get-value package) + (get-footprint package) + (get-vendor package) + (get-vendor-part-number package)) ;; sdb change + (get-parts-table-bom (cdr packages) vendor))) + (get-parts-table-bom (cdr packages) vendor))))) + +(define (get-opt-helper option list) + (if list + (let ((param (car list))) + (if (string-prefix? option (car param)) + (string-drop (car param) (string-length option)) + (get-opt-helper option (cdr list)))) + nil) + ) + +(define (get-opt option default) + (let ((opt (get-opt-helper (string-append option "=") (gnetlist:get-calling-flags)))) + (if opt + opt + default))) + +(define (get-vendor-match) + (get-opt "vendor" "digikey")) + +(define (partslist-bom output-filename) + (let ((port (open-output-file output-filename)) + (parts-table (marge-sort-with-multikey (get-parts-table-bom packages (get-vendor-match)) '(1 2 3 0)))) + (set! parts-table (count-same-parts parts-table)) + (partslist-bom:write-partslist parts-table port) + (close-output-port port))) diff --git a/scheme/gnet-partslist-csv.scm b/scheme/gnet-partslist-csv.scm new file mode 100644 index 0000000..291bb0a --- /dev/null +++ b/scheme/gnet-partslist-csv.scm @@ -0,0 +1,86 @@ +; Copyright (C) 2001-2010 MIYAMOTO Takanori +; gnet-partslist-csv.scm +; +; This program is free software; you can redistribute it and/or modify +; it under the terms of the GNU General Public License as published by +; the Free Software Foundation; either version 2 of the License, or +; (at your option) any later version. +; +; This program is distributed in the hope that it will be useful, +; but WITHOUT ANY WARRANTY; without even the implied warranty of +; MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the +; GNU General Public License for more details. +; +; You should have received a copy of the GNU General Public License +; along with this program; if not, write to the Free Software +; Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA + +; The /'s may not work on win32 +(load (string-append gedadata "/scheme/gnet-partslist-common.scm")) + +(define partslist-csv:write-top-header + (lambda (port) + (display "device,value,footprint,vendor,vendor_part_number,quantity,refdes\n" port))) + +(define (partslist-csv:write-partslist ls port) + (if (null? ls) + '() + (begin (write-one-row (cdar ls) "," "," port) + (write-one-row (caar ls) " " "\n" port) + (partslist-csv:write-partslist (cdr ls) port)))) + +(define (count-same-parts ls) + (if (null? ls) + (append ls) + (let* ((parts-table-no-uref (let ((result '())) + (for-each (lambda (l) (set! result (cons (cdr l) result))) (reverse ls)) + (append result))) + (first-ls (car parts-table-no-uref)) + (match-length (length (member first-ls (reverse parts-table-no-uref)))) + (rest-ls (list-tail ls match-length)) + (match-ls (list-tail (reverse ls) (- (length ls) match-length))) + (uref-ls (let ((result '())) + (for-each (lambda (l) (set! result (cons (car l) result))) match-ls) + (append result)))) + (cons (cons uref-ls (append first-ls (list match-length))) (count-same-parts rest-ls))))) + +(define get-vendor + (lambda (package) + (gnetlist:get-package-attribute package "vendor"))) + +(define get-vendor-part-number + (lambda (package) + (gnetlist:get-package-attribute package "vendor_part_number"))) + +(define get-footprint + (lambda (package) + (gnetlist:get-package-attribute package "footprint"))) + +(define get-loadstatus + (lambda (package) + (gnetlist:get-package-attribute package "loadstatus"))) + +(define (get-parts-table-csv packages) + (if (null? packages) + '() + (let ((package (car packages))) + (if (string=? (get-device package) "include") + (get-parts-table-csv (cdr packages)) + (if (string=? (get-loadstatus package) "smt") + (cons (list package + (get-device package) + (get-value package) + (get-footprint package) + (get-vendor package) + (get-vendor-part-number package)) ;; sdb change + (get-parts-table-csv (cdr packages))) + (get-parts-table-csv (cdr packages))))))) + +(define partslist-csv + (lambda (output-filename) + (let ((port (open-output-file output-filename)) + (parts-table (marge-sort-with-multikey (get-parts-table-csv packages) '(1 2 3 0)))) + (set! parts-table (count-same-parts parts-table)) + (partslist-csv:write-top-header port) + (partslist-csv:write-partslist parts-table port) + (close-output-port port))))