Path: Community Settings >> Data Management >> Import Data >> Import Votes
This feature allows Bulk upload of both idea and comment vote data from an Excel file that includes a listing of votes.
Skip First Line ( Header ): Set the switch to 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: Browse the excel file on your computer which needs to be uploaded or simply drag and drop it in the area.
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.
3. Disable Notifications: This option is used for disabling email notifications to the users during the time of importing votes.
Format for the Excel file
NOTE :- To get the Idea and Comment URLs , Export the idea and comment data .
The file should be in the following format:
The data to be uploaded should be in the first tab (Work sheet) in the Excel file.
First Column should be the URL for the Idea or the comment
Second Column should be the email address of a member of the community.
Third Column should contain vote which would be either 1 or -1.
1 = Up Vote (I agree)
-1 = Down Vote (I disagree)