Add Custom Attributes to Microsoft Office

Advanced Customization > Business Logic Customization > DTI Customization Framework > Add Custom Attributes to Microsoft Office

You can map Windchill attributes to Microsoft Office properties. For more information, see Mapping Windchill Attributes to Microsoft Office File Properties.

The custom properties limit in Microsoft Office documents is 255 chars. This limit can be enforced by a string length constraint in the Type and Attribute Management utility.

To add additional attributes to DTI, perform the following actions:

1. Stop the method server.

2. Create a backup copy of msoimap.xml. This file is located under the following directory:

<Windchill>\codebase\com\ptc\windchill\enterprise\nativeapp\msoi\server\msoimap.xml

3. Customize or add attributes to msoimap.xml using the following syntax:

<attribute>
<ms_name>Name_To_Display_In_Microsoft_Office</ms_name>
<wt_name>Windchill_Attribute_Introspection_Name</wt_name>
</attribute>

To find the introspection name (the <wt_name> value), open a Windchill shell and execute the InfoReport command for a specific object type. For example:

InfoReport wt.doc.WTDocument

Results are located in the following file:

<Windchill>\temp\doc.WTDocument.out

4. Start the method server.

To verify your changes, open a Microsoft Office application and select Windchill > Properties > Refresh Properties.

In the following example, the Created By, Modified By, and Created On attributes are added to the Microsoft Office custom properties:

<type key="wt.doc.WTDocument">

<attribute>
<ms_name>Created By</ms_name>
<wt_name>creator.name</wt_name>
<display>true</display>
<attrFormat>string</attrFormat>
</attribute>

<attribute>
<ms_name>Modified By</ms_name>
<wt_name>modifier.name</wt_name>
<display>true</display>
<attrFormat>string</attrFormat>
</attribute>

<attribute>
<ms_name>Created On</ms_name>
<wt_name>thePersistInfo.createStamp</wt_name>
<display>true</display>
<attrFormat>string</attrFormat>
</attribute>

</type>

Was this helpful?