Export

In the Projects module, various options for exporting project-related records can be found under the Export menu item of each individual project. If you export result data from a project with loops, you can check the status of your export job or download the complete file in the Export tasks menu. In EFS People installations, the Export menu item in the People module allows you to additionally export people-specific data (e.g. master data or address data of panelists).

Example: Exporting result data for evaluation in SPSS

The example below illustrates the export of project result data. The following requirements should be met:

• Only the results of closed-ended questions should be exported.

• Only survey data of respondents who have completed the survey should be exported.

• Further evaluation is conducted using SPSS.

Please proceed as follows:

1. Start the export process under Projects → {Selected project} → Export by selecting the data type “Result data”, and confirm by clicking on Next.

2. In the list which then appears for selecting the export template, format and extensive fine tuning adjustments, you can make the desired restrictions. In the “Export settings” area, choose “SPSS” as the file format and “Project, closed-ended questions only” as the export template. Leave the default settings for data compression (“No compression”) and language (“English (default)”) unchanged.

3. Open the “Restrict export to disposition codes” section and deactiveate all disposition codes except 31 (Completed) and 32 (Completed after break) according to the requirement defined above.

4. Then, click on the Export button and reconfirm the export by clicking on Copy file to local PC on the following page.

5. The download will begin. A pop-up window will open, in which you can choose to either open or save the file. Click on the Save button.

6. A further dialog window will open, in which you can choose the folder you wish to save the file to. You can also rename the file. Confirm by clicking on Save.

7. Once the download has been completed you can close the window by clicking on Close window.

Detailed Description of Result, Master and Address Data Export

Selecting the Appropriate File Format

The following formats are available:

Compressing Files

The following options are available for exporting a file in compressed format:

• No compression

• Zip format: commonly used format on Windows machines

• Tape archive (.tar.gz): commonly used format on UNIX machines. The default setting is “No compression”.

Selecting an Export Template

The following export templates are available:

• Complete project: All project result data will be exported, including time variables, which provide information on survey processing time.

• Project without timestamps: All project result data will be exported, with the exception of time variables.

• Project, open-ended questions only: Only questions with “varchar” type open-ended text fields will be exported.

• Project, closed-ended questions only: Only closed-ended questions (“int” type) will be exported.

• In personalized projects:

  • Participant data for current project: Only the address data of the participants assigned to the project will be exported.

  • Only if you have the required additional access right, you can access the combined participant data and result data export.

For panel surveys in EFS People installations, you have the additional option of exporting Master data for project: Only the master data of the participants assigned to the project will be exported.

Restricting Export to Individual Panel Groups

For panel surveys in EFS People installations, you have the additional option of either exporting data from the entire panel or restricting the export to individual panel groups by choosing the respective option from the drop-down list in the “Restrict export to” field.

Selecting the Language and Charset

For multilingual projects you can choose the language in which questionnaire texts are to be exported in the “Language” field. This setting only affects the language of text elements (e.g. questions texts, answer options) that are included in the SPSS export as labels, and does not affect exported survey data.

Set the character set of the exported data record in the field “Character set”. This setting affects the entire export data record, i.e. for both the questionnaire texts and any existing open-ended questions.

User-Defined Missing Values in Exported Data

You can define missing values for strings, numbers, calendar data and timestamps for further processing in SPSS. Here, the following applies:

• SPSS accepts user-defined missing values for calendar data and timestamps.

• Missing values for number fields can be numeric or empty. However, SPSS only accepts numeric values.

• In the case of numeric values, SPSS accepts a maximum of three variables per field. Missing values defined in the questionnaire editor are included in the process.

• SPSS does not accept user-defined missing values for string variables.

• For text fields, different missing values can be entered, depending on whether the fields were not seen (default value: –66) or were seen, but not edited (-99).

Removing Line Breaks

Excel and OpenOffice are not able to process and display CSV files containing line breaks properly. If you activate the field “Remove line breaks in values from export file” the line breaks will be removed.

In EFS 8.2 and more recent versions, this feature does not exist anymore, because from EFS 8.2 onwards, export data do not contain line breaks anymore in principle.

Replacing Codes with Labels in Excel Files

If you export result data in XLS or XLSX format (MS Excel), you have the option of replacing numeric codes with labels. To do so, navigate to the “Advanced options” section of the export dialog, and tick the checkbox labeled “Replace numeric codes with their labels”.

Exporting Open Answers Completely for New SPSS Versions

Until EFS 10.0, SPSS export (based on PSPP) truncated string variables after 254 characters. Until EFS 10.0, it is therefore recommended that you export the answers separately to open-ended questions in another format (e.g. XLS, CSV) and use a different program for viewing the answers.

• From EFS 10.1, when exporting for SPSS from version 14 onwards, it is optionally possible to work without this restriction. To do so, deactivate the new option “Cut text field entries after 254 characters for SPSS export”. Please mind that without restriction of the text length, the overall size of the export file can grow significantly, depending on the number of text fields in the questionnaire and the num- ber of participations.

• For SPSS versions below 14, the text length restriction must be used to ensure downward compatibility.

Restricting the Range of Exported Data

Restricting the range of data to a specific period

You can restrict the range of data collected during a certain period by making the respective selection in the “Last change from / until” fields.

Restricting the range of data using consecutive participant numbering

By making a respective entry in the “Lowest / Highest consecutive number” fields, you can restrict the range to survey data of a specific block of respondents who have successively completed the questionnaire.

Restricting the range of data to certain disposition codes

If you are authorized to access disposition codes (read right for show_dispcode), you can restrict export to survey data of respondents with a certain disposition code.

To do so, untick all disposition checkboxes in the “Restrict export to disposition codes” field, for which no survey data are to be exported.

Available are the disposition codes greater than/equal 20. No result data exist for disposition codes < 20, therefore a result data export for such codes is not advisable. By default, the data of all participants with disposition codes between 21 and 42 will be exported.

Exporting protected questions

If your project contains questions which are marked as “protected” and you have read rights for protect_questions, you can choose between various options when exporting result data:

• Export all questions

• Export “protected” questions only

• Export “unprotected” questions only

Restricting to participant groups

In personalized projects, you can limit the export to specific participant groups, defined by the characteristics of the participant variable u_group.

To do so, when exporting result data, select the appropriate group in the “Restrict to participant groups” field of the “Restrict range of exported data” section.

Selective export

If you have ticked the checkbox for the “Selective export (Please click here, if you want to specify which variable shall be exported)” field, you have the option of performing a selective export, i.e. you can choose from the range of available variables.

Once you have confirmed the selection by clicking on the Export button, the list of possible variables will be displayed and you can choose those desired.

Excel Export with External Variable Names and Meta Information

If you export result data in XLS or XLSX format (MS Excel), you have the option of adding meta information. In this case, additional columns with the following information will be inserted in the export file header:

• 1. Line: Question text

• 2. Line: Plain text description of the variable. Depending on the question type, this is In the case of questions with multiple response lists, the respective answer option is specified.

• 3. Line: external variable name If you want to use this option, tick the checkbox “Display meta information as additional column heading (excel export only)” in the “Advanced options” section.

Exporting Participant and Status Codes

The export type “Participant and status codes”, which is is available for personalized projects, enables you to determine the disposition code and last access for each survey participant.

The export file contains the following information:

• Participant code: The code used to access the survey.

• Disposition code: The selected disposition codes.

• “Tester” variable: Does the participant have tester status?

• Only with access right for combined participant data and result data export: Last accessed: Date and time of when the survey was last accessed.

Exporting Answers to Open Questions for Quantum

Some evaluation programs, such as Quantum, place special demands on export records for open-ended questions: Answers should not only be separated from the answers to closed-ended questions, but their display should also be different. Whereas in the case of normal export records, consecutive numbers and result variables of a respondent are displayed side by side in the columns of a single row, the individual answers of a respondent should be displayed in rows one above the other.

The “Data (open end answers only; optimized for column display in Quantum)” data type is available under Projects → {Selected project} → Export, and can be used to create such a record. When downloading, please proceed as follows:

1. Select the “Data (open-ended answers only; formats e.g. SPSS, CSV, Fixed Format, Quantum, MS Excel...)” data type.

2. After that, you can choose the format and make further settings as usual.

3. Confirm by clicking on Export, and download the file as usual.

4. Then open the record in the appropriate evaluation program. The exported record contains three columns:

   • lfdn: the respondent’s consecutive number

   • varname: the variable of the open text field

   • value: the entry made by the respondent

Open

The above figure shows an example of a record exported in CSV format and opened in Excel.

Special Functions for SAS Export

The SAS export generates an SPSS Portable-file, a text file with labels and a macro that can be executed in SAS. The macro can be used to label the SPSS Portable file and convert it into an SAS data table.

Notes on SAS

Since the SAS export is performed using an SPSS Portable file, it is subject to the technical default settings and restrictions of SPSS.

Character set

From EFS 8.2, the SPSS export supports UTF-8 and all other character sets which can be selected in EFS, with the single exception of UTF-16.

Missings

The default settings for missing values are interpreted as follows during SAS export:

• “-77” is defined as a missing in both SPSS and SAS. Therefore, it is represented with a period (“.”) in SAS.

• “-66”, “-99” and “0” are not defined as missings in SAS. Accordingly, they are interpreted and displayed as number values.

Making Default Settings for the Further Processing of the SAS Files

In order to apply the macro to the other files without any further configuration after the SAS export, you must make the following default settings in the Options → Personal preferences menu on the Common settings tab before exporting the data:

• Standard directory for SAS exports on your computer: This directory path is copied into the SAS macro generated by EFS Survey. Therefore, the compressed file must be located in this directory for you to apply the macro to it successfully. Default setting: c:\Documents and Settings\user name\Desktop\

• SAS library in which the SAS macro generated by EFS Survey is to store the con- verted data: The SAS macro will store the data temporarily in this library. You can access and then save the data from there. Default setting: work.export, where “work” is the name of the library and “export” is the user-defined name of the file.

Exporting and Opening SAS Files

Please proceed as follows:

1. In the Export menu, set the desired export options as usual, including the desired file compression (zip or tar). Also, please observe the above note on selecting the character set. After that, initiate the export process.

2. Save the compressed file locally in the directory that you chose under Options → Personal preferences.

3. Open the compressed file. It contains the three files export.por (SPSS Portable file containing the data), export.txt (text file with labels) and macro.sas (Macro).

4. Open the macro by double-clicking it.

5. To execute the macro, click on the Execute icon.

6. The data table will now automatically be stored in the library you specified under Personal preferences.

7. Navigate to the library and open the file.

Special Functions for Fixed Format Export

Adjusting Column Widths

The export dialog (Projects → {Selected project} → Export → {Selected data type}) provides two special options in the “Export settings“ area specifically for Fixed Format export, which particularly facilitate further processing of the data in Quantum:

• Adjust column widths to effective size of data: The columns are made as narrow as possible.

• Automatically adjust column widths if missing values are longer than column widths defined in export template: The export dialog allows you to define missing values yourself or use the default values (-77, -66, 0). If these missing values require more digits than provided for in the respective column, ticking this checkbox will widen the column. If the checkbox is not ticked, the value “-77” will be exported only as “-“, for example.

Downloading the Export Template

Another option that was set up specifically for Fixed Format export allows you to download the export template, including the information on the column width you configured yourself, as a CSV file.

To do so, you must first perform export selection as usual. The dialog shown in the figure, in which you can finally download the file, also contains a green bar displaying the here link you can click on to download the CSV file.

Excursion: Merging Records in SPSS (Matching)

Under certain conditions, various system files can be merged to create one system file. There are two possible ways of merging:

• Merging cases where variables are identical or almost identical (Add Files).

• Merging variables where cases are identical or almost identical (Match Files).

For the 'add files' command, cases are added from one or more records to an existing record (vertical conjunction). For identical variables, syntax in SPSS is as follows:

For the 'match file' command, several records can be merged using a key variable (horizontal conjunction).

Prerequisites for successful matching are:

• All files must contain the same number of cases.

• All files must contain a key variable with an identification number (e.g. lfdn).

• Each case must be assigned to a different identification number.

• A certain case must always have the same number in different files.

• All files must be sorted by identification number.

In this case, the consecutive number 'Lfdn' is chosen as a key variable, and the records must be sorted by this variable. For an identical number of cases, syntax in SPSS is as follows:

What do the Exported Result Data Reveal?

Overview of Variables

Depending on project, project properties, choice of export options and authorization of the user who executes the export, the result data record may contain the following variables:

Overview of Variable Preallocations

EFS Survey Variables

Overview of the Various Variable Types

The locations in the database, in which answers given by the respondents, participant administration data or system information regarding the course of the survey are saved, are identified using variables. In defining routing, e.g. via a filter or when importing saved contents via wildcards you can access the database contents via these variables. A range of variable types are used in EFS surveys:

• Project variables (v_000n): The results of the survey are saved in these variables. They are automatically created when new questions are created.

• URL parameters (p_000n): These variables allow you to pass variables to a survey from outside. They are created and configured manually.

• User-defined variables c_000n: These variables are used to store interim results. They are created and configured manually.

• Participant variables (u_000n): Information regarding survey participants is stored in these variables. A set of frequently used variables is available by default and additional variables may also be created.

• System variables: The variables are used to store meta-information regarding participants and the course of the interviewing process. System variables are automatically generated when a project is created.

• For EFS People installations only: Participant data of the panelists (u_000n). These variables are preset by the EFS People and are not configurable.

• For EFS People installations only: Master data (m_000n). Fundamental panelist properties determined by the panel administrator, which are stored independently of the specific project and which are permanently available.

• For EFS People installations only: Panel system data. The variables are used to store meta-information regarding the panelists.

Maximum Available Number of Variables

Up to 7,000 variables are available per project.

• This value is the sum of all variables in the project, not only the sum of the project variables.

• The maximum number of variables which are available in a specific project depends on various factors, as e.g. type and size of the variables created, and may be lower than 7,000.

In an EFS People installation, up to at most 2,800 master data variables can be used.

Generating and Editing Project Variables and Codes

Project variables (v_000n) will be created automatically when you create a question.

• In the case of single response questions only one variable per question is required for each and the various answer options are allocated codes.

• In the case of multiple response questions, one variable is created for each answer option. Whether the respondent has selected an option is recorded via the coding: 0 = not specified, 1 = specified.

• For matrix questions, one variable matches each answer option, and the scale characteristics are encoded (exception: question type 362 with checkboxes and question type 363 with text fields).

• Entries in open text fields are similarly recorded in a variable.

The variable names are assigned automatically for each project, beginning with v_1 and names cannot be edited. If required, however, you can allocate an external variable name. You can see the internal project variable names when working in the questionnaire editor depending on the question type

• in the “Answer options” area in the “Variable name” columns

• in the case of questions with an open entry field in the “Question options” area.

The codes are also assigned automatically, but can be edited in the case of single response and matrix questions. You can view and edit the codings in the questionnaire editor

• for single response questions in the “Code” column in the “Answer options” section.

• for matrix questions in the “Code” column in the “Scale options” section.

All project variables and their codings are listed in the codebook.

Preset and User-Defined Names for Project Variables

If variable names are displayed within EFS Survey the automatically preset, so-called internal variables are used. You can of course allocate alternative names which will be used on export instead of the internal names and then be available for external evaluation.

• Internal variable names: These are the variable names that are automatically allocated by the system when creating a question and are used within EFS. These have the format v_000n and cannot be changed.

• External variable names: These names can be changed optionally by the user and are then used on export instead of the internal variable names.

  • External variable names may have up to 64 characters.

  • The term “comment” should not be used as an external variable name (“comment” is a key term in PSPP, the program used for the SPSS export).

Viewing and Editing User-Defined Variable Names in the Questionnaire Editor

Internal variable names are always displayed in the question view. In addition, you can also display and edit external variable names, if required. Depending on the question type you will find the respective field

• in the “Question options” area for questions with a single response list or open entry field.

• in the “Answer options” area in a table column that is usually hidden in the case of multiple response and matrix questions. Click on the arrow icon in the “Variable name” column to display the “External varname” column.

Options for Centralized Editing of Variable Names

The codebook contains a range of functions which enable effective centralized editing of user-defined variable names in the “Edit variable names” section.

Editing variable names

When the option “ Edit variable names directly in this form” is selected and then confirmed with the Save settings button, entry fields are displayed in which you can edit the external variable names. After entering the new names, click on the Save variable names button.

Changing variable names according to a preset algorithm

You can allocate a unique label to the external variable names of a project in accordance with a predefined scheme.

Available options are:

• Consecutive internal variable name (v_x): Default in new projects

• User-defined prefix consecutive item number

• User-defined prefix consecutive question number_consecutive item number (per question)

• User-defined prefix consecutive question number|consecutive item number (per question)

Please proceed as follows:

1. In the codebook click the Select algorithm for creation of variable names link in the “Create new variable names in accordance with selected algorithm” field. This opens the Projects → {Selected project} → Project properties menu.

2. Set the desired labeling option in the select box.

3. Enter the desired prefix in the “Algorithm for creating the external variable names” field. Default preset is “v_”.

4. Switch back to the Codebook.

5. Activate “Create new variable names in accordance with selected algorithm”.

6. Confirm by clicking on Save settings.

Systematically naming variables in dynamic answer blocks

The “Rename variables in dynamic answer blocks” option allows you to automatically change the names of variables, for example, in a list or a loop in such a way that the link to the original variable can be read from the name. If, for example, a dynamic list is incorporated into a question, all variables that were generated via the dynamic list will have the name v_sourcevariablea once renaming is complete. If the questionnaire contains a second question that draws on the same dynamic list, then the corresponding variables will be named v_sourcevariableb.

Editing variable names externally

You can export external variable names, edit them outside EFS and then re-import them:

1. The “Export variable names for external editing” will create a CSV file containing the variables information, which you can load onto your workstation. You can specify which character set is to be used.

2. When editing you enter the new external variable name in the “New varname” column.

3. The “Import externally edited variable names” option allows you to re-import the externally edited list in CSV-format into EFS Survey. Here, too, the correct character set must be specified.

Undoing changes

Changes to external variable names can be undone applying the “Restore original variable names” options.

Defining Export Templates

You can define your own templates based on existing default export templates. This can be useful, for example, if you frequently need only specific excerpts from the result data.

Overview of Existing Export Templates

The Export → Export templates menu (until EFS 10.3: Template editor) contains a list of the templates that have been set up for the respective project and the functions for creating new templates.

• The default templates of the “Static template” type cannot be changed or deleted. Even though it is possible to download these templates, the modified templates must then be uploaded under a different name, in a newly created user-defined template.

• Templates of the “User-defined template” type can be edited and deleted.

The following icons are in the “Action” column:

• Upload definitions for template “...”: This function is only available for user-defined templates you have created. You can use it to upload an edited definition file.

• Download template as CSV file: The downloaded file has the .csv file type.

• Download template as Excel file: The downloaded file has the .xls or .xlsx file type

  and can be edited in MS Excel.

• Save as new template: You can save the selected template as a new template, allowing you to download and edit it afterwards.

• View template: The export template will open in a table.

• Delete template.

Viewing User-defined Templates and Sorting Their Contents

Clicking on the name of a template or on the View template icon will display its content in a table that cannot be edited.

It contains the following information for each variable of the template:

For user-defined templates, you will find that there are two additional buttons:

• Sort fields by position: Sorts the rows by the content of the “Position” column.

• Shrink column widths to width of actual data: This function is required for Fixed Format and Quantum exports.

Creating a User-defined Template

To define a new template, you must first select the appropriate basic template: This template should at least contain all of the data you wish to actually export later on. Select the basic template in the “Create a new template” section, and confirm by clicking on Create (alternatively, you can also click on the Save as new template icon).

In the next window, enter the name of the template and confirm by clicking on Save as new template. The new template of the “User-defined template” type will be created and displayed in the list of templates.

Downloading and Uploading Export Templates and Editing Them Externally

To edit an export template, you can download it and edit it externally. Please proceed as follows:

1. Click on the Download template as CSV file or Download template as Excel file icon to download the template to your hard disk.

2. Open the file in a suitable program, e.g. in MS Excel. Edit the file according to the rules presented below in the section titled “Editing a user-defined template”, and then save it. In the example shown, some variables are deactivated: “u_group”, “u_email” and “u_www” have already been deactivated.

3. Click on the Upload definitions for template “...” icon. Locate the definition file on your hard disk, and then confirm by clicking on Upload. Open the export tem- plate, and check the result. In the example shown, all variables after “u_group” were deactivated. You can use the buttons labeled Sort fields by position and Shrink column widths to width of actual data to edit the template further.

Editing a User-defined Template

When editing the template definition, you should pay attention to the following rules:

• A variable for export must be specified for each row, and each row must consist of seven values separated by tabs.

• You should not change the order of values.

• Deleting the variables from the list will not delete them from the export data record. The “active” column determines whether a variable is to be exported.

• It is not possible to add variables.

• Duplicate definitions of a variable are not permitted.

• Variable column positions (pos+width) may not overlap.

• The position and width of the columns for the individual variables must be such that they will not overlap.

You can click on the Sort fields by position button to have the variables arranged by their position. This arrangement will be saved and can then only be changed by downloading the template again and editing it manually.

Clicking on the Shrink column widths to width of actual data button allows you to optimize the export template for Fixed Format and Quantum exports.

Data Cleaning

If a respondent uses the “Back” button in the questionnaire or that of the browser while completing a questionnaire, they is possible that they will pass the same filter question more than once, giving different answers and then being routed into another filter branch, where they will answer different questions.

Example: Somebody answers the question whether they drive a car with “Yes” and is subsequently asked all car-related questions. Then, they go back in the questionnaire and state they do not drive a car. A filter lets them skip all car-related questions now. When the respondent completes the survey, they will have stated they do not drive a car. Nonetheless, all car-related variables will contain values.

In the past, such irrelevant data had to be manually cleaned from the result data. With the “Data cleaning” function, this cleaning process has been automated.

Before you start

Please note:

• Data cleaning only takes completed interviews into consideration, i.e. records with status 31 or 32.

• The following routing types are supported:

  • “Filter” and “Random rotation” branches.

  • Trigger types which affect routing via changes in the survey results. The function should, however, not be used in projects involving page triggers: In this case, the routing that the respondent took erroneously or for test purposes cannot be unambiguously identified.

  • Action pages.

  • Depot questions.

  • EFS-side Back buttons. Please mind: browser-side Back buttons are not fully supported. If a respondent skips back several pages using the browser Back button first, and then skips forward several pages using the browser Forward button ignoring the system warning, these steps cannot be tracked and stored correctly. I.e. pages might be missing in page history, though valid data from these pages exist.

• “Random rotation” branches and loops are not supported.

• Data cleaning should not be applied to surveys which are prefilled with values. I.e. it should not be combined with the options “Transfer master data values to survey variables” → “Always pre-fill”, “Allow multiple participations, pre-fill with values of last participation” and import of specific answers from other projects.

Activating Automatic Data Cleaning

Activating data cleaning before the beginning of the field phase

In the Projects module, click on the desired project, and then choose the Project properties menu item. On the tab General options, tick the checkbox in the “Enable data cleaning” field. Then, confirm by clicking on Submit. The Display link allows you to switch to the Data cleaning submenu.

Triggering Data Cleaning for the Entire Project

The documentation of all changes to the data as well as functions for restoring all or part of the original data are located in the data cleaning log. There are two ways of accessing this:

• Click on the Display link in the Project properties menu.

• The second way is via the Statistics → Data cleaning menu.

You are automatically taken to the General tab.

The “General information” area shows whether data cleaning has already been perfor- med and how many records were processed.

• Status data cleaning in this project: Data cleaning is activated from the Project properties menu.

• Number of cleaned records: The records that were changed during data cleaning.

• Number of data records that were checked but did not require cleaning: The records that would not be / are not affected in the event of data cleaning.

• Number of uncleaned records:

  • If data cleaning has not taken place, this value will contain the uncleaned records.

  • After data cleaning has taken place, all records that could not be checked and cleaned because the interviews were not completed remain in this field.

  • If further questionnaires were filled out after a manual data cleaning, this value will be the total of all uncleaned records, as well as all records that were not checked during the manual data cleaning because the interviews were not completed.

In the “Data cleaning for the whole project” area, you can trigger or undo data cleaning:

• If you select “Clean all data” and then confirm by clicking on Execute, the cleaning operation will be triggered.

• If you select “Recover all data” and then confirm by clicking on Execute, the ori- ginal state will be restored.

Viewing Details and Editing Records Manually

The Extended tab provides a detailed documentation of all changes to the data as well as functions for both editing individual records and restoring all or part of the original data.

Display options

• Number of datasets per page: If you enter the corresponding value and then con- firm by clicking on Apply, you can change the number of records displayed on one page.

• Display only datasets with a particular variable: This search function identifies all records containing the given string. After entering the string, you can trigger the search by clicking on Apply.

• Display routemap: Ticking the checkbox and then clicking on Apply will show the so-called routemap in the log. The routemap is a comma-separated page list reflec- ting the participant’s valid route through the survey (see the “Example” section below). It is extracted from the page history (phistory is the variable used in the export record, page history is the label used in the SPSS export record).

Interpreting the entries in the data cleaning log

• The data cleaning log contains the following information and functions:

• Cons. no.: The respondent’s consecutive number in both the survey table and the export record. The table contains only the records of those respondents for whom data cleaning might be required.

• Cleaned data: Those data from the complete record that were / would be changed during cleaning.

• Original: The original state of those data from the complete record that were / would be changed by cleaning.

• Routemap: Can be shown and hidden using the “Display routemap” function in the “Display options” area.

• Cleaned: yes / no.

Editing individual records

You have the option of targeting individual records for cleaning or for restoring the original state. To do so, tick the respective checkbox in the “Execute data cleaning” or “Recover data” column, and confirm by clicking on Save.

Identifying Cleaned Data in the Export Record

The export record provides information if a individual record was cleaned: It is stored in the variable cleaned (labeling in the SPSS export record: “datacleaning”) which can have the following properties:

• 0 = uncleaned data records and records of incomplete interviews which are excluded from the cleaning process

• 1 = cleaned

• 2 = checked but did not require cleaning

Quality Correction

The conscientiousness with which survey participants fill in questionnaires is critical for the quality of the results of online surveys. The results from survey participants that merely click very quickly through the questionnaire, for example to get a quick overview of the survey theme or on completion to participate in a prize draw, are of little value for further analysis in the end. The quality correction program helps you to reco- gnize participants who simply “clicked through” by their answer behavior, to mark these data records, and if desired to delete them.

Response times as quality criterion

The response times of a user are the key criteria needed for indexing the quality of survey participants. The time taken by each participant to complete a particular page of a survey can be calculated. First of all an index is formed for each participant that gives information on his mean processing time for a questionnaire page. Please note here: The time required by a participant to complete an entire survey is not a factor in the calculation. Depending on the direction of the questionnaire the number of pages that the participant sees can also vary tremendously.

Subsequently a separate calculation for each page is made, which shows where the survey participant is with regard to the processing time of the media. The median survey time of 100 participants corresponds to the average survey duration of the 50th and the 51st survey participant, when these have been sorted by survey time.

Determining the quality index for individual users

In order to determine the “quality” of a participant in a survey, his individual proces- sing time is set in relation to the average processing time of the entire sample. The relationship can be expressed as a number that is stored in the variable “quality”. For example a value of 0.5 signifies that the corresponding user required exactly the average time for processing the questionnaire pages. A value of 0.25 signifies that the respondent needed only half as long as the average processing time.

Triggering Quality Correction

You can start the program that calculates the quality index under Projects → {Selected project} → Statistics → Quality correction by clicking on the button Execute. It does not make any changes to the actual survey data, rather it expands the data record to include the variable “quality”.

Viewing the Quality Index in the Export Data Record

The quality index of a participant will be stored in the variable “quality”. This is contained within the export data record, and therefore you can identify the data records of participants with critical values and where necessary delete them before making an evaluation.

General Tips and Tricks on Exporting Data

The following applies to all exports:

Export duration

The exported data are not created in advance, they are created according to the settings you made the moment you click on the Export button. Depending on the desired content, selected format and number of records, the export can therefore take a considerable amount of time.

First save, then open the file!

Once you create the file after having made all settings, a dialog window will open, in which you can choose whether you wish to save the file on your local PC or open it directly.

Please always save the file on your local PC. This procedure has several advantages:

• The file only needs to be created once. Newly creating the file each time would cause unnecessary load on the server.

• Depending on the browser used, you may not be able to open the actual application and specify the file type when opening the file directly. Instead the browser may attempt to automatically open the file itself. However, it may be the case that the browser’s file type recognition was incorrectly implemented, i.e. the browser does not identify the file type correctly, cannot open the file and produces an error message.

Characters which cannot be exported

An effective export process into a variety of formats requires a few rather marginal modifications of the result data:

• Backslashes are removed.

• The special characters \n (Newline), \t (Horizontal tab), \r (Carriage return) and " (Double quote) are removed as well.

• NULL values are replaced by an empty string.

These modifications affect all result data exports including the panel exports.