To look at and analyse your Dialogue response data, or if you need to close your Dialogue site, you may need to extract all or some of the data from it. Here's the list of what you can extract, in what format, and what it includes:
Exporting challenge data
Once logged in as an admin user, select the Administration link at the top right of your screen. You should be taken straight to the Manage Challenges page, but if not, select the Challenges link at the top of the screen.
Here you can see headline stats across all your challenges and can you can select the option to Export site-wide data to get to the .xlsx exports of the ideas, comments and tags data for all challenges on your site.
You may instead wish to select individual challenges and look at the results for one of those. If that's the case, from the Manage Challenges page, select the title of the challenge you want - this will take you through to its dashboard (see screenshot). Here you will be able to take exports of ideas, comments, and tags for that challenge, as well as to see the number and average of the ratings given to the ideas in it.
The following data sets are available for download in .xlsx format from the challenge dashboard:
- All ideas (title, description, username of submitter, date, average rating, number of ratings, number of comments, list of tags, moderation state) sorted by either creation date, average rating or number of comments. Each .xlsx file contains the same data and the only difference is how it is sorted, so you only have to download one of these.
- All comments (includes the idea with which the comment is associated, username of submitter, date, and the comment itself).
- All topics (topic name, number of uses).
Exporting user data
To get data about who has registered on the site, head to Users in the admin links at the top of your window.
From here you will be able to:
- Download user list (.xlsx) - this includes username, email, mailing list op-in, and sign up date and time
- Download full user profiles (.xlsx) - this includes username, email address, mailing list opt-in status as well as any custom demographic information if extra questions have been added to the registration form.
Opening .xlsx files
.xlsx files can be opened in spreadsheet packages such as Microsoft® Excel®, or databases such as Access®.
Export other content
If you would also like to save web pages from Dialogue to your desktop, there are several ways to do this. One way you can do this is by viewing the page you want to save and pressing 'CTRL'+'S' on your keyboard.
Alternatively, you can also export your web pages to PDFs, which is easily achieved if you're using Google Chrome as your web browser.
Exporting a PDF in Google Chrome
When you are viewing the page you want to export, click the menu icon to the right of the address bar, then click 'Print':
You'll then need to change the settings so Chrome creates a PDF instead of sending the document to print:
Select 'Save as PDF' from the options:
Click 'Save' and you'll be asked to specify a location on your hard drive to save the file to.