Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

Export work item category and Planned For values to CSV

Questions
Tags
Users
Badges
Mastanaiah Mannem
(3●9●12) Oct 24 '16, 9:27 a.m.

We have CLM 602 Environment with multiple project areas with huge number of category and Planned for values.

Client requested to all planned for and category values. By taking manually it very difficult might be chances to miss it.

Is there any possibility to export the values to CSV or some other format.

Could you please help me on the same and

0 votes

2 answers
1,754 views
0 votes

2 answers

Permanent link
Ralph Schoon
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER (63.9k●3●36●48) Oct 24 '16, 10:07 a.m.
Your question seems to be missing parts of the sentence and does no make so much sense.

There is no export of this data I would be aware of. You could use the API to export the data. For categories it is

com.ibm.team.workitem.common.IWorkItemCommon with several methods.

IWorkItemCommon.findCategories(IProjectAreaHandle, ItemProfile<ICategory>, IProgressMonitor)

For iterations look at https://rsjazz.wordpress.com/2012/10/05/handling-iterations-automation-for-the-planned-for-attribute/ .

0 votes

Permanent link
Mastanaiah Mannem
(3●9●12) Oct 24 '16, 10:32 a.m.

thanks Ralph for your quick reply.

we are not much aware of script. is there any simple command for getting the list of work item categories/Planned for values.

0 votes

Comments
Ralph Schoon
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER Oct 24 '16, 11:04 a.m.

Not that I would know about. You could try to export the process template and then have a look in the XML once you download it. I haven't tried that.
I would use the API myself, I have enough example code lying around.

Your answer

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

Ask a question
Guidelines
FAQ
Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details

Question asked: Oct 24 '16, 9:27 a.m.

Question was seen: 1,754 times

Last updated: Oct 24 '16, 11:04 a.m.

Confirmation Cancel Confirm