It's all about the answers!

Ask a question
QuestionsTagsUsersBadges
Guidelines | FAQ
Follow this question
Question details

×10,951
×6,107

question asked: Apr 23 '18, 7:13 a.m.
question was seen: 3,766 times
last updated: Jun 18 '20, 5:49 p.m.

Related questions

Import excel data to RQM

0
Rohini Kumar (92●10●57) | asked Apr 23 '18, 7:13 a.m.

 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

Most liked answers ↑|Newest answers|Oldest answers

0
permanent link
Monika Rajput (256●1●2) | answered Apr 25 '18, 7:04 a.m.

 Hi Amruta,

Could you please let me know whether you are able to see the dialog when you click on option Export to File.

0
permanent link
Don Yang (7.7k●21●114●139) | answered Apr 27 '18, 1:54 a.m.
edited Apr 27 '18, 1:54 a.m.

This could be what is suggested in

RQM popup does not appear in Excel or Word when clicking on a menu entry

in https://jazz.net/wiki/bin/view/Main/RQMExcelWordImporter

0
permanent link
shubham shahu (105●3●68) | answered Apr 27 '18, 5:47 a.m.

Hi Amruta,


To do so you have to write mapping file in notepad and then you have to import it in RQM.

Regards,
Shubham.

0
permanent link
sreenath v (78●6●80) | answered May 09 '18, 2:09 a.m.

 The installation which you done rqm excel import utility might be wrong. You should have .net framework 2 and you should use rqmexcelimport*64.exe file
0
permanent link
Chris Greenwalty (11) | answered Jan 13 '19, 10:57 a.m.

 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

Your answer

Register or 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.