| Compatibilità: | IdSurvey 7 | IdSurvey 8 |
| √ | √ |
With IdSurvey you can export the data of the collected interviews in the page “Export Results” that you can enter clicking on the “Tools” icon of the survey menu.
You can export the interviews in SPSS, Excel, CSV, Triple-S, and TXT (fixed-sized columns) format. The export of aggregated results (in Excel format) and the export of the entire database in Access format – including interviews, contacts, outcomes, reasons for refusal and all survey data – are also available.
To proceed with the export simply press the export button, wait for the creation of the file and then click on “Download and close”.
In “Recent exports” the most recent exported files remain available.
You can also schedule automatic periodic exports by clicking on the clock icon. However, using this feature on many surveys or surveys with a large number of interviews may slow down the system. It is therefore highly recommended to stop scheduled exports when they are no longer needed.
Export options
Completed Interviews, Validated Interviews, and Partial Interviews
It allows to choose whether to export completed interviews, only those validated by the Quality control section, or partial interviews.
Include over-quotas
It allows you to include or exclude completed interviews that exceed the survey quotas.
Include rejected
It allows you to include or exclude any interviews marked as rejected by the Quality control section.
Codes or texts
It allows to export codes or texts of questions and answers.
Multiple choice answers
Select the layout of the export of multiple choice answers: “dichotomous variables” (options in multiple columns marked with 0 or 1), “in separated columns” or “comma separated values” in one single column.
- Not all export options are available for all formats. For example, SPSS files always integrate both codes and labels so the Codes and Texts option is not available for this format.
Settings
Filter by date
Limit the export only to interviews completed in the set period.
Meta data
It allows the inclusion of additional data such as date and start of interview and the interviewer’s id.
Contact fields
Select the fields you want to export along with the data file. These fields will be exported as the first columns of the file. To select or deselect all the fields of the contact to export, simply click on the circle button available below the list.
In order not to lose the choice of columns to export for future exports, select “Remember Selection”.
Include attachments
Export any photos, videos, and files attached to the answers of the questionnaire.
- These settings are available for all formats with the exception of the complete database export in Access format.
Complete database export in Access format
The export in Microsoft Access format includes the entire survey database and allows for in-depth analysis of results, appointments, and other data.
The gear allows you to customize labels for outcomes and reasons of refusals.
Tables structure
Appointments appointments
AppointmentsLogs appointments log
CallHistory calls log
ContactChanges editing on contact fields
ContactFieldDatas values of custom fields
ContactFields custom fields list
ContactPhones phone numbers used for appointments and calls
Contacts list of contacts and standard fields
Detail_Result completed interviews results
Detail_Result_Temp ongoing or paused interviews results
MailLogs results of emails and sms sent by CATI
Operators list of survey agents
Questions questions
Responses answers
Results list of interviews with start and end date and interviewer
Surveys surveys (it only contains the record of the selected survey)
How import exported files
Import the CSV file in Excel
Open Excel and click on “Data” -> “From text” (in Get external data).
Select the CSV file exported and click on “Import”.
In “File origin” select Unicode UTF-8 and click on “Next”.
Select “comma” as delimitation and click on “Next”.
Select all columns in the preview and set the “Text” format or the format that it’s best for each column.
Click on “End” to complete the import.
- In a very similar way, you can import in Excel the SPSS dat file but setting the character “§” as delimitation.
Import var and dat files in SPSS
IdSurvey will export a zipped folder with two text files to export to SPSS: a variables file (the name end with _var) and a data file (the name end with _dat).
Open the variables with any text editor.
Replace the “physical-path” with the actual complete path of the file.
You can find the complete path right-clicking on the file and selecting the properties.
Open SPSS and select “New syntax file”.
Paste the content of the variable file in the window.