Data Management: Managing Legacy Data with SOLIDWORKS PDM

Data Management: Managing Legacy Data with SOLIDWORKS PDM

Table of Contents


As a PDM administrator, the most time-intensive task youโ€™ll be faced with as you set up your vault is cleaning up your existing data so you can start with a clean slate. In this article, Iโ€™ll be highlighting some of the tools and techniques available in SOLIDWORKS PDM Professional to help you clean up and make your SOLIDWORKS files more accessible.

To decide on a plan for your migration project, youโ€™ll first want to get a solid gauge of where your data is coming from, how much data you have and how much cleanup there still is to do. If youโ€™re coming from another PDM software, such as SOLIDWORKS Workgroup PDM, youโ€™ll want to consider contacting our services team to get a quote so we can perform the migration for you:

https://www.hawkridgesys.com/services

One of the most common questions we get when customers are migrating their data is, โ€œWhy donโ€™t we just move all of our data into the vault first, and clean up later?โ€ We donโ€™t recommend doing this because when you copy a file into the vault that has references to other files, PDM is reading the locations of all the references from inside the file. It then saves these locations to the database so you can easily locate them later. If you have a lot of broken references going in, youโ€™re probably making more work for yourself by trying to fix these once that information has already been saved into the database. Rather than starting with broken references, you want to have a clean slate going in to give yourself the best chance at a successful implementation.

If youโ€™ve decided youโ€™d like to try migrating the files yourself, getting the total file size of everything youโ€™re migrating is a good start. But youโ€™ll also want to consider how diligent youโ€™ve been when creating and saving your models to make sure the reference information is correct. Any file that has incorrect or missing reference information should be cleaned up prior to migration.

If you think this might be too much work to be worth migrating everything, you might consider a partial migration โ€“ leaving the rest of the files outside the vault. Below are some of the possible migration scenarios โ€“ color coded from quickest to longest migration time:

Migrate nothing – Leave existing files as they are and start fresh in PDM.

Migrate as needed – Leave files where they are, and leave it to engineers to move files into the vault when they need to use them.

Migrate important/current projects only – Hybrid of leaving legacy files outside of the vault and migrating all files.

Full Migration – Migrating all files into the vault.

Itโ€™s recommended to migrate all files into the vault if possible to take full advantage of PDM permissions, searchability and revision management. Once youโ€™ve decided on a strategy, itโ€™s time to start the (sometimes) lengthy process of cleaning up your references.

Data Management: Managing Legacy Data with SOLIDWORKS PDM - Image 1

If youโ€™ve moved or otherwise broken the link to some of your referenced parts used in multiple assemblies, it may be worth taking a look at โ€œToolsโ€ > โ€œOptionsโ€ > โ€œFile Locationsโ€ > โ€œReferenced Documents.โ€

Data Management: Managing Legacy Data with SOLIDWORKS PDM - Image 2

This dialog will tell SOLIDWORKS where to look if itโ€™s not able to locate a reference. Keep in mind this does not automatically search any subfolders of the folder you specify; youโ€™ll need to explicitly add any subfolders youโ€™d like SOLIDWORKS to search. You may want to use the SOLIDWORKS Task Scheduler as well to automate opening and saving your files with the correct paths.

Once all your files have been saved with the correct references, itโ€™s time to copy them into the vault using a Copy > Paste, or drag and drop. Keep in mind that all files should be checked in after theyโ€™ve been copied so other users can work with them.

Once your files are in the vault, there are several handy tools that can help save you some time organizing your files to make them easier to work with:

Set Revision

Synchronizes the back-end PDM revision counter with existing Revision custom property value in files.

Data Management: Managing Legacy Data with SOLIDWORKS PDM - Image 3

If your files already have a Revision property before you bring them in, this tool can help PDM line that revision value up with a matching PDM revision number counter value. This ensures that the next revision the file gets in PDM will be correct. You can use this tool on folders and/or checked in files by selecting them in your vault view, and going to Modify > Set Revision. Right clicking anywhere in this tool will give you options for updating the revisions for multiple files. You can also optionally check the โ€œUpdate Variableโ€ box if you would like to update the PDM Revision variable to be in sync with what PDM thinks is the current revision.

In order to select a โ€œNew Revisionโ€ value, files must be in a workflow state with a value in its โ€œIncrement Byโ€ section under the โ€œRevision Numbersโ€ tab. Youโ€™ll also want to make sure youโ€™ve selected your revision variable in the upper-right dropdown of the โ€œRevision Numbersโ€ tab in the state properties.

Data Management: Managing Legacy Data with SOLIDWORKS PDM - Image 4

Move Tree

Moves and renames files in batch.

Data Management: Managing Legacy Data with SOLIDWORKS PDM - Image 5

This tool is a more powerful version of SOLIDWORKS โ€œPack and Goโ€ for files in the vault. It allows you to grab all a fileโ€™s references then move and rename them. One helpful option with this tool is โ€œPreserve Relative Pathsโ€. This adds the relative path of the file to the destination path, so you can duplicate whole folder structures along with the files being moved. If you select โ€œPreserve Relative Pathsโ€ and change the โ€œDefault Pathโ€ to the vault root folder, you can rename all files in place without moving them โ€“ even if theyโ€™re in different folders. This can be helpful when combined with the โ€œRename with Serial Numberโ€ option to turn your existing inconsistent โ€œsmartโ€ part names into more consistent โ€œdumbโ€ part names that donโ€™t rely on manual user input.

Update References

Manually updates a PDM file reference.

Data Management: Managing Legacy Data with SOLIDWORKS PDM - Image 6

If you need to replace a file reference after a file has been added to the vault, the โ€œUpdate Referencesโ€ tool allows you to manually point PDM to a new location. This is done on a per file basis, so itโ€™s recommended for one-off, or occasional use, as it is more of a time intensive process to use for multiple files. You can use the โ€œFind Filesโ€ button to help locate other instances of files in the vault and redirect the file paths to point to them, or the โ€œAdd Files to Vaultโ€ option to move new references from outside into the vault.

File Version Upgrade

Standalone tool for upgrading SOLIDWORKS files to the latest version inside the vault after migration. It can also help fix file references.

Data Management: Managing Legacy Data with SOLIDWORKS PDM - Image 7

This is a standalone tool that needs to be installed separately from PDM. It also requires SOLIDWORKS to be installed on any computers running the task. This tool lets you pick files in the vault to check out, open, rebuild, save and check in. It gives you many filtering options and even lets you run the process on multiple computers at the same time to share the load. If you set up the correct โ€œReference Documentsโ€ locations in your SOLIDWORKS options, any missing references will automatically be repointed and saved with the file if found. The installation files for this tool can be found in the PDM Client installation files folder under the โ€œSupportFileVersionUpgradeโ€ subfolder. For more information on this tool, consult the SOLIDWORKS PDM web help, or the โ€œInstallation Guideโ€ PDF file found in the PDM client installation directory.

For more information, check out ourย YouTube channel, get a SOLIDWORKS PDM quoteย or contact us atย Hawk Ridge Systemsย today. Thanks for reading!

Picture of Jake Howard

Jake Howard

Jake Howard is a PDM Specialist at Hawk Ridge Systems. He has a B.S. in Business Information Systems from Oregon State University, and has Professional-level certifications for SOLIDWORKS PDM. He has a passion for creating, and in his spare time, he enjoys programming and video game development, as well as many outdoor activities, such as camping and competitive sports.