Transferring data from a UNICOM Intelligence data file

You can transfer data from a UNICOM Intelligence data file (.ddf or .dzf) using the UNICOM Intelligence Data File CDSC.

Case data that is stored in a UNICOM Intelligence Data File is typically used with metadata in an .mdd file. When the case data is collected using UNICOM Intelligence software, the .mdd file typically contains versions, which record any changes to the content of the questionnaire. Typically, when the metadata changes (for example, when variables or categories are added or deleted) a new version is created and when the changes are complete, the version is locked. For more information, see Understanding versions.

In the connection string in the InputDataSource section, specify mrDataFileDsc for the Data Source property. Specify the name and location of the .ddf or .dzf file for the Location connection property and the name and location of the .mdd file for the Initial Catalog connection property:

InputDatasource(myInputDataSource, "My input data source")
  ConnectionString = "Provider=mrOleDB.Provider.2; _
    Data Source=mrDataFileDsc; _
    Location=<Name and location of .ddf or .dzf file>; _
    Initial Catalog=<Name and location of .mdd file>"
End InputDatasource

This example InputDataSource section is taken from the MergeVertical.dms sample DMS file, which is installed with the UNICOM Intelligence Developer Documentation Library. For more information, see Sample DMS files.

InputDatasource(myMasterDataSource)
  ConnectionString = " _
    Provider = mrOleDB.Provider.2; _
    Data Source=mrDataFileDsc; _
    Location = C:\Program Files\IBM\SPSS\DataCollection\7\DDL\Data\Data Collection File\MergeVerticalMaster.ddf; _
    Initial Catalog = C:\Program Files\IBM\SPSS\DataCollection\7\DDL\Data\Data Collection File\MergeVerticalMaster.mdd"
End InputDatasource