Community Settings >> Reports >> Export Data >> IdeaScale Community Data Export
 
Export data for the ideas, stages, tags, comments etc. in your community.

Output format: Idea data can be exported in following formats - 

  • Microsoft Excel sheet (.xls) format
  • XML (RSS 2.0)

Fields on Exported Excel sheet:

Sheet 1 - Audit Log 

  • Date/Time
  • IP
  • Type 
  • Mechanism 
  • Source Name 
  • User ID
  • Source Email 
  • Via Identity Type 
  • Target Name 
  • Target Email 
  • Event Type 

Sheet 2 - Member Report 

  • Member ID
  • Email Address 
  • Name 
  • Registered Date 
  • Source 
  • Status 
  • Ideas 
  • Votes
  • Comments 
  • Member Profile Language 
  • Points 
  • What type of member are you?

Sheet 3 - Member Report Campaign
Each Campaign will have a separate tab with the below information 

  • Member ID
  • Email Address
  • Name
  • Registered 
  • Source 
  • Status 
  • Ideas
  • Votes
  • Comments 
  • Member Profile Language 

Sheet 4 - Community Events 

  • Event ID 
  • Timestamp
  • Member ID
  • Action Name
  • Action Direction 
  • Idea ID
  • Comment ID 

Sheet 5 - Comment Votes 

  • Up/Down
  • Voter ID
  • Voter Name 
  • Email Address
  • Idea ID
  • Comment ID
  • Idea
  • Comment Summary 
  • URL
  • Timestamp 

Sheet 6 - Idea Votes 

  • Up/Down
  • Voter ID
  • Voter Name 
  • Email Address
  • Idea ID
  • Idea Number
  • Idea 
  • URL
  • Timestamp
  • Voter IP

Sheet 6 - Idea Details 

  • Creation Date/Time
  • Idea ID
  • Idea Number
  • Author ID
  • Stage 
  • Author 
  • Author Email 
  • Campaign 
  • Campaign Group
  • Total Votes
  • Vote Up
  • Vote Down
  • Comments 
  • Title 
  • Details
  • Tags
  • URL
  • Attachments
  • Owner
  • Contributors 
  • Latitude 
  • Longitude 
  • Idea Event
  • Modification Date/Time
  • Any custom questions will have separate column 

Sheet 7 - Comments

  • Date 
  • Idea ID
  • Comment ID
  • Member ID
  • Idea Number 
  • Author
  • Author Email
  • Comment 
  • Attachements 

Sheet 8 - Moderator Tags

  • Idea ID
  • Idea Number
  • Idea Title 

Sheet 9 - Tags

  • Idea ID
  • Idea Number
  • Idea Title 
  • Any tags you have in community will have separate column 

Sheet 10 - Assessment Results 

  • Idea ID
  • Idea Title
  • Idea Description
  • Idea Submitter
  • Member ID
  • Stage Name
  • Idea Campaign 
  • Assessment Rating 
  • Assessment Question 
  • Assessing Member ID
  • Assessing Member 
  • Email 
  • Date  
Did this answer your question?