It's all about the answers!

Ask a question

how to import with excel import utility a testplan and add schedule (new or existing iteration)


eirini petraki (5178) | asked Apr 23 '13, 9:07 a.m.
edited Apr 23 '13, 9:19 a.m.
I'm trying to import with excel import utility a testplan with schedule.
I saw that every time im trying to use schedule that alrady defined vor other testplan (already exists under project timeline under a name "testplan <other_tp_ID>) then i see during RQM export all ok:

RQMExport.JPG
but after refresching RQM project still is for this testplan the iteration unassigned!

here the schedule part of my cfg file:
//Config for testphase
testphase.XLSWorksheetID="Schedules"
testphase.XLSArtifactID=A
testphase.XLSStartRow=4
testphase.dc:title=B
testphase.dc:description=C
testphase.expectedTotalPoints=D
testphase.expectedDefects=E
testphase.expectedValidityRate=F
testphase.expectedStartDate=G
testphase.expectedEndDate=H
testphase.starttime=I
testphase.endtime=J
testphase.testplan=Link(K4)

and the corresponding xls file:
Schedule_xls_sheet.JPG

My question is how to handle this? Were are my mistakes on this topic?
My goal is to create over EXCEL import utility an TP with schedule and environments (using existing iterations and environments).












  

  

  

  

  

  

  

  

  

  

 
  

  

  

  

  

  

  

  

  

  

  

 
  

  

  

  

  

  

  

  

  

  

  

 
  

  

  

  

  

  

  

  

  

  

  

 
  

  

  

  

  

  

  

  

  

  

  

 
  

  

  

  

  

  

  

  

  

  

  

 

One answer



permanent link
Vidya Malkarnekar (1.0k15) | answered Apr 23 '13, 11:35 a.m.
JAZZ DEVELOPER
Looks like your attachment didn't go through. Can you please attach it again? Thanks!
Also, what is the RQM/importer version?

Comments
eirini petraki commented Apr 24 '13, 5:27 a.m.

RQM EXcel importer  version has the version 4.0.1.13426

after export to repository i see:
......
sending <testphase > 
........
Exporting completed successfully

but in RQM i see that:
In FirstPlan2 is no schedule attached.
Just for Info i had in FirstPlan1 already the schedule with same phases names and dates attached. I maybe there the problem?
If it so how i can link to an existing iteration?

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.