1 <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN"
2 "http://www.w3.org/TR/html4/strict.dtd">
5 <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
6 <meta name="GENERATOR" content="Mozilla/4.61 [en] (Win98; U) [Netscape]">
8 <title>ClearSCM: Clearquest</title>
10 <link rel="stylesheet" type="text/css" media="screen" href="/css/Article.css">
11 <link rel="stylesheet" type="text/css" media="print" href="/css/Print.css">
12 <link rel="SHORTCUT ICON" href="http://clearscm.com/favicon.ico" type="image/png">
15 <script src="http://www.google-analytics.com/urchin.js" type="text/javascript">
17 <script type="text/javascript">
18 _uacct = "UA-89317-1";
24 include "../php/clearscm.php";
34 <?php start_box ("cs3");?>
38 <p>There are many times when we have written custom code to
39 interact with Clearquest databases. Below are links to some of the
40 code we have developed over the years.</p>
42 <p>At one client, we had written a <a
43 href="/clearquest/cqd">Clearquest Daemon</a>, a daemon process
44 that maintained a connection to a Clearquest database and serviced
45 requests for information about Clearquest defects.</p>
47 <p>Other Perl scripts had been developed for a client to merge
48 together two similar, yet different, Clearquest databases into a
49 new combined database. This script, <a
50 href="pqamerge.php">pqamerge</a> does just that. Obviously such
51 conversions and merges are very specific to the customer at
52 hand. Still this script serves to show how to interact with the
53 Clearquest API to perform such actions.</p>
55 <p>The pqamerge script, while it did perform the merge in general,
56 also had a few side scripts that were useful when performing this
60 <li><a href="PQA.pm.php">PQA.pm</a>: Perl Module to hold common
63 <li><a href="pqamerge.php">pqamerge</a>: Main script - performs
66 <li><a href="pqaclean.php">pqaclean</a>: Cleans up by removing
67 all records from the destination database as well as removing
68 all Dynamic Lists.</li>
70 <li><a href="CheckCodePage.php">CheckCodePage.pl</a>: Checks to
71 see if there are any non US ASCII characters in the database
74 <li><a href="check_attachments.php">check_attachments</a>:
75 Checks to make sure that the size of the attachments added up
78 <li><a href="listdynlists.php">listdynlist</a>: Lists Dynamic
79 Lists present in the database</li>
81 <li><a href="enable_ldap.php">enable_ldap</a>: Prompts for the
82 data necessary to enable LDAP Authentication in Clearquest and
83 issues the necessary installutil commands to enable LDAP. Reads
84 data from a config file.</li>
91 <script language="JavaScript" src="/JavaScript/Menus.js" type="text/javascript"></script>