Home > Studio Manual > Chapter 6 – Exporting & Printing

Chapter 6 – Exporting & Printing

Back to Table Of Contents
Back to
Chapter 5 – Showing pictures & media on the PDA

About Exporting & Printing

SurveyToGo enables you to export the data of a survey at any point, to a number of different applications & formats. Furthermore, additional export providers can be written easily to support additional formats. Currently, the supported formats include MS Excel, MS Access, SPSS & XML. When exporting, you have complete control on the order of the exported columns, enabling you to separate the way the survey is presented from the way the data is to be exported.

The Export Wizard

Whenever you wish to export the data of the survey, you simply double click on the “Collected Data” Node in the relevant project:

On the screen that opens you have the choice of exporting the interviews or the actual survey structure. Choose the “Survey Results” option and select the relevant survey, then click “Export”:

Please note only active surveys will be displayed in the list. If your survey is marked as “Draft” or “Closed” then it will not be shown. If you need to export results of closed surveys, simply change their mode back to production or test.


Survey select screen

In this screen, simply select the survey who’s results you would like to export and click Next:

Export provider screen

Simply select the desired export provider and click the Next button.

Export options screen

Option Description
Index Column name of a running index of the subject.
Surveyor Name Column name of the surveyor that created the result. For PDA surveys, this will hold the actual surveyor name, while in WEB surveys, the surveyor name will STGWebSurveyor.
Restrict to SPSS format limits When checked, column names will be shortened to support older versions of SPSS that only supported 8 character column names.
Surveyor Comment Column name of the surveyor comment written by the surveyor while on the field.
Subject Name Column name of the subject name. The subject name is taken either from the relevant subject store the subject is a part of, or Anonymous for anonymous subjects.
Subject Unique Tag Column name of the unique subject tag. The unique subject tag is taken from the definition in the subject store, or the email for non-store subjects.
Upload Date Column name of the upload data/time. The upload date/time is the date/time that the result was uploaded to the server by the PDA, or submitted to the server in Web surveys.
Duration Column name of the duration. The duration specifies the time it took for the subject to reach the end of the survey from the moment the survey was started.
Execution Date Column name of the execution date/time. The execution date/time is the time the subject performed the survey. This date/time can differ dramatically from the upload time of the result for PDA surveys, while for WEB surveys the execution and upload date/times tend to be very close to each other.
Subject Data Column name of the subject data. The subject data is a custom optional data associated with the subject during the course of the survey that is mostly used as a way to send (and later retrieve) specific subject data while using an anonymous survey. For more information on the Subject Data field, please refer to Chapter 6.

When done you can either click the columns order tab to change the columns order settings, or click Next to continue.

Columns Order screen

The columns order screen allows you to define the exact order of the columns you would like to have when exporting the survey results. You can choose to export all or only a subset of the columns available, or even export a column more then once. Both the left list and the right list support multiple selections (by using the Shift and or Control keys) and are completely sort able by any column you desire.

When you are done configuring the order and number of columns you need to export, simply click the options tab or click Next to continue the export process.

Note: export settings are saved on your computer for the when you need to export the same survey again.

Option Description
Left list – Source columns Contains all the available columns. You can select one or more columns from this list to move to the output columns list. Internal columns, like the ‘duration’ column etc have a yellow background while survey specific columns have a white background. The list supports multiple selections & sorting. To sort, simply click the column of the list you would like to sort by.
Right list – output columns Contains all the columns that will be included in the output export file. The order of the columns is the actual order of the exported file. To change the order of the columns you can press the up/down arrows. To create a copy of a column, right click that column:
Up/down buttons Control the actual order of the columns. You can select either one or more columns and press the up down buttons to move these columns up or down.
Left/right buttons Control the movement of columns between the left and right list.

Options screen

The options screen allows you to specify some general options regarding the exported file. When you are done, simply click the Next button to continue.

Option Description
Include Filtered Out subjects Subjects who participate in your survey can be filtered out from the survey due to certain conditions. If checked filtered out subjects will also be included in the exported file, and an additional column – “Filter” is added to the exported data. The “Filter” column contains the index of the question the subject was filtered at.
Export only results submitted between… and … Enables you to specify a date range for the exported results. If specified, only results from the specified range are included in the export.
Swap rows and cols If checked, the results are exported so that each subject is a column, and each question is a row, instead of the regular format where each subject is a row and each question is a column.

File name selection screen

The file name selection screen allows you to enter the name of the output file name. When you are done, click the finish button to continue.

Option Description
Export Data File This is the file name that will be filled with all the results according to your selection
Include result attachments If you specify this option and select a folder location, any picture attachment that was included in the results will be placed in this folder. The name of the picture will be according to the relevant SubjectID field in the results file.
Include attachment list If checked, you can choose a csv file that will receive a list of links to the various pictures that were included in the results. This is useful if you need links to the attachments instead of the actual pictures.

After you click the finish button, you will see the following screen:

Answer Yes to open the exported file using its associated application, or no to continue without opening the external application.

Exporting the survey (not the results)

Sometimes there comes a need to export the actual survey structure. This can include backup purposes, moving a survey from one SurveyToGo server to another one and more. To export a survey to XML, simply choose “Survey > Export” then choose Export Survey:

Choose the survey you would like to export, and click Next:

Choose the default SurveyToGo export provider and click Next:

Then choose a file name and click the finish button. The survey will be saved to the path you indicated.


Printing a survey can be very useful for both keeping a hard copy version of the survey & for sending to clients & team members for review. You can both directly print a survey or perform a print preview.

Direct Printing

To directly print a survey in SurveyToGo, choose the “Survey > Print” menu option:

Then choose the printer you desire from the standard printer selection screen and press OK to print:

Print Preview

To preview a survey before printing, select the “Survey > Print Preview” menu option:

Then the print preview screen will show, allowing you to preview the output before printing:

Go To Chapter 7 – Rules

Back to Table Of Contents
Visit us at: http://www.dooblo.net

Categories: Studio Manual

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: