Data Model > Available DSCs > In2data DSC
 
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.
In2form object types
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
In2form loops
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.
How variable names are translated
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.
System variables
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.
Language handling
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.
Requirements
UNICOM Intelligence Data Model
See also
In2data DSC: Supported CDSC features
Available DSCs