creating jira issues from a confluence table for every new row

[vikas palakurthi]

Hi,

We do a lot of on demand work (requests from say email) and we wanted to track our work. So, we decided to track our work.

The issue creation is taking longer.

So, we are looking to automate issue creation.

Is there any way to create issues from a confluence page, where we can just add the summary and description to a existing page and publish it, thus creating a new issue to the added new content. All the other values should be copied from say a template. Any suggestions would be appreciated.

All I found was the jira issues macro, where either

1. I select from page view and create issue manually 

2. Insert the issue using the macro by adding values which is again same like creating issue in jira.

[Melanie DuPont]

This should work:

1. In Confluence and Google Chrome, edit a page, then create a table (make sure it has a header) with as many rows as you want tickets.
2. In the header, uniquely title your columns (Summary, Description, and so on).
3. Fill in ticket summaries and descriptions.
4. Publish or Update the page (so that you're not in edit mode).
5. Select the text of the first summary. In the tiny menu that appears, click the Jira icon.
6. In the Create Task window, make sure the Jira project and ticket type are correct, then click Create multiple issues from table.
7. In the Create Multiple Issues window, you are being asked which table column contains Summary text, and which contains Description text. Make sure these are right, then click Create.
8. You should get a message like "3 issues have been created. Your page has been updated to reflect the status of these issues." Notice that links to each Jira ticket have been added to the table! Go to Jira to see your new issues.

[pace]

Is there a way to automate this without external scripts? E.g., once a month JIRA takes each row in a confluence table and adds it as a separate sub-task in a specific issue? 

[Lucie Rösgen-Pomper]

@Melanie DuPont Do you know, if there is a solution to include pictures, that are embedded in the table cells in the issues description field? If I convert it as you mentioned, it only includes links which lead to a 404 page. 

[Mel DuPont]

@Lucie Rösgen-Pomper I do not know a way to push attachments from the Confluence table's Description column into the Description (or even Attachments) of the Jira ticket as it is created :(

That would be a good feature request to make, if someone hasn't already asked for it!

[Rafael Pinto Sperafico]

Hi @vikas palakurthi ,

You could:

• create a User Macro to consume a Jira REST API call creating issue(s) in Jira
• make use of ScriptRunner for Confluence and listen to the PageEvent (https://docs.atlassian.com/atlassian-confluence/5.9.7/com/atlassian/confluence/event/events/content/page/PageEvent.html)
• develop your own Atlassian Confluence add-on (https://developer.atlassian.com/server/confluence/event-listener-module/)

Alternatively, you could make use of Jira Issue Macro (https://youtu.be/reiLHEIlXDc?t=42)

Kind regards,
Rafael