Data Collection Import File Options

The File tab in the Data Collection node enables you to specify options for the metadata and case data you want to import.

Metadata Settings

Note: To see the full list of available provider file types, you need to install the Survey Reporter Developer Kit, available with your Data Collection software product.

Metadata Provider. Survey data can be imported from a number of formats as supported by your Data Collection Survey Reporter Developer Kit. Available provider types include the following:

DataCollectionMDD. Reads metadata from a questionnaire definition file (.mdd). This is the standard Data Collection Data Model format.
ADO Database. Reads case data and metadata from ADO files. Specify the name and location of the .adoinfo file that contains the metadata. The internal name of this DSC is mrADODsc.
In2data Database. Reads In2data case data and metadata. The internal name of this DSC is mrI2dDsc.
Data Collection Log File. Reads metadata from a standard Data Collection log file. Typically, log files have a .tmp filename extension. However, some log files may have another filename extension. If necessary, you can rename the file so that it has a .tmp filename extension. The internal name of this DSC is mrLogDsc.
Quancept Definitions File. Converts metadata to Quancept script. Specify the name of the Quancept .qdi file. The internal name of this DSC is mrQdiDrsDsc.
Quanvert Database. Reads Quanvert case data and metadata. Specify the name and location of the .qvinfo or .pkd file. The internal name of this DSC is mrQvDsc.
Data Collection Participation Database. Reads a project's Sample and History Table tables and creates derived categorical variables corresponding to the columns in those tables. The internal name of this DSC is mrSampleReportingMDSC.
Statistics File. Reads case data and metadata from an IBM® SPSS® Statistics .sav file. Writes case data to an IBM SPSS Statistics .sav file for analysis in IBM SPSS Statistics. Writes metadata from an IBM SPSS Statistics .sav file to an .mdd file. The internal name of this DSC is mrSavDsc.
Surveycraft File. Reads SurveyCraft case data and metadata. Specify the name of the SurveyCraft .vq file. The internal name of this DSC is mrSCDsc.
Data Collection Scripting File. Reads from metadata in an mrScriptMetadata file. Typically, these files have an .mdd or .dms filename extension. The internal name of this DSC is mrScriptMDSC.
Triple-S XML File. Reads metadata from a Triple-S file in XML format. The internal name of this DSC is mrTripleSDsc.

Metadata properties. Optionally, select Properties to specify the survey version to import as well as the language, context, and label type to use. See the topic Data Collection Import Metadata Properties for more information.

Case Data Settings

Note: To see the full list of available provider file types, you need to install the Survey Reporter Developer Kit, available with your Data Collection software product.

Get Case Data Settings. When reading metadata from .mdd files only, click Get Case Data Settings to determine what case data sources are associated with the selected metadata, along with the specific settings needed to access a given source. This option is available only for .mdd files.

Case Data Provider. The following provider types are supported:

ADO Database. Reads case data using the Microsoft ADO interface. Select OLE-DB UDL for the case data type, and specify a connection string in the Case Data UDL field. See the topic Database Connection String for more information. The internal name of this component is mrADODsc.
Delimited Text File (Excel). Reads case data from a comma-delimited (.CSV) file, such as can be output by Excel. The internal name is mrCsvDsc.
Data Collection Data File. Reads case data from a native Data Collection Data Format file. The internal name is mrDataFileDsc.
In2data Database. Reads case data and metadata from an In2data database (.i2d) file. The internal name is mrI2dDsc.
Data Collection Log File. Reads case data from a standard Data Collection log file. Typically, log files have a .tmp filename extension. However, some log files may have another filename extension. If necessary, you can rename the file so that it has a .tmp filename extension. The internal name is mrLogDsc.
Quantum Data File. Reads case data from any Quantum-format ASCII file (.dat). The internal name is mrPunchDsc.
Quancept Data File. Reads case data from a Quancept .drs, .drz, or .dru file. The internal name is mrQdiDrsDsc.
Quanvert Database. Reads case data from a Quanvert qvinfo or .pkd file. The internal name is mrQvDsc.
Data Collection Database (MS SQL Server). Reads case data to a relational Microsoft SQL Server database. See the topic Database Connection String for more information. The internal name is mrRdbDsc2.
Statistics File. Reads case data from an IBM SPSS Statistics .sav file. The internal name is mrSavDsc.
Surveycraft File. Reads case data from a SurveyCraft .qdt file. Both the .vq and .qdt files must be in the same directory, with read and write access for both files. This is not how they are created by default when using SurveyCraft, so one of the files needs to be moved to import SurveyCraft data. The internal name is mrScDsc.
Triple-S Data File. Reads case data from a Triple-S data file, in either fixed-length or comma-delimited format. The internal name is mr TripleDsc.
Data Collection XML. Reads case data from a Data Collection XML data file. Typically, this format may be used to transfer case data from one location to another. The internal name is mrXmlDsc.

Case Data Type. Specifies whether case data is read from a file, folder, OLE-DB UDL, or ODBC DSN, and updates the dialog box options accordingly. Valid options depend on the type of provider. For database providers, you can specify options for the OLE-DB or ODBC connection. See the topic Database Connection String for more information.

Case Data Project. When reading case data from an Data Collection database, you can enter the name of the project. For all other case data types, this setting should be left blank.

Variable Import

Import System Variables. Specifies whether system variables are imported, including variables that indicate interview status (in progress, completed, finish date, and so on). You can choose None, All, or Common.

Import "Codes" Variables. Controls import of variables that represent codes used for open-ended "Other" responses for categorical variables.

Import "SourceFile" Variables. Controls import of variables that contain filenames of images of scanned responses.

Import multi-response variables as. Multiple response variables can be imported as multiple flag fields (a multiple dichotomy set), which is the default method for new streams. Streams created in releases of IBM SPSS Modeler prior to 12.0 imported multiple responses into a single field, with values separate by commas. The older method is still supported to allow existing streams to run as they did previously, but updating older streams to use the new method is recommended. See the topic Importing Multiple Response Sets for more information.