Transferring data from log files
You can transfer data from a UNICOM Intelligence log file using Log DSC.
Reading from a UNICOM Intelligence log file
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 the log file>; _
MR Init MDSC=mrLogDsc"
End InputDatasource
Example
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 includes a sample Include file (called LogInput.dms) that you can use to define a transfer from a UNICOM Intelligence log file.
See