Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

RQM execution results startTime and endTime is not updated as provided in excel

Questions
Tags
Users
Badges
Sunil Kumar R
JAZZ DEVELOPER (1.1k●1●33●44) Feb 07 '14, 6:59 a.m.
Snapshot below shows the startTime and endTime values in execution results created using excel export into RQM. As you notice, irrespective of the dateString format used the value of the time string is consistent.


Impact : The dateStrings are not used as-is. i.e., the time values provided by the sheet and value updated in the artifacts in RQM are different.

The same scenario if tried for custom "date/Timestamp" attributes for eg: A Test Script created with custom date/TimeStamp attribute through excel, it supports the following behavior.

Any pointers?

1 vote

Comments
Don Yang
Mar 25 '15, 10:54 p.m.
Hi, Sunil Are you able to make it work as what Erica suggested == Example: Excel file: Start time:  2009-07-24T13:04:00  Web UI: Start time:  7/24/2009, 1:04 PM == In my test with ExcelIporter 4.0.5 and 5.0.1 here, if I specify 20014-07-24T11:04:00 as starttime in Excel and then import, it will show the execution start time as 20014-07-24T10:04:00pm (which is  20014-07-24T11:04:00 + 11 and it is UTC+11 for my local time) and the result is the same as having Z at the end or removing it. The user wants to specify the exact local time as starttime for execution result, but it seems to work like specified time+xx after the import which is not the expected timestamp. Thanks Don

1 answer
8,279 views
1 vote

Accepted answer

Permanent link
Erica Tran
JAZZ DEVELOPER (1.4k●7) Feb 07 '14, 3:24 p.m.
Hi Sunil,
The time in the on the left which has the Z at the end is Zulu time.  Which is same as GMT time.  The right shows the time values that are imported.

Based on the time difference, is the user and or the RQM server in IST time? 
13:04 Z = 6:34 PM IST

I'm not sure what the +0530 is at the end of some of the cells in the Excel spreadsheet, but if the server is in IST, then the time imported is correct.

I hope this helps.
Sunil Kumar R selected this answer as the correct answer

0 votes

Comments
Sunil Kumar R
JAZZ DEVELOPER Feb 10 '14, 10:56 a.m.
Is there an option to specify the server timezone as a part of the dateString in the excel sheet. So that the value in RQM field appears as in excel sheet? Best Regards, Sunil

Erica Tran
JAZZ DEVELOPER Feb 10 '14, 1:19 p.m.
Hi Sunil, The import should always be done on server time.  I just ran a quick test.  With the Z removed, There is no conversion in time.  The format is displayed a little differently in the Web, but the date/time is the same.  Example: Excel file: Start time:  2009-07-24T13:04:00 Web UI: Start time:  7/24/2009, 1:04 PM Does this answer your question?

1 vote

Your answer

Register or log in to post your answer.

Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.

Ask a question
Guidelines
FAQ
Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details
× 12,145

Question asked: Feb 07 '14, 6:59 a.m.

Question was seen: 8,279 times

Last updated: Mar 25 '15, 10:54 p.m.

Related questions
Confirmation Cancel Confirm