Exporting data

Use the main Export Data page to define the data format that you want to use for the output data file, and the type of data you want to export to that file.

Export Data uses the project’s DataLocation property in DPM to find the questionnaire definition (.mdd) file and the case data. If DataLocation points to a project folder in the User area and there is no .mdd file there, Export Data instead looks for a .mdd file in the Shared project folder.

If the .mdd file contains more than one version, Export Data uses the superversion; that is, a combination of all versions, which results in data for all questions that appear in any version being exported.

If you are exporting data in Quantum format and Metadata Model to Quantum has previously been run on the case data, Export Data uses the column allocations made using Metadata Model to Quantum rather than making new allocations.

If you downloaded the .mdd in order to run , upload it into the shared area before running Export Data.

1 In Export to, choose the data format in which you want to write the exported data. Hierarchical data is supported in the UNICOM Intelligence Data File and UNICOM Intelligence XML Data File formats.

When the MDM document contains unbounded loop questions, and you select UNICOM Intelligence Data File or UNICOM Intelligence XML Data File, the export will use HDATA (otherwise VDATA is used). For more information, see Unbounded loops.

2 If the data format allows more than one file type, use the File type box to select the one you want to use.

3 If the questionnaire definition (.mdd) file contains more than one language, use the Language box to select the language you want to use for question, response, and other texts. The default is the project’s default (base) language.

4 In System variables, choose which system variables you want to export: all, none, or only the common system variables: see Exporting only common system variables.

5 If you do not want to export all data variable types, do the following:

▪In Variable types choose Select below. Export Data displays one checkbox for each variable type below the Variable types box.

6 If you are exporting data in Quantum format, a set of prompts to do with card column options is displayed. Set the following properties:

Width of serial number: Type the number of columns to reserve for the respondent serial number. The default value is 5.

Width of card number: Type the number of columns to reserve for the card number. The default vale is 2.

Max card length: Type the maximum number of columns to write per card. The default value is 80.

Full name of serial variable: Type the serial variable name. The serial variable stores the respondents’ serial numbers.

When the data contains unlimited length text questions, you must export to a *.dau file. For limited length text questions, you can export to a *.dat or *.dau file.

7 If you are exporting data in delimited text format, choose the format for categories:

8 Select Generate extra columns for start and finish times in a specific time zone to calculate and then generate two extra data columns that contain the start and finish times for each case. You can select the following time zones:

▪Interview Server time zone: Uses the Interview Server’s time zone as the start and finish time zone values.

▪Respondent time zone: Uses the respondent’s time zone as the start and finish time zone values.

When daylight savings time is in effect in the respondent’s time zone, an offset of 60 minutes is applied.

▪Other: Select a start/finish time zone from the Time zone list. The default time zone is (GMT) Greenwich Mean Time.

Use the Filter Options section to include only records that relate to a filter condition, such as time period or survey status. Export Data provides some preset filters that you can change, and shortcuts that support filtering on status and date time.

▪Edit presets: Create, change or delete a filter. For more information, see Creating, changing, and deleting filters: Edit Preset Filters dialog.

▪Filter expression: Display the expression for the filter. Click Edit Presets to change the expression, and then see Creating, changing, and deleting filters: Edit Preset Filters dialog.

2 Under Select filtering based on data collection status, click Respondent data only, Test data only, or All data, and then at least one of the interview result types.

3 (Optional.) Click Select cases finished after a certain date/time or Select cases finished before a certain date/time.

▪When Select cases finished after a certain date/time is selected, and a date/time is defined, cases that finish after the specified date/time are returned.

▪When Select cases finished before a certain date/time is selected, and a date/time is defined, cases that finish before the specified date/time are returned.

▪When both Select cases finished after a certain date/time and Select cases finished before a certain date/time are selected, cases that are between the two specified dates/times are returned.

The defined filter condition date/time options do not correspond to the Respondent time zone. When defining the Select cases finished after a certain date/time and Select cases finished before a certain date/time options, the times are based on Coordinated Universal Time (UTC).

▪Export Data does not normally export dirty data, but can be configured to do so. For more information, contact your administrator.

▪During an export, DMOM removes all fields, reintroduces the required fields, and adds the fields to the Paper routing (only when the fields are appropriate in the Paper routing). This can result in duplicate items being added to the Paper routing. In DMOM, the generated MDD is not useful for surveys. As such, changes to the routing script are irrelevant.

▪During an export, DMOM removes all variables first, and then adds variables that exist in Query statement. This behavior might cause the exported MDD to contain invalid routing items: the exported MDD must be used for only data export and analysis; do not use it for survey or project design.