Importing legacy data is one of the most painful stages of any business system PDM, PLM, ERP, and practically any other system. To import data is a project that usually underestimated the amount of complexity, data cleaning, data import, and validation. OpenBOM is very different from many other BOM management and PLM systems you know.…
OpenBOM data organization contains Bills of Materials and Catalogs. If you’re not familiar with data modeling in OpenBOM I recommend you to check a few articles to get up to speed. OpenBOM Data Management Fundamentals How Many Catalogs To Create in OpenBOM In some situations, you can create a Bill of Materials from the CAD…
The spreadsheets are part of everyday life for every single manufacturing company. People love them despite all the mess they can bring. And people hate them because of the same reasons. At OpenBOM we are taking an approach to integrate spreadsheets into the user experience and workflows in a non-invasive way. So, we are good…
Excel (or spreadsheets) is one of the greatest inventions of IT for the last decades. Flexible, powerful and easy to use. But, it brings too many problems when it comes to engineering and product data management. In my Do’s and Don’ts of Escape Plan from Excel, I shared my recommendation on how you can move…
Best practices of Import BOM or Catalog to OpenBOM from your existing spreadsheet The things are rarely happening in the vacuum. Usually, you have already a bunch of data in spreadsheets you want to bring to OpenBOM to keep managing or using this data in the future. What are the most typical use cases? Over…
We’ve been getting many requests to expand OpenBOM integration with Google Sheet. I’m happy to share some early information about OpenBOM import from Google Sheet coming in the next release (yay!!!). So, let’s say, I want to import BOM from the following Google Sheet The first function will integrate Google Sheet file picker from OpenBOM import…
Another cool new feature coming soon in OpenBOM. Many of you asked us how to transform your existing BOM spreadsheets into nested structure Bill of Materials. For many companies, the structure like I show on the image before is a very typical way to store and manage Bill of Materials. How to transform this flat…