Trouble with csv import in JIRA

[Marc Vander Jeught]

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

[Marc Vander Jeught · Accepted solution]

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

[Udo Brand]

That explains it. Glad you found it.

[Udo Brand]

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\""

[Marc Vander Jeught]

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

[Udo Brand]

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

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