CAD-BOM synchronization using OpenBOM

Oleg Shilovitsky
Oleg Shilovitsky
25 June, 2019 | 4 min for reading
CAD-BOM synchronization using OpenBOM

One of the questions often asked by OpenBOM users and customers is how OpenBOM is merging data between CAD systems and Bill of Materials in OpenBOM. After talking to many users, I thought I’m ready now to write an article to summarize it and also clarify some potential misunderstanding.

To start with, I’m talking about the situation when we have OpenBOM CAD plug-in used for one of the available CAD integrations. In such a case, we do have CAD integration (running on the desktop or cloud) and OpenBOM running independently.

Here is an example of Solidworks OpenBOM plug-in installed in Solidworks desktop system

The question is what happens when you create a BOM for the first time? And what happens when you create/update BOM one more time? Will OpenBOM check all BOM parts and create a difference? How comparison of the data is done? What is the procedure?

This is a great question. At OpenBOM we call it “Merging”.  That’s the act of updating an existing BOM (or catalog) from CAD.  In a nutshell, here is what happens:

When you click Create/Update BOM from the CAD system, we look to see if a BOM already exists in OpenBOM.  If not we create one. Done.

If a BOM does exist:

1) We update the items (parts/assemblies) by part number in the BOM with values from the CAD system.  So, if you have CAD part with the part number (or name) ABC and we extracted 10 properties from CAD for that Part Number (FileName), then on the update, we would re-write (overwrite) those 10 properties from CAD to the BOM.  This ensures that any changes made to any part/assy properties in CAD are written to the BOM on update.

2) If you added properties (columns) in OpenBOM (which do not exist in CAD) we do nothing.  So, if you added Cost to your BOM and we updated from CAD, we would NOT change Cost. It (and any other properties added to the BOM) are untouched.  This ensures that any properties or values which are mastered in the BOM (eg. added in the BOM) are NEVER overwritten by CAD update.

3) If you add a line to the BOM.  Let’s say for “Glue” or ‘Tape” or some other item which is not in CAD.  We do nothing on Create/Update. This ensures any items you ADD to the BOM are persistent and will remain in the BOM following a CAD update.

4) If you Remove an item from the BOM which was created as a result of CAD. (in other words, it is in CAD), then run an update, OpenBOM will recreate that item in the BOM.  So, if the part number exists as a CAD part, and you create/update a BOM, you will get the same part number. Even if you had previously removed it from the BOM. If you wish to more permanently remove it from the BOM, the best way is to remove it from the BOM then mark it in CAD as “Do not show in BOM” so it will not come back on the next Create/Update BOM operation.

Here is a typical scenario of working with CAD plug-in and OpenBOM:

  1. Create the BOM
  2. Don’t change the data in the BOM which is mastered in CAD (it will be overwritten during the update)
  3. Use Add property command (apply to all level) if you need more column (like Cost, etc.)
  4. Run Create/Update BOM command from CAD plug-in to routinely update that BOM.

The following video can give you an example of using OpenBOM for Solidworks

Conclusion.

OpenBOM gives you a very flexible and powerful way to integrate any CAD system and information from the CAD system and convert it into the online bill of materials. Moreover, OpenBOM will keep the information in sync all the time and allows you to streamline design to the manufacturing process.

For more information about OpenBOM CAD integrations, check OpenBOM Integrations.

Best, Oleg

PS. Let’s get to know each other better. If you live in the Greater Boston area, I invite you for a coffee together (coffee is on me). If not nearby, let’s have a virtual coffee session — I will figure out how to send you a real coffee.

Want to learn more about PLM? Check out my Beyond PLM blog and PLM Book website

Related Posts

Also on OpenBOM

4 6
29 November, 2022

Welcome to the last set of videos from OpenBOM Video Demo Series. In this article today, I’m going to cover…

25 November, 2022

There are multiple holidays you need to work around as a manufacturing company. However, there is one holiday that heavily…

24 November, 2022

Change is the most important and permanent thing when it comes to design, product engineering, manufacturing, and procurement. OpenBOM gives…

23 November, 2022

Welcome to another article featuring the OpenBOM introductory video demo series. Check out our earlier articles from our series below. …

23 November, 2022

To continue the new OpenBOM video demo series today we are going to talk about how to perform calculations. Making…

22 November, 2022

Are you using Onshape and looking for an effective way to streamline your CAD downstream process? If so, then OpenBOM…

18 November, 2022

Our VP of Products, Steve Hess sat down with Tomcar’s Chief Engineer Jonathan Drori to talk about Tomcar’s recent developments…

18 November, 2022

Another exciting OpenBOM release is out and in today’s article, I want to take you through the highlights of the…

18 November, 2022

Manufacturers are always looking for ways to improve their overall bottom line and grow. In order to do this, some…

To the top