Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Celebration

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root

Avatar

1 badge earned

Collect

Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!

Challenges
Coins

Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.

Recognition
Ribbon

Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!

Leaderboard

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

HI @Divya Yathagiri Venkata ,

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


Hi,

Did anyone solve this error?

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

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
TAGS
AUG Leaders

Atlassian Community Events