Importing Files with Existing Revisions into an EPDM Vault

Importing Files with Existing Revisions into an EPDM Vault

Table of Contents

Manual Revisions

When working with SOLIDWORKS files outside of any PDM system, it is very
common to want to manage the revisions of your files by manually setting the
custom property values. You would simply define a “Property Name,” (most
commonly “Revision” or “Rev”) and then set the value:

Excel sheet

With these values set, you could then push these mappings onto a drawing to
display the revision and maintain your production system. However, the problem
with this scenario is that it requires a lot of discipline and upkeep to
ensure that everything is at the revision level it should be. As a result, it
is common to invest in a PDM system (especially EPDM) to have the revisions
automatically managed.

Importing Files with Manually Set Revisions into an EPDM Vault
However, when importing SOLIDWORKS files into EPDM, the database needs to be
taken into consideration as EPDM does not automatically sync the custom
property values to the database unless you build in the logic to do so. For
instance, if you just added legacy files with existing revisions to your
normal production workflow, EPDM would treat them as any new file, ignore any
manually set revision, and then when it came time to stamp the revision, it
would simply start at the beginning.

Work flow chart

In order to ensure the revisions on the files being imported to the vault get
synced up properly, it is first necessary to understand how revisions are
handled in EPDM. There is a set “database” revision that gets incremented
automatically when progressing through any workflow and this gets synced up
with the data card revision.

Data card revision example

However, when importing files with existing revisions, a different approach
needs to be taken. We ideally want to use the EPDM variable mappings to pull
in the custom property value from the file, and then tell the database to
match the value in the data card. This way, when the files are put into a
normal production workflow, they should increment normally.

The first step in the process is finding out how many property names for the
revision variable you have (as it could be “Revision, Rev., rev,… etc”) and
build your attribute mappings in your Revision variable accordingly:

Edit variable

Creating these mappings will pull the value from the custom property into the
data card. However, we simply cannot take the file and place it into a normal
production workflow. We must build what is known as an “Import workflow.” The
purpose of this workflow is to provide a “staging” area to sync the data card
revisions with the database revisions.

Flow steps

In the above example, there is an initial state, and then several potential
automatic transitions, for each case where files can have an “A, B, or C”
revision. The workflow will ideally sync the custom property revision to the
database and then automatically send it to the “production” workflow by the
use of a workflow link.

Each branch has a condition which only allows files to go through its
transition if it contains the appropriate value. (NOTE: be sure to use Text
Equal to instead of Text Contains when you have revisions like AA so that AA
files do not go through an A transition instead of an AA transition) See
conditions filter below:

Conditions

Also, each state will have a different “increment by” count which tells the
database what revision EPDM should regard that file as:

Workflow

At this point, the database revision for the file should be set to match the
original custom property. This same concept can be applied to any revision
scheme, and is not limited to just a simple Alpha scheme. One thing to be
aware of is that building this process requires a good amount of research in
examining how the revision scheme in your company progresses, and how your
scheme is currently being managed if you are just beginning to migrate files
into your vault. However, after applying this procedure, the process of
getting your files into the vault at the correct revision is much easier and
more efficient.

To see a detailed walkthrough on importing existing CAD data into EPDM check
out our tutorial on the data migration process here:




Title:
Data Migration from Windows Folders to EPDM: The Basics

Automated Data Cleansing and Import

The procedure described above is well suited for migration scenarios involving
a minimal amount of data that is well organized and already in line with
company standards and processes. However, some migration scenarios are more
complex and require an automated, bulk approach to clean and standardize the
data before importing into EPDM. Various factors over the years may have
contributed to the need for data cleansing including limited or poor data
management practices, limited enforcement of company standards and procedures,
non-centralized data storage, changing company standards and processes,
acquisitions of other companies and their datasets as well as a host of other
reasons. If there is value in moving your legacy or other data sets into EPDM,
then now is a good time to consider doing it the right way by correcting the
data management challenges, mistakes and oversights of the past. This will
ensure that you’re able to leverage the full capabilities and value that your
data management system has to offer. Below are a few examples of some common
data migration challenges that can be easily corrected by investing in an
automated solution with a data migration partner:

  • A large number of files
  • Data sets stored in multiple locations such as local workstations, servers
    or network drives
  • Multiple data sets with differing standards (properties, filenames, etc.)
  • Conforming to new or changing standards and processes for data management
  • Short timeline for completing the data migration
  • Insufficient internal resources to support the migration effort
  • Resolving duplicate filenames
  • Resolving missing references
  • Renaming or standardizing filenames/part numbers
  • Cleaning or manipulation of custom properties
  • Moving descriptive information from filenames into searchable properties
    (revision, description, etc.)
  • Cleaning or standardizing drawing title block information or drawing formats
  • Syncing and/or correcting discrepancies with revisions
  • Incorporating properties or other metadata from external databases (PDM,
    PLM, ERP, etc.) or data sources (Excel, XML, CSV, etc.)

Please
CONTACT US
or your local Hawk Ridge Account Manager for more information on the data
migration solutions and services that we offer.

Miles Hoffman

Miles Hoffman

Miles Hoffman is a PDM SPECIALIST with CSWP-D, CSWS-D16, CSWP certifications, and is based out of the Mountain View, CA office.
0 0 votes
Article Rating
Subscribe
Notify of
guest

2 Comments
Oldest
Newest Most Voted
Inline Feedbacks
View all comments
Richard Perry
Richard Perry
2 years ago

Hi:
Is there a way to point to the revision of the latest version of a SolidWorks drawing file in the PDM vault? Our production department uses the PDM drawing revision (not the PDM model revision) so we want to display a custom field in our ERP system by part number that pulls the current revision for the associated drawing held in the PDM vault. Basically we need to display the revision on the drawing’s PDM card on our ERP screen. One SQL db (ERP) needs to pull data from another SQL db (PDM)

Miles Hoffman
Miles Hoffman
2 years ago

Hi Richard,

It sounds like you will want to create a secondary revision variable in your PDM and then map that to another edit box on the data card of the drawing. You should also ensure the new drawing revision variable has a custom property mapping that does not overwrite the model revision property. Finally, you would want to update your workflow to add “Inc. Revision,” and “Set Variable” actions which bump the drawing revision separately from the model revision. That would take care of the PDM side of things. In terms of reading information into an ERP system, that is unfortunately not something that can be easily answered as there are many different ERP systems and they all perform differently. If you need more information on that, I would potentially get in contact with our Hawkware development team to see if they can design a solution for you. If you would like to pursue that option please give one of the following numbers a call:

United States: 877.266.4469
Canada: 866.587.6803