X-Authentication-Warning:	delorie.com: mail set sender to geda-user-bounces using -f
X-Recipient:	geda-user AT delorie DOT com
X-Original-DKIM-Signature:	v=1; a=rsa-sha256; c=relaxed/relaxed;
	d=gmail.com; s=20161025;
	h=date:from:to:subject:message-id:in-reply-to:references:mime-version
	:content-transfer-encoding;
	bh=iH7HXC+BNuf4wCSFhqx8wXS2jtFZNPRrCjPshpUAACI=;
	b=q87OdPHvXOj0OBW277po7GRvo3L2kJsFeiYo3+F4aUgzU3P20qx+//oCKYZTanv9KO
	HMT145vILyIQuu3/G6ywQ10kZLabPCjjt7QYFIG85c9fMCVqTK+V9xhMK+/SF9+lcA1N
	Cie7H3/j1G0MZN2ZtuwPG1c5Ivgzs4+IoYIDiHkGNUJU+I16y2FCeokqpFfL95NF/qci
	wO4Hn4QnQcVswAPmK1YX8ZgtmbFasVs+QMj9n9BZsuBYZB1bHOU8JXl7RPiMBHyUp3np
	TXV41ztgReTdlehZ6+S+lCuzgxU3QQ1/lLUksbElUjTSdnGFOldGfThuVmvV5AEHzsnW
	dG6w==
X-Google-DKIM-Signature:	v=1; a=rsa-sha256; c=relaxed/relaxed;
	d=1e100.net; s=20161025;
	h=x-gm-message-state:date:from:to:subject:message-id:in-reply-to
	:references:mime-version:content-transfer-encoding;
	bh=iH7HXC+BNuf4wCSFhqx8wXS2jtFZNPRrCjPshpUAACI=;
	b=ma77lh2uCeiNwwleML0meUrONn4Op8R6KbX2/eCE7IY1PjWsgiYvHbd3vjvFQsfTdF
	Tepk4s81rsIzN00OEgR1cpYGuvnD9wLeiA4GUd1beu24q0rt5p1X7GwKB5tb1losgKfG
	q5Mb+QiyrogfcxBlvOCVGaEN37phPQsnL357Sm0YCQhpV/90qNpvY9uQPrvLp0rCfl+2
	UkRjT015QH/rwo+Xc70jzUxckHN0wyOH4Q6xMOr+j7nS3i/Gj3rGFURe0sQ6rdrGst+g
	yKVw0tThjbpPWRSxkX24l9N9hM/z7KefEX3UnpmiB3jvbD3KsFyAQJ+nQucdLPfo9kqH
	+qDw==
X-Gm-Message-State:	ABuFfojZ7bUuCY3lMiwnqv/+coiWhJ2RrdsiBDTYZ5Ngg1iso62PeCBp
	X3f1qHlvULiOUdCxMs/2ZyMvKA4d
X-Google-Smtp-Source:	ACcGV63bkxbJNP8SbijRbLWPKV3yCuhJQpeVTKpceJmC2/NFS9XWljiAiXAZNB/pzp2lMNlKYB8Ljg==
X-Received:	by 2002:a2e:2942:: with SMTP id u63-v6mr19539137lje.28.1539853094018;
	Thu, 18 Oct 2018 01:58:14 -0700 (PDT)
Date:	Thu, 18 Oct 2018 10:58:12 +0200
From:	"Nicklas Karlsson (nicklas DOT karlsson17 AT gmail DOT com) [via geda-user AT delorie DOT com]" <geda-user AT delorie DOT com>
To:	geda-user AT delorie DOT com
Subject:	Re: [geda-user] Gschem component database? <-- mapping symbol
	attributes
Message-Id:	<20181018105812.abde204f9007586a71f16238@gmail.com>
In-Reply-To:	<87k1otcqyd.fsf@gag.com>
References:	<CALSZ9goACqKVRJ-EB=UnD38P+nCknSvuZ4UtRsmQqAjmkNA7+g AT mail DOT gmail DOT com>
	<20180814083707 DOT 7ef526fd225ce9179bb836a0 AT gmail DOT com>
	<87k1otcqyd DOT fsf AT gag DOT com>
X-Mailer:	Sylpheed 3.7.0 (GTK+ 2.24.32; x86_64-pc-linux-gnu)
Mime-Version:	1.0
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

On Tue, 14 Aug 2018 16:06:34 +0800
Bdale Garbee <bdale AT gag DOT com> wrote:

> "Nicklas Karlsson (nicklas DOT karlsson17 AT gmail DOT com) [via
> geda-user AT delorie DOT com]" <geda-user AT delorie DOT com> writes:
> 
> > If I had time I would try script to automatically find suitable
> > components in database from symbol attributes. This approach make it
> > possible to start with a fast sketch and refine attribute values
> > later. 
> 
> Keith and I did that, and the scripts and associated makefile fragments
> are in the hw/altusmetrum repo on git.gag.com.  We use the triplet of
> component, value, and footprint attributes to look up the rest of the
> part data for BOM creation in our preferred parts database.
> 
> We've spent zero time making it easy for others to use, but it's just a
> couple awk scripts, a flat file for the part data, and some makefile
> templates.
> 
> Bdale


Was thinking about it yesterday then ordering compontents. I used gnetlist and bom2 backend which write ":" separated "*.csv" style and by outputting to file with this file ending it was easy to view in Openoffice.

What is needed is this awk script or other script to add other information from symbol attributes, in my case distributor part number and in some cases manufacturer part number. If information is missing it should be possible to fill in and in such case it should be added to database probably as default but usually not aded to symbol although attribute to explicitly state this in symbol may be useful sometimes. This is the way I think it should be and question is how to get there?

SQL is common for databases and is probably a good choice for storage. Stored in file locally on computer is probably the choice for most users and for organizations with more people a server. Question is what programming language to use? You have link to your awk script? Or how does it store the data?


Regards, Nicklas Karlsson

- Raw text -