Exporting dateTime (timestamp) values into Rational Quality Manager through the RQMExcelWordImporter plugin
SunilKumarR 270001XXSY Visits (2490)
This blog entry is to provide suggestions to users who are surprised at incorrect / mismatched date attribute (TIMESTAMP) values seen in RQM artifacts while the data is exported from Excel using the RQM Excel Exporter.
In most cases, the excel export will succeed but you might see that the "date attribute" field, is not in accordance with what is exported.
The dateTime (Date/Time which translates to TIMESTAMP) values in Rational Quality Manager artifacts like Test Case, Test Plans and execution artifacts like Test Case Execution Record undergo translation when the data is coming from excel through the "Export to Repository" option in the RQME
A dateTime value passed through the excel sheet should follow a format yyyy
More details on the syntax are available at the date
RQM Client and RQM Server in same time zone: If the RQM client (where excel is used) and server are on machines in the same time zone? the TIMESTAMP value specified in the sheet is exported into RQM as is.
RQM Client and RQM Server in different time zone: If the RQM client and server are on different machines? the TIMESTAMP value specified in the sheet is converted to the time on the RQM server and used. to avoid this (i.e., to ensure the TIMESTAMP value is as per client time zone) you should use dateTime (TIMESTAMP) string as 2014
For example: 2014
If the excel exporter is on a machine in a different time zone, replace the timezone string highlighted above with the relevant value.
You can use a Java Applet online like a sample one here to get the timeZone string : http
AcdntlPoet 2700019V2G Visits (3344)
Rational Quality Manager v4.x: Best Practices in Manual Testing- In this video presentation, Dennis Schultz and Joshua Burton take you through an introduction to manual testing with Rational Quality Manager v4, and beyond, including test case designs, recording manual tests, and augmenting manual tests with automation.
And don't miss the next two videos with presentations based on content from last year's IBM Innovate!
Rational Quality Manager v4.0.1: Best Practices, with Examples, Part 1- with Allison Lynch, Advisory Test Architect, and Kathy Endres, Test Architect, Rational System and Integration Test. Topics include: - Test Planning and Construction, Test Plan, Test Case, Test Suite, and Test Script
Rational Quality Manager v4.0.1: Best Practices, with Examples, Part 2- with Allison Lynch, Advisory Test Architect, and Kathy Endres, Test Architect, Rational System and Integration Test. Topics include: Test Execution and Administration
AcdntlPoet 2700019V2G Visits (1638)
Rational Quality Manager v4.0.4: Understanding and Managing Test Case Execution Records (1 of 6)- This video is the first in a series of videos aimed at explaining how you can use test case execution records to plan, execute, and report on testing. Part 1 introduces test case execution records and explains why they are so important.
We've embedded the entire 6 video series playlist here, as well as added links below to allow you to navigate directly to each video if desired:
Exploring Test Case Execution Records (2 of 6)- This video explores existing Rational Quality Manager test case execution records and introduces different ways of generating test case execution records. More info: www.jazz.net
Generating Execution Records for a Single Test Case (3 of 6)- This video demonstrates how to generate test case execution records for a single test case.
Generating Execution Records for All Test Cases In a Plan (4 of 6)- This video demonstrates how to generate test case execution records for all of the test cases in a test plan.
Generating Test Case Execution Records (5 of 6)- This video demonstrates how to generate test case execution records without specifying iterations, test environments, or a test plan.
Test Case Execution Records and Generating Test Results (6 of 6)- This video demonstrates how to run tests using generated test case execution records and how to generate test results without executing test scripts.
dmmckinn 1200006SCS Visits (1829)
Our folks were busy the last few weeks of 2013 pulling together some new educational material to help you better understand how you can use test case execution records with IBM Rational Quality Manager (RQM). A new six part video series was published to help explain how you can use test case execution records to plan, execute, and report on testing activities.
These videos are included in the Rati
IBM UrbanCode Deploy v6.0 integration with IBM Rational Build Forge and IBM Rational Quality Manager
AcdntlPoet 2700019V2G Visits (3230)
IBM UrbanCode Deploy v6.0 integration with IBM Rational Build Forge and IBM Rational Quality Manager- Discussion and examples of UrbanCode Deploy's integration with Build Forge and RQM
0:14 - Integration with Build Forge