Polarion – Export Work Items as CSV

Problem

  • You want to export objects in csv format

Solution

First, create a classic wiki page.

## Get Project-Id
#set($projectId = $doc.getProject($doc.getSpace()))
## Get Project as object
#set($pro = $projectService.getProject($projectId))
## Query Work Items (here requirements ordered by id)
#set($objects = $trackerService.queryWorkItems($pro, “type:requirement”, “id”))
##Iterate over list
#foreach($entry in $objects)
##Display on page. Seperator is ;
$entry.getId();$entry.getTitle();$entry.getSeverity().getName()\\
#end

Copy the content of the page to Excel or whatever.

Fin.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s