Exporting dateTime (timestamp) values into Rational Quality Manager through the RQMExcelWordImporter plugin
SunilKumarR 270001XXSY Visits (2323)
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 (2322)
Hot off the OnDemand Demo Guy's plate:
Quality management and test data management for SAP- This demo looks at new Optim System Analyzer - Rational Quality Manager (RQM) product integration that delivers better quality for less efforts. It starts by looking at the key questions asked when faced with SAP changes.
kellypuffs 06000168YK Visits (2322)
Couldn't make it to Orlando in June for Innovate 2010? Can't attend one of our several regional events? No matter. We'll bring Innovate 2010 to YOU.
I'm attending. Hope to "see" you there!
AcdntlPoet 2700019V2G Visits (2320)
The following two ALM videos were highlighted previously on NFRS, but we wanted to add them to this post as well for continuity and in case you missed them previously: And lastly, how about an oldy-but-goody just to round it all out:
The following two ALM videos were highlighted previously on NFRS, but we wanted to add them to this post as well for continuity and in case you missed them previously:
And lastly, how about an oldy-but-goody just to round it all out:
mquimby 060001FAVB Visits (2318)
There are nine new videos for Rational Developer for System z 8.5 on IBM Education Assistant for Rational. Check out the newly published categories below. Also available is an introduction and tutorial for custom actions for Rational Automation Framework.
Rational Developer for System z
Rational Automation Framework
Your feedback helps us improve. You can find the feedback form on the category pages for your product and version. The feedback form is quick and easy. Leave comments and let us know if these demonstrations help you achieve your goals
What is IBM Education Assistant? IBM Education Assistant is a collection of multimedia educational modules designed to help you gain a better understanding of IBM software products and use them more effectively to meet your business requirements.