[kicad-users] BOM errors

[[e-mail] [kicad-users]]

Upgraded to the latest version of Kicad (4.05 ON WIN7 64bit) and just discovered a problem with the BOM generator. I have never used the new BOM generator so it's a bit confusing to me.


I have the bom.csv plug-in loaded and get the following error(s) when I generate a BOM list :
----------------------
Run command:
xsltproc -o "E:/Program Files/KiCad/share/kicad/Projects/MEDIUM WAVE REFLEX RECEIVER/MEDIUM WAVE REFLEX RECEIVER" "E:/Program Files/KiCad/bin/scripting/plugins/bom_cvs.xsl" "E:/Program Files/KiCad/share/kicad/Projects/MEDIUM WAVE REFLEX RECEIVER/MEDIUM WAVE REFLEX RECEIVER.xml"


Command error. Return code 11


Error messages:
I/O error : Invalid argument

I/O error : Invalid argument
-------------------


So, obviously, I'm messing something up. Any suggestions?


N9GOD Don Weissgerber

['John Woodgate' [e-mail] [kicad-users]]

Yes, it's an ongoing issue. I have several times asked about it, but no advice has worked.

With best wishes DESIGN IT IN! OOO – Own Opinions Only
<http://www.jmwa.demon.co.uk/> www.jmwa.demon.co.uk J M Woodgate and Associates Rayleigh England

Sylvae in aeternum manent.

From: kicad-***@yahoogroups.com [mailto:kicad-***@yahoogroups.com]
Sent: Saturday, March 25, 2017 4:45 AM
To: kicad-***@yahoogroups.com
Subject: [kicad-users] BOM errors


Upgraded to the latest version of Kicad (4.05 ON WIN7 64bit) and just discovered a problem with the BOM generator. I have never used the new BOM generator so it's a bit confusing to me.

I have the bom.csv plug-in loaded and get the following error(s) when I generate a BOM list :
----------------------
Run command:
xsltproc -o "E:/Program Files/KiCad/share/kicad/Projects/MEDIUM WAVE REFLEX RECEIVER/MEDIUM WAVE REFLEX RECEIVER" "E:/Program Files/KiCad/bin/scripting/plugins/bom_cvs.xsl" "E:/Program Files/KiCad/share/kicad/Projects/MEDIUM WAVE REFLEX RECEIVER/MEDIUM WAVE REFLEX RECEIVER.xml"

Command error. Return code 11

Error messages:
I/O error : Invalid argument
I/O error : Invalid argument
-------------------

So, obviously, I'm messing something up. An y suggestions?

N9GOD Don Weissgerber

['N.A. Moseley' [e-mail] [kicad-users]]

Hi,

There is a way to generate a BOM in PCBNew. Go to File -> fabrication outputs -> BOM.
Or something along those lines; I dont have kicad here.

It will generate a csv file that you can load into various programs, including a text editor.
It will also group components of the same value, unlike the bom tool in EESchema.

/Niels

Post by 'John Woodgate' ***@btinternet.com [kicad-users]
Yes, it's an ongoing issue. I have several times asked about it, but no advice has worked.
With best wishes DESIGN IT IN! OOO – Own Opinions Only
www.jmwa.demon.co.uk J M Woodgate and Associates Rayleigh England
Sylvae in aeternum manent.
Sent: Saturday, March 25, 2017 4:45 AM
Subject: [kicad-users] BOM errors
Upgraded to the latest version of Kicad (4.05 ON WIN7 64bit) and just discovered a problem with the BOM generator. I have never used the new BOM generator so it's a bit confusing to me.
----------------------
xsltproc -o "E:/Program Files/KiCad/share/kicad/Projects/MEDIUM WAVE REFLEX RECEIVER/MEDIUM WAVE REFLEX RECEIVER" "E:/Program Files/KiCad/bin/scripting/plugins/bom_cvs.xsl" "E:/Program Files/KiCad/share/kicad/Projects/MEDIUM WAVE REFLEX RECEIVER/MEDIUM WAVE REFLEX RECEIVER.xml"
Command error. Return code 11
I/O error : Invalid argument
I/O error : Invalid argument
-------------------
So, obviously, I'm messing something up. An y suggestions?
N9GOD Don Weissgerber

['John Woodgate' [e-mail] [kicad-users]]

Thanks very much. It's not quite easy to import in into Excel in a good format. The steps I found are:

Go to DATA and import 'From text'. In the pane that opens, set the separator to ' ;' (no quotes) and the text designator to 'none'.
Find and replace all " by <space>.
Save as .xlsx file

With best wishes DESIGN IT IN! OOO – Own Opinions Only
<http://www.jmwa.demon.co.uk/> www.jmwa.demon.co.uk J M Woodgate and Associates Rayleigh England

Sylvae in aeternum manent.

From: kicad-***@yahoogroups.com [mailto:kicad-***@yahoogroups.com]
Sent: Saturday, March 25, 2017 11:31 AM
To: kicad-***@yahoogroups.com
Subject: Re: [kicad-users] BOM errors


Hi,

There is a way to generate a BOM in PCBNew. Go to File -> fabrication outputs -> BOM.
Or something along those lines; I dont have kicad here.

It will generate a csv file that you can load into various programs, including a text editor.
It will also group components of the same value, unlike the bom tool in EESchema.
/Niels


On 25 mrt. 2017, at 08:59, "'John Woodgate' ***@btinternet.com <mailto:***@btinternet.com> [kicad-users]"<kicad-***@yahoogroups.com <mailto:kicad-***@yahoogroups.com> > wrote:
Yes, it's an ongoing issue. I have several times asked about it, but no advice has worked.

With best wishes DESIGN IT IN! OOO – Own Opinions Only
<http://www.jmwa.demon.co.uk/> www.jmwa.demon.co.uk J M Woodgate and Associates Rayleigh England

Sylvae in aeternum manent.

From: kicad-***@yahoogroups.com <mailto:kicad-***@yahoogroups.com> [mailto:kicad-***@yahoogroups.com]
Sent: Saturday, March 25, 2017 4:45 AM
To: kicad-***@yahoogroups.com <mailto:kicad-***@yahoogroups.com>
Subject: [kicad-users] BOM errors


Upgraded to the latest version of Kicad (4.05 ON WIN7 64bit) and just discovered a problem with the BOM generator. I have never used the new BOM generator so it's a bit confusing to me.

I have the bom.csv plug-in loaded and get the following error(s) when I generate a BOM list :
----------------------
Run command:
xsltproc -o "E:/Program Files/KiCad/share/kicad/Projects/MEDIUM WAVE REFLEX RECEIVER/MEDIUM WAVE REFLEX RECEIVER" "E:/Program Files/KiCad/bin/scripting/plugins/bom_cvs.xsl" "E:/Program Files/KiCad/share/kicad/Projects/MEDIUM WAVE REFLEX RECEIVER/MEDIUM WAVE REFLEX RECEIVER.xml"

Command error. Return code 11

Error messages:
I/O error : Invalid argument
I/O error : Invalid argument
-------------------

So, obviously, I'm messing something up. An y suggestions?

N9GOD Don Weissgerber

['[e-mail]' [e-mail] [kicad-users]]

I can recommend Boms-away. It is an external python application that
reads your .sch file and lists the parts found. you can add the ordering
info and backannotate the schematic by saving it. after all parts are
populated, you do a export as csv and the rest is done in Gnumeric,excal
etc. so much better than doing everything in excel and making mistakes
in part management.

simon

Post by 'John Woodgate' ***@btinternet.com [kicad-users]
Thanks very much. It's not quite easy to import in into Excel in a good
Go to DATA and import 'From text'. In the pane that opens, set the
separator to ' ;' (no quotes) and the text designator to 'none'.
Find and replace all " by <space>.
Save as .xlsx file
With best wishes DESIGN IT IN! OOO – Own Opinions Only
www.jmwa.demon.co.uk <http://www.jmwa.demon.co.uk/> J M Woodgate and
Associates Rayleigh England
Sylvae in aeternum manent.
*Sent:* Saturday, March 25, 2017 11:31 AM
*Subject:* Re: [kicad-users] BOM errors
Hi,
There is a way to generate a BOM in PCBNew. Go to File -> fabrication outputs -> BOM.
Or something along those lines; I dont have kicad here.
It will generate a csv file that you can load into various programs,
including a text editor.
It will also group components of the same value, unlike the bom tool in EESchema.
/Niels
Yes, it's an ongoing issue. I have several times asked about it, but
no advice has worked.
With best wishes DESIGN IT IN! OOO – Own Opinions Only
www.jmwa.demon.co.uk <http://www.jmwa.demon.co.uk/> J M Woodgate and
Associates Rayleigh England
Sylvae in aeternum manent.
*Sent:* Saturday, March 25, 2017 4:45 AM
*Subject:* [kicad-users] BOM errors
Upgraded to the latest version of Kicad (4.05 ON WIN7 64bit) and
just discovered a problem with the BOM generator. I have never used
the new BOM generator so it's a bit confusing to me.
I have the bom.csv plug-in loaded and get the following error(s)
----------------------
xsltproc -o "E:/Program Files/KiCad/share/kicad/Projects/MEDIUM WAVE
REFLEX RECEIVER/MEDIUM WAVE REFLEX RECEIVER" "E:/Program
Files/KiCad/bin/scripting/plugins/bom_cvs.xsl" "E:/Program
Files/KiCad/share/kicad/Projects/MEDIUM WAVE REFLEX RECEIVER/MEDIUM
WAVE REFLEX RECEIVER.xml"
Command error. Return code 11
I/O error : Invalid argument
I/O error : Invalid argument
-------------------
So, obviously, I'm messing something up. An y suggestions?
N9GOD Don Weissgerber

['John Woodgate' [e-mail] [kicad-users]]

No doubt it's very good for those who do not have to use Windows.

With best wishes DESIGN IT IN! OOO – Own Opinions Only
<http://www.jmwa.demon.co.uk/> www.jmwa.demon.co.uk J M Woodgate and Associates Rayleigh England

Sylvae in aeternum manent.

From: kicad-***@yahoogroups.com [mailto:kicad-***@yahoogroups.com]
Sent: Saturday, March 25, 2017 9:18 PM
To: kicad-***@yahoogroups.com
Subject: Re: [kicad-users] BOM errors


I can recommend Boms-away. It is an external python application that
reads your .sch file and lists the parts found. you can add the ordering
info and backannotate the schematic by saving it. after all parts are
populated, you do a export as csv and the rest is done in Gnumeric,excal
etc. so much better than doing everything in excel and making mistakes
in part management.

simon

Post by 'John Woodgate' ***@btinternet.com [kicad-users]
Thanks very much. It's not quite easy to import in into Excel in a good
Go to DATA and import 'From text'. In the pane that opens, set the
separator to ' ;' (no quotes) and the text designator to 'none'.
Find and replace all " by <space>.
Save as .xlsx file
With best wishes DESIGN IT IN! OOO – Own Opinions Only
www.jmwa.demon.co.uk <http://www.jmwa.demon.co.uk> <http://www.jmwa.demon.co.uk/> J M Woodgate and
Associates Rayleigh England
Sylvae in aeternum manent.
*Sent:* Saturday, March 25, 2017 11:31 AM
*Subject:* Re: [kicad-users] BOM errors
Hi,
There is a way to generate a BOM in PCBNew. Go to File -> fabrication outputs -> BOM.
Or something along those lines; I dont have kicad here.
It will generate a csv file that you can load into various programs,
including a text editor.
It will also group components of the same value, unlike the bom tool in EESchema.
/Niels
Yes, it's an ongoing issue. I have several times asked about it, but no advice has worked.
With best wishes DESIGN IT IN! OOO – Own Opinions Only
www.jmwa.demon.co.uk <http://www.jmwa.demon.co.uk> <http://www.jmwa.demon.co.uk/> J M Woodgate and
Associates Rayleigh England
Sylvae in aeternum manent.
*Sent:* Saturday, March 25, 2017 4:45 AM
*Subject:* [kicad-users] BOM errors
Upgraded to the latest version of Kicad (4.05 ON WIN7 64bit) and
just discovered a problem with the BOM generator. I have never used
the new BOM generator so it's a bit confusing to me.
I have the bom.csv plug-in loaded and get the following error(s)
----------------------
xsltproc -o "E:/Program Files/KiCad/share/kicad/Projects/MEDIUM WAVE
REFLEX RECEIVER/MEDIUM WAVE REFLEX RECEIVER" "E:/Program
Files/KiCad/bin/scripting/plugins/bom_cvs.xsl" "E:/Program
Files/KiCad/share/kicad/Projects/MEDIUM WAVE REFLEX RECEIVER/MEDIUM
WAVE REFLEX RECEIVER.xml"
Command error. Return code 11
I/O error : Invalid argument
I/O error : Invalid argument
-------------------
So, obviously, I'm messing something up. An y suggestions?
N9GOD Don Weissgerber

[Steve Burton [e-mail] [kicad-users]]

Post by 'John Woodgate' ***@btinternet.com [kicad-users]
No doubt it's very good for those who do not have to use Windows.
With best wishes DESIGN IT IN! OOO – Own Opinions Only
www.jmwa.demon.co.uk <http://www.jmwa.demon.co.uk/> J M Woodgate and
Associates Rayleigh England
Sylvae in aeternum manent.
*Sent:* Saturday, March 25, 2017 9:18 PM
*Subject:* Re: [kicad-users] BOM errors
I can recommend Boms-away. It is an external python application that
reads your .sch file and lists the parts found. you can add the ordering
info and backannotate the schematic by saving it. after all parts are
populated, you do a export as csv and the rest is done in Gnumeric,excal
etc. so much better than doing everything in excel and making mistakes
in part management.
simon

Post by 'John Woodgate' ***@btinternet.com [kicad-users]
Thanks very much. It's not quite easy to import in into Excel in a good
Go to DATA and import 'From text'. In the pane that opens, set the
separator to ' ;' (no quotes) and the text designator to 'none'.
Find and replace all " by <space>.
Save as .xlsx file
With best wishes DESIGN IT IN! OOO – Own Opinions Only
www.jmwa.demon.co.uk <http://www.jmwa.demon.co.uk>

<http://www.jmwa.demon.co.uk/> J M Woodgate and

Post by 'John Woodgate' ***@btinternet.com [kicad-users]
Associates Rayleigh England
Sylvae in aeternum manent.
*Sent:* Saturday, March 25, 2017 11:31 AM
*Subject:* Re: [kicad-users] BOM errors
Hi,
There is a way to generate a BOM in PCBNew. Go to File -> fabrication outputs -> BOM.
Or something along those lines; I dont have kicad here.
It will generate a csv file that you can load into various programs,
including a text editor.
It will also group components of the same value, unlike the bom tool in EESchema.
/Niels
Yes, it's an ongoing issue. I have several times asked about it, but
no advice has worked.
With best wishes DESIGN IT IN! OOO – Own Opinions Only
www.jmwa.demon.co.uk <http://www.jmwa.demon.co.uk>

<http://www.jmwa.demon.co.uk/> J M Woodgate and

Post by 'John Woodgate' ***@btinternet.com [kicad-users]
Associates Rayleigh England
Sylvae in aeternum manent.
*Sent:* Saturday, March 25, 2017 4:45 AM
*Subject:* [kicad-users] BOM errors
Upgraded to the latest version of Kicad (4.05 ON WIN7 64bit) and
just discovered a problem with the BOM generator. I have never used
the new BOM generator so it's a bit confusing to me.
I have the bom.csv plug-in loaded and get the following error(s)
----------------------
xsltproc -o "E:/Program Files/KiCad/share/kicad/Projects/MEDIUM WAVE
REFLEX RECEIVER/MEDIUM WAVE REFLEX RECEIVER" "E:/Program
Files/KiCad/bin/scripting/plugins/bom_cvs.xsl" "E:/Program
Files/KiCad/share/kicad/Projects/MEDIUM WAVE REFLEX RECEIVER/MEDIUM
WAVE REFLEX RECEIVER.xml"
Command error. Return code 11
I/O error : Invalid argument
I/O error : Invalid argument
-------------------
So, obviously, I'm messing something up. An y suggestions?
N9GOD Don Weissgerber

--
Met vriendelijke Groet,
Simon Claessen
drukknop.nl

python works on Windows.

C:\Users\sb.WEBDEV.000>python -V
Python 3.5.2

Steve.

[Andrey Kuznetsov [e-mail] [kicad-users]]

The built in BOMs in KiCad work well enough for me. I only use nightlies
because everything else is either buggy or too old and not enough features.
I use bom2csv and bom2csv_grouped. I save output to a .csv file.


THere is a bug in the generated output but it's easy to fix with find and
replace.
Basically, use Notepad++ or manually find ","\n and replace it with ",\n
Grouped output is great for purchasing parts, the other output might be
useful for something else, not sure.

Post by 'John Woodgate' ***@btinternet.com [kicad-users]
No doubt it's very good for those who do not have to use Windows.
With best wishes DESIGN IT IN! OOO – Own Opinions Only
www.jmwa.demon.co.uk J M Woodgate and Associates Rayleigh England
Sylvae in aeternum manent.
*Sent:* Saturday, March 25, 2017 9:18 PM
*Subject:* Re: [kicad-users] BOM errors
I can recommend Boms-away. It is an external python application that
reads your .sch file and lists the parts found. you can add the ordering
info and backannotate the schematic by saving it. after all parts are
populated, you do a export as csv and the rest is done in Gnumeric,excal
etc. so much better than doing everything in excel and making mistakes
in part management.
simon

Post by 'John Woodgate' ***@btinternet.com [kicad-users]
Thanks very much. It's not quite easy to import in into Excel in a good
Go to DATA and import 'From text'. In the pane that opens, set the
separator to ' ;' (no quotes) and the text designator to 'none'.
Find and replace all " by <space>.
Save as .xlsx file
With best wishes DESIGN IT IN! OOO – Own Opinions Only
www.jmwa.demon.co.uk <http://www.jmwa.demon.co.uk/> J M Woodgate and
Associates Rayleigh England
Sylvae in aeternum manent.
*Sent:* Saturday, March 25, 2017 11:31 AM
*Subject:* Re: [kicad-users] BOM errors
Hi,
There is a way to generate a BOM in PCBNew. Go to File -> fabrication outputs -> BOM.
Or something along those lines; I dont have kicad here.
It will generate a csv file that you can load into various programs,
including a text editor.
It will also group components of the same value, unlike the bom tool in EESchema.
/Niels
Yes, it's an ongoing issue. I have several times asked about it, but
no advice has worked.
With best wishes DESIGN IT IN! OOO – Own Opinions Only
www.jmwa.demon.co.uk <http://www.jmwa.demon.co.uk/> J M Woodgate and
Associates Rayleigh England
Sylvae in aeternum manent.
*Sent:* Saturday, March 25, 2017 4:45 AM
*Subject:* [kicad-users] BOM errors
Upgraded to the latest version of Kicad (4.05 ON WIN7 64bit) and
just discovered a problem with the BOM generator. I have never used
the new BOM generator so it's a bit confusing to me.
I have the bom.csv plug-in loaded and get the following error(s)
----------------------
xsltproc -o "E:/Program Files/KiCad/share/kicad/Projects/MEDIUM WAVE
REFLEX RECEIVER/MEDIUM WAVE REFLEX RECEIVER" "E:/Program
Files/KiCad/bin/scripting/plugins/bom_cvs.xsl" "E:/Program
Files/KiCad/share/kicad/Projects/MEDIUM WAVE REFLEX RECEIVER/MEDIUM
WAVE REFLEX RECEIVER.xml"
Command error. Return code 11
I/O error : Invalid argument
I/O error : Invalid argument
-------------------
So, obviously, I'm messing something up. An y suggestions?
N9GOD Don Weissgerber

--
Met vriendelijke Groet,
Simon Claessen
drukknop.nl
python works on Windows.
C:\Users\sb.WEBDEV.000>python -V
Python 3.5.2
Steve.

[Robin Whittle [e-mail] [kicad-users]]

Waking up an old thread . . .

Post by Andrey Kuznetsov ***@gmail.com [kicad-users]
I use bom2csv and bom2csv_grouped. I save output to a .csv file.
There is a bug in the generated output but it's easy to fix with find
and replace. Basically, use Notepad++ or manually find ","\n and
replace it with ",\n

I found these quoting problems in a CSV BoM files produced by the
bom2grouped_csv.xsl translation file which is included with KiCad 4.0.7.
A bug report with a fixed version of this file is:

https://bugs.launchpad.net/kicad/+bug/1722138

The fixed version "bom2grouped_csv-RW-2017.xsl.txt" and some examples of
the quoting problem is at my just-updated page:

http://www.firstpr.com.au/kicad/kicad-data-structures/#group


There are numerous other ways of generating grouped BoMs. It seems
there is quite a cottage industry writing such programs, especially in
Python. I haven't looked in detail at these in general, but this system
looks flexible and well-documented:

https://github.com/SchrodingersGat/KiBoM

My doco on how to get it running with KiCad 4.0.7 under Windows 7 is here:

http://www.firstpr.com.au/kicad/kicad-python-bom-scripts/

I found it easy, and I suggest that something like this written in a
real programming language, rather than the XSLT language of .xls files,
might be more powerful, flexible, robust and better documented.

- Robin

[[e-mail] [kicad-users]]

xsltproc is an abomination and god knows why they chose to inflict it on users. You might find this useful https://github.com/bobc/kicad-doc/wiki/Generate-BOM---Command-error.-Return-code-11 https://github.com/bobc/kicad-doc/wiki/Generate-BOM---Command-error.-Return-code-11

Apart from running a Python script or a third party tool, there is no good native solution for Windows that I have found.