Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Merge user Table with Jira Extract

Our teams use many custom Confluence tables to track misc information that is not included in our Jira instance. However, these tables always include Jira ticket keys as a common reference point. What I would like to do is merge basic Jira information into these tables based on the ticket keys.

I expect the Jira data will come from exporting the results of a filter into a CSV file. I'd then like to merge the CSV data with the user Table into one table based on the keys included in the user table.

Obviously the most automated approach would be ideal.

2 answers

2 accepted

Hi @Kevin Lyons,

We can recommend you to use our app - Table Filter and Charts for Confluence.

The Table from CSV macro will help your users to create Confluence tables from .csv and .tsv files.

To merge tables use the Table Transformer macro. The default automatic Lookup preset will suit you.

Besides our macros (filters, pivots and charts) work with the Jira Issues macro just fine and you'll be able to create real-time dashboards right in Confluence.

0 votes
Answer accepted

Thanks @katerina_Kovriga

The next requirement is direct editing of table cells. Will this app suite help with that?

Kevin

We have the "Edit table in the view mode" feature in our backlog, but it is not implemented at the moment.

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Apps & Integrations

🍻🍂Apptoberfest Update: Upcoming Virtual Events 🎉

Hello Community! I hope you've been enjoying the 🍂Apptoberfestivities🍂 (I know I have!) The event is heating up next week with a series of virtual events that we're calling the 🍻🍂Partner App ...

154 views 2 13
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you