jira server csv import issue

[fpiguet]

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 ]

[Fabio Racobaldo _Herzum_]

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

[Sachin Dhamale]

@fpiguet 

Welcome to the Community

Can you add whole log file to see more logs?

Are you using any special character in the summary or any other custom field?

Thanks,
Sachin 

[fpiguet]

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 ]

[fpiguet]

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