RQM 5.0: RQMExcelImporter : Date format is not getting imported correctly
2 answers
Date/time values are represented as XML dateTime values.
For eg :
2013-0606
2013-11-29T16:00:00.000Z
Comments
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.?
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
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.