kicad-developers team mailing list archive
-
kicad-developers team
-
Mailing list archive
-
Message #10005
Re: XSL Script to convert BOM XML File to CSV
I'm a little bit lost here, where do you get the .xml output to use with the .xsl ?
Miguel Angel Ajo
http://www.nbee.es (http://www.nbee.es/)
+34911407752
skype: ajoajoajo
On Wednesday, 17 de April de 2013 at 17:17, Miguel Angel Ajo wrote:
> 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