search

hildogjr / KiCost

Build cost spreadsheet for a KiCad project.
MIT License
503 stars 98 forks source link

Export component type (THT/SMD/Virtual) #374

Closed mdeweerd closed 1 year ago

mdeweerd commented 4 years ago

I do not think there is currently a way to export the component type to the BOM output. That would be usefull as some prototyping companies ask the number of THT/SMD lines/components or ask to identify them in the BOM after uploading that to their service (where they could extract the data from the BOM if present).

hildogjr commented 4 years ago

Unfortunately the XML file from KiCad and others BOM files (Altium / CSV / Eagle / Proteus) doesn't have such information, making impossible to get the "virtual". About the THT/SMD, yes, would be very useful (I also confront this exactly need). There a plan (roadmap) to include the electro-grammar into KiCost making possible (internal) check footprint and values and implement #4. I am just delayed with the current bugs.

About count the parts, I tried an approach one month ago using regex(foo) function but despise available at Google Spreadsheets and LibreOffice Calc, it is not on Microsoft Excel (KiCost spreadsheet should to be opened in those three software). If you give some idea how to dynamic count R/C/... in the spreadsheet (if a delete a line, the value should be updated), should be very useful to this issue.

romain145 commented 4 years ago

@mdeweerd All that's available in the XML file (generated from Eeschema) is the footprint link, where the information you're looking for is embedded within the footprint itself.

As a workaround, you way want to have a look at the exports from Pcbnew. For example: the .rpt , .cmp and in particular the .pos which only contains SMD parts.

mdeweerd commented 4 years ago

I did not examping the xml format in detail - there is some logic in the fact that this information is not in the xml file, but it is useful to have it in the BOM. The information does seem to be included in the report file (*.rpt).

mdeweerd commented 1 year ago

Stale, closing (limiting my issue backlog).