| icon | uncharted |
|---|
| Feature | Read | Create | Update |
|---|---|---|---|
| BOM hierarchy | ✅ | N/A | N/A |
| BOM meta data ** | ✅ | N/A | ✅** |
| BOM quantities | ✅ | N/A | N/A |
| Component thumbnails | ✅ | N/A | N/A |
| BOM Configurations | ✅ | N/A | N/A |
| File derivative transfers (e.g. STEP, DXF) | ✅ | N/A | N/A |
** 2 way sync updates to BOM metadata are available on request
SolidWorks files (*.sldasm, *.sldprt) are utilized to import Bills of Materials (BOMs) from desktop-based CAD software into SharpSync. (Drawing files' BOM's are not currently supported, but if demand is high enough we will consider it) Follow the steps below to begin importing data into SharpSync using CSV files.
- An installation of Solidworks 2023/4 or later (engage us for older versions)
- Download and install the SOLIDWORKS Addin from the
Downloadssection inSharpSync - Installation of the addin
- An assembly or part file
- Drawings Bill of Materials are not supported yet, but talk to us about integration
- From the
Data sourcessection, add the CSV Data Source as the Primary Data Source - Click the
Configurebutton >BOM Configuration - On a new line each, enter the Custom Properties to read
- These properties should be the standard properties that exist in any given SolidWorks file. If it does not exist, a blank value will be used
- Properties are read from the
Configurationtab first, then theCustomtab - Each value entered here will be available as an
Accessor(Property) in theProperty Mappingstab - Make sure to add the Quantity / Qty / qty. column (this will be used later in the property mappings). (The exact naming is not important, as long as it reflects the quantity of parts in an assembly)
For example if you want to display custom properties
Number,Description,Material, then enter these on a new line each
- Click the
Savebutton - On the main Data Source tab, make sure that the
Primary Component Identifiermatches with yourNumbercustom property.
The primary component identifier is the identifier that is unique across data source domains. If this is Number or No or PartNumber then the assumption is this property exists in both SolidWorks and your ERP solution.
{% hint style="success" %}
It does not have to be called Number. It can be called anything as long as it exists as a SolidWorks custom property. If it does not exist, the file name will be used as the fallback value
{% endhint %}
In the example below I've setup
- Number
- Description
- Revision
- Qty (Settings > Is Quantity property must be enabled)
After installing the SOLIDWORKS add-in, you'll need to configure how it will generate BOMs. Make sure your SOLIDWORKS files have the required properties. (Flattened BOMs are not supported)
- Click Tools > SharpSync > Login
- Enter your SharpSync username / password > Click Login
- If successful, the window will close
- Click Tools > SharpSync > Settings
- Click the radio button to use
Custom Property
- Click the radio button to use
- If the login succeed you should see the
Primary Component Identifierlisted - This is the preferred method of working with the BOM
Pushing data from SolidWorks to SharpSync is easy and straight forward. To push a Bill of Materials (BOM) to SharpSync do the following:
- Open a part or assembly file
- Make sure you've logged in to SharpSync (Click the login button at least once)
- Click the Push BOM button
- The active configuration of the assembly is used to display data in SharpSync
Click the button to send the Bill of Materials to SharpSync
- The configuration for the assembly is loaded in SharpSync.
- The version will always be shown as
current. - If you want to use information from different versions, the add-in for
SolidWorks PDM Professionalis recommended.
In the example below, the hierarchy in SharpSync is displayed using the mapped Number property mapped in SharpSync.
Notice that the component names are taken from the Number primary component identifier
You're now ready to submit this to your ERP.


