Need help? Looking for tips and tricks?

This knowledge base contains loads of useful advice and answers to common questions.

If you're still stuck you can always submit a support request and we'll get back to you ASAP.

Exporting your results and data

Eric -

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. 

image showing the manage challenges administration page which lists out challenges currently on the Dialogue


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.


image displaying the administration page for an individual challenge, providing top level statistics and options for modertation and editing


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:

image showing the menu drop down in a Chrome browser which is located in the top right corner next to the address bar, with the print option highlighted

Select 'Save as PDF' from the options:

image showing the print options with the chnage button highlighted as you use that to select the save as pdf option

Click 'Save' and you'll be asked to specify a location on your hard drive to save the file to.

image showing the window that opens in chrome when you select save as PDF , allowing you to select a file location on your PC