← Back to team overview

kicad-developers team mailing list archive

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