Transferring data from QDI/DRS
You can transfer data from the standard Quancept QDI/DRS format using QDI/DRS DSC. For information about how QDI/DRS DSC interprets and presents the information, see
QDI/DRS DSC.
QDI/DRS DSC automatically sets up system variables including Respondent.Serial (unlike Quanvert DSC and SPSS Statistics SAV DSC).
How do I specify reading from QDI/DRS?
1. Using QDI/DRS DSC to read the metadata
In the connection string in the
InputDataSource section, specify
mrQdiDrsDsc for both the
Data Source and the
MR Init MDSC connection properties. Specify the name and location of the .
drs file for the
Location connection property and the name and location of the .
qdi file for the
Initial Catalog connection property:
InputDatasource(myInputDataSource, "My input data source")
ConnectionString = "Provider=mrOleDB.Provider.2; _
Data Source=mrQdiDrsDsc; _
Location=<Name and location of .drs file>; _
Initial Catalog=<Name and location of .qdi file>; _
MR Init MDSC=mrQdiDrsDsc"
End InputDatasource
2. Using an .mdd file
In the connection string in the
InputDataSource section, specify
mrQdiDrsDsc for the
Data Source connection property and leave the
MR Init MDSC connection property blank. Specify the name and location of the .
drs 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=mrQdiDrsDsc; _
Location=<Name and location of .drs file>; _
Initial Catalog=<Name and location of .mdd file>"
End InputDatasource
Example
This example transfers the Museum sample .qdi and .drs files to a UNICOM Intelligence Data (.ddf) file.
InputDatasource(myInputDataSource)
ConnectionString = "Provider=mrOleDB.Provider.2; _
Data Source=mrQdiDrsDsc; _
Location=C:\Program Files\IBM\SPSS\DataCollection\7\DDL\Data\qdidrs\museum.drs; _
Initial Catalog=C:\Program Files\IBM\SPSS\DataCollection\7\DDL\Data\qdidrs\museum.qdi; _
MR Init MDSC=mrQdiDrsDsc"
End InputDatasource
OutputDatasource(myOutputDataSource)
ConnectionString = "Provider=mrOleDB.Provider.2; _
Data Source=mrDataFileDsc; _
Location=C:\Program Files\IBM\SPSS\DataCollection\7\DDL\Output\QdiDrsToDDF.ddf"
MetaDataOutputName = "C:\Program Files\IBM\SPSS\DataCollection\7\DDL\Output\QdiDrsToDDF.mdd"
End OutputDatasource
Note This example is provided as a sample DMS file (called
QdiDrsToDDF.dms) that is installed with the UNICOM Intelligence Developer Documentation Library. For more information, see
Sample DMS files.
See also