Update CMM Attributes

You can update the attribute XML files for all of your migrated items using a Microsoft Excel spreadsheet. This allows you to update all attribute files at once from one Excel file. You can update the attributes for many items in one place, including the review status for items. To update attribute files using Excel: 1. Create the summary report for the migrated items with one of the following two methods:

• Generate an XML summary report by running (cmmReport or nxmReport) –post –o

. Open the summary XML file in Excel and apply the cmmstatistics_excel.xsl style sheet when prompted.

• Create a new file in Excel with the attribute columns you want to update. You do not have to include all of the attribute types, only the ones you want to update. Save the file as an XML spreadsheet (*.xml). Appendix C: Command line report utility

Command line report utility A column can be created for each attribute type, however, Item and Revision are required columns. 2. Update the attributes in Excel. Also, add any comments. 3. Save the XML file as an XML spreadsheet (*.xml). 4. Type cmmBatch –mode attributes to update the fields in the attribute files for the items. You must configure Teamcenter to allow users to search for migrated items in Teamcenter using CMM attributes created during migration. The cmm_attributes_search.xml file in the \Config folder contains sample Query Builder import files for performing CMM searches. The CMM installation supplies two predefined CMM searches. You simply need to import them into the Query Builder. Command line report utility