Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Error in CSV import

arlei July 15, 2020

I'm trying to import a file with only one field (summary), but I got the follow error:

Importing: Issues
2020-07-15 13:36:30,003 INFO - ------------------------------
2020-07-15 13:36:30,003 INFO - Only new items will be imported
2020-07-15 13:36:30,017 INFO - Importing issue: [externalId='autoid--4296138607272068671', summary='Test issue']
2020-07-15 13:36:30,158 INFO - Created IssueType : 1 with id 10077
2020-07-15 13:36:30,214 INFO - ------------------------------
2020-07-15 13:36:30,214 INFO - Finished Importing : Issues
2020-07-15 13:36:30,214 INFO - ------------------------------
2020-07-15 13:36:30,215 ERROR - Unexpected failure occurred. Importer will stop immediately. Data may be in an unstable state: 

 I tryed to find the issue inside the Jira protect, but the informations that I've imported, I cant find it.

Im trying to import with a next-gen project service desk.

Help me please

1 answer

0 votes
Trevan Householder_Isos-Tech-Consulting_
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
July 15, 2020

@arlei Assuming you are trying to import a number of issues, the import file should follow this pattern:

Import.png

arlei July 15, 2020

Hi, I tryed to import with the follow pattern:

Summary,Issue Key
Resumo 1,1
Resumo 2,2

But, it happened the same error: (the interesting thing is, I didnt receive the true error)

2020-07-15 17:45:57,657 INFO - Retrieving custom fields...
2020-07-15 17:45:57,666 INFO - ------------------------------
2020-07-15 17:45:57,666 INFO - Importing: Issues
2020-07-15 17:45:57,666 INFO - ------------------------------
2020-07-15 17:45:57,666 INFO - Only new items will be imported
2020-07-15 17:45:57,748 INFO - Importing issue: [externalId='autoid--2514067094176602053', summary='Resumo 1']
2020-07-15 17:45:57,794 INFO - ------------------------------
2020-07-15 17:45:57,794 INFO - Finished Importing : Issues
2020-07-15 17:45:57,794 INFO - ------------------------------
2020-07-15 17:45:57,794 ERROR - Unexpected failure occurred. Importer will stop immediately. Data may be in an unstable state: 

 I choose the next gen project.

Trevan Householder_Isos-Tech-Consulting_
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
July 15, 2020

The Issue Key is not in the correct format.  An issue key has the project key at the beginning, followed by a hyphen and then the incremental number of that issue.

Please refer to the example I posted, above.

arlei July 15, 2020

Hi, my next gen project has a SUP key issue. Then I put in my CSV file, the follow issue key. SUP-48 and SUP-49, such as the next picture. I put the others steps util the same error. 

Can you check the pictures? I dont know what I've made wrong.error.jpg20200715_152930.jpg20200715_152913.jpg20200715_152937.jpg

Trevan Householder_Isos-Tech-Consulting_
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
July 15, 2020

I wonder if the language translation is getting in the way.  Does Jira call your Summary field "Resumo"?  If so, you may need to change Summary to Resumo in your import file.  Same with Issue Key.

arlei July 15, 2020

I tryed it, and I received the same error. Is it possible to create a next gen project in a service desk project? 

20200715_180339.jpg20200715_180326.jpg

arlei July 16, 2020

Do you have some ideia about it?

Trevan Householder_Isos-Tech-Consulting_
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
July 16, 2020

@arlei , I have been able to successfully import the contents of your file (using all English words) into both Next Gen and Classic projects without a problem.

FieldMapping.pngSampleImportFile.pngSuccess-ClassicJSD.pngSuccessNextGen.png

I'd recommend you contact support for assistance at this point.

https://support.atlassian.com/contact/#/

 

Good luck!

arlei July 16, 2020

Thanks man, Im gonna contact the support. Thanks again.

arlei July 16, 2020

One more question. Did you use Service Desk Project (next gen)? I tryed to import in another type of project, and it worked for me. But Service desk next, I have always the same error.

Trevan Householder_Isos-Tech-Consulting_
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
July 16, 2020

I successfully imported into both classic and next gen projects.

Check your permissions in the project where it failed, to make sure you have permission to create issues there.

arlei July 16, 2020

Yes, I have total permissions. I tryed to import in a development project, and the data were imported fine. But a service desk project, I've get always the same error. :(

I already contact the Atlassian support, and now a I need to wait for the answer.

Tks man, you are a great guy

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
FREE
TAGS
AUG Leaders

Atlassian Community Events