nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

CSV import - Status field

Kristine Williams

I'm trying to leverage import csv feature in JIRA, which is great, but from what I can see, although "Status" is in CSV Field column, we are not able to map that to "status" in JIRA field that must be populated. This seems like a pretty big issue for heavy users of JIRA since status is a key field. I'm hoping someone can help me map this field. If this is not possible, can someone tell me if this is an pending fix to the software?

Accepted answers

Dario B

Hello @Kristine Williams and @Nic Brough -Adaptavist- ,

Please notice that there are 2 different ways to import issues from CSV:

Only available to Jira administrators from Jira Administration -> External System Import. In here all the statuses are available to be mapped.
- Documentation page: Importing data from CSV
Available to non admin users as well from: Filters -> Advanced Issue Search -> ... -> Import Issues from CSV. In here you can only map a sub-set of fields.
- Documentation page: Create issues with the CSV importer

Now, I have checked the fields that can be mapped when using method #2 and Status is indeed not present in there.

@Kristine Williams can you kindly confirm this is the case? Also, can you confirm you are able to map the issue status if use External System Import instead?

Cheers,
Dario

All comments

Nic Brough -Adaptavist-

What do you mean by "can not map the status"?

You're absolutely right that this is a critical item (it's not technically a field, but that's not important here). You need to give it a status, unless you are in the one place where it's ok for every imported issue to go into new/open/to-do - whatever "create issue" would do if you typed each issue in manually.

As I get a status I can map when I import from csv, I don't know what you are seeing. What is stopping you from doing that mapping?

Kristine Williams

"Status" is not in the "JIRA Field" drop down box as an option, so I can't map it, from what I can see......

Kristine Williams

Is there any chance I can share screen shot of some sort of live view with you?

Nic Brough -Adaptavist-

You should have a little camera-like icon for attaching images here. Feel free to show us anything you feel is appropriate (and blur out data you think may be sensitive - we only need to see stuff like where you are and what the drop-down lists look like when you're trying to define a mapping)

Kristine Williams

Hey there folks.... was just trying to work through the challenge - sorry things have turned somewhat ugly. Not what I would expect from a professional community like this. I'll defer to some other groups for support at this point, but thanks for trying to assist.

Nic Brough -Adaptavist-

@Kristine Williams - you have nothing to say sorry for.

You've asked a perfectly good question about something that seems to be broken, and given us lots of information to try to help us work out what it might be and hence head towards a fix.

The conversation has been de-railed by what I'm hoping is just a misunderstaning. Frankly, I'd like to ignore that, move on, and get you a proper solution.

Dario B

Hello @Kristine Williams and @Nic Brough -Adaptavist- ,

Please notice that there are 2 different ways to import issues from CSV:

Only available to Jira administrators from Jira Administration -> External System Import. In here all the statuses are available to be mapped.
- Documentation page: Importing data from CSV
Available to non admin users as well from: Filters -> Advanced Issue Search -> ... -> Import Issues from CSV. In here you can only map a sub-set of fields.
- Documentation page: Create issues with the CSV importer

Now, I have checked the fields that can be mapped when using method #2 and Status is indeed not present in there.

@Kristine Williams can you kindly confirm this is the case? Also, can you confirm you are able to map the issue status if use External System Import instead?

Cheers,
Dario

Leo Lardizabal Seril

Hi, I am also encountering the same issue as the original reporter of this issue. I cannot find the "Status" field when trying to import a CSV file. I am pretty sure this was available in the past and judging by the date this issue was logged, it looks like it only started recently.

Initially I thought there was a problem with my issue screen layout, but I tried comparing with other projects where I have done CSV imports before and I could not select the Status field anymore.

Leo Lardizabal Seril

When I tried using the Import Wizard (since I have Admin access). I can see the "Status". In the past, I only used the normal Import from CSV function, I was not even aware that there was an import wizard for Administrators only.

Dario B

Hi @Leo Lardizabal Seril ,

Did you have any chance to read my answer (the one at the top of this thread) in which I explain that there are 2 different ways to import from CSV and the status field is only available in one of them?

Please notice that there are 2 different ways to import issues from CSV:

Only available to Jira administrators from Jira Administration -> External System Import. In here all the statuses are available to be mapped.
Documentation page: Importing data from CSV

Available to non admin users as well from: Filters -> Advanced Issue Search -> ... -> Import Issues from CSV. In here you can only map a sub-set of fields.
Documentation page: Create issues with the CSV importer

Now, I have checked the fields that can be mapped when using method #2 and Status is indeed not present in there.

Cheers,
Dario

Leo Lardizabal Seril

Hi @Dario B , Yes it was from your answer that I found out about the 2 different ways to import.

What I am saying though is that in the past, I think I was only using the non-admin method (#2) and could still import Status, but now it seems that I need to use my admin access to do this.

I could be wrong but I wanted to know if Status was previously present in the non-admin import method, and was only recently removed.

unknown

Hello,

I'm having the same issue when I try to do the import via the Issues menu --> Import issues from CSV. I cannot use the External Import because I'm not a Jira admin.

Is there any particular reason for this limitation? Are there any workarounds available that don't require the intervention of a Jira admin?

Many thanks!
Best wishes!

fazal Azeem

Just follow 2 simple steps, using the administrators import from system:

1. Upload the csv without using configuration file.

2. Download the configuration file, modify it as shown below and then re-upload the data using the configuration file.

Replace the following custom field with the JIRA field:

"Status" : {

"existing.custom.field" : "19005"

},

After replacing, the field looks like this

"Status" : {
"jira.field" : "status"
},

Now upload the data and status will change to what ever your want. either Closed, Resolved or In Process, as defined in the CSV.

Robert Horan

@Dario B - thank you for this. It would be great if this were made explicitly clear in the documentation. In the absence of a clearly written statement in the documentation, like what you wrote above, I think many, including myself, have found this somewhat confusing.

With that said, I am hoping you might know of some workaround that would allow non-admins to import issues with various statuses mapped, without requiring them to go through a time-consuming series of bulk changes.

shashank_zintku

I'm also facing the same issue. Not able to see Status jira field while import CSV.

Yves Tellier

Same issue for me and I have Project Administrator right, not System Admin.

I have updated the import file as per Fazal's comment but it doesn't for me: status does still not appear in the fields I can map to

Robert Horan

This is because a Project Admin does not have the ability to perform this kind of import - only a full Jira admin can do so.

There are limits to what you can import without full Jira admin rights.

Yves Tellier

Hi Robert,

Thanks for your prompt answer: I'm currently working on a project in which I have to refresh dates based on data imported from another system: is there another solution than requesting Admin rights (which I won't likely get) to refresh dates based on external data?

Thanks

Ryan McBryde_jycakt

I don't know if this has been solved yet but I was having this same problem when importing the results of a spreadsheet exported into a csv file and then trying to import that csv file into a project in Jira cloud. For some reason it would not show that field Status under the Issue field heading. The only fields that would show up when searching for the word Status were the Epic Status and the Startup Status. I decided to test with a very simple example csv file that simply had Summary Assignee, Description, and Status as fields with only one line of input after the header line with the fields. When I did that the Status field appeared under the Issue Fields header just as expected. This indicated that the problem was not with the import mechanism but possibly with the csv file to be imported. When I re-examined the csv file I found that the first problem is that the header line had 2 columns that had the name of Status. The second problem I believe was that many of the text fields were not surrounded by quotes, " , which meant that some of them could have contained embedded commas which would throw the import off. I tested by copying the first few lines of the original csv file into a new one and removed the extra Status column and then made sure that each of the text fields were enclosed in double quotes. When I imported this new file, the mapping page showed that the Status field was found under the Issue Fields header and the status were able to be mapped and imported successfully. I am not sure if this is the cause of some of the other reported issues but it appears likely that if the Status field is not showing up on the mapping page as expected that one of the culprits could be an improperly formatted csv import file. This assumes that the user performing the import has Admin privileges and can perform the Import External Files action.

William Paikin_nw79ii

Thank you everyone. There are 2 ways to reach the External System Import. Only 1 of them works for importing Status

As an Administrator go to the settings option in the top right hand corner of your screen.

Select "System"

Then select "External System Import"

Then Select CSB.

Status WILL be an option from the drop down.

The confusion above came from "being and admin" and going through the settings as an admin. It was also confusing because both methods are called External System Imports.

Regardless, I was no able to do it. Thank you everyone from the assistance, and apologies for my confusion.

Annelotte

Is there a feature / enhancement request open somewhere to allow non-admins to import a csv with the status? Since that is a pretty basic field to import, and it was available in the server version..

Octavian Stepan

Hi, I have an issue with migrating a ticket from external source to JIRA via CVS.
The statuses were exported fine but the user that changed from a status to another is the person that migrate the ticket. This is not good. How I could make, to have in history, the real history of the ticket, to see when status was changed, date when status was changed, person who change the status?
Thank you

Balaji Sankar_ekwzbu

Hi @Annelotte

User have to check with the Project Permission Scheme, is the user is associated with "View Read-Only Workflow" as project role or user group. if user associated with this function, then the user could not able to see a Status on CSV import.

Thanks & Regards

Balaji Sankar

Vincent TEPLITXKY

Hi fazal,

Couldn't get this to work, I'd appreciate if you explained in greater detail how you did it. Thanks.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

cloud

jira-software