Forums

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

import issues with multiple comments

ROUSSEAU Corentin November 2, 2023

Hello, i already followed many topics but i'm unable to import issues through csv with multiple comments in a service management project.

here my csv:

summary,Assignee,Reporter,Description,comment,comment
Ticket #36236,user1@mail.com,user2@mail.com,"here's the description","01/01/2012 10:10; <iduser1>; a first comment.","01/01/2012 13:10;<iduser2;a second comment",

when i import this file, i have this message: 

"Commenter named null not found. Creating issue with currently logged in user instead"

 

whereas <iduser1> and <iduser2> are IDs extracted from an export of users from jira admin.

i tried to put their mail address because it works for the columns assignee and reporter but i also have the error above.

Can you explain me what's wrong in my csv construction please?

 

regards

1 answer

0 votes
Marc - Devoteam
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.
November 2, 2023

HI @ROUSSEAU Corentin 

If you want to import multiple comments, each need to be specified in a separate column in the csv.

Multiple comment can't be placed in one cell of the comment row.

ROUSSEAU Corentin November 2, 2023

Hi @Marc - Devoteam

Thanks for your response.

As you can see i created 2 columns "comment" and i placed each comment in these 2 differents colums.

So Jira creates to 2 comments but not with the right author neither the right date and hours, sorry maybe i didn't correctly explain my issue.

Regards

Marc - Devoteam
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.
November 2, 2023

Hi @ROUSSEAU Corentin 

It is probably an issue with the date time format.

Check you date time format in the instance.

But you probably miss the seconds option, if your date time is correct.

The comment line should look like:

"01/01/2012 13:10:00;<iduser2>;a second comment"

ROUSSEAU Corentin November 3, 2023

Hi @Marc - Devoteam 

I add the seconds so I have exactly what you writed.

But I still have the same issue: "Commenter named null not found. Creating issue with currently logged in user instead"

Can you confirm me that I can't use mail address as I use for assignee and reporter for the comments's authors?

regards.

ROUSSEAU Corentin November 3, 2023

hi @Marc - Devoteam 

I succeeded with these settings: 

Ticket #36236,user1@mail.com,user2@mail.com,"here's the description","03/11/21 10:10 AM;<iduser1>; a first comment.","03/11/21 10:12 AM;user2@mail.com;a second comment"

from config file:

"config.date.format" : "dd/MM/yy h:mm a"

 

Thanks a lot.

Like Marc - Devoteam likes this

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
PERMISSIONS LEVEL
Product Admin
TAGS
AUG Leaders

Atlassian Community Events