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.
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 5 days ago