It's all about the answers!

Ask a question

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


Naveen Tyagi (19767152) | asked 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.

2 answers



permanent link
Reshma Ratnani (1.1k1) | answered Mar 18 '15, 3:46 a.m.
JAZZ DEVELOPER
Hi Naveen,

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

Comments
Naveen Tyagi commented 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.?


1
Reshma Ratnani commented Mar 18 '15, 4:09 a.m.
JAZZ DEVELOPER

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


Naveen Tyagi commented 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 (19767152) | answered 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.

Your answer


Register or to post your answer.