Issue import via CSV says successful but nothing imports

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,

 

8 answers

1 accepted

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.

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

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)

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

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

Have added this to the comment below.

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?

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.

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

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

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.

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

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.

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

The name of the project was TESTS

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)?

external system import

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

Hi Eric,

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

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

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

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

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,176 views 13 19
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