Transferring data from log files

In the connection string in the InputDataSource section, specify mrLogDsc for the Data Source and MR Init MDSC connection properties. Specify the name and location of the log file for the Location and Initial Catalog connection properties. In UNICOM Intelligence Data Model 2.7 and later, you can specify the location of a folder to include all of the log files in that folder:

InputDatasource(myInputDataSource, "My input data source")
  ConnectionString = "Provider=mrOleDB.Provider.2; _
    Data Source=mrLogDsc; _
    Location=<Name and location of the log file or log file        folder>; _
    Initial Catalog=<Name and location of log file>; _
    MR Init MDSC=mrLogDsc"
End InputDatasource

This example transfers the MDG335.tmp log file to a UNICOM Intelligence Data File (.ddf), using the DDFOutput.dms Include file.

InputDataSource(myInputDataSource, "My input data source")
ConnectionString = "Provider=mrOleDB.Provider.2; _
Data Source=mrLogDsc; _
Location=C:\Temp\DMG33Z.tmp; _
Initial Catalog=C:\Temp\DMG33Z.tmp; _
MR Init MDSC=mrLogDsc"
End InputDataSource

#define TargetDDF "C:\Program Files\IBM\SPSS\DataCollection\7\DDL\Output\LogToDDF.ddf"
#define TargetMdd "C:\Program Files\IBM\SPSS\DataCollection\7\DDL\Output\LogToDDF.mdd"
#Include "C:\Program Files\IBM\SPSS\DataCollection\7\DDL\Scripts\Data Management\DMS\Include\DDFOutput.dms"

The UNICOM Intelligence Developer Documentation Library comes with a sample Include file (called LogInput.dms) that you can use to define a transfer from a UNICOM Intelligence log file.