CSV Import Questions (from Unfuddle)

I'm preparing a csv file with the source information from unfuddle. Initially, the work items are all bugs. I'm hitting some issues in the import and hope that you can help. The challenges are that:

  • several issues are being refused because the system tells me that it is unable to assign issues to a user (the user is in the system) The error message is
2014-09-24 14:39:51,419 ERROR - Issue can't be created due to the error/s [ User 'xxx' cannot be assigned issues. ]
  • I'm not clear on how to import the defect creation dates? There doesn't appear to be a field to which those may be mapped.
  • Do all components need to be pre-established to import those values (I'm assuming that to be the case)

If there are some guidelines as to how to prepare/sequence the import, that would be great!

 

3 answers

The most useful documentation will be shown at the bottom of the failed import screen, so be sure to read the guidance you're given there.  Unfortunately, the CSV import documentation isn't as complete as it probably should be.  We do a lot of migrations for our clients, and they can be quite a challenge.

Regarding your questions, here are some things to look into:

  1. Check the destination JIRA project to make sure that the user indicated has "Create" and "Assignable User" permissions.  Depending on how you have your permission scheme(s) set up, there are a variety of ways to do this.
  2. There is an "Issue Created" field you can populate, but you need to make sure that all dates are in the same format.  You can change the format in one of the early steps in the wizard.  You'll also see notes at the bottom of the import screens.
  3. Yes, you will need to create your components and select list field values first, then map your CSV values to the values in those fields.

I hope that helps.

Dave,

Thanks for the pointers. Your guidance on the assignee field worked.

The mappings I'm receiving don't seem to have any accounting for an "Issue Created" field. I'm trying to pull these into a JIRA Agile/Kanban project. Is it possible that I need to modify something in the project to allow for that field to be imported?

Mike

I didn't have a CSV handy to do a mock import, so I got the exact field mapping name wrong.  It's called "Date Created."  It's not a field in the sense where it would show up in Custom Fields.  It's a system field that is set when an issue is opened.  It is something you can map in the CSV import wizard, though, as long as you have a column with the create dates in it.

Suggest an answer

Log in or Sign up to answer
Atlassian Community Anniversary

Happy Anniversary, Atlassian Community!

This community is celebrating its one-year anniversary and Atlassian co-founder Mike Cannon-Brookes has all the feels.

Read more
Community showcase
Julia Dillon
Posted Tuesday in Jira

Tell us how your team runs on Jira!

Hey Atlassian Community! Today we are launching a bunch of customer stories about the amazing work teams, like Dropbox and Twilio, are doing with Jira. You can check out the stories here. The thi...

200 views 1 18
Join discussion

Atlassian User Groups

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

Find a group

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

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you