PLM decoded – What’s a BOM?

WARNING: Do not read this post out loud in an airport or on a plane! What’s a BOM? In the context of companies that design and manufacture products, BOM is short for Bill of Material. I like to think of a BOM as a shopping list of items needed to make a product. If your product is a bicycle, your BOM would include tires, spokes, frame, seat, handlebars, and all the other items needed to build a ready-to-ride bike. It would also include important information like how many of each part is required and which of the seats you stock is the right one for this bike. The BOM might […]

Enterprise PDM/SOLIDWORKS PDM Professional: Upgrade Test Licensing

Enterprise PDM, soon to be known as PDM Professional, has undergone some changes in terms of licensing in 2015 and later. No longer will a new license file be needed to upgrade from one major release to another. Instead, PDM will be utilizing the same type of SolidNetworkLicense Manager as SOLIDWORKS has been using for years. This allows all of the PDM license to be updated and activated online using the serial numbers that you can access from the SOLIDWORKS customer portal. However, this may pose as an issue if you are looking to set up a new test environment for upgrading. If you are setting up a brand new […]


Just this week SOLIDWORKS announced the pre-release of SOLIDWORKS 2016.  Included in the release is a face lift on ENTERPRISE PDM, which includes a name change to SOLIDWORKS PDM Professional.  No longer will the EPDM abbreviation be used, but instead the product naming will line up with the other products distributed by SOLIDWORKS (i.e. SIMULATION).  In addition, SOLIDWORKS is launching a brand new product for PDM called SOLIDWORKS PDM Standard.  This product will be a trimmed down version of SOLIDWORKS PDM Professional (formally EPDM), designed for smaller teams of engineers at a single site.  More blogs will come out in the coming weeks with the new look, new features, and Standard vs. […]

Parallel Approval Data Mapping Is Finally Here In EPDM 2015!

In SOLIDWORKS Enterprise PDM 2013, parallel workflow transitions were introduced. This was the start to make setting up and administering parallel workflow processes easier. This was a great method as long as you didn't need to map variables for each individual approver. Traditionally to map individual approvers, you would need to create a workflow loop with an extra workflow state and two automatic transitions with conditions utilizing variables to determine when all approvals were received before the file would proceed in the workflow. This would also create a new version of the file every time it would go through the loop. So, does your head hurt yet? Well, now in EPDM […]

How To Find folders With Large Folder Counts In SOLIDWORKS Enterprise PDM

 In a previous blog, we provided a query to find folders that had a large file count (>1000 files). Folders of this size can lead to performance issues in SOLIDWORKS EPDM when browsing or referencing files in these folders. It is also possible that folders with a high number of folders can cause performance issues. You can use the following query to determine folders with high folder counts. SELECT P.Name AS FolderName, P.Path, COUNT(PT.ProjectID) AS 'Number of folders found' FROM Projects P JOIN ProjectTree PT ON PT.ProjectID = P.ProjectID WHERE P.FolderType = 1 AND P.Deleted = 0 GROUP BY P.Name, PT.ProjectID, P.Path HAVING COUNT(PT.ProjectID) > 1000 Jeff Barker | Senior Consultant […]

How To: Set Default Values on Enterprise PDM Search Cards

Search is easily the most used feature in Enterprise PDM. Would you like to save your users time and effort finding the files they need? Try adding default values to your search cards to make searching easier. Here is how to do it 1. Open the search card in the card editor 2. Identify the variables (search fields) you want to set – Notice that you can't set a default value in the property pane like you can in all other card types 3. Open the "Default Values" command from the "Card" menu 4. Set your defaults It is just that easy. Here is a list of commonly used default values: […]

Indexing Services for 2014 EPDM Content Search No Longer Available on Windows Server 2012

If you are planning to upgrade your SolidWorks Enterprise PDM server operating system in the near future, you may want to reconsider if you use Content Searching in EPDM. Content Searching will search the text contents and properties of a document. Enterprise PDM content search uses the Microsoft Indexing Service to create a catalog for each indexed vault. The catalog contains index information and stored properties for all versions of all documents in the vault archive folders. In Windows Server 2012, Microsoft discontinued the Indexing Service and replaced it with Microsoft Search Server Express for the server search side. Even though EPDM 2014 is supported on Windows Server 2012, the […]

How to find folders with large file counts in SolidWorks Enterprise PDM

After a file migration into EPDM, it is sometimes common to have folders with very large file counts (greater than 1000 files). This can contribute to slow performance when browsing through and opening folders with a large file count. The following is a query that will identify the folders with these large file counts. There is also more information about this query that can be found in the SolidWorks Customer Portal in solution S-048678. The query below has been modified from the query in the crp file in this solution to exclude files and folders that have been deleted, but not yet destroyed in EPDM. Once identified, you will want […]

Ever wanted to know what variables you have mapped in SolidWorks Enterprise PDM (EPDM)?

Here's a SQL script that will list all of the variables in your EPDM vault, their variable type, unique flag, mandatory flag, block, file extension, and what file attributes they are mapped to. This information can be very useful when troubleshooting issues such as when card or titleblock information is not being updated. Otherwise, it is a good method to document your variable setup within EPDM. Select V.VariableName as [Variable Name], CASE V.VariableType WHEN '1' THEN 'Text' WHEN '2' THEN 'Integer' WHEN '3' THEN 'Decimal Number' WHEN '4' THEN 'Yes or No' WHEN '5' THEN 'Date' END as [Type], CASE V.FlagUnique WHEN 1 then 'Yes' ELSE '' END as [Unique], […]

Script to kill all connections to a database

Whether you are restoring an EPDM Database or modified tables in an existing EPDM Database, you are required to stop connections to the database before continuing. Most of the time you can simply stop the SolidWorks Enterprise PDM Archive and Database services and that should kill the connections. However, sometimes this is not enough and this is where this script comes in handy. USE master GO ALTER DATABASE YourDatabaseName SET OFFLINE WITH ROLLBACK IMMEDIATE GO