Randy,
You didn't read my post. I'll repeat it here:
"Have you used the radio button on the BOM export that sets the field
separator for spreadsheet import?"
I'm guessing you are completely ignoring the dialog that gets popped up
when you export the BOM, because it allows you to set how the components
are organised and the field separator. You must also be ignoring the Excel dialogs, because they allow you to select a separator (at least they do on my copy, and Libre/OpenOffice has the same feature).
Regards,
Robert.
toggle quoted message
Show quoted text
On 05/07/2012 07:18, randyinnc55 wrote:
Andres-
This does the trick, thanks. My only issue is that they are not
organized by reference designator type. All the different types are
mixed together. In other words it would be nice if the list was
organized by capacitors (Cx), then diodes (Dx), then connectors (Jx),
etc, etc, and finally integrated circuits (Ux) instead of mixed
together. Oh well, it is close enough.
The other interesting thing I found is that KiCad uses ; as the field
delimiter and then saves the file by default as a .csv type. If you
then try to open the file that is made with Excel, it assumes that a
comma , is the field delimiter (it is a "comma spaced variable" file
after all I suppose). Even using Excel's Data> Text to Columns...
menu choice and telling Excel that the field delimiter is ; and not ,
it still wouldn't format properly. The only way I could get that to
work was to change the file extension from .csv to .bom. Then Excel
opened and formatted the file perfectly. So the lesson learned would
be to save the BOM file with an extension other than the default
.csv. Maybe .txt or .bom for example.
Thanks! -Randy
--- In kicad-users@..., Andres Kasulin<andreskasulin@...>
wrote:
pcbnew formats BOM similar to what you asked. Go to
"File"->"Fabrication Outputs"->"BOM File".
Check this thread:
________________________________ De: randyinnc55<rluck1@...> Para:
kicad-users@... Enviado: mi??rcoles, 4 de julio de 2012
10:27 Asunto: [kicad-users] 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!
------------------------------------
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 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
! Groups Links
--- avast! Antivirus: Inbound message clean. Virus Database (VPS):
120704-0, 04/07/2012 Tested on: 05/07/2012 08:04:34 avast! -
copyright (c) 1988-2012 AVAST Software.
--
() Plain text email - safe, readable, inclusive.
/\
