[Author Prev][Author Next][Thread Prev][Thread Next][Author Index][Thread Index]
Re: gEDA-user: New mass attribute tool: gattrib_csv
On Fri, Apr 1, 2011 at 2:19 PM, Joshua <Joshua@xxxxxxxxxxxxx> wrote:
> Hey guys. ÂI wrote a tool which exports and imports the properties from a
> project to and to a csv file. Â The format is simular to that of the bom2
> format as it groups lines together which have similar data. ÂThis way I
> could use oocalc to mass edit the attributes. ÂEach component in my design
> now has its price, distributer, manufactuer, width. height. etc etc.
> asociated with it. ÂBecause similar data shows up on the same line I could
> specify the vendor for all 40 resistors of a particular value with a single
> edit, and then the vendor for 20 caps with another single edit. ÂI can copy
> and paste a row of attributes from one group of parts to another group of
> parts. ÂIt accepts an filter file to specify which attributes to export.
> Parts do not need to have refdeses before the tool can work. ÂParts are
> distinguished by position in the csv when the refdes is not specific enough.
> ÂDo backup your project before you try it. ÂIt can be downloaded from
>
> http://public.laserlinc.com/Joshua/gattrib_csv.java
>
> I know. ÂIt is written in java. ÂThe following command compiles it to exe.
>
> gcj --main=gattrib_csv -o gattrib_csv gattrib_csv.java
>
> Have fun :-)
> ~Joshua
You may find that there is some effort duplication going on:
http://www.gedasymbols.org/user/dj_delorie/
# sch2csv - extract part attributes to a comma seperated list (open
with openoffice calc)
# csv2sch - merge part attributes to schematics. To use these:
$ sch2csv [-o foo.csv] *.sch
$ ooffice foo.csv
$ csv2sch foo.csv [*.sch]
If you don't specify -o file for sch2csv, the CSV is printed to
stdout. If you don't specify any schematics for csv2sch, all the
schematics mentioned in the CSV are updated. The new schematics are
named foo.sch.new - the original schematics are not changed.
> On 4/1/2011 12:00 PM, geda-user-request@xxxxxxxxxxxxxx wrote:
>>
>> Send geda-user mailing list submissions to
>> Â Â Â Âgeda-user@xxxxxxxxxxxxxx
>>
>> To subscribe or unsubscribe via the World Wide Web, visit
>> Â Â Â Âhttp://www.seul.org/cgi-bin/mailman/listinfo/geda-user
>> or, via email, send a message with subject or body 'help' to
>> Â Â Â Âgeda-user-request@xxxxxxxxxxxxxx
>>
>> You can reach the person managing the list at
>> Â Â Â Âgeda-user-owner@xxxxxxxxxxxxxx
>>
>> When replying, please edit your Subject line so it is more specific
>> than "Re: Contents of geda-user digest..."
>>
>>
>> Today's Topics:
>>
>> Â Â1. Re: SC70-6, which is pin 1? (Stephen Trier)
>> Â Â2. Re: SC70-6, which is pin 1? (Duncan Drennan)
>> Â Â3. Re: SC70-6, which is pin 1? (Cullen Newsom)
>>
>>
>> ----------------------------------------------------------------------
>>
>> Message: 1
>> Date: Fri, 1 Apr 2011 06:21:30 -0400
>> From: Stephen Trier<stephen.trier+geda@xxxxxxxxx>
>> Subject: Re: gEDA-user: SC70-6, which is pin 1?
>> To: gEDA user mailing list<geda-user@xxxxxxxxxxxxxx>
>> Message-ID:
>> Â Â Â Â<AANLkTinbEZNM0aFEU2OffSVPOW=rAwtjz8RsWSZy-v6G@xxxxxxxxxxxxxx>
>> Content-Type: text/plain; charset="iso-8859-1"
>>
>> It's hard to be sure from the picture, though my best guess matches yours.
>> If you want to be sure, take a look in the data sheet for the package
>> markings section. It will tell you what to look for.
>>
>> Â Â Â Â Â Â Â Â Stephen
>> -------------- next part --------------
>> Â ÂIt's hard to be sure from the picture, though my best guess matches
>> Â Âyours. If you want to be sure, take a look in the data sheet for the
>> Â Âpackage markings section. It will tell you what to look for.
>>
>> Â Â Â Â Â Â Â Â Â ÂStephen
>>
>> ------------------------------
>>
>> Message: 2
>> Date: Fri, 1 Apr 2011 12:58:41 +0200
>> From: Duncan Drennan<duncan.drennan@xxxxxxxxx>
>> Subject: Re: gEDA-user: SC70-6, which is pin 1?
>> To: gEDA user mailing list<geda-user@xxxxxxxxxxxxxx>
>> Message-ID:
>> Â Â Â Â<AANLkTi=q3w8zEfaXYi1NL-tUPrMSNE-1h_WUrD+7RXeC@xxxxxxxxxxxxxx>
>> Content-Type: text/plain; charset=ISO-8859-1
>>
>>> I'm guessing based off that mark the bottom left pin is pin 1. The
>>> datasheet isn't clear. Does anybody know for sure if thats pin 1?
>>
>> Yes, bottom left is pin 1.
>>
>>
>> ------------------------------
>>
>> Message: 3
>> Date: Fri, 1 Apr 2011 07:21:06 -0500
>> From: Cullen Newsom<cullennewsom@xxxxxxxxx>
>> Subject: Re: gEDA-user: SC70-6, which is pin 1?
>> To: gEDA user mailing list<geda-user@xxxxxxxxxxxxxx>
>> Message-ID:
>> Â Â Â Â<AANLkTin5v69=dRXnDkL+5nFzg0oE=XwOL5rhyE_6tGLw@xxxxxxxxxxxxxx>
>> Content-Type: text/plain; charset="iso-8859-1"
>>
>> Have you got a part number for it? What's inside? You could use a DMM to
>> confirm, if you consider its internals. Your guess of bottom left seems
>> reasonable.
>>
>> -CN
>>
>> On Fri, Apr 1, 2011 at 4:13 AM, yamazakir2<yamazakir2@xxxxxxxxx> Âwrote:
>>
>>> I'm guessing based off that mark the bottom left pin is pin 1. The
>>> datasheet isn't clear. Does anybody know for sure if thats pin 1?
>>>
>>>
>>>
>>> _______________________________________________
>>> geda-user mailing list
>>> geda-user@xxxxxxxxxxxxxx
>>> http://www.seul.org/cgi-bin/mailman/listinfo/geda-user
>>>
>>>
>> -------------- next part --------------
>> Â ÂHave you got a part number for it? What's inside? You could use a DMM
>> Â Âto confirm, if you consider its internals. Your guess of bottom left
>> Â Âseems reasonable.
>> Â Â-CN
>>
>> Â ÂOn Fri, Apr 1, 2011 at 4:13 AM, yamazakir2<[1]yamazakir2@xxxxxxxxx>
>> Â Âwrote:
>>
>> Â Â ÂI'm guessing based off that mark the bottom left pin is pin 1. The
>> Â Â Âdatasheet isn't clear. Does anybody know for sure if thats pin 1?
>> Â Â Â_______________________________________________
>> Â Â Âgeda-user mailing list
>> Â Â Â[2]geda-user@xxxxxxxxxxxxxx
>> Â Â Â[3]http://www.seul.org/cgi-bin/mailman/listinfo/geda-user
>>
>> References
>>
>> Â Â1. mailto:yamazakir2@xxxxxxxxx
>> Â Â2. mailto:geda-user@xxxxxxxxxxxxxx
>> Â Â3. http://www.seul.org/cgi-bin/mailman/listinfo/geda-user
>>
>> ------------------------------
>>
>> _______________________________________________
>> geda-user mailing list
>> geda-user@xxxxxxxxxxxxxx
>> http://www.seul.org/cgi-bin/mailman/listinfo/geda-user
>>
>>
>> End of geda-user Digest, Vol 59, Issue 2
>> ****************************************
>>
>
>
> _______________________________________________
> geda-user mailing list
> geda-user@xxxxxxxxxxxxxx
> http://www.seul.org/cgi-bin/mailman/listinfo/geda-user
>
_______________________________________________
geda-user mailing list
geda-user@xxxxxxxxxxxxxx
http://www.seul.org/cgi-bin/mailman/listinfo/geda-user