Import Comments
Make a one-time import of existing comments from a third-party platform
You can import comments from another commenting platform to OpenWeb. This lets your users continue their conversations in OpenWeb's Conversation.
Import comments with a CSV import
Use the following steps to manually import comments to OpenWeb though a .csv file:
- Create a .csv file with column headers. The following table lists the required and optional columns for .csv file imports.
Column headers are required in the .csv file.
Column | Description |
---|---|
content* | Message comment |
message_id* | Unique third-party platform identifier for the comment |
post_id* | Third-party platform identifier for the associated article |
user_id* | Third-party platform identifier for the user |
user_name | Unique personal identifier used to differentiate between different users A username has the following characteristics: • Is greater than 3 characters, but less than 30 characters • Can be comprised of foreign-language characters • Cannot be comprised of delimiters, such as spaces, tabs, and other ASCII delimiters ( /t , /r , and /n )• Cannot be comprised of special characters, such as < and > • Is preceded by the @ symbol when displayedIf a username is already taken, OpenWeb appends random letters or numbers to generate a unique version of that username and registers it to the user. If a username is not provided, OpenWeb creates a username from the display_name , appends random letters or numbers to generate a unique version of that username, and registers it to the user. |
display_name | Non-unique personal identifier used prominently throughout the platform A display name has the following characteristics: • Cannot exceed 30 characters • Is comprised of a combination of letters, numbers, special characters, or spaces When not provided, the name will be Guest. |
image_url | URL of the profile image of the user This image is the avatar used for all comments created by the user. If the image_url is not set, OpenWeb selects a random avatar from the avatar scheme for the user. |
Email of the user When not provided, OpenWeb is unable to match users to their comments if there is no SSO process that matches user IDs | |
email_verified | Indicates that the email of the user has been verified Possible values: • true • false Falsely indicating that an email address has been verified violates OpenWeb’s terms of use. Once identified, OpenWeb will invalidate all users. When not set, this is set to false |
created_at | User account creation date This field should be in RFC 3339 format. When not provided, the user creation date is set to the current time . |
private_profile | Indicates whether the user's commenting history and profile can be viewed by others Possible values: • false (default)• true |
approved | Status of a comment Possible Values: • approved • blocked • pending When not set, this is set to approved . |
written_at | Comment creation date This field should be in RFC 3339 format. When not provided, the comment creation date is set to the current time. |
parent | Identifier (message_id ) of a parent commentUse this field to associate a reply with its message. When not provided, all messages will be imported as basic comments, and replies will not be connected to their parents. |
absolute_likes | Total number of comment likes When not set, this is set to 0 likes (if we have this, we will have no user data associated with the likes). |
absolute_dislikes | Total number of comment dislikes When not set, this is set to 0 dislikes (if we have this, we will have no user data associated with the likes). |
- Share the .csv file with your PSM.
Updated 2 months ago