In2data DSC

The In2data data source component (DSC) can read case data and metadata from an In2data database (.i2d) file. Data can be read in a flattened format by using the VDATA virtual table and in a hierarchical format by using the HDATA virtual table. The internal name of this DSC is mrI2dDsc.

In2data is part of the In2quest suite of market research applications, which includes the In2form authoring tool.

Note The In2data data source component (DSC) is not available in x64 64-bit installations.

The following table shows how In2form object types are mapped to the Data Model data types.

In2form object type	UNICOM Intelligence Data Model data type
Single-response, Multi-response	Categorical
Grid - Single-response, Grid - Multi-response	Categorical
Open Text	Text
Open Numeric - Float	Double
Open Numeric - Integer	Long
Date	Date
Pen, Picture, Sound	Text

Both the In2form Loop Number and Loop Over constructions are mapped to numeric loops in the UNICOM Intelligence Data Model. A numeric loop is an object whose IteratorType is set to itNumericRanges. If the loop is unbounded then the Array object's Type is set to mlLevel, otherwise it is set to mlExpand. Unbounded loops can only be viewed using the HDATA virtual table. For more information, see Hierarchical data in the MDM.

The In2data DSC will replace any periods (.) and other illegal characters in the In2form variable names with underscore characters. For example, an In2form variable called Q1.Single1 will be renamed Q1_Single1. Variable and category names that begin with a digit will be prefixed with an underscore character. For example, a category called 4 will be renamed _4.

The following table shows how In2data standard columns are mapped to the UNICOM Intelligence Data Model System variables. In2data standard columns that are not listed here are not mapped.

In2data standard columns	UNICOM Intelligence Data Model system variable
Resp ID	Respondent.Serial
Respondent Serial Number	Respondent.ID
Respondent Start Time	DataCollection.StartTime
Respondent End Time	DataCollection.FinishTime
Respondent Exit Code	DataCollection.TerminateSignal
Rnd	DataCollection.SeedValue
Respondent Note	DataCleaning.Note

By default, In2data DSC will set the value of DataCollection.Status to Completed for all cases. However, if the value of Resp ID is -1, indicating that the data for that respondent was collected during a test interview, the value of DataCollection.Status will be set to Completed and Test.

If the .i2d file contains multiple languages, In2data DSC will export only those languages that are supported by the UNICOM Intelligence Data Model. If the default language on the .i2d file is not supported, In2data DSC will export the user's local language as the default language.