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

RQM 5.0: RQMExcelImporter : Date format is not getting imported correctly

Questions
Tags
Users
Badges
Naveen Tyagi
(197●78●152) Mar 18 '15, 2:28 a.m.
i am trying to Import some Custom section which contains value in date format[05-01-2015] and after importing, instead of actual value some random number[41883 ] is getting mapped in that custom sections . how exact date value can be imported exactly in RQM? you are help would greatly appreciated.

0 votes

2 answers
6,740 views
0 votes

2 answers

Permanent link
Reshma Ratnani
JAZZ DEVELOPER (1.1k●1) Mar 18 '15, 3:46 a.m.
Hi Naveen,

Date/time values are represented as XML dateTime values.
For eg : 
2013-0606
2013-11-29T16:00:00.000Z

0 votes

Comments
Naveen Tyagi
Mar 18 '15, 4:03 a.m.
 Hi Reshma, I did read this article before posting question but didn't get clear idea. can you please me what exactly i need to change in my config file to that date can be imported correctly.?

Reshma Ratnani
JAZZ DEVELOPER Mar 18 '15, 4:09 a.m.
So for Iteration if you want to set startDate or endDate etc below is syntax for few such cases testphase.expectedStartDate=C7 testphase.expectedEndDate=C8 testphase.starttime=C9 testphase.endtime=C10 where C7 has value 2013-0606 C8 has value 2013-11-29T16:00:00.000Z C9 has value 2013-11-15T07:29:00.000Z C10 has value 2013-0606

1 vote

Naveen Tyagi
Mar 18 '15, 5:04 a.m.
 I think you have given info about predefined sections, startdate,Enddate I have three columns in Excel file fine "Job1 Start of frame",", "Job2 Start of frame "Job3 Start of frame". all these columns contains date value in format DD-MM-YY. There are so many test plans[Excel rows] and every test plan has there custom values.  "tesplan.Section("myns:mysection,"my custom section")=C", I have used this for custom section to create automatically in RQM and also value to be mapped in that.. It's working fine for other custom sections contain numeric and string value but in case of there sections [contain Date] some four digit no. getting mapped instead of actual date value. I am wondering how can i use C7,C8,C9 when C7 is custom section and C8 is value of custom section for  other Test plan plan.

Permanent link
Naveen Tyagi
(197●78●152) Mar 23 '15, 2:31 a.m.
Since i didn't find any way to import Date from Excel file to RQM so, I  have converted date format into Text in Excel and now its getting imported fine.

0 votes

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
× 11,108

Question asked: Mar 18 '15, 2:28 a.m.

Question was seen: 6,740 times

Last updated: Mar 23 '15, 2:31 a.m.

Confirmation Cancel Confirm