BOM export only SMT

Drawing Schematics, Hierarchical Design, BOM, Exporting net-lists, etc.
Post Reply
Message
Author
nissebola
Posts: 19
Joined: 02 Nov 2011, 09:17

BOM export only SMT

#1 Post by nissebola » 16 Oct 2020, 08:17

Hi,
Has anyone found out a way to export a BOM including only SMT-components for a mixed PCB ?

I want to send this BOM to a PCBA subcontractor for quotation.
The design has a mix of SMT and TH components.
We will populate the TH components ourself afterwards.

BR/Nissebola
BR/Nissebola

Serg
Technical Support
Posts: 391
Joined: 09 Jun 2010, 08:12

Re: BOM export only SMT

#2 Post by Serg » 19 Oct 2020, 04:37

Now you can only edit BOM file in the text editor.
But the similar feature already developed.
You will be able to delete the some components from BOM list before exporting.
It will be available in the next update.

SoundMod
Posts: 61
Joined: 15 Feb 2016, 12:47

Re: BOM export only SMT

#3 Post by SoundMod » 19 Oct 2020, 22:00

The way I do that is using a python script.
But basically the idea is the following.

1. For each component, create an additionnal field in the property to define if the part is SMT or TH.
Capture01.PNG
2. Within diptrace with the BOM tool, you add the column with the parameter LANDPATTERN TYPE.

3. Export the BOM file as .csv.

4. Load the .csv with your python script, make your script check if the "landpattern type" is set to SMT or TH.
If set to TH, make you script change the quantity to 0.
Make you script write the csv file as an excel file.

There plenty of ressources on how to read/write/modify .csv file and .xlsx file.

It needs some work but once it works, it works fast and you can modify the behaviour since its yours.
You do not have the required permissions to view the files attached to this post.

nissebola
Posts: 19
Joined: 02 Nov 2011, 09:17

Re: BOM export only SMT

#4 Post by nissebola » 22 Oct 2020, 03:40

Thanks SoundMod,
I´ll follow your advise while waiting for the coming up version.
BR/Nissebola
BR/Nissebola

SoundMod
Posts: 61
Joined: 15 Feb 2016, 12:47

Re: BOM export only SMT

#5 Post by SoundMod » 23 Oct 2020, 10:16

Serg wrote:
19 Oct 2020, 04:37
Now you can only edit BOM file in the text editor.
But the similar feature already developed.
You will be able to delete the some components from BOM list before exporting.
It will be available in the next update.
That's good news ! :geek:

Could we get a glimpse of what's coming for the next minor update ?

Serg
Technical Support
Posts: 391
Joined: 09 Jun 2010, 08:12

Re: BOM export only SMT

#6 Post by Serg » 26 Oct 2020, 09:25

SoundMod wrote:
23 Oct 2020, 10:16
Could we get a glimpse of what's coming for the next minor update ?
Probably will be add the next features:
-"BOM" in PCB Layout
-"Interactive BOM and export HTML" in PCB Layout
-"Keep Raster Image" while placing a picture
-"Assembly Variants" in Pick and Place
-3D Models for all SMD packages in Pattern Generator
...
The full list will be after updating.

SoundMod
Posts: 61
Joined: 15 Feb 2016, 12:47

Re: BOM export only SMT

#7 Post by SoundMod » 27 Oct 2020, 10:11

Serg wrote:
26 Oct 2020, 09:25
Probably will be add the next features:
-"BOM" in PCB Layout
-"Interactive BOM and export HTML" in PCB Layout
-"Keep Raster Image" while placing a picture
-"Assembly Variants" in Pick and Place
-3D Models for all SMD packages in Pattern Generator
...
Ohhhh "Assembly Variants" that is nice :D.
I'm eager to see what "Interactive BOM" is all about and to see to full list of improvment.

Cheers

Post Reply