Loading ...
Sorry, an error occurred while loading the content.

Re: [kicad-users] Re: Relationship between Partnumbers, Symbols, and Footprints

Expand Messages
  • Donald H Locker
    I look forward to trying your solution, Robert. Many thanks, Donald. -- *Plain Text* email -- it s an accessibility issue () no proprietary attachments; no
    Message 1 of 32 , Apr 28 6:18 AM
    View Source
    • 0 Attachment
      I look forward to trying your solution, Robert.

      Many thanks,
      Donald.
      --
      *Plain Text* email -- it's an accessibility issue
      () no proprietary attachments; no html mail
      /\ ascii ribbon campaign - <www.asciiribbon.org>

      ----- Original Message -----
      > From: "brownbrummig" <birmingham_spider@...>
      > To: kicad-users@yahoogroups.com
      > Sent: Thursday, April 19, 2012 11:40:38 AM
      > Subject: [kicad-users] Re: Relationship between Partnumbers, Symbols, and Footprints
      > I've just uploaded my own attempt at this:
      >
      > http://tech.groups.yahoo.com/group/kicad-users/files/ComponentsDatabase/
      >
      > It includes a Firebird back-end database, an Access 97 front-end (I
      > wanted to use LibreOffice Base, but it has a fatal bug), and some
      > source code showing the use of ODBC library calls in an application.
      > Note that although the sample code was written for Windows, ODBC is
      > available on Linux too and it uses the same API. Firebird is also
      > multi-platform, so it's just the Access front-end that goes against
      > the grain.
      >
      > I've already used this on one project and made a few changes in the
      > light of the experience. In particular components are identified
      > uniquely using "Value", "Footprint", and "Field1", "Field1" being used
      > to store the manufacturer name. My original idea of using an integer
      > in "Field1" to uniquely identify a component in the database proved to
      > be too user-unfriendly.
      >
      > Regards,
      >
      > Robert.
      >
      > --- In kicad-users@yahoogroups.com, Robert <birmingham_spider@...>
      > wrote:
      > >
      > > Just thinking out loud here. How about linking the EESchema library
      > > browser with a database server using some sort of standardised or
      > > user-definable SQL? Similarly, allowing the BOM output to be sent
      > > direct to the database server would allow the automated creation of
      > > custom parts lists.
      > >
      > > Regards,
      > >
      > > Robert.
      > >
      > > On 06/03/2012 09:08, Jeff Kaskey wrote:
      > > > Agreed that would be nice. KiCad is close. There are additional
      > > > fields that you see in the browser, Keywords and Description. If
      > > > you could repurpose one as the footprint, you could build your
      > > > libraries so the Value/Footprint combo would be visible in the
      > > > browser. Of course you can do that now, but there is no way to
      > > > export the repurposed field into netlists or BOMs. So close, yet
      > > > so far. There may be some convoluted way to do that using complex
      > > > part names linked through cvpcb, but that sounds pretty painful.
      > > >
      > > > OK, not as painful as the guys who are entering part numbers,
      > > > vendor info, pricing, etc :-)
      > > >
      > > >
      > > >
      > > >
      > > > ________________________________
      > > > From: Robert<birmingham_spider@...>
      > > > To: kicad-users@yahoogroups.com
      > > > Sent: Tuesday, March 6, 2012 12:31 AM
      > > > Subject: Re: [kicad-users] Relationship between Partnumbers,
      > > > Symbols, and Footprints
      > > >
      > > >
      > > >
      > > >> Kicad should hold a part number that matches whatever your stock
      > > >> control
      > > >> system uses, and that's all. That then becomes the key field to
      > > >> your
      > > >> stock control database.
      > > >
      > > > It would be nice if there was a link between the two, so that one
      > > > could
      > > > just use some sort of browser in EESchema to select the correct
      > > > part.
      > > > I'm currently switching over to using IPC footprint names; this
      > > > eliminates the mess of mission-creep footprint names, but the IPC
      > > > names
      > > > don't exactly trip of the tongue.
      > > >
      > > > Regards,
      > > >
      > > > Robert.
      > > >
      > >
      > > --
      > > () Plain text email - safe, readable, inclusive.
      > > /\ http://www.asciiribbon.org/
      > >
      >
      >
      >
      >
      > ------------------------------------
      >
      > Please read the Kicad FAQ in the group files section before posting
      > your question.
      > Please post your bug reports here. They will be picked up by the
      > creator of Kicad.
      > Please visit http://www.kicadlib.org for details of how to contribute
      > your symbols/modules to the kicad library.
      > For building Kicad from source and other development questions visit
      > the kicad-devel group at
      > http://groups.yahoo.com/group/kicad-develYahoo! Groups Links
      >
      >
      >
    • Donald H Locker
      I look forward to trying your solution, Robert. Many thanks, Donald. -- *Plain Text* email -- it s an accessibility issue () no proprietary attachments; no
      Message 32 of 32 , Apr 28 6:18 AM
      View Source
      • 0 Attachment
        I look forward to trying your solution, Robert.

        Many thanks,
        Donald.
        --
        *Plain Text* email -- it's an accessibility issue
        () no proprietary attachments; no html mail
        /\ ascii ribbon campaign - <www.asciiribbon.org>

        ----- Original Message -----
        > From: "brownbrummig" <birmingham_spider@...>
        > To: kicad-users@yahoogroups.com
        > Sent: Thursday, April 19, 2012 11:40:38 AM
        > Subject: [kicad-users] Re: Relationship between Partnumbers, Symbols, and Footprints
        > I've just uploaded my own attempt at this:
        >
        > http://tech.groups.yahoo.com/group/kicad-users/files/ComponentsDatabase/
        >
        > It includes a Firebird back-end database, an Access 97 front-end (I
        > wanted to use LibreOffice Base, but it has a fatal bug), and some
        > source code showing the use of ODBC library calls in an application.
        > Note that although the sample code was written for Windows, ODBC is
        > available on Linux too and it uses the same API. Firebird is also
        > multi-platform, so it's just the Access front-end that goes against
        > the grain.
        >
        > I've already used this on one project and made a few changes in the
        > light of the experience. In particular components are identified
        > uniquely using "Value", "Footprint", and "Field1", "Field1" being used
        > to store the manufacturer name. My original idea of using an integer
        > in "Field1" to uniquely identify a component in the database proved to
        > be too user-unfriendly.
        >
        > Regards,
        >
        > Robert.
        >
        > --- In kicad-users@yahoogroups.com, Robert <birmingham_spider@...>
        > wrote:
        > >
        > > Just thinking out loud here. How about linking the EESchema library
        > > browser with a database server using some sort of standardised or
        > > user-definable SQL? Similarly, allowing the BOM output to be sent
        > > direct to the database server would allow the automated creation of
        > > custom parts lists.
        > >
        > > Regards,
        > >
        > > Robert.
        > >
        > > On 06/03/2012 09:08, Jeff Kaskey wrote:
        > > > Agreed that would be nice. KiCad is close. There are additional
        > > > fields that you see in the browser, Keywords and Description. If
        > > > you could repurpose one as the footprint, you could build your
        > > > libraries so the Value/Footprint combo would be visible in the
        > > > browser. Of course you can do that now, but there is no way to
        > > > export the repurposed field into netlists or BOMs. So close, yet
        > > > so far. There may be some convoluted way to do that using complex
        > > > part names linked through cvpcb, but that sounds pretty painful.
        > > >
        > > > OK, not as painful as the guys who are entering part numbers,
        > > > vendor info, pricing, etc :-)
        > > >
        > > >
        > > >
        > > >
        > > > ________________________________
        > > > From: Robert<birmingham_spider@...>
        > > > To: kicad-users@yahoogroups.com
        > > > Sent: Tuesday, March 6, 2012 12:31 AM
        > > > Subject: Re: [kicad-users] Relationship between Partnumbers,
        > > > Symbols, and Footprints
        > > >
        > > >
        > > >
        > > >> Kicad should hold a part number that matches whatever your stock
        > > >> control
        > > >> system uses, and that's all. That then becomes the key field to
        > > >> your
        > > >> stock control database.
        > > >
        > > > It would be nice if there was a link between the two, so that one
        > > > could
        > > > just use some sort of browser in EESchema to select the correct
        > > > part.
        > > > I'm currently switching over to using IPC footprint names; this
        > > > eliminates the mess of mission-creep footprint names, but the IPC
        > > > names
        > > > don't exactly trip of the tongue.
        > > >
        > > > Regards,
        > > >
        > > > Robert.
        > > >
        > >
        > > --
        > > () Plain text email - safe, readable, inclusive.
        > > /\ http://www.asciiribbon.org/
        > >
        >
        >
        >
        >
        > ------------------------------------
        >
        > Please read the Kicad FAQ in the group files section before posting
        > your question.
        > Please post your bug reports here. They will be picked up by the
        > creator of Kicad.
        > Please visit http://www.kicadlib.org for details of how to contribute
        > your symbols/modules to the kicad library.
        > For building Kicad from source and other development questions visit
        > the kicad-devel group at
        > http://groups.yahoo.com/group/kicad-develYahoo! Groups Links
        >
        >
        >
      Your message has been successfully submitted and would be delivered to recipients shortly.