Why do Comments get Repeated on CSV Imports

[Nic Cusack]

We are using CSV Exports and Imports to manage shared databases between two locations. What I have found is that if a bug is exported numerous times using CSV (all Fields) then comments previously captured in the export/import process are repeated on the next export/import cycle and so the issue has a growing number of comments on the imported issue saying the same thing. Is there a way to stop this happening?

[KAGITHALA BABU ANVESH · Accepted solution]

Hi @Nic Cusack

it’s not possible to merge all comments in one column in jira when you need to export from Jira.

actually comments have time stamps, when the comment is created by any user. If different comments posted individually, for every comment you will get a new column in csv.

for import,

if you want, you can merger all the columns into single comments column with Date and user details and try to import. When you do this all existing comments from the CSV treated as single comment in Jira. 

thanks,

 Kagithala Babu Anvesh

[Nic Cusack]

I think you mis-understood my question. I understand that in the csv the comments appear in separate columns, this is not the issue. 

When I import the issue the first time the comment is imported. if at a a later date I import the issue because of a change the original comment is imported again with the same name and date as the original but as though it was a new comment. Like this:

Comment by ERICNAME [ 14/Nov/18 ]
Assign to NMPS.
Comment by ERICNAME [ 14/Nov/18 ]
Assign to NMPS.

[KAGITHALA BABU ANVESH]

Sorry for the trouble. I got you.

for ABC-1 , it has a comment as “Anvesh working on it”. You imported this issue into jira by using CSV. All went well. 

now the comment is modified by adding/deleting some text. And you exported.

Your requirement is to “Replace existing comment” when you upload the modified CSV.

As of my knowledge it’s not possible, whenever we importing some data with .csv , jira treat it as a new comment, if you mentioned jira existing key also.

Thanks,

kagithala Babu Anvesh

[Nic Cusack]

No problem,

I appreciate the help.

Just to be clear. The comment has not been modified between export/import cycles. It is the same comment.

[KAGITHALA BABU ANVESH]

Whenever a new row is being updated with csv , jira will treat as a new. It doesn’t not append or replace the existing comment.