EPDM – Office Templates

This article is a continuation on my previous articles relating to linking Data Card Variables, to Office Properties. In this article we will look at how to create a Word or Excel template that can be used for ECO’s/ECN’s

As before, this article will assume that the appropriate variables have been added to SolidWorks Enterprise PDM and that these Variables have been mapped to the corresponding Data Card Fields.

The first step is to create the Office document as outlined in my previous blogs EPDM – Mapping Variables to Microsoft Office and ‘EPDM – Using “Link to content” to Define custom file properties in Excel.

The Office template needs to be checked into your vault. To control excess to the template it is recommended, that the template be checked into a folder, that only an administrator has write access to.

Once the Office template has been checked in, launch SolidWorks Enterprise PDM Administration and log into vault.

Right click on the Template Node and select New Template.

New Template


Enter a name for the Template and press Next.

template name


Select the appropriate permissions for creating files for the template. The user must have sufficient permissions to folder, where the ECO/ECN will be created. Click on Next.



We will not look at Template Cards at this point; click Next.

Template Cards


A Template can create folder and sub-folders. The folder names can be linked to Template Variables, such as Customer, Part/Project Number and date. We will not look at creating folders in this article.



For this article we will look at creating a ECO in the ‘Current Folder’. This is the folder that is open in the local vault view, when we run the template. Click on New Template.

New template file.


Select the Office template you created earlier and click on Open.

Select office template


We will not be using Template Variables, press on OK and press then Next.

edit template file


From the Extension pull-down, choose an Icon for your Template and press Next.



Select which Users and Groups will have be able to you this Template and click on OK to finish creating the Template.

users and groups


To run the Template, in the Local Vault View, right click and select New and then click on the Template .

Running template


Any variables in the Data Card that are mapped to the Office template, will be written to the new ECO. A unique name should be given to the new ECO. Click on Create File to create the new ECO.

Data Card


A new ECO is created



And the variable is mapped to the Office document.

updated Excel


We will look at using template variables and template cards in upcoming articles.








Become a SOLIDWORKS Expert User

If you want to become more efficient with SOLIDWORKS then learn SOLIDWORKS live over the web with Javelin. Classes include Drawings, Surfacing, Sheet Metal, Simulation, plus GD&T.

Leave a Reply

Your email address will not be published. Required fields are marked *