Path: Community Settings >> Data Management >> Import Data >> Import Ideas

Generation of Template and its Details
Importing Ideas for Single Campaign
Process of Importing Ideas & Attachments
Data Migration

Administrator of the community can import ideas as well as attachments at the same time to save time. Below is the step by step guide on how to do this.

GENERATION OF TEMPLATE AND ITS DETAILS

1 . To import ideas with attachment enable the switch 'Upload Attachments'.

2. Select the campaign where you wish to upload ideas from the drop down of 'Select Campaign' or you can choose to upload ideas to all the campaigns at a time, in which case you can select 'All Campaigns' in the dropdown.

3 . Generate Template button - The Generate Template option provides a readymade spreadsheet with all the required column headers. The administrator has to simply enter the data to be uploaded .

Please Note: In case there is a malicious content, virus or malware during the upload it will show an error and the upload will fail.


Below is the screenshot of the template generated for uploading ideas to "All campaigns" . It has 5 sheets :- Ideas, Stage IDs, Custom Fields, IdeaScale- Attachments and Moderator Tags.

Lets discuss about these in details.

A. Ideas Sheet

Ideas sheet has to filled in with all the idea details. The details are as follows:

  1. Title ( Mandatory ) -  This is subject of the Idea.
  2. Description ( Mandatory)  - In this column you have to idea description.
  3. Tags (Optional) - Make sure all the tags (if any) are comma separated.
  4. Idea Submitter Email (Mandatory) - If you are planning to upload ideas on behalf of users, then you will have to populate the "Idea Submitter Email" column. If not then this column should contain the Community Owners / Admins email address. NOTE: This column cannot be left blank. The sheet won't upload if this column is left blank.
  5. Idea Submission date (Optional)- This column can be left blank if you do not want to upload the pre-dated ideas. When left blank, the ideas will be shown as submitted on the date on which you upload them. 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 "text type" field.
  6. Stage ID ( Optional) - The second sheet in the template file has all the Stage IDs mentioned. Enter the ID of the stage to which the ideas has to be uploaded. You can upload ideas to various stages in one go. The Stage ID field can also be left blank. When left blank, the ideas will be uploaded in the first stage of the funnel.
  7. Idea Number ( Optional) - Its an optional column . But if you specify the Idea Number, then the sheet has to be sorted in the Ascending Order of the Idea Number. NOTE: The idea numbers have to be unique i.e. they cannot be the ones which are already given to any existing ideas in your community.
  8. Anonymous ( Optional)  - If the campaign allows "private" submissions that will only be viewable to admins and moderators, You can choose to submit idea anonymously. If the idea is anonymous enter the text 'True' and if it is not, then select 'False'.   Leave the column blank if there are no private submissions.
  9. Idea ID (Optional)  - Idea ID can be any unique number. NOTE: Add this column only if you are uploading attachments. 
  10. Campaign name - You will see the 'Campaign Name' column only if you have selected 'All Campaigns' under 'Select campaign' option.
  11. Custom field values are specified after this column. . The values are specified in the order in which the custom fields appear in the 'Custom Fields' sheet . This order is changeable in the custom field sheet but once the order is specified then the idea custom fields have to be filled in the same order.  If you select specific campaign, the custom field column will automatically appear in the template.

NOTE:- HTML tags/entities in the text of Idea title, description, custom fields is not supported for eg:- greater than , smaller than  signs , bullets , smartquotes ( curly quotation marks) , & , © copyright  ® registered trademark etc. . Ideas or any related fields, containing these characters would not be uploaded.

B. Stage IDs Sheet

This sheet contains the list of all the stage ids in the community. 

When the template is generated , this sheet is automatically populated . It is a reference sheet from which Stage id's are added

Note: This sheet should not be edited .

C. Custom Fields Sheet

This sheet is included only in the template generated for uploading ideas to 'All campaigns'. Below is the screenshot of Custom field sheet which is a Reference sheet:

For Eg. for the campaign Website : the custom fields are 'Country' and 'Department'.  The values 'Canada' and 'HR' are therefore specified in that order in the ideas sheet.

Campaign Product has the custom fields 'Ïs this new Product?' and 'Who would be the target users?'. The values for the idea custom field  are specified as 'Yes' and 'Children'.

The order  of the custom fields can be changed in the custom field sheet  eg,  - you may choose to have values for Custom field "Department" first and then "Country". Interchange the the columns accordingly in the custom field sheet . Now In the idea sheet, make sure you specify 'HR' (value for custom field 'Department') in the first column followed by 'Country' ( ie 'Canada').

D. Ideascale - Attachments Sheet 

Idea Id specified in the 'Idea Sheet' indicates the idea to which the attachment would be uploaded.

1 . Idea ID - If an idea has multiple attachments , the idea ID will remain the same (for eg, Idea Id 924854 underline in red). 2 attachments will be uploaded to idea id 924854.  

2. Author Email - Email address of the user on whose behalf we are uploading the attachment.

3. File Name - Should contain the file names of attachments which are included in the .zip file.

4. Note - Add notes to the image for your reference.

5. Size -  Specify the attached file size in bytes.  The attached file size should fall within the limits of the 'Maximum upload size' allowed for your community.
Note
- When uploading an attachment the users have the option to also add a note to the attachment. This column can be left blank if the user does not want to add a note.

5. Date - Specify the date of upload in the format YYYY-MM-DD-HH-MM-SS. The attachment date could be same as the idea date but not earlier than the idea date

NOTE: Create a .zip file of all the files which are to be uploaded as attachments.

E. Moderator Tags Sheet

Moderator Tags sheet has the below mentioned columns

  1. Idea ID - Its the idea Id of the idea to which the moderator tags would be uploaded
  2. Tag - The tags words which would be assigned as moderator tag. If the community has predefined moderator tags , then the tag column should have exactly those tag words . It's best to copy the tag from the community's moderator predefined tags list.
  3. Tag submitter Email - Its mostly the email address of the moderators , but if users from certain group are permitted to tag ideas with moderator tags , then this column can include the email addresses of the users belonging to that group.

NOTE :-  Ensure that the email Tags submitter email address is either a global  moderator/campaign moderator /Custom field moderator/group moderator of the idea to which the tags is submitted to .

For eg:- uploading moderator tag on behalf of [email protected] would be possible only if he is a global  moderator/campaign moderator /Custom field moderator/group moderator for Idea with idea ID 924853 - He should have the moderation right over the idea tagged with the moderator tag.

A campaign moderator will be able to submit moderator tags only for the Campaigns to which he is assigned as a moderator . In other campaigns he is a regular user so he will not be able to use the moderator tag.

__________________________________________________________________

IMPORTING IDEAS FOR SINGLE CAMPAIGN

Importing Ideas with Attachments for individual campaign is essentially the same as uploading ideas to all campaigns. 

The template generated for uploading ideas to an individual campaign has 3 sheets . It does not include the Sheet for Custom fields since custom fields values are filled in the ideas sheet itself.  

https://support.ideascale.com/en/articles/2035176-importing-ideas-for-single-campaign

__________________________________________________________________

PROCESS OF IMPORTING IDEAS AND ATTACHMENTS

Once the spreadsheets are ready for the upload go to Community Settings >> Data Management >> Import Data >> Import Idea and browse the file from your computer or simply drag and drop it in the area.
Before starting the upload make sure of following: 

  1. Enable the setting 'Skip First Line ( Header)'. 
  2. Select the campaign to which the ideas are to be uploaded
  3. Under 'File to upload' select the spreadsheet of ideas to be uploaded. 
  4. Under 'Attachment file to upload' select the zip file with the attachments
  5. Click on Upload

__________________________________________________________________

Data Migration

When ideas from one have community have to be copied to another community.
Export the Ideas from the original community from Community Settings >> Reports >> Export Data >> Export Idea Data.

1 .Output Format - Select output format from the dropdown.

2. Export Ideas attachments - This will return a zip file with all the attachments (if any) on ideas in the community.

3. Start and the End Date -  Specify a start and end date to export data for a limited period. In case you want to export all data, leave it blank.

4. Select your timezone - You may retain the default timezone or select a suitable time zone.

5. Campaign - Choose to export data for a single campaign or for all the campaigns.

6. Include GeoLocation - Enable this switch to include the Geo Location details in the export. 

Once you export, it will return two files - Excel file and Zip file. The excel file will contain all idea details. The last sheet in this excel file will be a new sheet named “Ideascale - Attachments” which contains the data related to attachments. Zip file will include all the attachments if there are any.

As mentioned earlier, a ready made spreadsheet can be generated and the exported idea data can be used to populate the spreadsheet to be uploaded.

The zip file returned here while exporting ideas is selected as  'Attachment file to upload' while importing the ideas. 

Note: It's optional to upload the attachments.

Did this answer your question?