Issue import via CSV says successful but nothing imports

[Eric Sara]

Wanting to import a number of issues in bulk to a project.

I created a simple CSV (via Excel) that has two columns, being...

Subject

Description

I enter only one test issue and import this.  It comes back and says it was successful and that 0 project imported (this is ok as I select the issue during the import process)  and 1 issue imported.

I then look at the project and no issues have been imported.

Any suggestion on what I may be doing wrong would be appreciated.

Thanks,

[Eric Sara · Accepted solution]

I got to the bottom of this.

The project that had been created had Issue Security,  As the issues I loaded did not have any security set, so they would not show.

After changing the Issue Security Scheme to none, all issues now show.

Thanks for all the help.  The suggestion to look in the JIRAISSUE table is the one that got us there in the end.

[Udo Brand]

Good to have an answer on this (not any more) mysterious behavior.

[Chandra Sateesh]

Yes Udo, Finally..

[Monika]

Thanks Eric! This worked for my project as well

[Mehdi]

Thanks Eric, this was helpful.

How can I bring back the security schema and keep imported issues visible?

[Udo Brand]

Have you tried to search for that issue, maybe it was created in another project.

created > -1h

(change the time frame according to your needs)

[Eric Sara]

Gave this a go and the issue is not in JIRA at all.

[Udo Brand]

hmm, and do you see (as Sateesh mentioned) any errors in the logs?

[Eric Sara]

Have added this to the comment below.

[Udo Brand]

So according to the logs in TESTS one issue was created. I currently can't verfiy if it is possible that I (as an admin) can import issues in a project where I have no browse project permission. But I also couldn't find a hint in the docs that I need this permission as well. So the question: Do you have browse projects permission in that project TESTS?

[Eric Sara]

I do have this permission. I am part of the jira-administration group is has been added to all project permissions in the project TESTS.

[Udo Brand]

Since the logs say the issue was created, I'm curios, do you see the issue in the database table i.e. in JIRAISSUE.

[Sateesh Chandra]

Hi Eric,

The Date format will be needed. This is for JIRA to populate the Created field in the issue.

[Eric Sara]

It defaults to dd/MM/yy h:mm a Do you see an issue with this format?

[Chandra Sateesh]

Reading the logs, No. 2015-04-03 09:31:39,460 INFO - Reindexing last 1 issues imported ... 2015-04-03 09:31:39,507 INFO - Reindexing took 47 ms. 2015-04-03 09:31:39,507 INFO - 1 issues successfully created Did you search for issues created by in the last three days in the TESTS project

[Chandra Sateesh]

I also suggest you check the recently created issues from browse project. Try with time setting as dd/MMM/yyyy and remove the rest

[Eric Sara]

Confirming that I go to Projects/Import External Project. Enter Admin Details. Then use the Import from Comma-separated values (CSV)

[Chandra Sateesh]

external system import

[Udo Brand]

Can you tell us what csv-import you are using, the one for admins (under 'external system import') or the other (issue > import issues from csv)?

[Sateesh Chandra]

I just tried the same scenario. It prompted me to add the issuetype as well. Can you try adding the issuetype column and provide a value. put the date format as well

[Eric Sara]

I also have tried with the issuetype but still no luck. With your comment of "Put the date format as well', what do you mean? Non of the fields in the file have a date.

[Chandra Sateesh]

Hi Eric, Do you remember the name of the project you imported to.

[Eric Sara]

The name of the project was TESTS

[Chandra Sateesh]

Hi Eric,

Can you post the import logs here. If not available, please try reimport again and take a look at the logs or post them here.

Regards,

Sateesh

[Eric Sara]

Did try to post this yesterday but could not as I hit a limit on posts for the one question. Log looks to be ok. It reads... 2015-04-03 09:31:39,210 INFO - Import started by SaraE using com.atlassian.jira.plugins.importer.imports.csv.CsvDataBean 2015-04-03 09:31:39,210 INFO - ------------------------------ 2015-04-03 09:31:39,210 INFO - Importing: Users 2015-04-03 09:31:39,210 INFO - ------------------------------ 2015-04-03 09:31:39,210 INFO - Only new items will be imported 2015-04-03 09:31:39,210 INFO - 0 users associated with import. 0 new users were created and imported as active. 2015-04-03 09:31:39,210 INFO - ------------------------------ 2015-04-03 09:31:39,210 INFO - Finished Importing : Users 2015-04-03 09:31:39,210 INFO - ------------------------------ 2015-04-03 09:31:39,210 INFO - 0 users successfully created. 2015-04-03 09:31:39,210 INFO - Retrieving projects... 2015-04-03 09:31:39,210 INFO - Project ExternalProject[jiraId=<null>,id=<null>,externalName=<null>,name=<null>,key=TESTS,url=<null>,lead=<null>,description=<null>,projectCategoryName=<null>,avatarUrl=<null>,assigneeType=<null>,versions=<null>,components=<null>,issues=<null>,workflowSchemeName=<null>] already exists. Not imported 2015-04-03 09:31:39,210 INFO - ------------------------------ 2015-04-03 09:31:39,210 INFO - Importing: Versions 2015-04-03 09:31:39,210 INFO - ------------------------------ 2015-04-03 09:31:39,210 INFO - Only new items will be imported 2015-04-03 09:31:39,210 INFO - ------------------------------ 2015-04-03 09:31:39,210 INFO - Finished Importing : Versions 2015-04-03 09:31:39,210 INFO - ------------------------------ 2015-04-03 09:31:39,210 INFO - ------------------------------ 2015-04-03 09:31:39,225 INFO - Importing: Components 2015-04-03 09:31:39,225 INFO - ------------------------------ 2015-04-03 09:31:39,225 INFO - Only new items will be imported 2015-04-03 09:31:39,225 INFO - ------------------------------ 2015-04-03 09:31:39,225 INFO - Finished Importing : Components 2015-04-03 09:31:39,225 INFO - ------------------------------ 2015-04-03 09:31:39,225 INFO - Retrieving custom fields... 2015-04-03 09:31:39,225 INFO - ------------------------------ 2015-04-03 09:31:39,225 INFO - Importing: Issues 2015-04-03 09:31:39,225 INFO - ------------------------------ 2015-04-03 09:31:39,225 INFO - Only new items will be imported 2015-04-03 09:31:39,225 INFO - Importing issue: ExternalIssue{externalId=autoid-5684068889858253893, summary=Summary Test 1, issueType=3} 2015-04-03 09:31:39,460 INFO - Reindexing last 1 issues imported ... 2015-04-03 09:31:39,507 INFO - Reindexing took 47 ms. 2015-04-03 09:31:39,507 INFO - 1 issues successfully created 2015-04-03 09:31:39,507 INFO - ------------------------------ 2015-04-03 09:31:39,507 INFO - Finished Importing : Issues 2015-04-03 09:31:39,507 INFO - ------------------------------ 2015-04-03 09:31:39,507 INFO - ------------------------------ 2015-04-03 09:31:39,507 INFO - Importing: Issue Links & Subtasks 2015-04-03 09:31:39,507 INFO - ------------------------------ 2015-04-03 09:31:39,507 INFO - Only new items will be imported 2015-04-03 09:31:39,507 INFO - ------------------------------ 2015-04-03 09:31:39,507 INFO - Finished Importing : Issue Links & Subtasks 2015-04-03 09:31:39,507 INFO - ------------------------------ 2015-04-03 09:31:39,772 INFO - No issues need to be reindexed.