Community Settings >> Data Management >> Import Data >> Import Comments
This feature allows Administrators to bulk upload an MS Excel spreadsheet that includes a list of comments.
- Skip First Line (Header): Switch this option "ON" when the first line in the excel file contains headings to the data to be uploaded. When ON, the first line in the excel file is ignored and the data from second line onwards is uploaded.
- File to upload: Choose the excel file to be uploaded.Instructions for the Excel File. The file should be in the following format:
1)First Column should be Comment ID.
2)The second Column should be Comments ParentID.
3)The third Column should be Comments Author.
4)The fourth Column should consist of the AuthorEmail address.
5)The fifth Column should contain the Comment Content.
6)The sixth Column consists of Comment Submission date- The date field has to be in yyyy-MM-dd-HH-mm-ss format. While populating dates the excel automatically converts the field to date type. Please set this column to "TEXT type"field".
7)The seventh Column should consist of the Pinned value. Which represents if the comment is pinned. The possible values are [true, false].
8)The eighth Column should consist of the Private value. Which represents if the comment is a private comment. The possible values are [true, false].
9)The ninth Column should contain the Merged value.Which represents if the comment is a merged comment. The possible values are [true, false].
10)The tenth Column should contain the Stage of the comment.
11)The eleventh Column should contain the IdeaURL of the Idea that the comment is going to be part of.
PleaseNote: All of the above columns are required.