Can't import CSV file to JIra

Hi all,

 

As part of migration to production from staging, I want to import all issues

I followed the API here  & export all issues from staging machine. The problem is that when I upload the CSV file in the production machine , it gives the next error:

The CSV file you uploaded contains non-ASCII characters. Make sure to set the right encoding.

 Searching the web for solution came up with nothing. I tried to follows:

  1. Use Notepad & convert the content (here)
  2. Remove all ASCII using this tutorial

More than that, we also facing problem with projects. We holds 2 main projects in Jira. They share same headers/ fields. The problem is with importing & converting the fields from CSV fields to Jira fields. I can't find all the fields in Jira that appears in CSV. I need to manipulate data to solve this - meaning I map only mandatory fields (summay, project key/name/type) & fields are highly frequent in use. Doing that leaves me with lack of data or data that I need to customize with different key

If I map all fields It pop an error for issues that can't be imported. I can't find why from the log

See image below with the error:

error.png

Any idea?

10x in advance 

Aviv

 

 

 

 

1 answer

0 vote

Is there a particular reason you are trying to use the CSV import method to transfer this data?   If this is coming from another Jira instance, it might be better to use the Restoring a project from a backup method.   Granted, that process can be very complex to complete, but I think this would be a better way to get that issue data into Jira.  

There tends to be a number of things that have to happen on the instance before you can import the project itself, such as setting up custom fields and in some cases you might need to make sure the destination Jira has the same plugins/versions as the source.

Also what version of Jira is your source data in?

And what version of Jira are you trying to import this data to?

Hi @Andrew Heinzer, tnx for the input !

Both instance holds version 7.3.1 

Suggest an answer

Log in or Join to answer
Community showcase
Sarah Schuster
Posted Jan 29, 2018 in Jira

What are common themes you've seen across successful & failed Jira Software implementations?

Hey everyone! My name is Sarah Schuster, and I'm a Customer Success Manager in Atlassian specializing in Jira Software Cloud. Over the next few weeks I will be posting discussion topics (8 total) to ...

3,317 views 14 20
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
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot