Map fields using an editor for the Quality Center - Project Tracker connector

You can define data transformation rules non-graphically, using Eclipse's default XML editor.

  1. In theCCF Explorer, right-click a project mapping and select Edit field mappings.
  2. In the Edit Field Mappings dialog, select Edit using default editor.
  3. Click Finish. Based on the source and target systems in your project mapping, an XSLT file is automatically created and opens up in the default XML editor.
  4. Customize your mappings in the XSLT file based on the samples provided. Here's an example of how the Priority field is mapped in the Project Tracker-to-Quality Center XSLT mapping file. Priority is reversed.
                        <xsl:template match="ccf:field[@fieldName=concat($artifactTypeNameSpace,"Priority")]">
                        <xsl:variable name="priorityValue" as="xs:string" select="."/>
                        <field>
                        <xsl:copy-of select="@*"/>
                        <xsl:attribute name="fieldName">BG_PRIORITY</xsl:attribute>
                        <xsl:if test="$priorityValue = 'P5'">
                        <xsl:text>1-Low</xsl:text>
                        </xsl:if>
                        <xsl:if test="$priorityValue = 'P4'">
                        <xsl:text>2-Medium</xsl:text>
                        </xsl:if>
                        <xsl:if test="$priorityValue = 'P3'">
                        <xsl:text>3-High</xsl:text>
                        </xsl:if>
                        <xsl:if test="$priorityValue = 'P2'">
                        <xsl:text>4-Very High</xsl:text>
                        </xsl:if>
                        <xsl:if test="$priorityValue = 'P1'">
                        <xsl:text>5-Urgent</xsl:text>
                        </xsl:if>
                        <xsl:if test="$priorityValue = ''">
                        <xsl:text>1-Low</xsl:text>
                        </xsl:if>
                        </field>
                        </xsl:template>