QC-config-concat.pxml

Below are the 4 sections relating to this QC connector run:

  1. This configuration file: QC-config-concat-qc-2-rally.pxml
  2. The logfile output: rallylog.log
  3. This configuration file: QC-config-concat-rally-2-qc.pxml
  4. The logfile output: rallylog.log


 

Configuration File QC-config-concat-qc-2-rally.pxml

<!-- **********************************************************************
FILE:    QC-config-concat-qc-2-rally.pxml

PURPOSE: To demonstrate the use of the <OtherConcatFieldHandler>.

USAGE:   Replace all the "Your-..." strings below with values appropriate
         for your environment.
*********************************************************************** -->
<config>
        <RallyConnection>
                <Url>Your-Rally-URL</Url>
                <WorkspaceName>Your-Rally-Workspace</WorkspaceName>
                <Projects>
                        <Project>Your-Rally-Project</Project>
                </Projects>
                <User>Your-Rally-Username</User>
                <Password>Your-Rally-Password</Password>
                <ArtifactType>Defect</ArtifactType>
                <ExternalIDField>Your-Rally-ExternalID</ExternalIDField>
        </RallyConnection>

        <QCConnection>
                <Url>Your-QC-URL</Url>
                <Domain>Your-QC-Domain</Domain>
                <Project>Your-QC-Project</Project>
                <User>Your-QC-Username</User>
                <Password>Your-QC-Password</Password>
                <ArtifactType>Bug</ArtifactType>
                <IDField>BG_BUG_ID</IDField>
                <ExternalIDField>Your-QC-ExternalID</ExternalIDField>
                <ExternalEndUserIDField>BG_USER_03</ExternalEndUserIDField>
                <CopySelectors>
                        <CopySelector>BG_BUG_ID = 13</CopySelector>
                </CopySelectors>
        </QCConnection>

        <Connector>
                <FieldMapping>
                        <Field><Rally>Name</Rally>              <Other>BG_SUMMARY</Other></Field>
                        <Field><Rally>Description</Rally>       <Other>BG_DESCRIPTION</Other></Field>
                        <Field><Rally>CreationDate</Rally>      <Other>BG_DETECTION_DATE</Other></Field>
                </FieldMapping>

                <OtherFieldHandlers>
                        <QCDatetimeToDateFieldHandler>
                                <FieldName>BG_DETECTION_DATE</FieldName>
                        </QCDatetimeToDateFieldHandler>

                        <OtherConcatFieldHandler>
                                <FieldName>BG_DESCRIPTION</FieldName>
                                <ConcatFields>
                                        <Field>BG_USER_06</Field>
                                        <Field>BG_USER_08</Field>
                                </ConcatFields>
                        </OtherConcatFieldHandler>
                </OtherFieldHandlers>
        </Connector>

        <ConnectorRunner>
                <Preview>false</Preview>
                <LogLevel>Debug</LogLevel>
                <Services>COPY_QC_TO_RALLY</Services>
        </ConnectorRunner>
</config>


The rallylog.log File for QC-config-concat-qc-2-rally.pxml

*******************************************************************************************
     rally2_qc_connector
         pid: 2716
         starting at: 2013-10-31 17:14:16 Z
         cwd: C:/Users/jpkole/JPKoleQC
         configs: x063-concat-qc-2-rally.xml
         interval: -1
         connector-version: Connector version: 3.3.3-513-master-586780a12a6ebc079c80f586d05ca1ae88404432
         rally-version: Rally Spoke version 3.2.0 using rally_api gem version 0.9.22
         other-spoke: QCConnection version 2.10.0
*******************************************************************************************
  ANY : ConnectorRunner.block in run - processing to commence using content from x063-concat-qc-2-rally.xml
  ANY : Class.read_config_file - x063-concat-qc-2-rally.xml last modified 2013-10-31 17:13:54 UTC, size: 1683 chars
  ANY : RallyConnection.initialize - Initializing Rally connection version 3.2.0
 INFO : RallyConnection.initialize - Rally Web Services version 1.42
  ANY : QCConnection.initialize - Initializing Quality Center connection version 2.10.0
 INFO : Connector.initialize - Ruby platform i386-mingw32
 INFO : Connector.initialize - Ruby version 1.9.2
 INFO : QCConnection.connect - Connecting to Quality Center at http://vmwin2008qc11.f4tech.com:8080/qcbin as user jpqc11
DEBUG : QCConnection.block in identify_qc_version - Preparing to open Registry to examine: Software\Classes\CLSID\{C5CBD7B2-490C-45f5-8C40-B8C3D108E6D7}\InprocServer32
DEBUG : QCConnection.block in identify_qc_version - Registry Software\Classes\CLSID\{C5CBD7B2-490C-45f5-8C40-B8C3D108E6D7}\InprocServer32 opened...
DEBUG : QCConnection.block (2 levels) in identify_qc_version - Registry path to HPQC OTAClient.dll ==> C:\PROGRA~2\COMMON~1\MERCUR~1\TDAPIC~1\OTACLI~1.DLL
DEBUG : QCConnection.win_path_expanded - expanded Registry path to DLL target: C:/Program Files (x86)/Common Files/Mercury Interactive/TDAPIClient/OTAClient.dll
 INFO : QCConnection.connect - Connected to Quality Center at http://vmwin2008qc11.f4tech.com:8080/qcbin/wcomsrv.dll (version 11.0.0.8258)
 INFO : QCConnection.connect -   Domain: DEFAULT
 INFO : QCConnection.connect -   Project: JPproject11
 INFO : RallyConnection.connect - Connecting to Rally
DEBUG : RallyConnection.connect - In connect begin clause - connecting to Rally via rally_api
DEBUG : RallyConnection.connect - Looking up projects
 INFO : RallyConnection.connect - Connected to Rally at https://rally1.rallydev.com/slm -  Workspace: JP
 INFO : RallyConnection.connect -   Projects: PR01
 INFO : Connector.validate - Beginning validation
DEBUG : RallyConnection.validate - Rally Connection - user entry "[email protected]" detected in config file
DEBUG : RallyConnection.validate - Rally Connection - password entry detected in config file
DEBUG : RallyConnection.validate - Rally Connection - artifact type "defect" validated
DEBUG : RallyConnection.validate - Rally Connection - IDField entry "ObjectID" validated
DEBUG : RallyConnection.validate - Rally Connection - ExternalIDField entry "QCPR01ExtID" validated
DEBUG : RallyConnection.validate - Rally Connection - FieldHandler target fields existence validated
DEBUG : RallyConnection.validate - Rally Connection - Field Defaults settings validated
DEBUG : Connector.validate - RallyConnection validate succeeded
DEBUG : QCConnection.validate - Quality Center Connection - user entry "jpqc11" detected in config file
DEBUG : QCConnection.validate - Quality Center Connection - password entry detected in config file
DEBUG : QCConnection.validate - Quality Center Connection - artifact type "bug" validated
DEBUG : QCConnection.validate - Quality Center Connection - IDField entry "BG_BUG_ID" validated
DEBUG : QCConnection.validate - Quality Center Connection - ExternalIDField entry "BG_USER_01" validated
DEBUG : QCConnection.validate - Quality Center Connection - FieldHandler target fields existence validated
DEBUG : QCConnection.validate - Quality Center Connection - Field Defaults settings validated
DEBUG : Connector.validate - Quality Center Connection validate succeeded
DEBUG : Connector.block in validate - RallyConnection field_mapping target "Name" existence validated
DEBUG : Connector.block in validate - Quality Center Connection field_mapping target "BG_SUMMARY" existence validated
DEBUG : Connector.block in validate - RallyConnection field_mapping target "Description" existence validated
DEBUG : Connector.block in validate - Quality Center Connection field_mapping target "BG_DESCRIPTION" existence validated
DEBUG : Connector.block in validate - RallyConnection field_mapping target "CreationDate" existence validated
DEBUG : Connector.block in validate - Quality Center Connection field_mapping target "BG_DETECTION_DATE" existence validated
DEBUG : Connector.block in validate - Quality Center Connection field_handler validation for "BG_DETECTION_DATE" succeeded
DEBUG : Connector.block in validate - Quality Center Connection field_handler validation for "BG_DESCRIPTION" succeeded
 INFO : Connector.validate - Validation complete
  ANY : ConnectorRunner.run_services - Last Run 2013-10-31 17:09:32 UTC  --- Now 2013-10-31 17:14:32 UTC
  ANY : ConnectorRunner.process_service - Starting Service COPY_QUALITY CENTER_TO_RALLY
 INFO : QCConnection.find_new - find_new query: BG_USER_01 ="" and BG_BUG_ID ="13"
 INFO : QCConnection.find_new -   Found 1 New bugs in QC
 INFO : Connector.copy_to_rally - Copy Quality Center bug ID 13 to Rally
DEBUG : Connector.block in map_fields_to_rally -   Mapping BG_SUMMARY(Test dup iterations 1) - to - Name(Test dup iterations 1)
DEBUG : Connector.block in map_fields_to_rally -   Mapping BG_DESCRIPTION(<html>
<body>
<div align="left"><font face="Arial"><span style="font-size:9pt">QC foobar</span></font></div>
</body>
</html>) - to - Description(BG_DESCRIPTION: <html>
<body>
<div align="left"><font face="Arial"><span style="font-size:9pt">QC foobar</span></font></div>
</body>
</html><br />BG_USER_06: BGuser06text<br />BG_USER_08: BGuser08text)
DEBUG : Connector.block in map_fields_to_rally -   Mapping BG_DETECTION_DATE(2013-10-09 00:00:00 -0600) - to - CreationDate(2013-10-09 00:00:00 -0600)
 INFO : RallyConnection.create_internal -   Created DE457
DEBUG : QCConnection.update_external_id_fields - set QC Bug BG_BUG_ID: 13  external id field BG_USER_01 --> |14993769237|
DEBUG : QCConnection.update_external_id_fields - set QC Bug BG_BUG_ID: 13  external end user id field BG_USER_03 --> |DE457|
 INFO : Connector.copy_to_rally - Quality Center bug 13 copied to Rally defect DE457
  ANY : ConnectorRunner.process_service - Finished Service COPY_QUALITY CENTER_TO_RALLY
 INFO : QCConnection.disconnect - Disconnected from Quality Center
  ANY : ConnectorRunner.run_services - time file written with value of 2013-10-31 17:14:32 UTC
  ANY : ConnectorRunner.block in log_service_statistics - x063-concat-qc-2-rally.xml: 1 items copied from Quality center to Rally 
  ANY : ConnectorRunner.log_service_statistics - x063-concat-qc-2-rally.xml: service run took 19 seconds


Configuration File QC-config-concat-rally-2-qc.pxml

<!-- **********************************************************************
FILE:    QC-config-concat-rally-2-qc.pxml

PURPOSE: To demonstrate the use of the <RallyConcatFieldHandler>.

USAGE:   Replace all the "Your-..." strings below with values appropriate
         for your environment.
*********************************************************************** -->
<config>
        <RallyConnection>
                <Url>Your-Rally-URL</Url>
                <WorkspaceName>Your-Rally-Workspace</WorkspaceName>
                <Projects>
                        <Project>Your-Rally-Project</Project>
                </Projects>
                <User>Your-Rally-Username</User>
                <Password>Your-Rally-Password</Password>
                <ArtifactType>Defect</ArtifactType>
                <ExternalIDField>Your-Rally-ExternalID</ExternalIDField>
                <CopySelectors>
                        <CopySelector>FormattedID = DE456</CopySelector>
                </CopySelectors>
        </RallyConnection>

        <QCConnection>
                <Url>Your-QC-URL</Url>
                <Domain>Your-QC-Domain</Domain>
                <Project>Your-QC-Project</Project>
                <User>Your-QC-Username</User>
                <Password>Your-QC-Password</Password>
                <ArtifactType>Bug</ArtifactType>
                <IDField>BG_BUG_ID</IDField>
                <ExternalIDField>Your-QC-ExternalID</ExternalIDField>
                <ExternalEndUserIDField>BG_USER_03</ExternalEndUserIDField>
                <FieldDefaults>
                        <Field><Name>BG_SEVERITY</Name> <Default>1-Low</Default></Field>
                </FieldDefaults>
        </QCConnection>

        <Connector>
                <FieldMapping>
                        <Field><Rally>Name</Rally>              <Other>BG_SUMMARY</Other></Field>
                        <Field><Rally>Description</Rally>       <Other>BG_DESCRIPTION</Other></Field>
                        <Field><Rally>CreationDate</Rally>      <Other>BG_DETECTION_DATE</Other></Field>
                </FieldMapping>

                <RallyFieldHandlers>
                        <RallyConcatFieldHandler>
                                <FieldName>Description</FieldName>
                                <ConcatFields>
                                        <Field>FoundInBuild</Field>
                                        <Field>FixedInBuild</Field>
                                </ConcatFields>
                        </RallyConcatFieldHandler>
                </RallyFieldHandlers>

                <OtherFieldHandlers>
                        <QCDatetimeToDateFieldHandler>
                                <FieldName>BG_DETECTION_DATE</FieldName>
                        </QCDatetimeToDateFieldHandler>
                </OtherFieldHandlers>
        </Connector>

        <ConnectorRunner>
                <Preview>false</Preview>
                <LogLevel>Debug</LogLevel>
                <Services>COPY_RALLY_TO_QC</Services>
        </ConnectorRunner>
</config>


The rallylog.log File for QC-config-concat-rally-2-qc.pxml

*******************************************************************************************
     rally2_qc_connector
         pid: 2376
         starting at: 2013-10-31 17:42:12 Z
         cwd: C:/Users/jpkole/JPKoleQC
         configs: x063-concat-rally-2-qc.xml
         interval: -1
         connector-version: Connector version: 3.3.3-513-master-586780a12a6ebc079c80f586d05ca1ae88404432
         rally-version: Rally Spoke version 3.2.0 using rally_api gem version 0.9.22
         other-spoke: QCConnection version 2.10.0
*******************************************************************************************
  ANY : ConnectorRunner.block in run - processing to commence using content from x063-concat-rally-2-qc.xml
  ANY : Class.read_config_file - x063-concat-rally-2-qc.xml last modified 2013-10-31 17:40:44 UTC, size: 1841 chars
  ANY : RallyConnection.initialize - Initializing Rally connection version 3.2.0
 INFO : RallyConnection.initialize - Rally Web Services version 1.42
  ANY : QCConnection.initialize - Initializing Quality Center connection version 2.10.0
 INFO : Connector.initialize - Ruby platform i386-mingw32
 INFO : Connector.initialize - Ruby version 1.9.2
 INFO : QCConnection.connect - Connecting to Quality Center at http://vmwin2008qc11.f4tech.com:8080/qcbin as user jpqc11
DEBUG : QCConnection.block in identify_qc_version - Preparing to open Registry to examine: Software\Classes\CLSID\{C5CBD7B2-490C-45f5-8C40-B8C3D108E6D7}\InprocServer32
DEBUG : QCConnection.block in identify_qc_version - Registry Software\Classes\CLSID\{C5CBD7B2-490C-45f5-8C40-B8C3D108E6D7}\InprocServer32 opened...
DEBUG : QCConnection.block (2 levels) in identify_qc_version - Registry path to HPQC OTAClient.dll ==> C:\PROGRA~2\COMMON~1\MERCUR~1\TDAPIC~1\OTACLI~1.DLL
DEBUG : QCConnection.win_path_expanded - expanded Registry path to DLL target: C:/Program Files (x86)/Common Files/Mercury Interactive/TDAPIClient/OTAClient.dll
 INFO : QCConnection.connect - Connected to Quality Center at http://vmwin2008qc11.f4tech.com:8080/qcbin/wcomsrv.dll (version 11.0.0.8258)
 INFO : QCConnection.connect -   Domain: DEFAULT
 INFO : QCConnection.connect -   Project: JPproject11
 INFO : RallyConnection.connect - Connecting to Rally
DEBUG : RallyConnection.connect - In connect begin clause - connecting to Rally via rally_api
DEBUG : RallyConnection.connect - Looking up projects
 INFO : RallyConnection.connect - Connected to Rally at https://rally1.rallydev.com/slm -  Workspace: JP
 INFO : RallyConnection.connect -   Projects: PR01
 INFO : Connector.validate - Beginning validation
DEBUG : RallyConnection.validate - Rally Connection - user entry "[email protected]" detected in config file
DEBUG : RallyConnection.validate - Rally Connection - password entry detected in config file
DEBUG : RallyConnection.validate - Rally Connection - artifact type "defect" validated
DEBUG : RallyConnection.validate - Rally Connection - IDField entry "ObjectID" validated
DEBUG : RallyConnection.validate - Rally Connection - ExternalIDField entry "QCPR01ExtID" validated
DEBUG : RallyConnection.validate - Rally Connection - FieldHandler target fields existence validated
DEBUG : RallyConnection.validate - Rally Connection - Field Defaults settings validated
DEBUG : Connector.validate - RallyConnection validate succeeded
DEBUG : QCConnection.validate - Quality Center Connection - user entry "jpqc11" detected in config file
DEBUG : QCConnection.validate - Quality Center Connection - password entry detected in config file
DEBUG : QCConnection.validate - Quality Center Connection - artifact type "bug" validated
DEBUG : QCConnection.validate - Quality Center Connection - IDField entry "BG_BUG_ID" validated
DEBUG : QCConnection.validate - Quality Center Connection - ExternalIDField entry "BG_USER_01" validated
DEBUG : QCConnection.validate - Quality Center Connection - FieldHandler target fields existence validated
DEBUG : QCConnection.validate - Quality Center Connection - Field Defaults settings validated
DEBUG : Connector.validate - Quality Center Connection validate succeeded
DEBUG : Connector.block in validate - RallyConnection field_mapping target "Name" existence validated
DEBUG : Connector.block in validate - Quality Center Connection field_mapping target "BG_SUMMARY" existence validated
DEBUG : Connector.block in validate - RallyConnection field_mapping target "Description" existence validated
DEBUG : Connector.block in validate - Quality Center Connection field_mapping target "BG_DESCRIPTION" existence validated
DEBUG : Connector.block in validate - RallyConnection field_mapping target "CreationDate" existence validated
DEBUG : Connector.block in validate - Quality Center Connection field_mapping target "BG_DETECTION_DATE" existence validated
DEBUG : Connector.block in validate - Rally Connection field_handler validation for "Description" succeeded
DEBUG : Connector.block in validate - Quality Center Connection field_handler validation for "BG_DETECTION_DATE" succeeded
 INFO : Connector.validate - Validation complete
  ANY : ConnectorRunner.run_services - Last Run 2013-10-31 17:41:20 UTC  --- Now 2013-10-31 17:42:28 UTC
  ANY : ConnectorRunner.process_service - Starting Service COPY_RALLY_TO_QUALITY CENTER
 INFO : RallyConnection.find_new - Find New Rally defects
DEBUG : RallyConnection.find_new - Rally using find_new query: (((QCPR01ExtID = "") AND (Project.Name = "PR01 - Brewing - Beer - All Grain")) AND (FormattedID = "DE456"))
 WARN : RallyConnection.block in check_for_warnings - API status is Deprecated and will become Not Supported on 2014-May-08
 INFO : RallyConnection.find_new -   Found 1 new defects in Rally
 INFO : Connector.copy_to_other - Copy DE456 to Quality Center
DEBUG : Connector.block in map_fields_to_other -   Mapping Name(Test concat) - to - BG_SUMMARY(Test concat)
DEBUG : Connector.block in map_fields_to_other -   Mapping Description(<div><font face="Arial"><span style="font-size:9pt">Desc</span></font></div>) - to - BG_DESCRIPTION(Description: <div><font face="Arial"><span style="font-size:9pt">Desc</span></font></div><br />FoundInBuild: --Rally Found In--<br />FixedInBuild: --Rally Fixed In--)
DEBUG : Connector.block in map_fields_to_other -   Mapping CreationDate(2013-10-09T16:08:27.105Z) - to - BG_DETECTION_DATE(2013-10-09)
DEBUG : QCConnection.create_internal - set all artifact fields
 INFO : QCConnection.create_internal -   Created bug 16 in QC
DEBUG : RallyConnection.block in has_changed? -  16 !=  is true
 INFO : RallyConnection.update_internal -   Updating DE456
 INFO : Connector.copy_to_other - Rally defect DE456 copied to Quality Center bug 16
  ANY : ConnectorRunner.process_service - Finished Service COPY_RALLY_TO_QUALITY CENTER
 INFO : QCConnection.disconnect - Disconnected from Quality Center
  ANY : ConnectorRunner.run_services - time file written with value of 2013-10-31 17:42:28 UTC
  ANY : ConnectorRunner.block in log_service_statistics - x063-concat-rally-2-qc.xml: 1 items copied from Rally to Quality center 
  ANY : ConnectorRunner.log_service_statistics - x063-concat-rally-2-qc.xml: service run took 18 seconds

 

Feedback

Need more help? The CA Agile Central Community is your one-stop shop for self-service and support. To submit feedback or cases to CA Agile Central Support, find answers, and collaborate with others, please join us in the CA Agile Central Community.