Exporting dateTime (timestamp) values into Rational Quality Manager through the RQMExcelWordImporter plugin
SunilKumarR 270001XXSY Visits (712)
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 (2396)
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 (662)
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 (950)
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 (2085)
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
AcdntlPoet 2700019V2G Visits (1483)
Here's the most recent list of the latest and greatest downloads which have gone live from Rational Support since August 28th! These links below are provided to help you find the fixes you need in order to stay up to date and successful with your Rational products.... Plus, don't forget to check out the downloads tag to see any of the fixes you may have previously missed:
image credit: (c) 2012 WaywardCelt Photography
dmmckinn 1200006SCS Visits (1827)
Have you had a chance to check out the new 4.0.4 release of the IBM Rational Collaborative Lifecycle Management (CLM) products (Rational Quality Manager, Rational Requirements Composer, Rational Team Concert)? This new release delivers new features and enhancements such as the following and more:
AcdntlPoet 2700019V2G Visits (1644)
As many of us are in the last weeks of summer break, getting ready to head back to school or get the kids ready, we're still pushing headlong forwards to make sure you get the best information you need to get your job done and get it done right the first time. Our awesome developerWorks authors are always focused on producing the right information you need... so here you go, the following articles and trials went live last week on developerWorks Rational:
Use Rational Quality Manager to manage lab assets in virtual environments
Manage test data more effectively with Rational Quality Manager 4.0.1
Create an automation framework for an HTML-based application
UML Model Metric Analysis rules-based generation of class diagrams
Rapid JPA development with Rational Application Developer
Reconcile, a new feature in Rational Quality Manager
IBM Rational Quality Manager
Webcast: IBM DevOps Solution: Continuous business planning to get cost out and agility in
Webcast: IBM DevOps Solution: Collaborative development to spark innovation and integration among teams
Webcast: IBM DevOps Solution: Continuous testing to save costs and improve application quality
AcdntlPoet 2700019V2G Visits (1755)
Follow-up Tests with Reports/Queries in Rational Quality Manager- Rational Quality Manager includes reporting and querying capabilities to help you stay informed about the status of your project. Use these wherever you are in the test effort to gather in-depth information on things like test case and test script states, testing coverage, test execution progress, and overall project health.
And as a bonus, This video demos how to customize the menu in Rational Quality Manager 4.0.3: IBM Rational Quality Manager v4.0.3: Customizing Menus
AcdntlPoet 2700019V2G Visits (1504)
These are the top content reused during June to help solve your Rational Change, Rational Focal Point, and Rational Quality Manager issues. Last month the following technotes were the most heavily reused when closing PMRs opened by you, our clients. We hope that highlighting them here will help others encountering the same or similar issues also find quick resolution:
IBM Rational Change:
IBM Rational Focal Point:
IBM Rational Quality Manager:
AcdntlPoet 2700019V2G Visits (1527)
It doesn't take long for our amazing content authors to break out of a short holiday week and come back with much more to highlight for you all. In-between all the holidays, vacations, and general time-off relaxing during these summer months, we're still focused on getting you the right content when you need it, to help drive your business forward to success. Last week was no different with the following items that went live on developerWorks Rational:
Software Delivery and Lifecycle patterns for Private Cloud
Using Screen Definition II with Rational Team Concert
Enhanced distributed development with IBM Rational Developer for AIX and Linux Version 9.0
Collaborative lifecycle management
Rational Team Concert
We are also pleased to feature Contributing Author Paul Urban
Paul Urban has more than 25 years experience in developing systems, software, and hardware in the embedded and real-time systems industry. Urban is currently a senior systems market manager for IBM Rational software and has worked with Rational software in various roles since 1995.
AcdntlPoet 2700019V2G Visits (1668)
We're back from Innovate, IBM's Technical Summit and on the tails of our mid-year release cycles. Even with the busy schedules this past month, our authors are still committed to getting you the best information we can to help you be successful with our products an in your daily work. To that end, here's the articles, featured downloads and upcoming webcasts that went live on developerWorks Rational recently:
New capabilities from IBM put developers in the spotlight
Capture multiple tooltips in one image automatically with IBM Rational Functional Tester
Find out for yourself: 7 new video demonstrations
What's new in IBM Rational Rhapsody 8.0.3 and Rhapsody Design Manager 4.0.3
Ensure effective administration and security in Rational ClearCase 8.0.1
Simplify user management for Collaborative Lifecycle Management applications
Automate deployment of an IBM Worklight customized WAR file with Rational Automation Framework
Server-side mobile application development with IBM Worklight: Parts 1-4
Configure Rational Team Concert to build ISPF Dialog Tag Language components
Using PHP and cURL for server-side caching of dynamic web pages
Now available from IBM Press: Transform your business with a winning mobile strategy: IBM's Dirk Nicol helps you navigate the mobile landscape with ease. Order now and save 35% with coupon code: IBM4916
IBM developerWorks LIVE! Jam: The jam opened June 11. Come share your ideas for developerWorks.
IBM Rational Rhapsody software's specialized editions help systems engineers and embedded software developers analyze, design, develop, test, and deliver embedded, real-time systems and software.
The Rational solution for Collaborative Lifecycle Management is a set of seamlessly integrated applications that work together as one: IBM® Rational Team Concert, IBM® Rational® Quality Manager, and IBM® Rational® Requirements Composer.
Rational Application Developer for WebSphere Software on the cloud: http
Rational Team Concert on the cloud: http
Rational Developer for System z on the cloud: http
AcdntlPoet 2700019V2G Visits (1215)
Last month the following technotes were the most heavily reused when closing your PMRs. These are the top content reused during May to help solve your Rational Focal Point, Rational Change, or Rational Quality Manager issues. We hope that highlighting them here will help others encountering the same or similar issues also find quick resolution:
Have you found a technote that helped you solve an issue without having to open a PMR? Let us know by rating and leaving feedback on that content using the "Rate this page" stars on the top right of the content or the box of the same name at the bottom of each technote! Your feedback is highly valuable to us as we work to improve the quality of solutions and help you solve issues more effectively and efficiently.
Rational Team Concert 2.0 communication with Rational Quality Manager and Rational Requirements Composer 3.0
I started working as a Technical Support Engineer, initially on Telelogic Synergy/Change products, later on IBM Rational ClearCase for the past couple of years, and lately with IBM Rational CLM (Collaborative Lifecycle Management) solutions.