Ravenbrook / Projects / Perforce Defect Tracking Integration / Project Documents

Perforce Defect Tracking Integration Project


TeamTrack sample data

Gareth Rees, Ravenbrook Limited, 2000-09-06

1. Introduction

This document describes sample data for the TeamTrack database to illustrate the TeamTrack schema extensions for Perforce defect tracking integration [GDR 2000-09-04a].

The data was generated as files in comma-separated variable format using the teamtrack_sample_data.py program [GDR 2000-09-04b] and then imported into the TeamTrack sample database using Microsoft Access. The resulting database and exported copies of the two affected files were sent to Larry Fish at TeamShare [GDR 2000-09-06].

The intended readership of the document is developers at TeamShare and Ravenbrook.

This document is not confidential.

2. Sample data

TS_CASES.txt The TS_CASES table, including sample data, exported from the TeamTrack sample database in comma-separated value format using Microsoft Access.
TS_VCACTIONS.txt The TS_VCACTIONS table, including sample data, exported from the TeamTrack sample database in comma-separated value format using Microsoft Access.
tTrackSample.zip The TeamTrack sample database, with Perforce integration sample data added, compressed using WinZip.

A. References

[GDR 2000-09-04a] "TeamTrack database schema extensions for integration with Perforce"; Gareth Rees; Ravenbrook Limited; 2000-09-04.
[GDR 2000-09-04b] teamtrack_sample_data.py; Gareth Rees; Ravenbrook Limited; 2000-09-04.
[GDR 2000-09-06] "Sample case, change, filespec and fix data" (e-mail message); Gareth Rees; Ravenbrook Limited; 2000-09-06 13:21:33 GMT.

B. Document History

2000-09-06 GDR Created.

Copyright © 2000 Ravenbrook Limited. This document is provided "as is", without any express or implied warranty. In no event will the authors be held liable for any damages arising from the use of this document. You may make and distribute verbatim copies of this document provided that you do not charge a fee for this document or for its distribution.

$Id: //info.ravenbrook.com/project/p4dti/doc/2000-09-06/teamtrack-sample-data/index.html#4 $

Ravenbrook / Projects / Perforce Defect Tracking Integration / Project Documents