It's all about the answers!

Ask a question

Create workitem by fetching excel data


Minakshi Verma (153) | asked Sep 20 '21, 3:58 a.m.
edited Sep 21 '21, 3:05 a.m.

I am able to fetch the complete excel, also it is reading the data but after that, for some particular field i want to create workitem.
Can anyone please help in this. It is really on urgent basis.
Thanks in advance,
Minakshi

Accepted answer


permanent link
Ralph Schoon (63.1k33646) | answered Sep 20 '21, 5:01 a.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER

 EWM supports CSV/Excel import of work items in the product. 


The WCL https://github.com/jazz-community/work-item-command-line is open source and also supports CSV/Excel import. It also provides commands to create retrieve update work items.

Minakshi Verma selected this answer as the correct answer

Comments
Minakshi Verma commented Sep 20 '21, 6:59 a.m.

Hi @Ralph,

I have already imported the excel sheet but after that, for some of the data, i need to create workitem and in that only, i am facing issue.
I have gone through that link which you posted but i am not getting that.
Can you please explain in detail


Ralph Schoon commented Sep 20 '21, 7:06 a.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER

Explain what in detail? What does create a work item mean? Why, what purpose. For WCL read https://github.com/jazz-community/work-item-command-line#readme 


Minakshi Verma commented Sep 20 '21, 7:17 a.m.

Okay sure, thanks 


Ralph Schoon commented Sep 20 '21, 8:45 a.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER

My point besides read to understand what WCL does, provide more information about what and why if you want better answers. 


Minakshi Verma commented Sep 20 '21, 2:05 p.m.

Yes i got your point.

Thanks a lot,
Minakshi

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.