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

This widget could not be displayed.

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.

This widget could not be displayed.

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 Sign up to answer
Community showcase
Posted Tuesday in Jira

What modern development practices are at the heart of how your team delivers software?

Hey Community mates! Claire here from the Software Product Marketing team. We all know software development changes rapidly, and it's often tough to keep up. But from our research, we've found the h...

120 views 1 3
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