External import from CSV Import failed

Rajesh Gajula April 24, 2017

 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

1 vote
Harsha Shelar November 27, 2018

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

Nik C November 9, 2023

This does not work

0 votes
Alex Christensen
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
April 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.

Rajesh Gajula April 24, 2017

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 Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
April 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.

Divya Yathagiri Venkata May 23, 2018

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.

Anvesh Kagithala June 16, 2022

HI @Divya Yathagiri Venkata ,

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


Wasim Ansari August 1, 2023

Hi,

Did anyone solve this error?

I'm facing a similar kind of issue...
image.png

Toomas Adson September 19, 2023

I did encountered same error.


Actually, the reason is simple. I tried to input the values, that didnt existed in system fields. 
In my case - I did tried to enter the wrong status, that was not associated in the project workflow. 

When importing new tasks through CSV, make sure that besides SUMMARY field you have following fields correct values in the file:

- Status

- Priority

- Issue Type

 

If you try to generate new tasks and dont have these field or have non-existent value in CSV file, you will encounter the error. 

Suggest an answer

Log in or Sign up to answer