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 Sign up to answer
How to earn badges on the Atlassian Community

How to earn badges on the Atlassian Community

Badges are a great way to show off community activity, whether you’re a newbie or a Champion.

Learn more
Community showcase
Published Thursday in Jira

5 ways you can make the most of Jira Software and Bitbucket Cloud

As part of the Bitbucket product team I'm always interested in better understanding what kind of impact the use of our tools have on the way you work. In a recent study we conducted of software devel...

64 views 0 5
Read article

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