Path: Community Settings >> Data Management >> Import Data >> Import Idea Owners

The administrator of the community can now easily bulk import members to be assigned as Idea owners for various ideas.

Select Campaign: Select a specific campaign from the dropdown to which the idea owners need to be imported.

File to upload: Choose the excel file to be uploaded.

Disable Notification: This option is used for disabling email notifications to the users while importing ideas owners.

Generate Template: It is always recommended to use this option for importing Idea owners. The template will provide you with the exact columns that are required in the sheet.

Instructions for the Excel File

The file has the following format:

  1. Idea Title: The template will generate all the ideas in the selected campaign in the first column.
  2. Idea Url: The template will generate all the short idea URL. We are not required to make any changes.
  3. Email Address of the person assigning owner: The email address of the member assigning the owner will be required to be added in the third column. This member should be an assigned moderator in the community.
  4. Date (YYYY-MM-DD-HH-SS): This column cannot be left blank if you do not want to update any previous dates for if you wish you will have to follow the format as mentioned in the fourth column.
    Please note: The date field has to be in MM-DD-YYYY format. While populating dates the excel automatically converts the field to date type. Please set this column to the 'text-type' field.
  5. Assignment Message(Optional): An assignment message to new Idea Owners is optional. You can leave this column blank if you do not wish to add any message.
  6. Email Address of Idea Owner 1: Add in the email address of the member you would like to assign as an Idea Owner.
  7. Email Address of Idea Owner 2: Add in the email address of the member you would like to assign as a second Idea Owner.
  8. Email Address of Idea Owner 3: Add in the email address of the member you would like to assign as a third Idea Owner.

You can increase or decrease the number of columns for the Email Address of Idea Owner you would like as per how many Idea Owners you would like to be assigned to an idea. The template has 3 columns provided for you.

Once the excel sheet has been successfully uploaded you will receive an email notification regarding the import. In case there has been some issue you will receive an email will the error occurred.

Did this answer your question?