Transferring data to a delimited text file
You can transfer case data to a text file that contains tab-delimited, variable length records. The text file typically has a .csv extension and can be imported in to Microsoft Excel. For more information, see
Delimited Text DSC.
Writing to a new file
If the delimited text file that you specify in the
OutputDataSource section does not exist, the Delimited Text DSC will create a new file.
Writing to an existing file
The Delimited Text DSC appends data to an existing file that has the same name as the delimited text file to be written, but does not attempt to check whether the structure of the existing data and the new data are the same.
Exporting to a delimited text file
In the connection string in the
OutputDataSource section, specify
mrCsvDsc for the
Data Source connection property. Then specify the name and location of the delimited text file, which will normally have a .
csv extension, for the
Location connection property, as shown in the following example:
OutputDataSource(Output, "The output data source")
ConnectionString = "Provider=mrOleDB.Provider.2; _
Data Source = mrCsvDsc; _
Location = <name and location of .csv file>"
End OutputDataSource
Example
This example OutputDataSource section creates a delimited text file and an output metadata document (.mdd) file:
OutputDataSource(Output)
ConnectionString = "Provider=mrOleDB.Provider.2; _
Data Source=mrCsvDsc; _
Location=C:\Program Files\UNICOM\Intelligence\
<version>\DDL\Output\MyDelimTextFile.csv"
MetaDataOutputName = "C:\Program Files\UNICOM\Intelligence\
<version>\DDL\Output\MyDelimTextFile.mdd"
End OutputDataSource
A similar example is provided as a sample file called
CreateCSVAndCategoryMap.dms, which is installed with the UNICOM Intelligence Developer Documentation Library. For more information, see
Sample DMS files.
See