SOLIDWORKS World 2018 Recap: The Future of PLM and Beyond

At SOLIDWORKS World 2012 in San Diego, California, Vice Chairman and CEO of Dassault Systems, Bernard Charles, introduced the 3DEXPERIENCE platform to the SOLIDWORKS community. Bernard explained the concept as “beyond PLM” connecting companies, users, and processes. The idea was introduced as a simple compass that represented the 3DEXPERIENCE platform. Over the next 6 years, the SOLIDWORKS community has been slowly introduced to details about the platform, further explaining the vision of the 3DEXPERIENCE. This year at SOLIDOWKRS World 2018 was no exception. The introduction of SOLIDWORKS 3DEXPERIENCE PLM Services on the 3DEXPERIENCE platform was unveiled by Milos Zupanski, Director or Product Portfolio Management, in one if the keynote presentations […]

SOLIDWORKS 2017 What’s New: SOLIDWORKS PDM Professional Database Replication – #SW2017

SOLIDWORKS PDM Professional 2017 now supports database replication which can be useful in high latency or high usage environments. This is only available in PDM Professional (and not PDM Standard) and requires Microsoft SQL Enterprise Edition 2012 or higher. The way it works is by setting up secondary SQL server(s) that can assist a primary server with “read” type database requests which in turn reduces the load on the primary server. The primary server will still handle any read/write operations such as check ins/outs, workflow transitions, and datacard updates. The secondary servers will handle operations such as folder browsing, contains, where used, UI responsiveness, search, BOM, data card viewing, RMB […]

EPDM Attempts to Automatically Login on Windows Login – Search/Indexing Issue

It has been observed that after upgrading the SOLIDWORKS software in an environment that has its Toolbox in EPDM can cause the EPDM login window to display immediately after logging into Windows even if Automatic Login is enabled. This issue is caused by the Toolbox location in EPDM to be added to the Search Path options in SOLIDWORKS which in turn, adds the path to the Windows Indexing Options since the SOLIDWORKS search capabilities are dependent on Windows Indexing. If you exclusively set indexing locations in Windows do not modify the locations in the SOLIDWORKS Search Paths since this will effect your indexing paths. Upgrading SOLIDWORKS can potentially reset these index […]

Don’t Forget to Update Your Task Scripts When Upgrading EPDM

In recent releases of SOLIDWORKS Enterprise PDM, there have been some nice improvements in the Task add-in functionality. Most EPDM administrators remember to update the add-in itself, but not the scripts that are used in the tasks for the add-in. In most cases this is not enough to get the full benefit of the upgrade. In addition to the Task being upgraded, you will want to ensure that the script used in the task is updated also. This does not happen automatically when you upgrade the Task add-in. To verify the version of the script, open the Task, select "Output File Details", and select "Advanced Scripting Options". Somewhere around the […]

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 […]

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], […]

SolidWorks Enterprise PDM Client Processes

As most of you know, Enterprise PDM is fully integrated into Windows Explorer.  So when you are running Enterprise PDM, you are actually using the windows explorer process, otherwise known as explorer.exe.  But, there are other processes on your PC that play a key role.  When looking at task manager, you will also see 2 other processes: EdmServer.exe and ViewServer.exe. You may have seen these in your task manager, but always wanted to know what they do.  Well, here you go: ViewServer.exe – every 30 seconds or so, this process listens to the archive server for “broadcasted” changes/updates/deletes made by other clients (i.e. if they check out a file) and […]