Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,298,973
Community Members
 
Community Events
165
Community Groups

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.']

2 answers

Hi,

I have added one more column in CSV to map with Status. and i have enter the name of very first status of workflow. eg. todo because i have "todo" first status in my workflow. and then imported the test case from CSV. Doing this my all test cases imported successfully.

TCID, Summary,     step,    data,     Expected Result, Status
1,       CSV import,  test,     test,      test,                     to do

0 votes

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']

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.

HI @Divya Yathagiri Venkata ,

getting the same kind of error here too.
Did you find any solutions.


Suggest an answer

Log in or Sign up to answer
TAGS

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you