Unable to Import Comment Author and Entry Date and Time when Importing CSV File by PvcsComment

Still need help?

The Atlassian Community is here for you.

Ask the community

Symptoms

When following Extra CSV Importing Guide to import CSV file via PvcsComment, the author and entry datetime of comments can't be imported correctly even when CSV configuration file is set appropriately.

Causes

  • If all comment author & entry datetime can't be imported, it's probable that the parsed comment body doesn't match the required format: "Type of Comment: Username : Entry Datetime: Comment Content".
  • If some of comment authors can't be correctly imported, it's because those authors do not exist in JIRA user list.
  • If some of comment entry datetimes can't be correctly imported, it's because those entry datetimes don't match the required format - "MM/dd/yy hh:mm:ss a".

Resolution

  1. If all comment author & entry datetime can't be imported, check to make sure the parsed comments are formatted as "Type of Comment: Username : Entry Datetime: Comment Content", for example:

    Tester Notes: MarkChai: 02/27/05 10:36:14 AM: Sufficiently tested attempting demos. 
    
  2. If some of comment authors can't be correctly imported, check to make sure those failed imports are the existing JIRA users. If not, create them in JIRA before performing the import. Alternatively, if the comment author is the same as the imported issue's reporter or assignee, turn on "Create New Users" in the importing wizard.
  3. If some of comment entry datetimes can't be correctly imported, double check to make sure those "failed" entry datetimes are formatted as "MM/dd/yy hh:mm:ss a"(since this format is hardcoded in program, it's no exception), for example

    02/27/05 10:36:14 AM
    
    tip/resting Created with Sketch.

    For full customisation, you can modify the class com.atlassian.jira.imports.csv.mappers.PvcsComment by using the instructions from How to Make a JIRA Patch. Note that development queries are not supported.

Last modified on Feb 26, 2016

Was this helpful?

Yes
No
Provide feedback about this article
Powered by Confluence and Scroll Viewport.