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

Updating Workflow/status by uploading CSV file

Hi, When i am trying to update the ticket workflow/Status by importing CSV file, a new ticket is being generated. Where as i want to make updates to the same ticket. 

1. Cannt we make changes to the workflow/Status by importing CSV file?

2. When i try to update the status, i dont have the option to map it "Status" as you can see below. The "Task Status" is different from "Status". So, i try to map it to Workflow & proceed ahead but a new ticket is created. 

3. I also tried using "Key" as its a unique entity to edit the status, but didnt work. 

 

 

Screenshot 2020-04-18 at 00.51.27.png

2 answers

0 votes

Hello @Sri

Welcome to the Atlassian Community!

Per your description, I understand you are basically facing two problems: 

  1. Instead of updating the desired issues when importing your CSV, the import client is creating new issues in your site
  2. You are not being able to map the status of the issues in the CSV

Can you please confirm if you are using a Classic or Next-gen project? There are different behaviors for each project type when import CSV files.

Anyway, allow me to bring you some common details and concepts for both project types so we can confirm we are on the same page here:

The updating of new issues through CSV happens when you map the correct issue key in your CSV file to match the existing issues of your site, as described in the documentation below:

Matching Exported Issue Data to Update JIRA Projects with JIRA Importers Plugin 

Basically, the easiest way to update existing issues in your site would be following the steps below:

  1. Create a JQL filter returning all the issues you want to update and export it, using the option "Export to Excel (All fields)":
    Screen Shot 2020-04-20 at 18.16.08.png
  2. Edit the fields you want and import the same CSV file back to your Jira (Using the option under Jira Settings > System > External System import), keeping the Issue Key field untouched

About the status field not appearing to be mapped, I see you have several custom fields with the word "Status" that by default appear at the top of the drop-down, so maybe the correct status field must be at the end of the list. Can you please check if you can scroll down to it? 

Screen Shot 2020-04-20 at 17.27.32.png

Also, check if you are using the import option under Jira Settings > System > External System import. P.S: This option is only available for Site-Admins.

If the instructions above didn't help, please provide us more details about the results you got and what project template you are currently using (Next-gen or Classic).

It's bad that is only available for Site-Admins. It seems like you are a programmer or something like that. Reading your reply, I'm fascinated by your knowledge about programs and CSV files. I see so many actions, which I wouldn't do myself. Recently I had some problems with a file, and I found an interesting article about how to upload CSV formatted data. I'm using it until today, it's helpful for beginners or low knowledge guys on pc. Also, I would love it if someone is a programmer beginner and will read the article I left.

Suggest an answer

Log in or Sign up to answer
TAGS

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