Import excel data to RQM
After installation of RQM excel importer utility, the RQM menu under ADD-INS was found in the excel sheet successfully, but after selecting the option "Export to Repository" nothing is happening, the box to fill all the information to export is not getting displayed.
Please help me in finding what is the issue.
Thanks in advance.
5 answers
This could be what is suggested in
RQM popup does not appear in Excel or Word when clicking on a menu entry
The best and easy way defined by a dissertation writing service to import Date from Excel to RQM Custom field is to change the format of date in Excel.
A dateTime value passed through the excel sheet should follow a format : YYYY-MM-DDTHH:MM:SS
To get this format in CSV, Just select the column / Cell which contains the date in any format ==> Right Click and Select Format the Cells ==> and then change the format under custom section. Please refer to the below Image.
Once the date format is fixed in CSV File. Now let’s write entry for CFG file so that we can import it into RQM. The following Entry will create a custom attribute in Test Case Template and import date from Excel in that field.
testcase.customAttributes identifier=”Creation_Date”.name=” Creation Date”.type=”TIMESTAMP”.value=L
Few Points to consider :
RQM Server and Client Machine should have same time zone, otherwise there will be change in Excel sheet Time and RQM Date Field time.
If there is difference in Time Zone then you can add Timezone at the end of date format. e.g 2016-08-09T12:00:00+03:00