Keyboard Shortcuts
Likes
- Kicad-Users
- Messages
Search
BOM formatting question
Is there a way to get the KiCad BOM output to look like the following:
generically: Item#<t>Quantity<t>RefDesList<t>PartValue<t>Footprint where <t> is a tab character. hypothetical example: 1<t>3<t>C1,C2,C5<t>0.1uF<t>SM0603 2<t>2<t>C3,C4<t>100pF<t>SM0603 3<t>2<t>R1,R3<t>1.0K<t>SM0603 4<t>1<t>R2<t>10R0<t>SM1206 5<t>1<t>U1<t>LM358AM<t>SOIC8 Then I can import this file into Excel and use the tabs to delimit each field. Notice that all the reference designators in the RefDesList are all within one field. This way all those of a particular part value they end up all in one Excel cell. OrCad can make this kind of BOM easily. Thanks! |
Re: Is this a bug?
Gaaa! I hate CVPCB. The problem is that you need to ensure the .CMP file generated by CVPCB and the .NET file generated by EESchema match. If you miss a stage, you end up with weirdness. Personally I just put the footprint in the relevant field in the component properties in EESchema and bypass CVPCB, using it only as a convenient means of checking my footprint selections.
toggle quoted message
Show quoted text
Regards, Robert. On 04/07/2012 14:12, randyinnc55 wrote:
Or did I do something wrong? --
() Plain text email - safe, readable, inclusive. /\ |
Is this a bug?
Or did I do something wrong?
I created a multisheet schematic with a top level sheet and then 5 sheets in parallel below that. I then used the CvPcb button and filled in all the footprints to associate each item on the schematic with a footprint. I made a netlist and ran that forward to a PCB. I placed all the components on the PCB layout. Then I realized that I wanted to move a small subsection of the schematic from one of the sheets to another. I kept all the part values, footprints, and reference designators the same. I re-ran the netlister because I had also changed something else, adding a couple of new components. It added these new components to the PCB layout. The ones I moved from one schematic sheet to another were all still there. I did my PCB layout, routed and made Gerbers and everything looks fine. Now I go to make a Bill of Materials. In looking at the BOM listing, I see that all the components that I moved from one sheet to the other don't have footprints associated with them. But the netlister says they do, and the PCB clearly has these parts with the correct footprints. If I select and edit these particular components on the schematic, the footprint text box is blank. But if I look at the listing from CvPcb, these components do in fact show footprints. Is this a bug or did I do something wrong? Thanks. |
Re: Editing ARC on PCB edge layer
Thanks Robert and Andy,
toggle quoted message
Show quoted text
@Andy, Which can file can be edited to set this ARC PCB edges..Brd file? Do you particular point in file[some search keyword] where I can edit this? Regards, Mahesh --- In kicad-users@..., Andy Eskelson <andyyahoo@...> wrote:
|
Re: Multi-Part Components
Interfacing to existing databases would be a great feature of a parts management tool, but it is not in itself a parts management tool. Besides octopart, KiCad users could make good use of interfaces to DigiKey, McMaster, Mouser etc. For instance, once you include a DigiKey part in your database it would be cool if the tool would periodically keep the pricing up to date including quantity discounts. Would dramatically simplify quoting and kitting. Given a good open source framework for a parts management tool, the community could provide such a capability. But deciding which interfaces are important is rather putting the cart before the horse, methinks. On the topic of existing parts management tools, there are open source MRP/ERP tools that might be relevant, but I for one
have not done any work to see if they are appropriate. Does anyone know applicability of tools like ERP5 or Apache OFBiz? Or are they just too heavy to be workable in a one or two person design environment? -J From: Frank bennett To: kicad-users@... Cc: Robert Sent: Tuesday, July 3, 2012 8:44 AM Subject: Re: [kicad-users] Multi-Part Components
?
On 07/03/2012 01:57 AM, Robert wrote:
?No sure what this discussion has to do with Multi-Part Components!? (see previous discussion wrt BOM management) How about accessing an existing database? I would recommend checking out: http://octopart.com where either a manual or API search of the site is provided. Part searches provide description, pdf spec, multi-distributor, cost, inventory,etc -Frank
--
Frank Bennett owner, contractor 613 Bentley Pl Fort Collins, Co 80526 970.402.9269 |
Re: Multi-Part Components
Frank bennett
¿ªÔÆÌåÓýOn 07/03/2012 01:57 AM, Robert wrote:
?No sure what this discussion has to do with Multi-Part Components!? (see previous discussion wrt BOM management) How about accessing an existing database? I would recommend checking out: where either a manual or API search of the site is provided. Part searches provide description, pdf spec, multi-distributor, cost, inventory,etc -Frank
--
Frank Bennett owner, contractor 613 Bentley Pl Fort Collins, Co 80526 970.402.9269 |
Re: Editing ARC on PCB edge layer
Andy Eskelson
It is a pain, this is where diving into the file with a text editor is
useful. Andy On Tue, 03 Jul 2012 15:11:47 +0100 Robert <birmingham_spider@...> wrote:
|
Re: Holes in modules
Andy Eskelson
Modules don't have any concept of "pins" as such they are all pads.
Pads with matching pin numbers will connect to the eeschema component with the same pin numbers. You can make odd shaped pads by overlaying pads as well. Just remember that if you want the pads to auto connect then give them the same pin number. That may not be quite what you want, but it's easy enough to try out. Andy On Mon, 02 Jul 2012 22:15:13 -0400 David Novak <david.novak@...> wrote: It's an odd module. All the pins of the LCC will have a pth connected to |
Re: Multi-Part Components
Another multi-platform option is Qt. See http://qt-project.org/doc/qt-4.8/sql-driver.html#qibase -Mithat
|
Re: Multi-Part Components
On 03/07/2012 15:07, Koenraad Lelong wrote:
On 03-07-12 09:57, Robert wrote:Thanks, that is well worth knowing.Thanks, that's certainly worth knowing should I suddenly find myselfYes, they are full client-server "drivers". Actually they are an There is one sort-of advantage to ODBC which I have exploited in the past. I have written an app that used Firebird with ODBC, expecting the response "yes, that's very nice but I want to use MySQL/SQL Server, not Firebird even if it is better". I did indeed get that response, and I was able to say that my app would also work with MySQL and Postgres, but I had had to give up on SQL Server because the installer ran out of disk space after about forty minutes of installing all the dark matter in the universe. Using ODBC in this way does require code that adapts to the SQL dialect, and IIRC the sample ODBC code I included with my database includes the self-adapting code. But if someone wrote the code using the Lazarus drivers I wouldn't object. Regards, Robert. -- () Plain text email - safe, readable, inclusive. /\ |
Re: Editing ARC on PCB edge layer
On 03/07/2012 15:02, maheshsutariya wrote:
I am not getting arc edit form for second time[so unable to editArcs can be difficult or impossible to select, especially once edited, and I don't know any workaround other than right-clicking all over the arc until you get lucky. If you don't get lucky then all you can do is use block selection to delete the arc and start again. IMHO arcs in kicad really, badly need re-thinking and re-coding. Regards, Robert. -- () Plain text email - safe, readable, inclusive. /\ |
Re: Multi-Part Components
Koenraad Lelong
On 03-07-12 09:57, Robert wrote:
Thanks, that's certainly worth knowing should I suddenly find myselfYes, they are full client-server "drivers". Actually they are an interface to the installed db-drivers. There is no odbc-layer. Firebird is my favorite database server ;-) . Regards, Koenraad Lelong |
Editing ARC on PCB edge layer
Hi,
I am using following latest kicad from link[] on windows XP. In PCB Editor, I am trying to draw ARC in pcb edge layer. After drawing arc, when I click on edit arc option using 'E' key pressed while mouse on ARC. I get menu for editing ARC e.g. start position, center, angle. After making some changes in this form[e.g. angle:1800, start position:114,70] when I click on OK. It works and I get desired arc as per setting. But unfortunately then after I am unable to edit ARC neigher using 'E' keyboard shortcut or using rightclick menu[it does not appear]. I am not getting arc edit form for second time[so unable to edit again]. Even I am not able to delete this ARC once edited. is this known problem? is there any work around for this? looking for your help.. Regards, Mahesh |
Re: Problem with kicad specctra export with round corners on board
I've just run a quick test along these lines. I was able to trigger
toggle quoted message
Show quoted text
the Spectra export problem with one of my tests (Test1 in the attached zip). This was where I created three edges of a rectangle, block-moved everything, and then added the fourth edge. Nothing is visibly wrong until one looks in the line properties dialog, and then one can see that the line that was added after the move is offset from where it ought to be. The block move only triggered the problem if the grid was metric. Of course I may just have got lucky with the other tests (moving on a US grid and switching metric grids), but at least it looks like we're homing in on the source of the problem. Regards, Robert. On 02/07/2012 17:34, dickelbeck wrote:
What you say here seems plausible. Someone would have to do a bug --
() Plain text email - safe, readable, inclusive. /\ |
Re: Multi-Part Components
To make you application you could use Lazarus. That's a "write once,Thanks, that's certainly worth knowing should I suddenly find myself with the time to write the front end app :). Is the Lazarus driver a proper client-server interface, that would allow the front end to talk to a Firebird server on a remote machine? Firebird can be run "embedded" using a driver, but that would limit kicad to being used by only one engineer at a location, acting as a barrier to it being used professionally. I did look into ODBC and although originally a Microsoft technology it is supported by Linux. The Firebird ODBC driver for Linux is here: I've not checked to see if there are any snags, but the Firebird community is very active and I'm sure they would not tolerate something buggy. Regards, Robert. -- () Plain text email - safe, readable, inclusive. /\ |
Re: Multi-Part Components
Koenraad Lelong
On 02-07-12 21:09, Robert wrote:
The database I'm working on uses Firebird as the back end, which is FOS.Hi Robert, To make you application you could use Lazarus. That's a "write once, compile everywere" RAD environment. It's more or less a clone of Delphi, but very cross-platform. It has native drivers to access Firebird (and other DB's) so ODBC is not needed, since ODBC is mostly Windows. Just my 2 cents. Regards, Koenraad. |
Re: Holes in modules
It's an odd module. All the pins of the LCC will have a pth connected to
toggle quoted message
Show quoted text
the pad and then all the pads connected in two groups. Each of these groups will connect to two surface mount pins that will be the pins of the module. So I would like to be able to add pth's that aren't pins. Is that possible? Maybe numbering all the pads in one group '1' and all the pads in the other group '2' is the right way to handle it. What's the best solution? Thanks, David On 7/2/2012 6:16 PM, Andy Eskelson wrote:
Are you trying to create a module that will suit different components? |
Re: Multi-Part Components
Andy Eskelson
Parts and Vendors... that's the one I was thinking of, my mistake I
thought it was a shareware prog. Andy On Mon, 2 Jul 2012 11:14:09 -0700 (PDT) Jeff Kaskey <jkaskey@...> wrote: FWIW, that's the way I do it. I am using Parts&Vendors (neither open source nor free, and win-only, but reasonably inexpensive) and I dump my KiCad BOM into it and output my purchase lists, kits, etc. Let each tool do what it does best, do not expect KiCad to become an MRP system. |
Re: Holes in modules
Andy Eskelson
Are you trying to create a module that will suit different components?
i.e. pad--pth--pth--pth or pad--pad--pad--pth if so then just a standard pth pad as needed. Tweak the size if need be. Pads with the same number will show up as all connected together in pcbnew. Andy On Mon, 02 Jul 2012 17:48:51 -0400 David Novak <david.novak@...> wrote: I have a need to create a 68 pin LCC module with every pad connected to |
Holes in modules
I have a need to create a 68 pin LCC module with every pad connected to
a plated through hole. Multiple pads will connect together and form 4 different part pins. In other words, I need to include plated through holes in my module that aren't pins. What is the best way to make this happen? Thanks, David |