jira server csv import issue

Question

Hi all,

I currently try to import a csv file in jira server. I get the following error message after defining import parameters which for me are correct :

As far as i can see, i got no special sign in my csv file.

Does anyone have a hint or an idea of what is this error about?

Thanks in advance

2022-02-21 10:16:46,592 INFO - Importer started!
2022-02-21 10:16:46,595 INFO - Engine is running in Import mode
2022-02-21 10:16:46,598 INFO - All issues will be imported to project: Conventionnement (CONV)
2022-02-21 10:16:46,599 INFO - Creating issue: [externalId='autoid-8328964645024715281', summary='Injection initiale - adresse a identifier qualifier']
2022-02-21 10:16:46,604 INFO - Issue does not have issue type selected, the affected issues will be created with issue type [Tâche]
2022-02-21 10:16:46,608 ERROR - Issue can't be created due to the error/s [ '�' est trop grand. La valeur maximale autorisée est 100000000000000 ]

fpiguet · Answer

Hi,

I found the answer. The encoded character was the transcription of empty value which was not accpeted for a numerical field.

Thanks for your help

fpiguet · Answer

Hi,

first of all, thanks for your answer.

Also first row of my csv which does not contain special character as far as i can see :

Résumé;Descriptif;MOE;Adresse - Numéro de rue;Adresse-Complément;Adresse - Type voie;Adresse - Nom de voie;Code INSEE;Code Postal;Commune;AD_NB LR HAB;AD_NB LR PRO;Total LR
Injection initiale - adresse a identifier qualifier;LI+LC;SPIE;9;-;RUE;DES MILLE SOUPES; ;78126;AULNAY SUR MAULDRE;0;0;6

Import by csv globally worked fine few time ago whith same data but stopped working.

Creating issues manually with "Create"  works fine but i still have more than 500 issues to create, so i wished to use the csv import again.

Below the whole log file

Thanks for your help

2022-02-21 10:43:14,678 INFO - Importer started!
2022-02-21 10:43:14,679 INFO - Engine is running in Validation-only mode
2022-02-21 10:43:14,683 INFO - All issues will be imported to project: Conventionnement (CONV)
2022-02-21 10:43:14,683 INFO - Creating issue: [externalId='autoid-6394048545166282834', summary='Injection initiale - adresse a identifier qualifier']
2022-02-21 10:43:14,689 INFO - Issue does not have issue type selected, the affected issues will be created with issue type [Tâche]
2022-02-21 10:43:14,698 ERROR - Issue can't be created due to the error/s [ '�' est trop grand. La valeur maximale autorisée est 100000000000000 ]
2022-02-21 10:43:14,698 INFO - Creating issue: [externalId='autoid-8927976726953471897', summary='Injection initiale - adresse a identifier qualifier']
2022-02-21 10:43:14,704 INFO - Issue does not have issue type selected, the affected issues will be created with issue type [Tâche]
2022-02-21 10:43:14,710 ERROR - Issue can't be created due to the error/s [ '�' est trop grand. La valeur maximale autorisée est 100000000000000 ]
2022-02-21 10:43:14,719 INFO - Creating issue: [externalId='autoid-9178246076903095062', summary='Injection initiale - adresse a identifier qualifier']
2022-02-21 10:43:14,727 INFO - Issue does not have issue type selected, the affected issues will be created with issue type [Tâche]
2022-02-21 10:43:14,734 ERROR - Issue can't be created due to the error/s [ '�' est trop grand. La valeur maximale autorisée est 100000000000000 ]
2022-02-21 10:43:14,734 INFO - Creating issue: [externalId='autoid-6406701964072665783', summary='Injection initiale - adresse a identifier qualifier']
2022-02-21 10:43:14,742 INFO - Issue does not have issue type selected, the affected issues will be created with issue type [Tâche]
2022-02-21 10:43:14,749 ERROR - Issue can't be created due to the error/s [ '�' est trop grand. La valeur maximale autorisée est 100000000000000 ]
2022-02-21 10:43:14,757 INFO - Creating issue: [externalId='autoid-4979322733968967085', summary='Injection initiale - adresse a identifier qualifier']
2022-02-21 10:43:14,765 INFO - Issue does not have issue type selected, the affected issues will be created with issue type [Tâche]
2022-02-21 10:43:14,775 ERROR - Issue can't be created due to the error/s [ '�' est trop grand. La valeur maximale autorisée est 100000000000000 ]
2022-02-21 10:43:14,775 INFO - Creating issue: [externalId='autoid-8189750107570848049', summary='Injection initiale - adresse a identifier qualifier']
2022-02-21 10:43:14,780 INFO - Issue does not have issue type selected, the affected issues will be created with issue type [Tâche]
2022-02-21 10:43:14,785 ERROR - Issue can't be created due to the error/s [ '�' est trop grand. La valeur maximale autorisée est 100000000000000 ]
2022-02-21 10:43:14,785 INFO - Creating issue: [externalId='autoid-5207123810041203883', summary='Injection initiale - adresse a identifier qualifier']
2022-02-21 10:43:14,791 INFO - Issue does not have issue type selected, the affected issues will be created with issue type [Tâche]
2022-02-21 10:43:14,796 ERROR - Issue can't be created due to the error/s [ '�' est trop grand. La valeur maximale autorisée est 100000000000000 ]
2022-02-21 10:43:14,796 INFO - Creating issue: [externalId='autoid-8323605465683487052', summary='Injection initiale - adresse a identifier qualifier']
2022-02-21 10:43:14,801 INFO - Issue does not have issue type selected, the affected issues will be created with issue type [Tâche]
2022-02-21 10:43:14,805 ERROR - Issue can't be created due to the error/s [ '�' est trop grand. La valeur maximale autorisée est 100000000000000 ]

Fabio Racobaldo _Catworkx_ · Answer

Hi @fpiguet ,

welcome to the Atlassian community!

Please, verify that encoding for your csv is Unicode(UTF-8). It seems that there's some problem with encoding

'�'

Please could you check field/custom field associated to that value?

Please, let me know.

Fabio