How to ensure TIMESTAMP values in Rational Quality Manager (RQM) test artifacts using custom attributes hold the same value as exported from excel

Technote (FAQ)


Question

How do you ensure TIMESTAMP values in IBM Rational Quality Manager (RQM) test artifacts using custom attributes hold the same value as exported from excel?

Cause

You want to export data from excel into RQM

Answer

The dateTime (Date/time) value in RQM artifacts are represented as XML dateTime values and a valid dateTime string is as given below:

For example, 2014-06-29T12:00:00+05:30 represents noon on 29th of June 2014, India Standard Time.




Any other formats of dateTime string eg : 2014-12-10T12:00:00Z, 2014-12-10T12:00:00 will convert to a different time string based on the timezone of the client machine (Microsoft office package which contains RQMExcelExport addin) or that of the RQM server.

Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

Rational Quality Manager
Integrations: 3rd Party

Software version:

4.0, 4.0.1, 4.0.2, 4.0.3, 4.0.4, 4.0.5

Operating system(s):

AIX, Linux, Solaris, Windows

Reference #:

1662739

Modified date:

2014-01-24

Translate my page

Machine Translation

Content navigation