Export Project Tracker data as XML

You can export artifacts in XML format.

Note: Transitions defined for state attributes and rules defined for dependent attributes are not enforced during XML import. This allows artifacts that were created before the state transitions were defined to be imported.

Go to the Project Tracker administration page.
1. Click Admin in the CollabNet TeamForge navigation bar.
2. On the site administration navigation bar, click Integrated App.
3. Select Project Tracker and click Configure.
Click the Create New button or click the link for an existing query.
If you are creating a new query, enter your criteria and click Submit.
In the Query Results section of the query results page, click the drop-down list labeled Export Results To and select XML (full artifact).

Note: If you query an artifact of an artifact type that has a Date attribute associated with it and export it to an Excel (XLS) format from the "Export Results To" option and open it using the spreadsheet editor, for example Microsoft Excel, there is a possibility that the cells having the "Date" property may not display the date in the format used by Project Tracker; which is "YYYY-MM-DD". This is because of the date settings used by your spreadsheet editor, even though the actual date reamins the same. To change the appearance of the date in the excel file exported, do the following in your spreadsheet editor:

Select the entire Column or Row or specific cells in the excel sheet which has the Date property associated with it.
Right-click and select the Format Cells option.
Under the Number tab, select the Custom category option.
From the sub-menu that appears on the right, in the Type textbox, enter the following: "yyyy-mm-dd" (without quotes)
Click the OK button to save the changes.

This will make sure that dates appear in the "yyyy-mm-dd" format no matter what the date settings is used by your Operating System. Changing the date settings of your Operating system will have affect other applications as well.