Expand SOLIDWORKS PDM File ExplorerSOLIDWORKS PDM File Explorer
Expand SOLIDWORKS PDM Professional Item ExplorerSOLIDWORKS PDM Professional Item Explorer
Collapse SOLIDWORKS PDM Administration ToolSOLIDWORKS PDM Administration Tool
Expand Introducing the Administration ToolIntroducing the Administration Tool
Expand Local SettingsLocal Settings
Expand VaultsVaults
Expand Archive ServersArchive Servers
Expand SOLIDWORKS PDM Add-ins (For SOLIDWORKS PDM Professional only)SOLIDWORKS PDM Add-ins (For SOLIDWORKS PDM Professional only)
Expand Dispatch (For SOLIDWORKS PDM Professional only)Dispatch (For SOLIDWORKS PDM Professional only)
Expand Bills of MaterialsBills of Materials
Expand Data CardsData Cards
Expand Card Lists (For SOLIDWORKS PDM Professional only)Card Lists (For SOLIDWORKS PDM Professional only)
Expand Categories (For SOLIDWORKS PDM Professional only)Categories (For SOLIDWORKS PDM Professional only)
Expand ColumnsColumns
Expand File TypesFile Types
Expand Importing and Exporting Data (For SOLIDWORKS PDM Professional only)Importing and Exporting Data (For SOLIDWORKS PDM Professional only)
Expand Indexing the Vault (For SOLIDWORKS PDM Professional only)Indexing the Vault (For SOLIDWORKS PDM Professional only)
Expand Items (For SOLIDWORKS PDM Professional only)Items (For SOLIDWORKS PDM Professional only)
Expand  Installing and Configuring SolidNetWork Licensing Installing and Configuring SolidNetWork Licensing
Expand Message SystemMessage System
Expand Revision NumbersRevision Numbers
Expand Serial Numbers (For SOLIDWORKS PDM Professional only)Serial Numbers (For SOLIDWORKS PDM Professional only)
Expand  Tasks (For SOLIDWORKS PDM Professional only) Tasks (For SOLIDWORKS PDM Professional only)
Expand Templates (For SOLIDWORKS PDM Professional only)Templates (For SOLIDWORKS PDM Professional only)
Expand ToolboxToolbox
Expand Users and GroupsUsers and Groups
Collapse VariablesVariables
Data Card Variables
Assigning Default Values
Considerations when Setting Up Data Card Variables
Removing Unused Variables and Cards
Collapse Variable MappingVariable Mapping
Mapping Variables to File Properties
Expand Variable Mapping - Microsoft Office FilesVariable Mapping - Microsoft Office Files
Expand Modifying Custom Properties of PDFs Using PDF Plug-in [Project 20810]   (For SOLIDWORKS PDM Professional only)Modifying Custom Properties of PDFs Using PDF Plug-in [Project 20810] (For SOLIDWORKS PDM Professional only)
Expand Variable Mapping - SOLIDWORKS FilesVariable Mapping - SOLIDWORKS Files
Expand Variable Mapping - CALS Raster Files (For SOLIDWORKS PDM Professional only)Variable Mapping - CALS Raster Files (For SOLIDWORKS PDM Professional only)
Variable Mapping - Outlook MSG Files (For SOLIDWORKS PDM Professional only)
Mapping Variables - INI files
Where is Variable Used Dialog Box
Edit Variables Dialog Box
Edit Variable Dialog Box
Expand WorkflowsWorkflows
Expand Administering Web Servers (For SOLIDWORKS PDM Professional only)Administering Web Servers (For SOLIDWORKS PDM Professional only)
Expand Database ServerDatabase Server
Expand MiscellaneousMiscellaneous
Expand SOLIDWORKS PDM Archive Server Configuration ToolSOLIDWORKS PDM Archive Server Configuration Tool
Expand SOLIDWORKS PDM File Version Upgrade ToolSOLIDWORKS PDM File Version Upgrade Tool
Hide Table of Contents

Variable Mapping - Microsoft Office Files

Variables can be mapped to both predefined properties (such as title and subject) and custom named properties found within most office file types.

Examples of Microsoft Office variable mappings:
  • Showing Summary Information
  • Adding Custom Properties to Documents
  • Adding a Refresh Macro

Changes between Microsoft Office 2003 and Microsoft Office 2007

With Microsoft Office 2007, Microsoft has changed the way that properties are stored, and in some cases changed their names.

The Microsoft Office 2007 suite has XML based file formats, typically signified by the addition of the letter x to the file extension. For example, documents that previous versions of Word stored in a binary .doc file, are now stored in a .docx file. The document file properties are now held in XML elements.

Some of the element names are different from the old property names. This means that properties which were transferred using .doc files may not transfer when the same document is stored as a .docx file.

Properties that follow the Office 2003 (.doc) conventions are not always suitable for the newer Office 2007 XML (.docx) based files.

In most cases the properties are obvious, and can be mapped easily; however, it may be necessary to define different mappings for .doc and .docx attributes to continue using the same data card.

Microsoft Office 2007 Format Files

Common Extensions

DOCX, DOT, MPPX, PPTX, PUB, VSD, XLSX, XPS

Property Mappings

Block name Attribute name
Summary title, subject, creator, keywords, description, Template, lastModifiedby, revision, TotalTime, lastPrinted, created, modified, Pages, Words, Characters, Application, DocSecurity
DocSummary category, PresentationFormat, Lines, paragraphs, Slides, Notes, HiddenSlides, MMClips, ScaleCrop, Manager, Company, LinksUpToDate
CustomProperty The attribute names are custom defined.

Microsoft Office 2003 Format Files

Common Extensions

DOC, DOT, MPP, PPT, PUB, VSD, XLS, XPS

Property Mappings

Block name Attribute name
Summary Title, Subject, Author, Keywords, Comments, Template, Last Saved By, Revision Number, Total Editing Time, Last Printed, Created, Last Saved, Page Count, Word Count, Char Count, Application Name, Security.
DocSummary Category, Presentation Target, Bytes, Lines, Paragraphs, Slides, Notes, Hidden Slides, MMClips, ScaleCrop, HeadingPairs, TitlesofParts, Manager, Company, Links Dirty.
CustomProperty The attribute names are custom defined.


Provide feedback on this topic

SOLIDWORKS welcomes your feedback concerning the presentation, accuracy, and thoroughness of the documentation. Use the form below to send your comments and suggestions about this topic directly to our documentation team. The documentation team cannot answer technical support questions. Click here for information about technical support.

* Required

 
*Email:  
Subject:   Feedback on Help Topics
Page:   Variable Mapping - Microsoft Office Files
*Comment:  

Print Topic

Select the scope of content to print:



x

We have detected you are using a browser version older than Internet Explorer 7. For optimized display, we suggest upgrading your browser to Internet Explorer 7 or newer.

 Never show this message again
x

Web Help Content Version: SOLIDWORKS PDM 2016 SP05

The search functionality within the web help is in a beta test phase and you may experience periodic delays or interruptions in its performance. These are the normal and ordinary features of a beta test and shall not under any circumstances give rise to any liability on the part of Dassault Systèmes SolidWorks Corporation or its licensors. The topics within the Web-based help are not beta topics; they document SOLIDWORKS PDM 2016 SP05.

To disable Web help from within SOLIDWORKS and use local help instead, click Help > Use SOLIDWORKS Web Help.

To report problems encountered with the Web help interface and search, contact your local support representative. To provide feedback on individual help topics, use the “Feedback on this topic” link on the individual topic page.