CSV Import Results in Issues Not Existing Edited

After importing and validating the input from our CSV file, the resulting tasks don't appear to exist. We consulted the output and nothing stands out as an error. 

We're using the user-facing CSV importer, and we're running this while on an admin account. 

The output is as follows:

2017-08-03 11:32:01,390 INFO - Importer started!
2017-08-03 11:32:01,390 INFO - Engine is running in Import mode
2017-08-03 11:32:01,405 INFO - All issues will be imported to project: *********************** (KMT)
2017-08-03 11:32:01,405 INFO - Creating issue: [externalId='autoid-*********************', summary='*********************']
2017-08-03 11:32:01,483 INFO - Issue does not have issue type selected, the affected issues will be created with default issue type [Task]
2017-08-03 11:32:01,671 INFO - Issue created successfully with Key [KMT-712], [externalId='autoid-*********************', summary='*********************']
2017-08-03 11:32:01,671 INFO - Creating issue: [externalId='autoid-*********************', summary='*********************']
2017-08-03 11:32:01,671 INFO - Issue does not have issue type selected, the affected issues will be created with default issue type [Task]
2017-08-03 11:32:01,858 INFO - Issue created successfully with Key [KMT-713], [externalId='autoid-*********************', summary='*********************']
2017-08-03 11:32:01,858 INFO - Creating issue: [externalId='autoid-*********************', summary='*********************']
2017-08-03 11:32:01,858 INFO - Issue does not have issue type selected, the affected issues will be created with default issue type [Task]
2017-08-03 11:32:02,062 INFO - Issue created successfully with Key [KMT-714], [externalId='autoid-*********************', summary='*********************']
2017-08-03 11:32:02,062 INFO - Creating issue: [externalId='autoid-*********************', summary='*********************']
2017-08-03 11:32:02,062 INFO - Issue does not have issue type selected, the affected issues will be created with default issue type [Task]
2017-08-03 11:32:02,218 INFO - Issue created successfully with Key [KMT-715], [externalId='autoid-*********************', summary='*********************']
2017-08-03 11:32:02,218 INFO - Creating issue: [externalId='autoid-*********************', summary='*********************']
2017-08-03 11:32:02,233 INFO - Issue does not have issue type selected, the affected issues will be created with default issue type [Task]
2017-08-03 11:32:02,515 INFO - Issue created successfully with Key [KMT-716], [externalId='autoid-*********************', summary='*********************']

I've had to censor out the project specific information, but I don't believe any of it was relevant to the issue at hand. 

Is there a flag or something we need to set to make them accessible?

Thanks!

 

2 answers

1 accepted

Commenting again so I can close out the question.

As it turns out, our default security level was set incorrectly, and all of our imported tasks were being assigned a higher security level than any of our developers were assigned. We've reworked our security levels and the issue has been resolved. 

1 votes
Josh Steckler Community Champion Aug 03, 2017

Assuming you can get into the project and see other issues there. Barring possible permissions issues, can you go to your database and see if the issues exist there?

select jiraissue.* from jiraissue left join project on jiraissue.project = project.ID where project.pkey = "KMT" and jiraissue.issuenum >= 712 order by jiraissue.issuenum;

Thank you for your response, Josh. We have found and fixed the issue.

As it turns out, our default security level was set incorrectly, and all of our imported tasks were being assigned a higher security level than any of our developers were assigned. We've reworked our security levels and the issue has been resolved. 

Thanks again!

Suggest an answer

Log in or Join to answer
Community showcase
Teodora [Botron]
Published Thursday in Marketplace Apps

Jira Inferno: The Nine Circles of Jira Administration Hell

If you spend enough time as a Jira admin - whether you are managing a single, mid-sized instance, a large enterprise one or juggling multiple instances at once - you will eventually find yourself in ...

595 views 2 15
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
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