KEY Project in Excel Export /Project Pivot Доклад/

[Former user]

Is it possible to add a column 'Key Project' in Excel Export for Project Pivot Report when uncheck Show Details ?

Thanks, Tsenka

[Andriy Zhdanov]

Hi Tsenka,

Project key is easily seen from issue key, and there is also project name column. If you necessarily need project key column, you can change pivot-report-excel.vm as follows:

@@ -22,7 +22,7 @@
        #foreach ($worklog in $worklogs) 
            <tr #if ($count % 2 == 0) class="rowNormal" #else class="rowAlternate" #end >
                #set ($relPath = "/browse/$issue.projectObject.key")
-               <td width="1%"><a href="$textUtil.expandUrl($req, $relPath)">$issue.projectObject.name</a></td>
+               <td width="1%"><a href="$textUtil.expandUrl($req, $relPath)">$issue.projectObject.key</a></td>
                <td width=1%>$issue.getIssueType().getString("name")</td>
                #set ($relPath = "/browse/$issue.key")
                 <td width=1%><a href="$textUtil.expandUrl($req, $relPath)">$issue.key</a></td>

You need to extract it from plugin jar and then update it, e.g.

jar xf jira-timesheet-plugin-2.5.6.jar templates/pivotreport/pivot-report-excel.vm
jar uf jira-timesheet-plugin-2.5.6.jar templates/pivotreport/pivot-report-excel.vm

Hope it helps.

Thank you.