It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

CSV import comments, author, date

julian bankston Sep 07, 2012

Is there a way to associate the comment author and date to the comment body using the CSV importer? If not is there a more efficient way to do this? Thanks.

2 answers

1 accepted

2 votes
Answer accepted

Sure, there is please use following syntax for the comment columns: "01/01/2012 10:10;Admin; This comment works".

Remember that the data format must math the one set during the wizard.

Sufian Rashid Nov 07, 2017 • edited

I have prepared the CSV as mentioned above; however i am stuck at mapping. There is no 'comment' column in dropdown to map to (as shown in screenshot below).

So where do I import the comments?JIRA CSV Comment Import.png

Kelly Albrecht Nov 22, 2017

@Sufian Rashid, I'm having the same issue, did you find a solution?

Sufian Rashid Nov 23, 2017

Hi @Kelly Albrecht

Yes i found the solution. Actually there are two imports.

One is 'Bulk Create CSV Import' and other is 'External CSV Import'

When i used the external import; i found all the missing fields there.

Please see below screenshots for more details.

Step 1:

step1.png

 

Step 2:

step2.png

 

Step 3:step3.png

Like # people like this
Kelly Albrecht Nov 23, 2017

@Sufian Rashid! Thank you so much!!

Andrei Bragarenco Dec 30, 2018 • edited Jan 02, 2019

Thanks

0 votes
kvn_ln Mar 27, 2018

Hi everyone,

Is there a way to set in the CSV if the comment is private or public ?

In case of Service Desk import for example.

Best regards,

kvn_ln

Frédéric Camblor Jun 24, 2018

+1 Would really appreciate a way to import comment visibility

Like # people like this
Jonathan Zschau Feb 08, 2019

I do not have an answer to this, but this relates to an ongoing thread I posted a while back. If they were to ever add this functionality, being able to control comment visibility at the bulk import level would also be nice... 

https://community.atlassian.com/t5/Jira-questions/JIRA-Service-Desk-Email-Handler-amp-Comments/qaq-p/922673

Suggest an answer

Log in or Sign up to answer
This widget could not be displayed.
This widget could not be displayed.
Community showcase
Published in Jira

Try Jira Cloud for Outlook: Organize your work without leaving your inbox

Hi Atlassian community, My name is Max and I work on the product integration team at Atlassian. I am pleased to announce the early access program for the Jira Cloud add-in for Outlook. This add-in...

2,080 views 6 15
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you