Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Xporter - loops all sheets

Jacob Wulff
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
January 20, 2021

Hi

I am using Xporter to export info about issues, e.g. time spent, remaining etc.

Problem:

All content in every sheet is copied for each issue line in the Xporter sheet. Also sheets with only static information.

 

How do I change that?

 

Details:

In my excel file I have 4 sheets

2021-01-20 10_49_39-fil 3 - Xporter template.xlsx - Excel.png

I have made the following export in the "Xporter" sheet. All other sheets are static info.

The loop in Xporter:

2021-01-20 10_46_33-fil 3 - Xporter template.xlsx - Excel.png

When I go to the "Setting" sheet, the two settings line are copied X times.. :(

Before export:

2021-01-20 10_59_09-issues (19).xlsx - Excel.png

After export:

2021-01-20 10_49_33-issues (19).xlsx - Excel.png

What am I doing wrong?

 

Thanks guys!

1 answer

1 accepted

0 votes
Answer accepted
Jacob Wulff
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
January 22, 2021

Found a solution.

On the sheets that are not to be looped insert the following:

 

&{for issues|filter=%{'${BulkIssueIndex}' == 0}}

Setting 1
Setting 2

&{end}

 

Works like a charm! :)

Jussi-Petteri Penttilä
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
April 5, 2022

Thanks for documenting the solutions! :)

Suggest an answer

Log in or Sign up to answer