Issue import via CSV says successful but nothing imports

Eric Sara
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
April 1, 2015

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

3 votes
Answer accepted
Eric Sara
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
April 8, 2015

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
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
April 8, 2015

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

Sateesh Chandra April 8, 2015

Yes Udo, Finally..

Monika April 11, 2019

Thanks Eric! This worked for my project as well

Mehdi June 24, 2020

Thanks Eric, this was helpful.

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

1 vote
Udo Brand
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
April 1, 2015

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
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
April 2, 2015

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

Udo Brand
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
April 2, 2015

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

Eric Sara
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
April 3, 2015

Have added this to the comment below.

Udo Brand
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
April 3, 2015

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
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
April 6, 2015

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
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
April 7, 2015

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

0 votes
Sateesh Chandra April 6, 2015

Hi Eric,

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

Eric Sara
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
April 6, 2015

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

Sateesh Chandra April 7, 2015

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

Sateesh Chandra April 7, 2015

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

0 votes
Eric Sara
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
April 2, 2015

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

0 votes
Sateesh Chandra April 1, 2015

external system import

0 votes
Udo Brand
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
April 1, 2015

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

0 votes
Sateesh Chandra April 1, 2015

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
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
April 3, 2015

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.

Sateesh Chandra April 5, 2015

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

Eric Sara
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
April 6, 2015

The name of the project was TESTS

0 votes
Sateesh Chandra April 1, 2015

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
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
April 3, 2015

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.

Suggest an answer

Log in or Sign up to answer