IdeaScale Community Data Export

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