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
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.
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.
|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.
|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.
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:
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