Trouble with csv import in JIRA

Hi

I'm trying to import issues in an existing JIRA project.

The import wizard tells me the import has been done successfully and the log shows no errors.

However I can't find the issues in the project.

Also I wonder in which project they ave been imported as there is no way ti specify the target project (excepted in the beginning of the import where you specify it)

Here is the content of the log file

2014-04-08 09:06:26,088 INFO - Import started by jira using com.atlassian.jira.plugins.importer.imports.csv.CsvDataBean
2014-04-08 09:06:26,244 INFO - ------------------------------
2014-04-08 09:06:26,244 INFO - Importing: Users
2014-04-08 09:06:26,244 INFO - ------------------------------
2014-04-08 09:06:26,244 INFO - Only new items will be imported
2014-04-08 09:06:26,244 INFO - 0 users associated with import.
2014-04-08 09:06:26,244 INFO - ------------------------------
2014-04-08 09:06:26,244 INFO - Finished Importing : Users
2014-04-08 09:06:26,244 INFO - ------------------------------
2014-04-08 09:06:26,244 INFO - 0 users successfully created.
2014-04-08 09:06:26,244 INFO - Retrieving projects...
2014-04-08 09:06:26,244 INFO - Project ExternalProject[jiraId=<null>,id=<null>,externalName=<null>,name=<null>,key=AD,url=<null>,lead=<null>,description=<null>,projectCategoryName=<null>,avatarUrl=<null>,assigneeType=<null>,versions=<null>,components=<null>,issues=<null>,workflowSchemeName=<null>] already exists. Not imported
2014-04-08 09:06:26,244 INFO - ------------------------------
2014-04-08 09:06:26,259 INFO - Importing: Versions
2014-04-08 09:06:26,259 INFO - ------------------------------
2014-04-08 09:06:26,259 INFO - Only new items will be imported
2014-04-08 09:06:26,259 INFO - ------------------------------
2014-04-08 09:06:26,259 INFO - Finished Importing : Versions
2014-04-08 09:06:26,259 INFO - ------------------------------
2014-04-08 09:06:26,259 INFO - ------------------------------
2014-04-08 09:06:26,259 INFO - Importing: Components
2014-04-08 09:06:26,259 INFO - ------------------------------
2014-04-08 09:06:26,259 INFO - Only new items will be imported
2014-04-08 09:06:26,259 INFO - ------------------------------
2014-04-08 09:06:26,259 INFO - Finished Importing : Components
2014-04-08 09:06:26,259 INFO - ------------------------------
2014-04-08 09:06:26,259 INFO - Retrieving custom fields...
2014-04-08 09:06:26,259 INFO - ------------------------------
2014-04-08 09:06:26,259 INFO - Importing: Issues
2014-04-08 09:06:26,259 INFO - ------------------------------
2014-04-08 09:06:26,259 INFO - Only new items will be imported
2014-04-08 09:06:26,259 INFO - Importing issue: ExternalIssue{externalId=autoid-2362769536863850486, summary=Securities Management & Administration, issueType=Issue}
2014-04-08 09:06:26,571 INFO - Importing issue: ExternalIssue{externalId=autoid-9237451289852017, summary=Sleeping accounts, issueType=Issue}
2014-04-08 09:06:26,634 INFO - Importing issue: ExternalIssue{externalId=autoid-1196861462325633022, summary=PMS et la Gestion Collectieve, issueType=Issue}
2014-04-08 09:06:26,696 INFO - Reindexing last 3 issues imported ...
2014-04-08 09:06:27,445 INFO - Reindexing took 749 ms.
2014-04-08 09:06:27,445 INFO - 3 issues successfully created
2014-04-08 09:06:27,445 INFO - ------------------------------
2014-04-08 09:06:27,445 INFO - Finished Importing : Issues
2014-04-08 09:06:27,445 INFO - ------------------------------
2014-04-08 09:06:27,445 INFO - ------------------------------
2014-04-08 09:06:27,445 INFO - Importing: Issue Links & Subtasks
2014-04-08 09:06:27,445 INFO - ------------------------------
2014-04-08 09:06:27,445 INFO - Only new items will be imported
2014-04-08 09:06:27,445 INFO - ------------------------------
2014-04-08 09:06:27,445 INFO - Finished Importing : Issue Links & Subtasks
2014-04-08 09:06:27,445 INFO - ------------------------------
2014-04-08 09:06:27,476 INFO - No issues need to be reindexed.
 
Any assistance would be highly appreciated.
 
Marc

2 answers

1 accepted

Hello

I found it!

The reason is that I use an Issue Security Scheme which allows only a set of users to browse the issues. For some reason the user used to import the issues is not the current user. I added a reporter field in my csv quoting the current user and now the issues are visible to me.

I wonder which user name is used to import issues...

Anyway thanks for your assistance.

Cheers

Marc

That explains it. Glad you found it.

In Step 2 of the import you are asked to select the project or if it is defined in the csv file. I wonder what you selected?

You could search for your issues, e.g.: the one with summary=Sleeping accounts

summary~"\"Sleeping accounts\""

Hello

Thanks for this quick reply

I specified the target project by using the drop down list at the beginning of the import.

As it does not seem to work properly I've just added the Project name and Key in my CSV file but it does not work either.

I searched for an issue with summary Sleeping accounts and could not find anything...

since the issues where created at 9:06 am you could search for them with

created > startofday("+544m") and created < startofday("+548m")

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 ...

2,755 views 11 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
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