kicad-developers team mailing list archive
-
kicad-developers team
-
Mailing list archive
-
Message #10004
Re: XSL Script to convert BOM XML File to CSV
Hi!, thanks!,
Yesterday I was struggling through the same problem trying to generate
some documentation for a project we must assemble & deliver soon.
I still miss some fields (user inserted) that we (Tome Verissimo, hi!)
include in the schematic parts, like supplier codes, etc..
At this moment, the .csv BOM generator can build a CSV with user fields,
but if you have variable fields in your parts
part1:
field_name_A: "aaa content"
field_name_X: "xxx content"
part2:
field_name_A: "aaa content"
field_name_B: "bob content"
field_name_X: "xxx content"
the field names get lost in export, and the the columns move back and forth across the rows.
So I was thinking to add an extra .CSV writer that takes care of this, and, may be even
some kind of json writer, that writes a dictionary that can be used for interoperability/scripts.
I'd love to have scripting in eeschema, but yet I must get the full stack of pcbnew documented
properly, and eeschema is in the refactoring queue AFAIK.
Greetings,
Mike.
Miguel Angel Ajo
http://www.nbee.es (http://www.nbee.es/)
+34911407752
skype: ajoajoajo
On Wednesday, 17 de April de 2013 at 17:02, Dick Hollenbeck wrote:
> On 04/15/2013 06:11 PM, Stefan Helmert wrote:
> > Hello,
> >
> > the internal BOM generator has too much bugs. I had to use the python plugins, but they are generating only incompatible XML Files or CSV Files without the user defined entries.
> >
> > Now I designed a XSL script, which converts the generated XML Partlist in a CSV file for Libre Office or Open Office. It is very easy to use. You can specify it as a plugin for KiCad
> >
> > It searches for all field names. Generates the table head out of this names and assignes the table entries.
> >
> > Here you can have the script. It would be a pleasure for me to find the file in the next KiCad version in the pluigns directory.
> >
> > Best regards
> >
> > Stefan Helmert
>
> Committed in revision 4100 with changes.
>
> Thanks.
>
>
>
> _______________________________________________
> Mailing list: https://launchpad.net/~kicad-developers
> Post to : kicad-developers@xxxxxxxxxxxxxxxxxxx (mailto:kicad-developers@xxxxxxxxxxxxxxxxxxx)
> Unsubscribe : https://launchpad.net/~kicad-developers
> More help : https://help.launchpad.net/ListHelp
>
>
Follow ups
References