External import from CSV Import failed

[Rajesh Gajula]

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

[Harsha Shelar]

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

[Alex Christensen]

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]

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]

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]

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]

HI @Divya Yathagiri Venkata ,

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

[Wasim Ansari]

Hi,

Did anyone solve this error?

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

[Toomas Adson]

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.