Checking the status of multiple backlogs in Jira

[Ahsan Hameed]

I have multiple backlogs which I need to update in Excel every week .I am doing it one by one . Can I do mass upload and get the status ?

[Aron Gombas _Midori_]

As Trudy pointed out, it is not clear what is the direction of your data transformation.

If it is Jira Cloud to Excel, use this app which allow exporting from the Issue Navigator, from the backlog and even from boards: https://marketplace.atlassian.com/apps/1212652/better-excel-exporter-for-jira?hosting=cloud&tab=overview

[Trudy Claspill]

Hello @Ahsan Hameed 

Welcome to the community.

Can you provide more information about what you are trying to do.

Are you trying to update Jira with information from Excel, or update Excel with information from Jira?

Are you trying to keep data between Excel and Jira synchronized? Do you have an app to support real time integration between Excel and Jira?

[Ahsan Hameed]

Actually there are multiple backlogs in my excel and I have to update their status one by one from Jira . What I would like to do is to upload all of them in Jira and got their updates instead of doing one by one.

[Trudy Claspill]

Hello @Ahsan Hameed 

I am still unclear about where you data exists and where updates are being made and coming from.

You said "there are multiple backlogs in excel".

That tells me you are storing some sort of data in Excel files.

You said "and I have to update their status [backlogs in Excel] one by one from Jira".

That implies that you have the same data in Jira, that it gets updated in Jira, and that you then are manually copying updates from Jira to your Excel files.

You said you would like "to upload all of them in Jira".

Your previous statement indicates the data is already in Jira.

You said "and get their updates instead of doing one by one".

So, I am very confused.

It sounds like you have data stored in two places - Excel and Jira. 

It sounds like data is being updated in Jira.

It sounds like you are manually copying the data from Jira back to your Excel files.

What value is added by having the data stored in two places? Why do you need to update the Excel data? Why not just reference the Jira data in Jira directly?

If you need the current information about Jira issues in Excel, you can do that by exporting data from Jira to Excel. You don't need to manually copy data between the applications.

Can you explain your use case from start to finish, starting with when and where you originally create your data, and the details of when/where/how the data is getting updated? 

[Ahsan Hameed]

Actually situation is that they have copied the data manually for 65 backlogs in excel with status . Now we have to update status manually for each backlog. These backlogs are from different releases and projects.

What I am asking is can we import backlog numbers in bulk from excel to Jira and get their status and export back to Excel. 

[Trudy Claspill]

You can create new issues in Jira by import data from a CSV file. You can use Excel to create the CSV file.

https://support.atlassian.com/jira-cloud-administration/docs/import-data-from-a-csv-file/

If the issues already exist in Jira and you want to update the data in them with data that is in Excel, you can also do that by including in the CSV file the Issue Key for the issue and mapping that field appropriately during the import. Refer to this post:

https://community.atlassian.com/t5/Jira-questions/Update-existing-issue-via-import/qaq-p/1291133

You can export data for Jira issues to a CSV file which you can open in Excel. Use the Filters > Advanced Issue Search screen to select the issues you want to export. There is an Export button in the upper right corner that will enable you to export the results of the search.

[Ahsan Hameed]

I want to update the data in excel which already has list of backlogs from multiple releases.

Can I create dashboard with these specific backlogs which are spread over multiple releases. 

[Trudy Claspill]

You can create a filter for issues based the value of the Fix Version field (which is where a Release is typically noted), sort the output by the Fix Version field, and get information about the issue that can then be exported.

Alternately you can look for third party apps that support direct integration between Excel and Jira Cloud to see if you could get what you want that way.

https://marketplace.atlassian.com/search?hosting=cloud&product=jira&query=excel

I have not used any of those before and have no insights on which might work for you.