How to define 'Date format' for TCER Start time, End time while uploading Testcases from Excel to RQM4.0.6?
Im using "Scripts that create testcases with TCER" sample config file for uploading Testcases to RQM4.0.6. How to define 'Date format' for TCER's Start time, End time while uploading Testcases from Excel to RQM4.0.6 in IST time format.
I have referred the link: https://jazz.net/wiki/bin/view/Main/RQMExcelWordImporter#Configuration_file_structure and tried the format, still getting errors for date format while upload.
Regards
Sirisha
Accepted answer
In the samples directory of the RQMExcelImporter installation, there is a example Excel file, Execution Results.xls, that has a Start Time and End Time you can use as an example.
An example of a date in this file is:
| 2009-07-24T13:04:00Z |
The example uses Z which is Zulu time, but if you leave that out, I believe it uses the server time.
I hope this helps.
Comments
Hi Erica,
I have tried above date format it worked fine but now it is throwing error past12 noon.
Unhandled exception has occured in a component in your application.
The string was not recognised as valid Date Time. There is a unknown word at index 0.
See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.
** Exception Text **
System.FormatException: The string was not recognized as a valid DateTime. There is a unknown word starting at index 0.
at System.DateTimeParse.Parse(String s, DateTimeFormatInfo dtfi, DateTimeStyles styles)
at System.Convert.ToDateTime(String value)
at Mso2Rqm_Common.ArtifactFactory.fillRefs(Worksheet currentWorksheet, Int32 iCurRow, PreferenceStore
Could you please help how to resolve this issue?
I'm not sure. The example of the time 2009-07-24T13:04:00Z that I took from the sample, Execution Results.xls, is a time after 12:00 noon. Does this value work for you? What is the exact format you're using?