Exporting dateTime (timestamp) values into Rational Quality Manager through the RQMExcelWordImporter plugin
SunilKumarR 270001XXSY Visits (1918)
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 (1183)
IBM UrbanCode Release playlist- In the series of seven videos below, you will learn about IBM UrbanCode Release, a release management and coordination platform. Each video will auto play after the other for a total runtime of 55 minutes. So grab a pot of coffee, sit back, and enjoy learning about UrbanCode Release!
NikhilBhat 270005V9K6 Visits (1353)
Of late I have come across instances, where license administrators are facing issues related to permanent and temporary licenses. I thought it will be a good idea to provide all the relevant information through this post. Let me start with a description of license key types.
License key type : These are broadly categorized into two parts
Permanent: A license issued to a customer to run products for an indefinite period of time.
To order your permanent floating, named-user floating, or authorized user license keys for most products, use the IBM Rational License Key Center.
To acquire an authorized user license key for IBM Rational products based on the Eclipse framework, purchase and download an activation kit from Passport Advantage. See Requesting license keys for information about ordering keys from the License Key Center.
Temporary (evaluation or emergency): A time-limited license issued to a customer for running IBM Rational products. You can use it on any computer until the specified expiration date.
Temporary license keys can be floating or authorized user.
Temporary keys are generated only for single or multiple license servers. They are not generated for redundant servers.
NOTE : To evaluate a product, ask your sales representative for an evaluation key.
Important : License key files file name with description:
→ rational_temp.dat: Contains all authorized user temporary license keys. Obtain a permanent license key to use your IBM Rational product past the temporary license key expiration date.
→ rational_perm.dat: Contains all authorized user permanent license keys. Go to IBM Rational License Key Center to request permanent license keys.
Now as we know and understand the basics about licenses, we can move ahead to discuss a few issues related with using the licenses in your environment. To start off, I would like to discuss about using a newly generated temp
The figure below shows the contents of a temporary license file
the Host name is “this_host”
the host id is “ANY”
the host-id is “ANY” to signify that this license can be run on any machine irrespective of the license type,
But while configuring these licenses on the license key server you need to make sure that the host name is updated to reflect the the actual Host name of the machine on which the license key server is running.
If this is not done, license checkouts will not happen.
Steps to modify the temporary license file:
1. Open the temporary license file with notepad or any other text editor.
2. Replace this_host with hostname of the machine.
3. Save the changes and exit from text editor.
If the Rational license key server is running on the host ABCD, then the above steps should be followed and the updated file should look like the one below
There may be instances where you have to use both permanent and temporary license. The following discussion focuses on this.
How to serve both permanent and temporary licenses at the same time
As pointed out earlier for temporary licenses, the following files are used
and for permanent licenses, the following files are used
So we have to configure the license server to read two license files instead of one
Steps to make the license server to read two license files
If Rational License Key Server is configured as a Service
1. Open windows registry editor (regedit.exe)
2. Navigate to the following registry key:
Note: On 64-bit Windows 7 platform, please navigate to the following key:
3. Modify the current value, and specify the complete paths to the two license files, separated with a semi-colon “;”.
4. Close the registry editor and restart your Rational License Server.
If the license server was initially started as a process from a command prompt:
1. Stop the license server by using following command
lmutil lmdown -c <pat
2).Restart the Rational License Server process using the following command:
lmgrd -c <pat
Note: The 2 paths are separated by a semi-colon ";".
I would also mention that removing the references to expired temporary licenses is also very important. If not removed, the expired licenses can cause issues while importing new licenses.
To remove expired temporary licenses:
1. Navigate to location of rati
2. Open the file in a text editor.
3. Delete the lines or INCREMENT block(s) corresponding to the expired temporary licenses.
4. Restart the license server.
→ How to serve both permanent and temporary licenses at the same time: http
→ Rational License File Management: http
→ Rational Common Licensing 8.1.4: http
AcdntlPoet 2700019V2G Visits (1177)
What is IBM Event Connect?
Let's us do the work!
Learn more on SlideShare here !
Contact Janet Baum for more information: phone 720.396.2912 or Emai
Sumant Renukarya 270002B42N Visits (1142)
It is possible to export and import the work items from a repository to another. Here was a unique situation, which demanded additional work.
We were trying to export workitems to CSV and import it in to other repository. It is possible to get the XML data entered in an attribute of a work item upon export, if that attribute is of the type wiki or HTML. However we had an attribute of the type largeString, which had XML content as the data for this attribute.
Exporting the work item to CSV in this case did export the attribute but not the XML data to CSV.
==> Here are the steps that we took, to bring the XML content from the attribute of the type large string at the target project area. It makes use of Temporary HTML attribute for this cause.
4. Apply the script to the LargeHTML attribute.
Please note, the use case mentioned here may not be applicable to all users performing an export and import, as this was a unique situation with a non-typical solution.