CQEXPORT(1)

     NAME
          cqexport - ClearDDTS to ClearQuest converter / exporter.

     SYNOPSIS
          ~ddts/bin/wt_perl cqexport classname destination_dir

     DESCRIPTION
          Prepares raw data files of ClearDDTS defect data so that it can be
          easily imported into ClearQuest.  The ClearQuest administrator will
          need to prepare a suitable CQ schema in order to import the data.

     REQUIREMENTS
          Access to the "ddts" user account on the ClearDDTS site.  Sufficient
          disk space to contain the exported data.  ClearDDTS 4.0 or above.

     NOTE
          This tool does not modify any DDTS data.  You may safely run this as
          many times as you wish without hurting your data in DDTS.

     OPTIONS

          classname        - The class that you wish to export.

          destination_dir  - The path to where the exported data
                                      belongs.

     FILES
          The exporter contains the following files:
          cqexport   - A perl script.  The only program you need to run
                       directly.
          cqconv     - A binary executable that actually exports the data
                       given complicated directions.

     USAGE
          Log into the DDTS server.  Change to the ddts user.  cd to the
          directory where you extracted the exporter.

          Choose the class that you wish to export. (Only one class is handled
          at a time, because each class contains its own field definitions.)
          Choose the destination storage directory for all the data.

          Run:
           $DDTSHOME/[your_platform_bin]/wt_perl cqexport [classname] \
              [destination_dir]

          You will first be asked confirmation of the startup arguments.  Then
          it iterates over each field in the given class's master.tmpl file
          and asks you about each field that it doesn't know about.  You can
          choose whether to export the given field.  You must also enter the
          type of each field.  You can choose from "DATE", "USER" and
          "STRING".

     Data type definitions

          For the purpose of this tool we need to distinguish between 4
          datatypes:

          String   Anything typed at the keyboard.

          Date     Fields that ddts thinks of as a datetime ClearQuest
                          needs these printed out in a special format.

          User     String fields that have a semantic meaning of being
                          the user name.  ClearQuest needs to have knowledge
                          of the user before importing the record.

          Status  The status field has to be exported as its expanded
                         name.  (User is not prompted for this).

          You may interrupt the process of prompting for the fields at any
          time with "Control-C". The tool will save your current answers.
          Restarting the exporter will continue where it was interrupted.
          This is useful if you make a mistake on a field and wish to change
          your answer.  Just edit the [destination_dir]/fieldinfo file and
          remove the offending field.  When you rerun the exporter, it will
          prompt again for that field.

          You are then asked for the findbug query string to select the
          records that you wish to export.  You may use the default query
          string or a different string.  See the findbug manpage for more
          details.

          The exporter also prompts for the path to where the data will be
          placed on the ClearQuest machine.  This is needed because of the
          import format of attachments (DDTS uses the term "enclosures").  The
          format requires the full path to each enclosure including drive
          letter.  If you choose incorrectly, you can easily edit the
          enclosures.txt and history.txt files after you have moved them to
          the proper location.

          After one last prompt, it does the exporting and data preparation.

          After running cqexport, get the exported data.  Copy the two files:
          export.tar and export.bat to your ClearQuest NT machine. Place the
          files in the location you entered above.  Run the export.bat script.
          (Double click on it or run it from a command prompt.)

          Run the CQ Design program and import the users.txt into your CQ
          database.  Run the CQ Import Tool. Use it to import the data in the
          following order:

               projects.txt
               defects.txt
               enclosures.txt
               history.txt

     OTHER CLEARQUEST TIPS
          Make sure you have a field to contain the old DDTS identifier.  The
          attachments will need to be imported by refering to this
          identifier.