External import from CSV Import failed

 I am trying to import from CSV file using the External system inport and when i tried to import the issues using CSV, its failed with the below error.. which is not completely clear. can you please help. 

2017-04-24 11:00:56,262 INFO - Only new items will be imported
2017-04-24 11:00:56,309 INFO - Importing issue: [externalId='autoid-6388203444939620375', summary='ShipAddr Object needs explicit Address 1 & Address 2 fields.']
2017-04-24 11:00:56,346 ERROR - Error importing issue [externalId='autoid-6388203444939620375', summary='ShipAddr Object needs explicit Address 1 & Address 2 fields.']

1 answer

This widget could not be displayed.
Alex Christensen Community Champion Apr 24, 2017

Was this the entirety of the error log? There's usually more info about why an import would fail like this and there's not really enough here tell based on the lines you've provided.

Thanks for your reply Alex, yes.. that is the snippet of the error log and it doesnt have more details.  it thrown the same message for each entry i tried to import.

2017-04-24 11:00:56,362 INFO - Importing issue: [externalId='autoid-362771390179179179', summary='Prevent adjust/add of benefit time for SSU emp on non-TMW regstr']
2017-04-24 11:00:56,363 ERROR - Error importing issue [externalId='autoid-362771390179179179', summary='Prevent adjust/add of benefit time for SSU emp on non-TMW regstr']
2017-04-24 11:00:56,363 INFO - Importing issue: [externalId='autoid-8619563019020230762', summary='Change consultant allowed during fiscal week instead of same day']
2017-04-24 11:00:56,364 ERROR - Error importing issue [externalId='autoid-8619563019020230762', summary='Change consultant allowed during fiscal week instead of same day']
2017-04-24 11:00:56,364 INFO - Importing issue: [externalId='autoid-3682082175450797068', summary='Hide Pre-Sale shipping btn for selected stores']

Alex Christensen Community Champion Apr 24, 2017

Hmmm. It's hard to say what the issue might be, but here are a couple things I usually look for when I have errors with my imports:

  • Did you define the issue type in the CSV for each row?
  • Do the user fields have "real" users?
  • Are all of the required fields configured for that issue filled out correctly in the import file?
  • If you chose to define the project in the CSV file, is the project name and key defined correctly?

It's hard to say without seeing more information from an error log, but I hope this helps.

Hi,

Can few fields be left blank while import? 

I have the same error and I met all the above points you mentioned above.

https://confluence.atlassian.com/jirakb/external-system-import-fails-to-import-csv-file-779160696.html

https://confluence.atlassian.com/jirakb/incomplete-csv-import-when-issue-type-is-not-properly-defined-146407700.html

Followed the above links still the same error -

1 projects and 0 issues imported successfully!

Import completed with 100 errors:

  • Error importing issue [externalId='autoid-3193429464196132252', summary='Internal Pre and PRD consoles should be restricted to jumphost. But can be accessed by desktops']
  • Error importing issue [externalId='autoid-3595183157424957155', summary='corpregistry has an ejb injection in all environments']
  • Error importing issue [externalId='autoid-2241411063412407852', summary='corpregistry only needs one server running in the cluster']
  • Error importing issue [externalId='autoid-8673940725337750076', summary='client IP not being passed into logs']
  • Error importing issue [externalId='autoid-337310478029586513', summary='need splunk dashboard for PRD']

Last week I could successfully import in dev, I hardly made any changes to file, not sure why it doesn't import now.

Suggest an answer

Log in or Sign up to answer
Atlassian Summit 2018

Meet the community IRL

Atlassian Summit is an excellent opportunity for in-person support, training, and networking.

Learn more
Community showcase
Posted Wednesday in New to Jira

Are you planning to trial, or are currently trialling Jira Software? - We want to talk to you!

Hello! I'm Rayen, a product manager at Atlassian. My team and I are working hard to improve the trial experience for Jira Software Cloud. We are interested in   talking to 20 people planning t...

226 views 3 0
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