Printed Circuit Board Assembly & PCB Design Forum

SMT electronics assembly manufacturing forum.

SMTnet
»
Electronics Forum
»
Software for matching BOM/CAD data

Software for matching BOM/CAD data

Subscribe to Thread

Hello, Does anyone know some good softwares/tools for match... - Jul 29, 2024 by jerGOD

You can try SMT Maestro ... - Jul 29, 2024 by Szilard

Okay, havent heard about that. Thanks. Where i can find this... - Jul 30, 2024 by jerGOD

SMT Maestro is long gone from the wider web. You have to beg... - Jul 30, 2024 by Spoiltforchoice

Yes, i found program from earlier posts. thanks. Yes, seems ... - Jul 30, 2024 by jerGOD

If both BOM and CAD are Excel spreadsheets, you could write ... - Jul 30, 2024 by ProcEng1

Hello. Last Excel (from 2018) allows you to split cell into ... - Aug 01, 2024 by Zerk

There are several solutions on forums &amp;amp;amp; ... - Aug 02, 2024 by Spoiltforchoice

Attach a screenshot of a text document? This forum for all o... - Aug 02, 2024 by MistrThou

We definitely need more moderation from SPAM accounts, unfor... - Aug 02, 2024 by ProcEng1

For a while at least a typo on the URL revealed there was at... - Aug 02, 2024 by Spoiltforchoice

jerGOD

#91220

Software for matching BOM/CAD data | 29 July, 2024

Hello,

Does anyone know some good softwares/tools for matching CAD and BOM files (excel files/CSV files).

In attachments is example. So basicly i need to add component code to CAD file for every ref.des and that component code can be found from different file (BOM).

If someone have good solution for that i would like to hear that. :)

Attachments:

reply »

Szilard

#91222

Software for matching BOM/CAD data | 29 July, 2024

You can try SMT Maestro

reply »

jerGOD

#91227

Software for matching BOM/CAD data | 30 July, 2024

Okay, havent heard about that. Thanks. Where i can find this program?

reply »

Spoiltforchoice

#91228

Software for matching BOM/CAD data | 30 July, 2024

SMT Maestro is long gone from the wider web. You have to beg those of us who have a copy to share a link or find one of the previously shared links in this forum and see if it is still active. Technically this basic requirement is not that difficult to code yourself, but it is good enough that my own version lies half finished for lack of time. SMT Maestro stops short of including other useful features that you might want to include. Things like recognizing spaces after commas in the list of references, or understanding how to expand a reference range like C1-6,9,11,12,15 are missing.

reply »

jerGOD

#91229

Software for matching BOM/CAD data | 30 July, 2024

Yes, i found program from earlier posts. thanks. Yes, seems like it doesnt work for references like C1-9 etc. But for me it seems to be good enough for most of cases!

reply »

ProcEng1

#91231

Software for matching BOM/CAD data | 30 July, 2024

If both BOM and CAD are Excel spreadsheets, you could write a routine to search the BOM for the REF DES, and then paste the Manuf PN from the column in that row. The issue becomes if you are searching for R1, it's going to find R10, R11, R12 etc. When I do similar functions, I search for R1, <- to include the comma.

I use Circuitcam (which is no longer supported) and I would assume it's replacement, Factory Logix does the same thing. I use the CAD file to import the board files (or GERBER layers), then import the BOM and it connects the part numbers by the references in both.

reply »

Zerk

#91250

Software for matching BOM/CAD data | yesterday at 12:50 PM

Hello. Last Excel (from 2018) allows you to split cell into rows with Power Query (see on youtube) So you can split your Bom into rows, sort by REFDES, and then combine it with your CAD file.

reply »

Spoiltforchoice

#91252

Software for matching BOM/CAD data | today at 10:38 AM

There are several solutions on forums &amp;amp; youtube for breaking up a cell into multiple rows.

I have this macro in LibreOffice Calc for expanding ranges if only I knew how to format on this hideous forum software REM ***** BASIC *****

Function ExpandString(input_string As String) As String, Dim prefix As String Dim numbers As String Dim elements() As String Dim expanded_elements() As String Dim element As String Dim startNum As Integer Dim endNum As Integer Dim i As Integer Dim result As String prefix = Left(input_string, 1) numbers = Mid(input_string, 2) elements = Split(numbers, &amp;quot;,&amp;quot;) ReDim expanded_elements(0) For Each element In elements If InStr(element, &amp;quot;-&amp;quot;) &amp;gt; 0 Then startNum = Val(Split(element, &amp;quot;-&amp;quot;)(0)) endNum = Val(Split(element, &amp;quot;-&amp;quot;)(1)) For i = startNum To endNum ReDim Preserve expanded_elements(UBound(expanded_elements) + 1) expanded_elements(UBound(expanded_elements) - 1) = prefix &amp;amp; i Next i Else ReDim Preserve expanded_elements(UBound(expanded_elements) + 1) expanded_elements(UBound(expanded_elements) - 1) = prefix &amp;amp; element End If Next element result = Join(expanded_elements, &amp;quot;,&amp;quot;) ExpandString = result End Function

reply »

MistrThou

#91254

Software for matching BOM/CAD data | today at 11:52 AM

Attach a screenshot of a text document? This forum for all of the benefit of the knowledge has a lot of bad going on (spam, bots, lack of moderation)

reply »

ProcEng1

#91255

Software for matching BOM/CAD data | today at 11:54 AM

We definitely need more moderation from SPAM accounts, unfortunately.

reply »

Spoiltforchoice

#91257

Software for matching BOM/CAD data | today at 12:03 PM

For a while at least a typo on the URL revealed there was at least a trial installation of an alternative forum software, some delay and hoops to jump through should kill the worst spam. I will edit my earlier post with an attachment of some kind at a later point.

reply »